This table tracks changes made to an autobid. An autobid is written to the AUTOBIDLOG table before it is changed in the AUTOBID table.
Column Name | Column Type | Column Description |
---|---|---|
ABFIELD1 | BIGINT NULL |
Customizable. |
ABFIELD2 | DECIMAL (20,5) NULL |
Customizable. |
ABFIELD3 | VARCHAR (254) NULL |
Customizable. |
ABQUANT | DOUBLE 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 date and time. |
ACTIONMSG | VARCHAR (254) NULL |
Description of the change to the autobid. |
ACTIONTIME | TIMESTAMP NOT NULL |
Date and time of the change to the autobid. |
ACTIONTYPE | INTEGER NULL |
Type of change made to the autobid. |
ADMIN_ID | BIGINT NULL |
ID of the administrator who retracted the autobid. |
AUCPAYINFO_ID | BIGINT NULL |
Reserved for IBM internal use. |
AUCT_ID | BIGINT NULL |
Auction ID of the auction that the autobid is based on. |
AUTOBID_ID | BIGINT NOT NULL |
ID of autobid that was changed. |
BIDMSG | VARCHAR (254) NULL |
Reserved for IBM internal use. |
BID_ID | BIGINT NULL |
Bid ID generated for the autobid. |
BILLADDR | BIGINT NULL |
The billing address specified by the user submitting the bid. |
BKNAME | VARCHAR (254) NULL |
Bank name associated with credit card number in DEVICE column. |
DEVICE | VARCHAR (64) NULL |
The credit card number used for this autobid. |
ENCRYPT | INTEGER NULL |
Indicates if the credit card number is encrypted or not. Valid values: 0=not encrypted, 1=encrypted. |
ENDTIME | TIMESTAMP NULL |
Reserved for IBM internal use. |
EXPDATE | TIMESTAMP NULL |
Expiration date of the credit card. |
INITBIDVAL | DECIMAL (20,5) NULL |
Initial bid value. |
LASTBID_ID | BIGINT NULL |
Reserved for IBM internal use. |
MAXBIDLIMIT | DECIMAL (20,5) NULL |
The maximum bid amount. |
MSGFLAG | INTEGER NULL |
Reserved for IBM internal use. |
OWNER_ID | BIGINT NULL |
ID of the user submitting the autobid. |
PAYTYPE | CHARACTER (64) NULL |
Payment type. Valid values: MC=MasterCard, VS=Visa, DS=Discover, AM=American Express, DC=Diners Club, and BK=other bank card. |
QUANTSCALE | INTEGER NULL |
Reserved for IBM internal use. |
REFCODE | CHARACTER (36) NULL |
Reference code. A unique code that identifies the auction. |
SHIPMODE | INTEGER NULL |
The shipping mode specified by the user submitting the bid. |
SHIPTO_ID | BIGINT NULL |
The shipping address specified by the user submitting the bid. |
STARTTIME | TIMESTAMP NULL |
Reserved for IBM internal use. |
STORE_ID | INTEGER NULL |
The ID of the store 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 |
---|---|---|
SQL030416034841230 | AUTOBID_ID, ACTIONTIME | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_102 | AUCPAYINFO_ID | AUCPAYINFO | AUCPAYINFO_ID | Cascade |
F_103 | STORE_ID | STORE | STORE_ID | Cascade |
F_104 | OWNER_ID | MEMBER | MEMBER_ID | Cascade |
F_105 | ADMIN_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|