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.
|