PO_HDR_STG_MSG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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
3	PO_STG_ID	Character(10)	VARCHAR2(10) NOT NULL	Uniqye key to the PO Staging table
4	PO_DT	Date(10)	DATE NOT NULL	Date
5	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
6	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
7	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: BUYER_ACTIVE_VW
8	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Prompt Table: ORIGIN_PO
9	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
10	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: VENDOR_CNTCT_VW
11	SALES_CNTCT_SEQ_N	Number(3,0)	SMALLINT NOT NULL	Salesperson Prompt Table: VENDOR_CNTCT_VW
12	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION Prompt Table: LOCATION_TBL
13	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit Default Value: N
14	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
16	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
17	RATE_DATE	Date(10)	DATE	Exchange Rate Date
18	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
19	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
20	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Default Value: VENDOR.DEFAULT_LOC
21	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Prompt Table: PO_HDR_VW1
22	PO_BUILT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates if PO already exists or not. Y/N Table Edit Default Value: N
23	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
24	DISP_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Allow Dispatch When Appr Y/N Table Edit Default Value: Y
25	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
26	PO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PO Type GEN=General KAN=Kanban Prompt Table: PO_PO_TYPE_VW_N
27	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard
28	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule Prompt Table: %EDITTABLE2
29	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
30	TERMS_BASIS_DT	Date(10)	DATE	Payment Terms Basis Date
31	USER_HDR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
32	CUSTOM_C100_A1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
33	CUSTOM_C100_A2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
34	CUSTOM_C100_A3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
35	CUSTOM_C100_A4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
36	CUSTOM_DATE_A	Date(10)	DATE	Custom Date
37	CUSTOM_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2