PO_SSPOLST_VW

(SQL View)

SELECT DISTINCT A.PO_ID , A.PO_DT , A.PO_STATUS , A.VENDOR_ID , A.BUSINESS_UNIT , A.VENDOR_SETID , B.BUSINESS_UNIT , B.VOUCHER_ID , A.BUYER_ID , A.PYMNT_TERMS_CD FROM PS_PO_HDR_FS A , PS_VCHR_LN_FS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT_PO AND A.PO_ID = B.PO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PO_DT Date(10) DATE Date

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_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

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

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

8 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
2	PO_DT	Date(10)	DATE	Date
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_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
9	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
10	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.