BU_LED_COMB_VW

(SQL View)
 Index Back

BU Ledger & COMBO View

Business Unit/Ledger Group for CF Combo.

SELECT a.business_unit , a.ledger_group , b.setid , b.process_group , c.combination ,a.combo_tran_src_opt FROM ps_bu_led_comb_tbl a , ps_combo_group_tbl b , PS_COMBO_GRRUL_TBL c , ps_set_cntrl_rec x WHERE a.process_group = b.process_group AND b.process_group = c.process_group AND c.setid = b.setid AND b.setid = x.setid AND x.recname = 'COMBO_RULE_TBL' AND x.setcntrlvalue = a.business_unit

  • Parent record: BU_LED_GRP_TBL

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

    Prompt Table: COMBO_GROUP_TBL

    5 COMBINATION Character(10) VARCHAR2(10) NOT NULL Combination Rule
    6 COMBO_TRAN_SRC_OPT Character(1) VARCHAR2(1) NOT NULL Combo Edit Transaction Source Option
    A=All Transaction Sources
    V=Specific Transaction Source