PON_SELLER_AUC_BID

Details

Schema: FUSION
Object owner: PON
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
PON_SELLER_AUC_BID_LINES_PK	BID_NUMBER, LINE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SELLER_AUCTION_HEADER_ID	NUMBER		18	Yes	Unique identifier for seller auction
BID_NUMBER	NUMBER		18	Yes	Bid number for the response
LINE_ID	NUMBER		18	Yes	System-generated unique identifier for the bid line
PUBLISH_DATE	DATE				Date of this response being published
BID_QUANTITY	NUMBER				Response quantity
BID_PRICE	NUMBER				Currency of the response.
BID_PROXY_MAXIMUM	NUMBER				Proxy Maximum in bid currency
PROXY_INCREMENT	NUMBER				Minimum change in bid price if proxy bidding is allowed
PROXY_ACTIVE_FLAG	VARCHAR2	1			The flag will set to "Y" if there is active proxy going on for that line. The flag will be cleared out when the proxy bid is exhausted.
PROXY_BID_FLAG	VARCHAR2	1			Flag to indicate if the bid is a proxy bid or not.
TRIGGER_BID_NUMBER	NUMBER		18		Bid number which triggered system to generate this bid. Applicable from responses where proxy was enabled.
RANK	NUMBER				Rank for this particular bid line.
IS_CHANGED_LINE_FLAG	VARCHAR2	240			This flag indicates if the bid on an item is changed compared to the previous bid.
AWARD_STATUS	VARCHAR2	25			Award status of bid line
AWARD_QUANTITY	NUMBER				Awarded Quantity
NOTE_TO_BIDDER	VARCHAR2	4000			Note to bidder provided by the seller during award.
NOTE_TO_AUCTION_OWNER	VARCHAR2	4000			Note to auction owner submitted by Bidder while creating bid.
OLD_PUBLISH_DATE	DATE				Publish date of the response that is being revised.
OLD_BID_QUANTITY	NUMBER				Quantity of the response that is being revised.
OLD_BID_PRICE	NUMBER				Bid currency price of the response that is being revised.
OLD_BID_PROXY_MAXIMUM	NUMBER				Proxy maximum in bid currency of the response that is being revised.
OLD_PROXY_INCREMENT	NUMBER				Minimum change in bid price if proxy bidding is allowed from the bid that is being revised
OLD_NOTE_TO_AUCTION_OWNER	VARCHAR2	4000			Note to auction owner submitted by Bidder for the response that is being revised.
BID_START_PRICE	NUMBER				Start price of the bid line. This is calculated based on the price increment provided by auctioneer.
HAS_BID_FLAG	VARCHAR2	1			Indicates whether bidder has bid on the line or not.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PON_SELLER_AUC_BID_LINES	pon_seller_auc_bid_headers	BID_NUMBER
PON_SELLER_AUC_BID_LINES	pon_seller_auction_lines	SELLER_AUCTION_HEADER_ID, LINE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PON_SELLER_AUC_BID_LINES_U1	Unique	Default	BID_NUMBER, LINE_ID