This table contains the history of changes made to an auction. The auction row is stored in this table before it is changed.
Column Description(s):
Column Name | Column Type | Description |
AUCT_ID |
BIGINT NOT NULL |
Auction ID. This is the same as the AUCT_ID in the AUCTION table. |
ACTIONTIME |
TIMESTAMP NOT NULL |
The date and time that the auction was changed. |
ACTIONTYPE |
INTEGER |
The type of change made to the auction. |
AUCPAYINFO_ID |
BIGINT |
Reserved for IBM internal use. |
OWNER_ID |
BIGINT |
Owner of the auction. This the same as the owner of the CATENTRY that is on auction. |
ADMIN_ID |
BIGINT |
The ID of the administrator who changed the auction. |
MBRGRP_ID |
BIGINT |
Reserved for IBM internal use. |
FFMCENTER_ID |
INTEGER |
Fulfillment center ID. The ID of the fulfillment center that provides the inventory for the auction. |
ACTIONMSG |
VARCHAR(254) |
An explanation of the change made to the auction. |
REFCODE |
CHAR(36) |
Reference code. A unique code that identifies the auction. |
CATENTRY_ID |
BIGINT |
ID of the item that is on auction. |
AUTYPE |
CHAR(4) |
Auction type. Valid values are as follows:
- O=open cry
- SB=sealed bid
- D=dutch
|
AUSTATUS |
CHAR(4) |
Auction status. Valid values are as follows:
- BC=bidding closed
- SC=settlement closed
- C=current
- F=future
- R=retracted or deleted
|
AUQUANT |
DOUBLE |
Quantity available on auction. |
BIDRULE_ID |
BIGINT |
ID of the bid rule used for this auction. |
QUANTSCALE |
INTEGER |
Reserved for IBM internal use. |
RESRVPRICE |
DECIMAL (20,5) |
Reserve price. Bids below the reserve price will be ignored when winning bids are determined. |
OPENPRICE |
DECIMAL (20,5) |
Opening price of the auctioned item. |
CURRPRICE |
DECIMAL (20,5) |
Current auction price. Used for Dutch auctions. |
CURRQUANT |
DOUBLE |
Current auction quantity. Used by Dutch auctions to track the available quantity. This quantity is reduced by each winning bid. |
CLOSEPR |
CHAR(4) |
Auction closing price rule. Valid values are as follows:
- D=discriminative
- ND=non-discriminative
|
CURRENCY |
CHAR(4) |
Auction currency. All bids must be in this currency. This is a currency code as per ISO 4217 standards. |
PAYMETHODS |
CHAR(254) |
Allowable payment methods. |
CLOSETYPE |
INTEGER |
Auction closing rule. Valid values are as follows:
- 1=at a fixed end time
- 2=if a specified amount of time has elapsed since the last bid
- 3=based on logical OR 1 and 2
- 4=based on logical AND 1 and 2
|
RULEPAGE |
VARCHAR(254) |
Rule page. The name of the JSP file that will be used to display the auction rules. |
STARTTIME |
TIMESTAMP |
Auction start time. |
ENDTIME |
TIMESTAMP |
Auction ending time. |
DURATION |
TIMESTAMP |
Auction duration. |
DEPOSIT |
DECIMAL (20,5) |
The amount of deposit required for the auction. |
BESTBID_ID |
BIGINT |
ID of the best bid for this auction. Only used for open cry auctions. |
LOCKFLAG |
INTEGER |
Lock flag. Valid values are as follows:
|
HIGHBID_ID |
BIGINT |
ID of the bid with the highest price. |
UPDATETIME |
TIMESTAMP |
Auction end time. |
LASTBKTIME |
TIMESTAMP |
Updated when best bid is calculated by way of schedule task. |
REALENDTIME |
TIMESTAMP |
Auction ending date and time. |
PRECEDENCE |
INTEGER |
Reserved for IBM internal use. |
FIELD1 |
BIGINT |
Customizable. |
RETRACT_BID |
INTEGER |
Reserved for IBM internal use. |
FIELD2 |
BIGINT |
Customizable. |
FIELD3 |
DECIMAL (20,5) |
Customizable. |
FIELD4 |
DECIMAL (20,5) |
Customizable. |
FIELD5 |
VARCHAR(254) |
Customizable. |
FIELD6 |
VARCHAR(254) |
Customizable. |
SUPPLIER_ID |
BIGINT |
Reserved for IBM internal use. |
DURDAYS |
INTEGER |
Auction duration in days. |
REFPRICE |
DECIMAL (20,5) |
Reserved for IBM internal use. |
STATE |
INTEGER |
Reserved for IBM internal use. |
INVRSRVID |
BIGINT |
Inventory reservation ID. |
AUCMODE |
CHAR(4) |
Reserved for IBM internal use. |
PRICELIMIT |
DECIMAL (20,5) |
Reserved for IBM internal use. |
QUANTLIMIT |
DOUBLE |
Reserved for IBM internal use. |
DURLENGTH |
INTEGER |
Reserved for IBM internal use. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |