This table contains information about autobids. Autobids are bids automatically submitted by a scheduler command.
Column Name | Column Type | Column Description |
---|---|---|
ABFIELD1 | BIGINT NULL |
Customizable. |
ABFIELD2 | DECIMAL (20,5) NULL |
Customizable. |
ABFIELD3 | VARCHAR (254) NULL |
Customizable. |
ABQUANT | DOUBLE NOT NULL |
Autobid quantity. |
ABSTATUS | CHARACTER (4) NULL |
Autobid status. Valid values: A=active bid, R=bid retracted by customer, D=bid deleted by administrator. |
ABTIME | TIMESTAMP NULL |
Autobid creation date and time. |
ADMIN_ID | BIGINT NULL |
ID of the administrator who retracted the autobid. |
AUCPAYINFO_ID | BIGINT NULL |
Reserved for IBM internal use. |
AUCT_ID | BIGINT NOT NULL |
Auction ID. |
AUTOBID_ID | BIGINT NOT NULL |
Unique identifier for autobid. Primary key for this table. |
BIDMSG | VARCHAR (254) NULL |
Reserved for IBM internal use. |
BID_ID | BIGINT NULL |
Reference to the bid generated from this autobid. |
BILLADDR | BIGINT NULL |
Billing address for customer. |
BKNAME | VARCHAR (254) NULL |
Reserved for IBM internal use. |
DEVICE | VARCHAR (64) NOT NULL |
Credit card number. |
ENCRYPT | INTEGER NOT NULL |
Indicates whether credit card number is encrypted or not. Valid values: 0=not encrypted, 1=encrypted. |
ENDTIME | TIMESTAMP NULL |
Reserved for IBM internal use. |
EXPDATE | TIMESTAMP NOT NULL |
Expiration date for the credit card. |
INITBIDVAL | DECIMAL (20,5) NULL |
The initial bid value for the autobid. |
LASTBID_ID | BIGINT NULL |
Reserved for IBM internal use. |
MAXBIDLIMIT | DECIMAL (20,5) NULL |
Maximum bid. No autobids will be generated if the bidding exceeds this limit. |
MSGFLAG | INTEGER NULL |
Reserved for IBM internal use. |
OWNER_ID | BIGINT NOT NULL |
ID of the customer who submitted the bid. |
PAYTYPE | CHARACTER (64) NOT NULL |
Payment type. This is set to the value of the cardBrand payment parameter when the autobid is submitted. |
QUANTSCALE | INTEGER NULL |
Reserved for IBM internal use. |
REFCODE | CHARACTER (36) NOT NULL |
Reference code. A unique code that identifies the auction. |
SHIPMODE | INTEGER NULL |
Shipping mode. |
SHIPTO_ID | BIGINT NULL |
ID of ship-to address. |
STARTTIME | TIMESTAMP NULL |
Reserved for IBM internal use. |
STORE_ID | INTEGER NULL |
ID of the store that is conducting the auction. |
WINOPT | CHARACTER (4) NULL |
Indicates if bidder will accept a partial quantity. Valid values: A=bidder will only accept full quantity, P=bidder will accept a partial quantity. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000034 | REFCODE | Unique Index |
I0000035 | BID_ID | Non-Unique Index |
I0000036 | ABQUANT | Non-Unique Index |
I0000037 | MAXBIDLIMIT | Non-Unique Index |
I0000038 | ABSTATUS | Non-Unique Index |
SQL030416034840890 | AUTOBID_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_100 | OWNER_ID | MEMBER | MEMBER_ID | Cascade |
F_101 | ADMIN_ID | MEMBER | MEMBER_ID | Cascade |
F_97 | AUCPAYINFO_ID | AUCPAYINFO | AUCPAYINFO_ID | Cascade |
F_98 | AUCT_ID | AUCTION | AUCT_ID | Cascade |
F_99 | STORE_ID | STORE | STORE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|