CC_PO_HDR_VW

(SQL View)
Index Back

ProCard PO_ID prompt


SELECT A.BUSINESS_UNIT , A.PO_ID , A.PO_DT , A.PO_STATUS , A.CC_SECURITY_ID , A.CC_USE_FLAG FROM PS_PO_HDR A WHERE A.PO_STATUS IN ('A', 'D') AND A.MID_ROLL_STATUS <> 'Y' AND A.MATCH_STATUS_PO <> 'M'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 PO_DT Date(10) DATE Date
4 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
5 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Procurement Card Number
6 CC_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Use Procurement Card

Y/N Table Edit

Default Value: N