LM_ORG_CHARTFLD

(SQL Table)
Index Back

Organization Chartfields

Organization Chartfields

  • Parent record: LM_ORGANIZATION
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

    Default Value: 999999999999999

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 LM_CF_TYPE Character(4) VARCHAR2(4) NOT NULL Chartfield Type
    CHBK=Charge Back
    CRED=Credit
    REVN=Revenue

    Default Value: REVN

    4 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Business Unit

    Prompt Table: LM_BUS_UNIT_VW

    5 LM_ACCOUNT Character(20) VARCHAR2(20) NOT NULL Account Chart Field

    Prompt Table: %EDITTABLE9

    6 LM_ALTACCT Character(20) VARCHAR2(20) NOT NULL Alternate Account Chartfield

    Prompt Table: %EDITTABLE11

    7 LM_BUDGET_REF Character(20) VARCHAR2(20) NOT NULL Budget Reference Chartfield

    Prompt Table: %EDITTABLE13

    8 LM_CHARTFIELD1 Character(20) VARCHAR2(20) NOT NULL Chartfield 1

    Prompt Table: %EDITTABLE15

    9 LM_CHARTFIELD2 Character(20) VARCHAR2(20) NOT NULL Chartfield 2

    Prompt Table: %EDITTABLE16

    10 LM_CHARTFIELD3 Character(20) VARCHAR2(20) NOT NULL Chartfield 3

    Prompt Table: %EDITTABLE17

    11 LM_CLASS_FLD Character(20) VARCHAR2(20) NOT NULL Class Chart Field

    Prompt Table: %EDITTABLE7

    12 LM_FUND_CODE Character(20) VARCHAR2(20) NOT NULL Fund Code

    Prompt Table: %EDITTABLE6

    13 LM_HR_DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: LM_DEPT_CF_VW

    14 LM_OPERATING_UNIT Character(20) VARCHAR2(20) NOT NULL Operating Unit ChartField

    Prompt Table: %EDITTABLE12

    15 LM_PRODUCT Character(20) VARCHAR2(20) NOT NULL Product Chartfield

    Prompt Table: %EDITTABLE14

    16 LM_PROGRAM_CODE Character(20) VARCHAR2(20) NOT NULL Program Chart Field

    Prompt Table: %EDITTABLE8

    17 LM_PROJECT_ID Character(20) VARCHAR2(20) NOT NULL Project Chart Field

    Prompt Table: %EDITTABLE10

    18 LM_DISPLAY_CF Character(1) VARCHAR2(1) NOT NULL Display Chartfields

    Y/N Table Edit