GM_PROP_PO_VW

(SQL View)
Index Back

Purchase Order Header View

Purchase Order Header View

SELECT VENDOR_ID , BUSINESS_UNIT , PO_ID , PO_TYPE , PO_STATUS , DISP_ACTION , DISP_METHOD , PO_DT , PO_REF FROM PS_PO_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

2 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Default Value: NEXT

4 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban

Default Value: GEN

Prompt Table: %EDITTABLE30

5 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

Default Value: I

6 DISP_ACTION Character(1) VARCHAR2(1) NOT NULL Allow Dispatch When Appr

Y/N Table Edit

Default Value: Y

7 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
8 PO_DT Date(10) DATE NOT NULL Date

Default Value: %date

9 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.