PO_WB_OP_ENC_VW

(SQL View)
Index Back

Used by the PO Recon WB


SELECT H.BUSINESS_UNIT , H.PO_ID , SUM(B.MONETARY_AMOUNT) FROM PS_KK_SOURCE_HDR A , PS_KK_LIQUIDATION B , PS_PO_HDR H WHERE A.BUSINESS_UNIT = H.BUSINESS_UNIT AND A.PO_ID = H.PO_ID AND A.KK_TRAN_ID = B.KK_TRAN_ID AND A.KK_SOURCE_TRAN = 'PO_POENC' GROUP BY H.BUSINESS_UNIT, H.PO_ID

# 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_ENCUM_NET Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance