PO_OPENENCM_SVW

(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 , h.po_dt , h.vendor_id , h.buyer_id , h.budget_hdr_status , b.foreign_currency , b.base_currency , b.kk_tran_ln , MIN(b.ledger_group) , b.foreign_amount , b.monetary_amount FROM ps_kk_shdr_poenc 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' AND a.kk_rolled_seq = 0 AND h.po_status NOT IN ('C','X') AND h.hold_status <> 'Y' 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' GROUP BY h.business_unit, h.po_id, h.po_dt, h.vendor_id, h.buyer_id, h.budget_hdr_status, b.foreign_currency ,b.base_currency, b.kk_tran_ln, b.foreign_amount, b.monetary_amount

# 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
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
6 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
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 KK_TRAN_LN Number(9,0) DECIMAL(9) NOT NULL Commitment Control Transaction Line number.
10 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
11 PO_ENCUM_NET Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance
12 PO_ENCUM_NET_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Outstanding PO Encumbrance Bse