PO_OPENENCM_VW

(SQL View)
 Index Back

PO Open Encumbrance

Used for POs in mid roll when the budget status has been reset to 'N'

SELECT h.business_unit , h.po_id , b.line_nbr , b.sched_nbr , 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') OR (h.budget_hdr_status = 'V' AND h.budget_hdr_sts_np <> 'V') OR (h.budget_hdr_status <> 'V' AND h.budget_hdr_sts_np = 'V')) AND h.mid_roll_status = 'Y' AND a.kk_source_tran = 'PO_POENC' 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.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 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
8 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
9 PO_ENCUM_NET Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance
10 PO_ENCUM_NET_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance Bse