PO_OPENENCNP_VW

(SQL View)
Index Back

PO Open Encumbrance


SELECT h.business_unit , h.po_id , b.line_nbr , b.sched_nbr , b.dst_acct_type , b.distrib_line_num , c.foreign_currency , c.base_currency , MIN(c.ledger_group) , SUM(c.foreign_amount) , SUM(c.monetary_amount) FROM ps_kk_shdr_poenc a , ps_kk_source_ln b , ps_kk_liquidation c , PS_PO_HDR h WHERE a.business_unit = h.business_unit AND a.po_id = h.po_id AND h.po_status NOT IN ('C','X') AND h.budget_hdr_status = 'V' AND h.budget_hdr_sts_np = 'V' AND a.kk_source_tran = 'PO_POENCNP' AND a.kk_rolled_seq = 0 AND a.kk_tran_id = b.kk_tran_id AND a.kk_tran_dt = b.kk_tran_dt AND b.kk_tran_id = c.kk_tran_id AND b.kk_tran_dt = c.kk_tran_dt AND b.kk_tran_ln = c.kk_tran_ln GROUP BY h.business_unit, h.po_id, b.line_nbr, b.sched_nbr, b.dst_acct_type, b.distrib_line_num, c.foreign_currency, c.base_currency, c.ledger_group

# 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
8 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
9 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
10 PO_ENCUM_NET Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance
11 PO_ENCUM_NET_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance Bse