PO_ITM_STG_VW2

(SQL View)
 Index Back

Staging Tbl BY Record ID


Select distinct process_instance, business_unit, po_stg_type, po_stg_id, vendor_setid, vendor_id, vndr_loc, buyer_id, po_process_id, stage_status, replen_opt, cntrct_setid from PS_PO_ITM_STG_UD where po_built_flg = 'N' and consolidate_flg = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_STG_TYPE Character(1) VARCHAR2(1) NOT NULL Used in conjunction with PO_STG_ID to make a unique key on the stage tables.
O=Other
R=Requisition
4 PO_STG_ID Character(10) VARCHAR2(10) NOT NULL Uniqye key to the PO Staging table
5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
8 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
9 PO_PROCESS_ID Character(3) VARCHAR2(3) NOT NULL Shows the process that created the row on the stage table
CON=Contract Releases
CRT=PAR Location Replenishment
OLS=Manual / Expedite Requisitions
OMR=Order Management Referenced
PLL=Planning System
RFQ=Request for Quotation
SFL=Production/Shop Floor
SPO=Services Work Order
SRC=AutoSelect / Quick Source
WKM=Work Order Management
10 STAGE_STATUS Character(1) VARCHAR2(1) NOT NULL Stage Status
B=Ready to Create
C=Completed
D=Inv Demand Build in Process
E=Error
I=In Process
N=Needs Approval
P=PO Create in Process
R=Error Recycle
S=Staged
V=POCALC in Process
W=Warning Issued
X=Reset Req and Purge
11 REPLEN_OPT Character(2) VARCHAR2(2) NOT NULL Replenish Code
01=Standard
02=Stockless
12 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID