PON_BID_PO

Details

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

Primary Key

Name	Columns
PON_BID_PO_LINES_PK	BID_NUMBER, SEQUENCE_NUMBER, LINE_NUMBER

Columns

Name	Datatype	Length	Precision	Not-null	Comments
AUCTION_HEADER_ID	NUMBER		18	Yes	Auction Header Id
ITEM_DESCRIPTION	VARCHAR2	2500			Item Description associated to the po line
ITEM_REVISION	VARCHAR2	18			Item Revision associated to the po line
ITEM_ID	NUMBER		18		Item Id associated to the po line
AUCTION_LINE_NUMBER	NUMBER			Yes	Line number of the Negotiation line
PO_TRADING_ORGANIZATION_ID	NUMBER		18		Purchasing Trading Organization unique identifier. Indicates the inventory organization where the trade buy-sell transaction defined by the orchestration agreement is cost accounted.
SFO_AGREEMENT_LINE_NUMBER	NUMBER		18		Orchestration Agreement Line Number.
BID_NUMBER	NUMBER		18	Yes	Bid Number
SFO_PTR_ID	NUMBER		18		Unique identifier of a Primary Trade Relationship in an Orchestration Agreement.
SEQUENCE_NUMBER	NUMBER			Yes	PO Sequence Number
SFO_AGREEMENT_NUMBER	VARCHAR2	100			Indicates the orchestration agreement entered into between the legal entities, business units and trade organizations establishing a trade relationship.
LINE_NUMBER	NUMBER			Yes	Line Number
QUANTITY	NUMBER				PO Quantity
SOLDTO_LE_ID	NUMBER		18		Sold to Legal Entity unique identifier. Indicates the party which is financially responsible for the purchases on a purchase order. This contains the sold to legal entity for the record based on negotiation line , requsition business unit and supplier site. This column is applicable for orders only.
CRITERIA_FOR_SINGLE_PO	VARCHAR2	30			This column will be populated if this PO line is moved from another PO to current PO while consolidating POs. It can have below values- WITHOUT_BACKING_REQ - If the line is Sourcing line and is moved here during consolidation FROM_OTHER_PO - If this is a line that has different tax attributes than the current PO but is moved here during consolidation UNALLOCATED_FROM_SAME_PO - If this is a line that originally belonged to this PO but is unallocated. Quantity in this PO is updated during consolidation
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.
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.
INTERNAL_PO_LINE_NUMBER	NUMBER				Internally generated purchase order line number within Sourcing if purchase order is created through web service.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PON_BID_PO_LINES	pon_auction_headers_all	AUCTION_HEADER_ID
PON_BID_PO_LINES	pon_bid_headers	BID_NUMBER
PON_BID_PO_LINES	pon_bid_item_prices	BID_NUMBER, LINE_NUMBER
PON_BID_PO_LINES	pon_bid_po_numbers	BID_NUMBER, SEQUENCE_NUMBER
PON_BID_PO_LINES	pon_auction_item_prices_all	AUCTION_HEADER_ID, AUCTION_LINE_NUMBER

Indexes

Index	Uniqueness	Tablespace	Columns
PON_BID_PO_LINES_N1	Non Unique	Default	AUCTION_HEADER_ID, AUCTION_LINE_NUMBER
PON_BID_PO_LINES_U1	Unique	Default	BID_NUMBER, SEQUENCE_NUMBER, LINE_NUMBER
PON_BID_PO_LINES_U2	Unique	Default	AUCTION_HEADER_ID, BID_NUMBER, SEQUENCE_NUMBER, LINE_NUMBER