PV_PO_HDR_STG_V (SQL View)	Index Back
PO Header Staging Table

PV_PO_HDR_STG_V

(SQL View)

PO Header Staging Table

SELECT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.PO_STG_TYPE , A.PO_STG_ID , A.PO_DT , A.PO_REF , A.PYMNT_TERMS_CD , A.BUYER_ID , A.ORIGIN , A.ADDRESS_SEQ_NUM , A.CNTCT_SEQ_NUM , A.SALES_CNTCT_SEQ_N , A.BILL_LOCATION , A.TAX_EXEMPT , A.TAX_EXEMPT_ID , A.CURRENCY_CD , A.RT_TYPE , A.RATE_DATE , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.PO_ID , A.PO_BUILT_FLG , A.PO_PROCESS_ID , A.DISP_ACTION , A.DISP_METHOD , A.PO_TYPE , A.MATCH_ACTION , A.MATCH_CNTRL_ID , A.PAY_TRM_BSE_DT_OPT , A.TERMS_BASIS_DT , %subrec(PUR_USR_HDR_SBR, A) , A.CC_SECURITY_ID , A.CC_USE_FLAG , A.IGNORE_CONSOLIDATE , A.PROCURE_INSTRUM_ID , A.PI_ID_PARENT , A.UNIVERSAL_REC_ID , A.FEDERAL_AWARD_ID , A.EXCLUDE_REPORTING , A.PRIORITY_FLG FROM PS_PO_HDR_STG A

# 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

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

#	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
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