CHART_KEYS_HR

(SQL Table)
 Index Back

Chart Distrib Values HR to GL

This record associates values from the mapped accounts to a specific General Ledger account.

  • Related Language Record: CHART_KEYS_LANG

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

    Prompt Table: SETID_TBL

    2 ACTIVITY Character(3) VARCHAR2(3) NOT NULL Payroll Activity
    3 ACCOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Account Type
    $=Issue Check
    C=Checking
    L=Liability
    N=Non Applicable
    S=Savings
    X=Expense
    4 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit

    Prompt Table: SETID_BU_GL_VW

    5 CHART_KEY Character(50) VARCHAR2(50) NOT NULL ChartField Key
    6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_VW

    7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPARTMENT_VW

    8 LINE_DESCR Character(30) VARCHAR2(30) NOT NULL Journal Line Description
    9 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

    Prompt Table: FUND_VW