Primary Sourcing Staging Tables

The primary PeopleSoft Purchasing sourcing staging tables are:

Term	Definition
PO_ITM_STG	This core staging table provides line and schedule level information destined for the purchase order. The information in the table may be derived from the requisition, requests for quotes, supply planning, manufacturing, par replenishment, or contracts. Many fields on this table are work fields and should be ignored. These fields in the PO_ITM_STG table are particularly important: PO_STG_TYPE: R (requisition) is used for the AutoSelect Requisitions process (PO_REQSORC) or for online requisition selection when the Define purchase order option is not selected. O (other) is used for any other process. PO_STG_ID: This is the same as the requisition ID when the PO stage type is R. This field is derived from INSTALLATION_PO.LAST_PO_STG_ID, when the purchase order stage type is O. PO_PROCESS_ID: Indicates the process that placed the row into the staging table. CONSOLIDATE_FLG: Indicates whether similar rows (same item and supplier) can be consolidated into a purchase order during the PO Calculations process (PO_POCALC). OVERRIDE_SUGG_VNDR: Indicates whether or not the PO Calculations process can override the suggested supplier with the preferred supplier. INVENTORY_SRC_FLG: Indicates whether a given row is destined for inventory demand or for a purchase order.
PO_ITM_STG_UD	The PO Calculations process takes the information from PO_ITM_STG and copies it, along with each possible supplier from whom the item can be sourced, to PO_ITM_STG_UD. Due to the addition of suppliers, PO_ITM_STG_UD may contain multiple rows for each row in PO_ITM_STG. As the PO Calculations process performs its calculations, it stores the updated information in PO_ITM_STG_UD, leaving the original request information in PO_ITM_STG untouched. Once the sourcing process is complete, the supplier and purchase order ID results update PO_ITM_STG.
PO_DISTRIB_STG	This table provides distribution information. One row is placed here for each distribution destined for the purchase order. For requisitions, the information in this table comes directly from the requisition. Note: RFQ, supply planning, manufacturing, par replenishment, and contract requests also populate this table. Information in this table is copied to the PO_LINE_DISTRIB table.
PO_HDR_STG	This is an optional table built by online requisition selection, RFQs, and contract releases. It is used for manually consolidated requisitions to specify information destined for the Purchase Order Header table (PO_HDR).