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 |