1. Tables and Views for Procurement
  2. PON_BID_PO_NUMBERS_HISTORY

PON_BID_PO_NUMBERS_HISTORY

PON_BID_PO_NUMBERS_HISTORY stores the back up of records in PON_BID_PO_NUMBERS when award is reopened.

Details

  • Schema: FUSION

  • Object owner: PON

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PON_BID_PO_NUMBERS_HISTORY_PK

BID_NUMBER, SEQUENCE_NUMBER, REOPEN_AWARD_NUMBER

Columns

Name Datatype Length Precision Not-null Comments
AUCTION_HEADER_ID NUMBER 18 Yes Value that uniquely identifies the negotiation.
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 that uniqeuly identifies the response of a negotiation
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.
REOPEN_AWARD_NUMBER NUMBER 5 Yes Number of times award has been reopened.

Foreign Keys

Table Foreign Table Foreign Key Column
PON_BID_PO_NUMBERS_HISTORY pon_auction_headers_all AUCTION_HEADER_ID
PON_BID_PO_NUMBERS_HISTORY pon_bid_headers BID_NUMBER
PON_BID_PO_NUMBERS_HISTORY po_headers_all PO_HEADER_ID
PON_BID_PO_NUMBERS_HISTORY hz_parties TRADING_PARTNER_CONTACT_ID

Indexes

Index Uniqueness Tablespace Columns
PON_BID_PO_NUMBERS_HISTORY_U1 Unique Default BID_NUMBER, SEQUENCE_NUMBER, REOPEN_AWARD_NUMBER
PON_BID_PO_NUMBERS_HISTORY_U2 Unique Default AUCTION_HEADER_ID, BID_NUMBER, SEQUENCE_NUMBER, REOPEN_AWARD_NUMBER