PON_BID_HEADERS_INTERFACE

PON_BID_HEADERS_INTERFACE is the interface table for bid headers for xml spreadsheet upload during bidding.

Details

• Schema: FUSION

• Object owner: PON

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
PON_BID_HEADERS_INTERFACE_PK	BATCH_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_ID	NUMBER		18	Yes	Batch Id
AUCTION_HEADER_ID	NUMBER		18	Yes	Auction Header Id
BID_NUMBER	NUMBER		18		Bid Number
BIDDERS_BID_NUMBER	VARCHAR2	25			Reference Number
BID_EXPIRATION_DATE	DATE				Bid Valid Until
NOTE_TO_AUCTION_OWNER	VARCHAR2	4000			Note to buyer
SURROG_BID_RECEIPT_DATE	DATE				Response Received Time for Surrogate bids
MIN_BID_CHANGE	NUMBER				Proxy Bid Decrement value
PROXY_BID_ROW	NUMBER				Spreadsheet row number in which proxy bid column is displayed
REFERENCE_NUMBER_ROW	NUMBER				Spreadsheet row number in which Reference Number column is displayed
HEADER_WORKSHEET_NAME	VARCHAR2	80			Name of the XML Worksheet in which the error occurred for the fields in the header worksheet.
LINES_WORKSHEET_NAME	VARCHAR2	80			Name of the XML Worksheet in which the error occurred for the field in the lines worksheet i.e Proxy Bid Decrement.
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.
BID_CURRENCY_MIN_BID_CHANGE	NUMBER				Minimum bid change in response currency if proxy bidding is allowed

Indexes

Index	Uniqueness	Tablespace	Columns
PON_BID_HEADERS_INTERFACE_U1	Unique	Default	BATCH_ID