This table contains information about autobids. Autobids are bids automatically submitted by a scheduler command.
Column Description(s):
Column Name | Column Type | Description |
AUTOBID_ID |
BIGINT NOT NULL |
Unique identifier for autobid. Primary key for 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 |
ID of the customer who submitted the bid. |
STORE_ID |
INTEGER |
ID of the store that is conducting the auction. |
ADMIN_ID |
BIGINT |
ID of the administrator who retracted the autobid. |
AUCT_ID |
BIGINT NOT NULL |
Auction ID. |
ABQUANT |
DOUBLE NOT NULL |
Autobid quantity. |
PAYTYPE |
CHAR(64) NOT NULL |
Payment type. This is set to the value of the cardBrand payment parameter when the autobid is submitted. |
ENCRYPT |
INTEGER NOT NULL |
Indicates whether 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. |
MAXBIDLIMIT |
DECIMAL (20,5) |
Maximum bid. No autobids will be generated if the bidding exceeds this limit. |
ABSTATUS |
CHAR(4) |
Autobid status. Valid values are as follows:
- A=active bid
- R=bid retracted by customer
- D=bid deleted by administrator
|
WINOPT |
CHAR(4) |
Indicates if bidder will accept a partial quantity. Valid values are as follows:
- A=bidder will only accept full quantity
- P=bidder will accept a partial quantity
|
ABTIME |
TIMESTAMP |
Autobid creation date and time. |
LASTBID_ID |
BIGINT |
Reserved for IBM internal use. |
BID_ID |
BIGINT |
Reference to the bid generated from this autobid. |
BKNAME |
VARCHAR(254) |
Reserved for IBM internal use. |
SHIPTO_ID |
BIGINT |
ID of ship-to address. |
SHIPMODE |
INTEGER |
Shipping mode. |
BIDMSG |
VARCHAR(254) |
Reserved for IBM internal use. |
MSGFLAG |
INTEGER |
Reserved for IBM internal use. |
STARTTIME |
TIMESTAMP |
Reserved for IBM internal use. |
ENDTIME |
TIMESTAMP |
Reserved for IBM internal use. |
ABFIELD1 |
BIGINT |
Customizable. |
ABFIELD2 |
DECIMAL (20,5) |
Customizable. |
ABFIELD3 |
VARCHAR(254) |
Customizable. |
BILLADDR |
BIGINT |
Billing address for customer. |
INITBIDVAL |
DECIMAL (20,5) |
The initial bid value for the autobid. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000034 |
REFCODE |
Unique Index |
SQL050212031200380 |
AUTOBID_ID |
Primary Key |
I0000035 |
BID_ID |
Non-Unique Index |
I0000036 |
ABQUANT |
Non-Unique Index |
I0000037 |
MAXBIDLIMIT |
Non-Unique Index |
I0000038 |
ABSTATUS |
Non-Unique Index |
I0000467 |
STORE_ID |
Non-Unique Index |
I0000468 |
ADMIN_ID |
Non-Unique Index |
I0000469 |
OWNER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_97 |
AUCPAYINFO_ID |
AUCPAYINFO |
AUCPAYINFO_ID |
Cascade |
F_98 |
AUCT_ID |
AUCTION |
AUCT_ID |
Cascade |
F_100 |
OWNER_ID |
MEMBER |
MEMBER_ID |
Cascade |
F_101 |
ADMIN_ID |
MEMBER |
MEMBER_ID |
Cascade |
F_99 |
STORE_ID |
STORE |
STORE_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.