REG_LEDGER_MAP1

(SQL Table)
 Index Back

Reg Ledger Mapping Structure

Stores the mapping structure (or positional concatenation) rules for a regulatory ledger

  • Related Language Record: REG_LED_MAP1LNG

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

    Prompt Table: SP_SETID_NONVW

    2 REG_LEDGER Character(20) VARCHAR2(20) NOT NULL Regulatory Ledger ID

    Prompt Table: REG_LEDGER_DEFN

    3 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

    Prompt Table: SP_LEDG_D_NONVW

    4 REG_MAPPING_ID Character(5) VARCHAR2(5) NOT NULL Regulatory Ledger Mapping ID - used to differentiate between account types (used in Regulatory Ledger Mapping Structure)
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description