This table stores bid information. The information is updated when a customer submits a bid.
Column Descriptions
Column Name
| Column Type
| Description |
BID_ID
| BIGINT NOT NULL
| Bid ID. Primary key to this table.
|
REFCODE
| CHAR(36) NOT NULL
| Reference code. A unique code that identifies the auction.
|
AUCPAYINFO_ID
| BIGINT
| Reserved for IBM internal use.
|
OWNER_ID
| BIGINT NOT NULL
| The user who submitted the bid.
|
STORE_ID
| INTEGER
| Store that is conducting the auction.
|
ADMIN_ID
| BIGINT
| ID of the administrator who retracted the autobid or bid.
|
AUCT_ID
| BIGINT NOT NULL
| Auction ID. Foreign key to AUCTION table.
|
BIDQUANT
| DOUBLE NOT NULL
| Bid quantity.
|
BIDPRICE
| DECIMAL (20,5) NOT NULL
| The bid price.
|
BIDTIME
| TIMESTAMP NOT NULL
| The time the bid was placed.
|
WINOPT
| CHAR(4) NOT NULL
| 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) NOT NULL
| 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 created from this bid
- WC=create order failed and see logs for details.
|
PAYTYPE
| CHAR(64) NOT NULL
| Payment type. This is set to the value of the cardBrand payment parameter when the bid is submitted.
|
ENCRYPT
| INTEGER NOT NULL
| Indicates if the credit card number is encrypted or not. Valid values are as follows:
- 0=not encrypted
- 1=encrypted
|
DEVICE
| VARCHAR(64) NOT NULL
| Credit card number.
|
EXPDATE
| TIMESTAMP NOT NULL
| Expiration date for the credit card.
|
QUANTSCALE
| INTEGER
| Reserved for IBM internal use.
|
AUTOBID_ID
| BIGINT
| Points to the AUTOBID table if this bid was created from an autobid.
|
BIDROOT
| BIGINT
| Reserved for IBM internal use.
|
BKNAME
| VARCHAR(254)
| Bank name.
|
SHIPTO_ID
| BIGINT
| Ship to address.
|
SHIPMODE
| INTEGER
| Shipping mode.
|
WINPRICE
| DECIMAL (20,5)
| Winning price for the bid based on the close price rule.
|
WINQUANT
| DOUBLE
| Winning quantity.
|
BIDMSG
| VARCHAR(254)
| Message set by the bidder.
|
FIELD1
| BIGINT
| Customizable.
|
FIELD2
| DECIMAL (20,5)
| Customizable.
|
FIELD3
| VARCHAR(254)
| Customizable.
|
BILLADDR
| BIGINT
| Billing address for the customer.
|
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.
|