DCM_PO_HDR (SQL View)	Index Back
View of Purchase Orders View of Purchase Orders

DCM_PO_HDR

(SQL View)

View of Purchase Orders

SELECT A.BUSINESS_UNIT %Concat '.' %Concat A.PO_ID , A.BUSINESS_UNIT , A.PO_ID , D.XLATLONGNAME , A.RECV_STATUS , A.PO_DT , B.DCM_SUPPLIER_KEY , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , A.CURRENCY_CD , A.MATCH_ACTION , A.MATCH_CNTRL_ID , A.MATCH_STATUS_PO , A.BUYER_ID , A.PYMNT_TERMS_CD , A.ACTIVITY_DATE FROM PS_PO_HDR A , PS_DCM_SUPPLIER B , PS_BUS_UNIT_TBL_PM C , PSXLATITEM D WHERE A.VENDOR_SETID = B.VENDOR_SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.BUSINESS_UNIT_AP = B.BUSINESS_UNIT AND A.PO_STATUS IN ('D','C','X','PX') AND A.CC_USE_FLAG IN ('N',' ') AND D.fieldname = 'PO_STATUS' AND D.fieldvalue = A.PO_STATUS AND D.eff_status = 'A' AND D.effdt = ( SELECT MAX(DD.effdt) FROM psxlatitem DD WHERE DD.fieldname = D.fieldname AND DD.fieldvalue = D.fieldvalue AND DD.effdt <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DCM_PO_KEY Character(16) VARCHAR2(16) NOT NULL Purchase Order Key

2 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

4 DCM_PO_STATUS Character(30) VARCHAR2(30) NOT NULL Supplier Classification Description

5 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled

6 PO_DT Date(10) DATE Date

7 DCM_SUPPLIER_KEY Character(27) VARCHAR2(27) NOT NULL Business Unit Concatenated with Supplier ID and Supplier Location to make a unique combination for third party systems.

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

9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

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

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

12 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
N=No Match
Y=Standard

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

14 MATCH_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Match Status
M=Matched
N=Not Required
P=Partially Matched
T=To Match

15 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

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

17 ACTIVITY_DATE Date(10) DATE Last Activity

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DCM_PO_KEY	Character(16)	VARCHAR2(16) NOT NULL	Purchase Order Key
2	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	DCM_PO_STATUS	Character(30)	VARCHAR2(30) NOT NULL	Supplier Classification Description
5	RECV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Status C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled
6	PO_DT	Date(10)	DATE	Date
7	DCM_SUPPLIER_KEY	Character(27)	VARCHAR2(27) NOT NULL	Business Unit Concatenated with Supplier ID and Supplier Location to make a unique combination for third party systems.
8	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
9	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
10	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard
13	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule
14	MATCH_STATUS_PO	Character(1)	VARCHAR2(1) NOT NULL	Match Status M=Matched N=Not Required P=Partially Matched T=To Match
15	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
16	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.
17	ACTIVITY_DATE	Date(10)	DATE	Last Activity