LED_DEFN_TBL

(SQL Table)
 Index Back

Ledger Definition

Contains valid Ledger Definitions

  • Parent Record Of LED_FLDS_SF_TBL LED_FLDS_TBL LED_FLDS_TBL_VW LED_SF_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 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
    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 Scenario
    8 DETAIL_LEDGER Character(10) VARCHAR2(10) NOT NULL Detail Ledger ID
    9 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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