LED_GRP_TBL

(SQL Table)
 Index Back

Ledger Group Table

  • Related Language Record: LED_GRP_LANG

  • Parent Record Of BUBAL_LEDGRP_VW LED_GRP_LED_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 LEDGER_TEMPLATE Character(10) VARCHAR2(10) NOT NULL Ledger Template

    Prompt Table: LED_TMPLT_D_VW

    5 LEDGER_GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Group Type
    A=Average Daily Balance
    B=Budget
    E=Commitment Control Expense
    R=Commitment Control Revenue
    S=Standard
    T=Translation

    Default Value: S

    6 LEDGERS_SYNC Character(1) VARCHAR2(1) NOT NULL Keep Ledgers in Sync

    Y/N Table Edit

    Default Value: Y

    7 SECOND_LEDGERS Character(1) VARCHAR2(1) NOT NULL Secondary Ledgers Exist

    Y/N Table Edit

    8 GEN_BAL_ENTRIES Character(1) VARCHAR2(1) NOT NULL IntraUnit Balancing Entries

    Y/N Table Edit

    Default Value: N