PO_HDR_STG

#	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 Default Value: O
4	PO_STG_ID	Character(10)	VARCHAR2(10) NOT NULL	Uniqye key to the PO Staging table
5	PO_DT	Date(10)	DATE NOT NULL	Date
6	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
7	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. Prompt Table: PYMT_TR_EFF_VW
8	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: BUYER_ACTIVE_VW
9	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Prompt Table: ORIGIN_PO
10	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
11	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: VENDOR_CNTCT_VW
12	SALES_CNTCT_SEQ_N	Number(3,0)	SMALLINT NOT NULL	Salesperson Prompt Table: VENDOR_CNTCT_VW
13	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION Prompt Table: LOCATION_TBL
14	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit Default Value: N
15	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
17	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Default Value: BUS_UNIT_TBL_PM.RT_TYPE Prompt Table: RT_TYPE_TBL
18	RATE_DATE	Date(10)	DATE	Exchange Rate Date
19	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
20	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
21	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Default Value: VENDOR.DEFAULT_LOC
22	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Prompt Table: PO_HDR_VW1
23	PO_BUILT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates if PO already exists or not. Y/N Table Edit Default Value: N
24	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
25	DISP_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Allow Dispatch When Appr Y/N Table Edit Default Value: Y
26	DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Dispatch Method EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
27	PO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PO Type GEN=General KAN=Kanban Prompt Table: PO_PO_TYPE_VW_N
28	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard
29	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule Prompt Table: %EDITTABLE2
30	PAY_TRM_BSE_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Date Type A=Acct Date C=Doc Date I=Inv Date R=Recpt Date S=Ship Date U=User Date
31	TERMS_BASIS_DT	Date(10)	DATE	Payment Terms Basis Date
32	USER_HDR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
33	CUSTOM_C100_A1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
34	CUSTOM_C100_A2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
35	CUSTOM_C100_A3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
36	CUSTOM_C100_A4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
37	CUSTOM_DATE_A	Date(10)	DATE	Custom Date
38	CUSTOM_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
39	CC_SECURITY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Procurement Card Number
40	CC_USE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Use Procurement Card Y/N Table Edit Default Value: N
41	IGNORE_CONSOLIDATE	Character(1)	VARCHAR2(1) NOT NULL	Define PO Default Value: N
42	PROCURE_INSTRUM_ID	Character(50)	VARCHAR2(50) NOT NULL	Procurement Instrument ID
43	PI_ID_PARENT	Character(50)	VARCHAR2(50) NOT NULL	Parent PIID
44	UNIVERSAL_REC_ID	Character(70)	VARCHAR2(70) NOT NULL	Universal Record Identifier
45	FEDERAL_AWARD_ID	Character(30)	VARCHAR2(30) NOT NULL	Federal Award IdentificationNo
46	EXCLUDE_REPORTING	Character(1)	VARCHAR2(1) NOT NULL	Exclude from DATA Act Y/N Table Edit Default Value: N
47	PRIORITY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Priority Flag 1=High 2=Medium 3=Low