LED_DEFN_TBL

(SQL Table)
 Index Back

Ledger Definition

Detail Ledger definition

  • Related Language Record: LED_DEFN_LANG

  • Parent Record Of BD_LED_FLDS_VW BU_LED_FVW CF_PRMPTRECS_VW COMBO_CFDEFN_V2 COMBO_CFDEFN_VW COMBO_CFUD_VW COMBO_CF_DEFN COMBO_FLDS_TBL LED_FLDS_BAL_VW LED_FLDS_TBL LED_FLDS_VW LED_FLDS_VW2 LED_FLDS_VW3 LED_GRP_FLD_TBL LED_GRP_FLD_VW LED_GRP_FVW

    • # 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 Character(10) VARCHAR2(10) NOT NULL Ledger
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 LEDGER_TEMPLATE Character(10) VARCHAR2(10) NOT NULL Ledger Template

    Prompt Table: %EDITTABLE2

    5 LEDGER_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Type
    D=Detail Ledger
    K=Commitment Control Ledger
    S=Summary Ledger
    6 BUDGET_TYPE Character(2) VARCHAR2(2) NOT NULL Budget Type
    AL=Allotment Budget
    AP=Appropriation Budget
    IN=Initial Budget
    IS=Installment Budget
    OR=Organizational Budget
    OT=Other
    PR=Project/Grant Budget
    RE=Revenue Estimate
    SU=Supplemental Budget
    7 SCENARIO Character(10) VARCHAR2(10) NOT NULL A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
    8 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    9 DETAIL_TMPLT Character(10) VARCHAR2(10) NOT NULL Detail Template

    Prompt Table: LED_TMPLT_D_VW