PO_HDR_PICK_VW

(SQL View)
Index Back

Init/Open PO Header View

Date Init Ref# Descr 08/28/09 ei CustTest Provide prompt for PO ID on PO Pick Order page.

SELECT BUSINESS_UNIT , PO_ID , PO_REF , PO_STATUS , CHNG_ORD_BATCH , BUYER_ID FROM PS_PO_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 ORDER_ID Character(25) VARCHAR2(25) NOT NULL Order ID
3 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
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 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
6 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer