CM_LED_GRP_LVW

(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 ,lng.language_cd ,lng.descr FROM ps_led_grp_tbl lg ,PS_LED_TMPLT_TBL lt ,ps_set_cntrl_rec s ,ps_led_grp_lang lng WHERE lg.ledger_template=lt.ledger_template AND lt.default_ledger<>'C' AND s.recname = 'LED_GRP_TBL' AND lg.setid = s.setid AND lg.setid = lng.setid AND lg.ledger_group = lng.ledger_group

  • Related Language Record for CM_LED_GRP_VW SP_CMLGRP_CLSVW SP_CMLGRP_NONVW SP_CMLGRP_OPRVW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description