PO_COPY_VW (SQL View)	Index Back
PO Header View 034/16/2014: Bug - 18235546, Added a field DST_CNTRL_ID to ensure that the Accounting Template on the purchase order header details is copied correctly to a new purchase order using the copy PO functionality.

PO_COPY_VW

(SQL View)

PO Header View

034/16/2014: Bug - 18235546, Added a field DST_CNTRL_ID to ensure that the Accounting Template on the purchase order header details is copied correctly to a new purchase order using the copy PO functionality.

SELECT A.business_unit , A.PO_ID , A.po_status , A.vendor_setid , A.VENDOR_ID , A.VNDR_LOC , B.vendor_name_short , A.buyer_id , A.origin , A.disp_method , A.pymnt_terms_cd , A.cntct_seq_num , A.address_seq_num , A.sales_cntct_seq_n , A.bill_location , A.tax_exempt , A.tax_exempt_id , A.currency_cd , A.rt_type , A.po_ref , A.PO_DT , A.MATCH_CNTRL_ID , A.CURRENCY_CD_BASE , A.PRICE_SETID , A.PRICE_VENDOR , A.PRICE_LOC , A.RATE_MULT , A.RATE_DIV , A.LC_ID , A.PREPAID_PO_FLG , A.PREPAID_AMT , A.PAY_TRM_BSE_DT_OPT , A.TERMS_BASIS_DT , A.POA_STATUS , A.PO_TYPE , A.DST_CNTRL_ID , %subrec(PUR_USR_HDR_SBR, A) , A.PRIORITY_FLG FROM PS_PO_HDR a , PS_VENDOR b WHERE a.VENDOR_SETID = b.SETID AND a.VENDOR_ID = b.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_PM_NONVW

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
Default Value: NEXT

3 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled

4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Default Value: VENDOR_SHRT_VW.VENDOR_ID
Prompt Table: VENDOR_PO_VW

6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

7 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

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

11 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.

12 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

13 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

14 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson

15 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

16 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

17 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID

18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

19 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.

20 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.

21 PO_DT Date(10) DATE Date

22 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule

23 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

24 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID

25 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID

26 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location

27 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

28 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

29 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System
Prompt Table: LC_HDR_PO_VW
Set Control Field: BUSINESS_UNIT_GL

30 PREPAID_PO_FLG Character(1) VARCHAR2(1) NOT NULL Prepaid PO Flag
Y/N Table Edit
Default Value: N

31 PREPAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepaid Amount

32 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

33 TERMS_BASIS_DT Date(10) DATE Payment Terms Basis Date

34 POA_STATUS Character(2) VARCHAR2(2) NOT NULL po ack status field that will be on po_hdr.
AC=Acknowledged with changes
AK=Acknowledged
BA=Approved, Changes Pending
IN=Initial Dispatch Acknowledged
NR=Not Required
SR=Responded, Awaits Review
WD=Awaiting PO Dispatch
WR=Awaiting Acknowledgement

35 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban
Default Value: GEN

36 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template

37 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1

38 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1

39 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2

40 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3

41 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4

42 CUSTOM_DATE_A Date(10) DATE Custom Date

43 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2

44 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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Default Value: NEXT
3	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled
4	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Default Value: VENDOR_SHRT_VW.VENDOR_ID Prompt Table: VENDOR_PO_VW
6	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
7	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
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	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
11	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.
12	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
13	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
14	SALES_CNTCT_SEQ_N	Number(3,0)	SMALLINT NOT NULL	Salesperson
15	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location
16	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
17	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	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.
20	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
21	PO_DT	Date(10)	DATE	Date
22	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule
23	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
24	PRICE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Price From Vendor SetID
25	PRICE_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Price Vendor ID
26	PRICE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Price from Location
27	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
28	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
29	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Letter of Credit Number Assigned by the System Prompt Table: LC_HDR_PO_VW Set Control Field: BUSINESS_UNIT_GL
30	PREPAID_PO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prepaid PO Flag Y/N Table Edit Default Value: N
31	PREPAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Prepaid Amount
32	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
33	TERMS_BASIS_DT	Date(10)	DATE	Payment Terms Basis Date
34	POA_STATUS	Character(2)	VARCHAR2(2) NOT NULL	po ack status field that will be on po_hdr. AC=Acknowledged with changes AK=Acknowledged BA=Approved, Changes Pending IN=Initial Dispatch Acknowledged NR=Not Required SR=Responded, Awaits Review WD=Awaiting PO Dispatch WR=Awaiting Acknowledgement
35	PO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PO Type GEN=General KAN=Kanban Default Value: GEN
36	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template
37	USER_HDR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
38	CUSTOM_C100_A1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
39	CUSTOM_C100_A2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
40	CUSTOM_C100_A3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
41	CUSTOM_C100_A4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
42	CUSTOM_DATE_A	Date(10)	DATE	Custom Date
43	CUSTOM_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
44	PRIORITY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Priority Flag 1=High 2=Medium 3=Low