1. Tables and Views for Procurement
  2. PON_BID_PO_NUMBERS

PON_BID_PO_NUMBERS

PON_BID_PO_NUMBERS stores the reference of the various PO/BPA created form a response. For a negotiation with outcome as blanket/contract purchase agreement there will be one record in this table per response. For a negotiation with Standard Purchase Order outcome this table can have multiple records per response. This can happen if the awarded response has lines created for different requisition business units or the corresponding negotiation line is created from requisitions with same requisition business unit but different tax attributes.

Details

  • Schema: FUSION

  • Object owner: PON

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PON_BID_PO_NUMBERS_PK

BID_NUMBER, SEQUENCE_NUMBER

Columns

Name Datatype Length Precision Not-null Comments
AUCTION_HEADER_ID NUMBER 18 Yes Auction Header Identifier
PO_INTERFACE_HEADER_ID NUMBER 18 PO Interface header unique identifier
DEFAULT_PO_TRADE_ORG_ID NUMBER 18 Unique identifier for Purchasing Trade Organization. Purchasing Trade Organization is the inventory organization reporting to the Sold-to Legal Entity identified in a Purchase Order. This organization is used for cost accounting the transactions in the Sold-to Legal Entity.
MULTIPLE_LEGAL_ENTITIES VARCHAR2 20 Indicates whether multiple legal entities on order should be allowed or not.
BID_NUMBER NUMBER 18 Yes Bid Number
SEQUENCE_NUMBER NUMBER Yes Sequence Number that will take unique values such as 10,20 20 etc. This is unique within a negotiation
PARENT_SEQUENCE_NUMBER NUMBER Sequence Number of the Parent from which PO is split for Large Negotiation.
REQ_BU_ID NUMBER 18 Req Bu Id
DEFAULT_TAXATION_COUNTRY VARCHAR2 2 The country for taxation for tax calculation purposes
TAX_DOCUMENT_SUBTYPE VARCHAR2 240 Country specific classification of the document used for tax calculation and reporting purposes
AGENT_ID NUMBER 18 Stores the buyer user who creates the PO
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 1 Acceptance required indicator.
PO_HEADER_ID NUMBER 18 PO Header ID
PO_ERROR_CODE NUMBER Error code returned by PO autocreate API
PO_ERROR_MSG VARCHAR2 2000 Stores the outcome creation error
PO_START_DATE DATE Blanket award effective from date
PO_END_DATE DATE Blanket award effective to date
INITIATE_APPROVAL VARCHAR2 1 Flag to indicate wether to initiate the PO approval workflow
VENDOR_SITE_ID NUMBER 18 Stores the vendor site id used to create the PO
TRADING_PARTNER_CONTACT_ID NUMBER 18 The contact of the supplier for whom the PO Document is being created.
NOTE_TO_SUPPLIER VARCHAR2 4000 PO note to supplier
AUTOMATIC_GENERATE_ORDER VARCHAR2 1 Automatically generate orders
AUTOMATIC_SUBMIT_FOR_APPR VARCHAR2 1 Automatically submit for approval
GROUP_REQUISITION VARCHAR2 1 Group Requistions
GROUP_REQUISITION_LINES VARCHAR2 1 Group requisition lines
USE_NEED_BY_DATE VARCHAR2 1 Group requisition lines using need-by date
USE_SHIP_TO VARCHAR2 1 Group requisition lines using ship-to organization and location
RETRO_PRICE_COMM_UPDATES_FLAG VARCHAR2 1 Communicate price updates flag
RETRO_PRICE_APPLY_UPDATES_FLAG VARCHAR2 1 Retroactively apply price updates to existing POs flag.
ACKNOWLEDGEMENT_WITHIN_DAYS NUMBER Acknowledgement within days
FOR_BACKING_REQUISITION VARCHAR2 1 For Backing Requisition if set to 'Y' indicates that the PO is created for backing requisition. Otherwise it is set to 'N'.
ORDER_NUMBER VARCHAR2 30 Purchase order number
INTERNAL_PO_NUMBER VARCHAR2 35 Internally generated purchase order number within Sourcing if purchase order is created through web service.
EXTERNAL_PO_NUMBER VARCHAR2 35 Purchasing document number generated by the external legacy purchasing application. The value is present if the purchasing document creation process is through web service.
EXTERNAL_PO_URL VARCHAR2 1000 URL to view the external purchasing document details in the external application. The value is present if the purchasing document creation process is through web service.
PO_WF_CREATION_RND NUMBER The number of attempts required to create the PO.
BILLTO_BU_ID NUMBER 18 Bill-to Business Unit unique identifier. This captures the business unit which vouches the supplier invoices received for a purchase order.
BILL_TO_LOCATION_ID NUMBER 18 Ship-to location unique identifier (References HR_LOCATIONS_ALL.location_id).
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.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
PON_BID_PO_NUMBERS pon_auction_headers_all AUCTION_HEADER_ID
PON_BID_PO_NUMBERS pon_bid_headers BID_NUMBER
PON_BID_PO_NUMBERS po_headers_all PO_HEADER_ID
PON_BID_PO_NUMBERS hz_parties TRADING_PARTNER_CONTACT_ID
pon_bid_po_org_assignments pon_bid_po_numbers BID_NUMBER, PO_SEQUENCE_NUMBER
pon_bid_po_lines pon_bid_po_numbers BID_NUMBER, SEQUENCE_NUMBER
pon_bid_po_lines_history pon_bid_po_numbers BID_NUMBER, SEQUENCE_NUMBER

Indexes

Index Uniqueness Tablespace Columns
PON_BID_PO_NUMBERS_U1 Unique Default BID_NUMBER, SEQUENCE_NUMBER
PON_BID_PO_NUMBERS_U2 Unique Default AUCTION_HEADER_ID, BID_NUMBER, SEQUENCE_NUMBER