SP_LEDGNB_NONVW

(SQL View)
 Index Back

Sec Vw - Non-Balanced Ledgers


SELECT a.business_unit , a.ledger , c.descr , b.calendar_id , e.open_year_from , e.open_period_from , f.open_year_to , f.open_period_to FROM ps_bu_led_tbl a , PS_BU_LED_GRP_TBL b , ps_led_defn_tbl c , ps_fin_open_min_vw e , ps_fin_open_max_vw f WHERE b.business_unit = a.business_unit AND b.ledger_group = a.ledger_group AND b.balanced_ledger = 'N' AND c.setid = ( SELECT setid FROM ps_set_cntrl_rec d WHERE d.setcntrlvalue = a.business_unit AND d.recname = 'LED_DEFN_TBL') AND c.ledger = a.ledger AND c.ledger_type = 'D' AND e.business_unit = b.business_unit AND e.ledger_group = b.ledger_group AND f.business_unit = b.business_unit AND f.ledger_group = b.ledger_group

  • Related Language Record: BU_LED_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
    5 OPEN_YEAR_FROM Number(4,0) SMALLINT NOT NULL Open Year From
    6 OPEN_PERIOD_FROM Number(3,0) SMALLINT NOT NULL Open Period From
    7 OPEN_YEAR_TO Number(4,0) SMALLINT NOT NULL Open Year To
    8 OPEN_PERIOD_TO Number(3,0) SMALLINT NOT NULL Open Period To