This table tracks bid change history. The bid is written to the BIDLOG table before it is changed in the BID table.
Column Description(s):
Column Name | Column Type | Description |
BID_ID |
BIGINT NOT NULL |
Bid ID. |
ACTIONTIME |
TIMESTAMP NOT NULL |
Date and time that the bid was changed. |
ACTIONTYPE |
INTEGER |
Type of change to the bid. |
AUCPAYINFO_ID |
BIGINT |
Reserved for IBM internal use. |
STORE_ID |
INTEGER |
Store that is conducting the auction. |
OWNER_ID |
BIGINT |
ID of the customer who submitted the bid. |
ADMIN_ID |
BIGINT |
ID of the administrator who retracted the autobid or bid. |
ACTIONMSG |
VARCHAR(254) |
Reason the bid was changed. |
REFCODE |
CHAR(36) |
Reference code. A unique code that identifies the auction. |
AUCT_ID |
BIGINT |
Auction ID for the auction that the bid is based on. |
BIDQUANT |
DOUBLE |
Bid quantity. |
BIDPRICE |
DECIMAL (20,5) |
The bid price. |
BIDTIME |
TIMESTAMP |
The time the bid was placed. |
WINOPT |
CHAR(4) |
Indicates if bidder will accept partial quantity. Valid values are as follows:
- A=bidder only accepts full
- P=bidder will accept partial
|
BIDSTATUS |
CHAR(4) |
The bid status. Valid values are as follows:
- A=active
- R=retracted by customer
- S=superceded
- W=winning
- D=delete by administrator
- C=order completed successfully from this bid
- WC=create order failed and see logs for details
|
PAYTYPE |
CHAR(64) |
Reserved for IBM internal use. |
ENCRYPT |
INTEGER |
Indicates if credit card number is encrypted. Valid values: 0=not encrypted, 1=encrypted. |
DEVICE |
VARCHAR(64) |
Credit card number. |
EXPDATE |
TIMESTAMP |
Credit card expiration date. |
QUANTSCALE |
INTEGER |
Reserved for IBM internal use. |
AUTOBID_ID |
BIGINT |
ID of the autobid when the bid is generated from an autobid. Otherwise the field is empty. |
BIDROOT |
BIGINT |
Reserved for IBM internal use. |
BKNAME |
VARCHAR(254) |
Bank name. |
SHIPTO_ID |
BIGINT |
Shipping address for the customer submitting the bid. |
SHIPMODE |
INTEGER |
Shipping mode selected by the customer submitting the bid. |
WINPRICE |
DECIMAL (20,5) |
The price the bidder will pay if the bid is a winner. |
WINQUANT |
DOUBLE |
Quantity awarded to this bid if the bid is a winner. |
BIDMSG |
VARCHAR(254) |
Reserved for IBM internal use. |
FIELD1 |
BIGINT |
Customizable. |
FIELD2 |
DECIMAL (20,5) |
Customizable. |
FIELD3 |
VARCHAR(254) |
Customizable. |
BILLADDR |
BIGINT |
Billing address of the customer submitting the bid. |
INITPRICE |
DECIMAL (20,5) |
Reserved for IBM internal use. |
LIMITPRICE |
DECIMAL (20,5) |
Reserved for IBM internal use. |
BIDMODE |
CHAR(4) |
Reserved for IBM internal use. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |