CM_LED_GRP_VW

(SQL View)
 Index Back

Non-KK Ledger Group View

Copy of LED_GRP_NOKK_VW - added BUSINESS_UNIT_GL as key and dropped setid. Any changes to LED_GRP_NOKK_VW may have impact on this view. This was created to fix an issue in business unit books page - use glbu instead of inventory bu to get the ledger group; use as prompt table for ledger group

SELECT %Substring(s.setcntrlvalue, 1, 5) ,lg.ledger_group ,lg.descr ,lg.setid FROM ps_led_grp_tbl lg ,PS_LED_TMPLT_TBL lt ,ps_set_cntrl_rec s WHERE lg.ledger_template=lt.ledger_template AND lt.default_ledger<>'C' AND s.recname = 'LED_GRP_TBL' AND lg.setid = s.setid

  • Related Language Record: CM_LED_GRP_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID