ENC_PSTBL_VW

(SQL View)
 Index Back

Encs Eligible for Posting


SELECT business_unit , po_id , po_dt FROM PS_PO_HDR WHERE in_process_flg = 'N' AND ( po_status IN ('A','AC','C','D','PX','X') OR chng_ord_batch > 0 ) AND po_post_status = 'N'

# 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