CNTRCT_PO_VW (SQL View)	Index Back
PO Header View

CNTRCT_PO_VW

(SQL View)

PO Header View

SELECT DISTINCT A.business_unit , A.vendor_setid , A.VENDOR_ID , A.PO_ID , A.VNDR_LOC , B.vendor_name_short , A.po_status , A.pymnt_terms_cd , A.currency_cd , A.rt_type FROM PS_PO_HDR a , PS_VENDOR b WHERE a.VENDOR_SETID = b.SETID AND a.VENDOR_ID = b.VENDOR_ID AND a.PO_STATUS = 'D' AND NOT EXISTS( SELECT 'X' FROM ps_cntrct_pp_xref x WHERE x.business_unit = a.business_unit AND x.po_id = a.po_id)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
Default Value: CNTRCT_WRK0.BUSINESS_UNIT_PO
Prompt Table: SETID_CNT_PO_VW

2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
Default Value: CNTRCT_HDR.VENDOR_SETID

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

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

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

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

7 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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit Default Value: CNTRCT_WRK0.BUSINESS_UNIT_PO Prompt Table: SETID_CNT_PO_VW
2	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Default Value: CNTRCT_HDR.VENDOR_SETID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Default Value: CNTRCT_HDR.VENDOR_ID Prompt Table: VENDOR_PO_VW
4	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
5	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
6	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
7	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
8	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.
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	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.