SCP_RCTPOD_VW

(SQL View)
 Index Back

Receipt Purchase Order


SELECT DISTINCT A.PO_ID , C.PO_DT , C.PO_STATUS , A.VENDOR_ID , A.SETID ,A.oprid ,B.NAME1 , D.OPRDEFNDESC , C.PO_REF FROM PS_SCP_RJCTRCPT_VW A , PS_VENDOR B , PS_PO_HDR C , PSOPRDEFN D WHERE A.VENDOR_ID = B.VENDOR_ID AND A.SETID = B.SETID AND A.PO_ID IS NOT NULL AND A.PO_ID <> ' ' AND A.BUSINESS_UNIT_PO = C.BUSINESS_UNIT AND A.PO_ID = C.PO_ID AND C.BUYER_ID = D.OPRID

# 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
8 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
9 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.