Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLCHARTDTL


                            GLCHARTDTL FILE

                      General Ledger Chart Detail

This file contains chart detail records including posting and currency
options defined in the Detail Accounts and Account Information subforms form
GL00.1 (Chart of Accounts).


REFERENCED BY

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC32.1    AC37.1    AC490     ACVW.1
AM180     CA10.5    CA10.1    CA10.7    CA110     FB100
FB101     FB11.1    FB111     FB160     FB20.1    FB20.6
FB20.7    FB20.3    FB20.4    FB21.1    FB211     FB296
FB60.1    FB95.1    FB95.2    FB95.3    FB95.4    FB95.5
FB95.6    GL191     GL256     GL298     GL326     GL328
GL90.6    GL90.1    GL94.1    GL94.2    GL94.3    GL94.4
GL94.5    GL94.6    GL94.7    GL95.1    GL95.2    GL95.3
GL95.4    GL95.5    GL95.6    GL95.7    GL95.8    GL95.9
GL96.1    GL96.2    GL96.3    GL96.4    GL96.5    GL97.1
GL97.2    GL97.3    GL97.4    GL97.5    GL97.6    GL97.7
GL97.8    GL97.9    GL98.1    GL98.2    GL98.3    GL98.4
GL98.5    GL99.1    GL99.2    GL99.3    GL99.4    GL99.5
GL99.6    RW100     RW215     RW230     RW270     RW30.1
RW70.1    RW80.1    GL121     GL16.2    GL16.4    GLAV.1
GLCV.1    GLVW.1    IFBA.1    SLVW.1    AC191     AC40.4
AC41.4    AC42.1    AP125     AP126     AP213     AP25.1
AP25.2    AP26.1    AP27.1    AP284     AP30.2    AR286
AR287     BR41.4    BR44.1    CB10.1    CB15.1    CB15.2
CB191     CB20.1    CB30.1    CB500     EE135     EE35.1
EE35.2    EE520     FB145     FB165     FB190     FB195
FB220     FB235     FB295     FB31.1    FB40.1    FB40.2
FB40.3    FB45.1    GL134     GL135     GL146     GL147
GL148     GL165     GL167     GL170     GL190     GL195
GL196     GL197     GL199     GL215     GL230     GL238
GL243     GL281     GL284     GL285     GL286     GL287
GL288     GL289     GL290     GL291     GL295     GL296
GL297     GL325     GL327     GL330     GL34.1    GL40.1
GL40.2    GL40.3    GL40.7    GL40.8    GL43.1    GL44.1
GL45.1    GL500     GL65.1    GL70.1    GL70.2    GL70.3
GL70.5    GL70.6    GL75.1    JB240     HGDT.1    HGLM.1
IC02.1    IC222     GL124     GL14.2    GL14.4    GL20.1
GL20.2    GL20.4    GL200     GL216     GL22.2    GL22.1
GL221     GL222     GL225     GL38.1    GLAC.1    GLDM.3
GLOP.1    IFAC.1    MX123     PA495     PO150     PO25.1
PO25.6    PO25.7    PO536     POIM.1    MM280     SL40.4
SLSE.1    WO30.1    SL02.2    MX202     MX223

UPDATED BY

GL100     GL00.2    GL00.3    GL00.6    GL00.7    GL00.9
GL02.1    GL02.2    GL02.3    GL02.6    GL03.3    GL03.5
GL160

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GDT-CHART-NAME         Alpha 12                                  GL00.3  GL00.9
Element: Chart Name    This is the name you assigned to the      GL02.1  GL02.2
                       chart of accounts when you defined your   GL02.3  GL160
                       company structure in the General Ledger
                       system.


GDT-SUMRY-ACCT-ID      Numeric 6                                 GL00.3  GL00.6
Element: Summary AccounThe summary account ID.                   GL02.1  GL02.2
                                                                 GL02.3  GL02.6
                                                                 GL160

GDT-CHART-SECTION      Alpha 1                                   GL00.3  GL02.1
Element: Chart Section The chart section.                        GL02.2  GL02.3
                       1 = Balance Sheet                         GL160   GL500
                       2 = Income Statement

GDT-ACCOUNT            Numeric 6                                 CA110   FB11.1
Element: Account       This field along with the accounting      FB95.1  FB95.2
                       unit and subaccount make up the location  FB95.3  FB95.4
                       (account) where amounts and other         FB95.5  FB95.6
                       account information is stored.            GL00.3  GL02.1
                                                                 GL02.2  GL02.3
                                                                 GL160   GL90.6
                                                                 GL94.1  GL94.2
                                                                 GL94.3  GL94.4
                                                                 GL94.5  GL94.6
                                                                 GL94.7  GL95.1
                                                                 GL95.2  GL95.3
                                                                 GL95.4  GL95.5
                                                                 GL95.6  GL95.7
                                                                 GL95.8  GL95.9
                                                                 GL96.1  GL96.2
                                                                 GL96.3  GL96.4
                                                                 GL96.5  GL97.1
                                                                 GL97.2  GL97.3
                                                                 GL97.4  GL97.5
                                                                 GL97.6  GL97.7
                                                                 GL97.8  GL97.9
                                                                 GL98.1  GL98.2
                                                                 GL98.3  GL98.4
                                                                 GL98.5  GL99.1
                                                                 GL99.2  GL99.3
                                                                 GL99.4  GL99.5
                                                                 GL99.6  RW100

GDT-SUB-ACCOUNT        Numeric 4                                 CA110   GL00.3
Element: Subaccount    This field along with the accounting      GL02.1  GL02.2
                       unit and subaccount make up the location  GL02.3  GL160
                       (account) where amounts and other         RW100
                       account information is stored.

GDT-OLD-ACCT-NBR-D     Derived
Old Account Nbr        The derived old account number.
Description

GDT-ACCOUNT-DESC       Alpha 60  (Lower Case)                    AP213   AR287
Element: Account DescriThe account description.                  GL00.3  GL02.1
                                                                 GL02.2  GL02.3
                                                                 GL160   GL284
                                                                 GL285   GL286
                                                                 GL287   GL288
                                                                 GL289   GL297
                                                                 RW100

GDT-SHORT-ACCT-DSC     Derived
Short Account
Description

GDT-SPACE-CODE         Numeric 1                                 GL00.3  GL02.1
Element: Space Code    Indicates the number of spaces you want   GL02.2  GL02.3
                       to advance after the account appears on   GL100   GL160
                       a report.

                       1 = Advance One Line
                       2 = Advance Two Lines
                       3 = Advance Three Lines
                       9 = Advance To Next Page

GDT-SIGN-CODE          Alpha 1                                   GL00.3  GL02.1
Element: Sign Code     Indicates a negative sign beside a        GL02.2  GL02.3
                       positive amount.                          GL100   GL160

                       N = No
                       Y = Yes

GDT-UNITS-CODE         Alpha 1                                   GL00.3  GL00.7
Element: Units Code    Determines if units are allowed.          GL02.1  GL02.2
                       Y = Yes - Not Required                    GL02.3  GL03.3
                       N = No                                    GL100   GL160
                       O = Only
                       R = Yes - Required

GDT-ACTIVITY-REQ       Alpha 1                                   GL00.3  GL02.1
Element: Activity RequiIndicates if an Activity is required.     GL02.2  GL02.3
                       Y = Yes                                   GL100   GL160
                       N = No
                       B = Blank

GDT-POSTING-LEVEL      Alpha 1                                   GL00.3  GL02.1
Element: Posting Level Determines if transactions are            GL02.2  GL02.3
                       interfaced to the Lawson General Ledger   GL100   GL160
                       system in detail or summary form.

                       D = Detail
                       S = Summary

GDT-CURRENCY-CODE      Alpha 5                                   FB45.1  GL00.3
Element: Currency Code This field contains the company's base    GL02.1  GL02.2
                       currency code.                            GL02.3  GL100
                                                                 GL135   GL160
                                                                 GL167   GL190
                                                                 GL195   GL196
                                                                 GL199   GL20.4
                                                                 GL330   GL45.1
                                                                 GL500

GDT-CURR-CONTROL       Alpha 1                                   GL00.3  GL02.1
Element: Currency ContrLets you limit all transactions to one    GL02.2  GL02.3
                       currency.                                 GL100   GL160

                       0 = No
                       1 = Yes

GDT-TRANSL-CODE        Alpha 2                                   GL00.3  GL02.1
Element: Translation CoIdentifies the translation rate applied   GL02.2  GL02.3
                       against the account balance to calculate  GL100   GL160
                       the translation value.


GDT-REVALUE            Alpha 1                                   GL00.3  GL02.1
Element: Revalue       Lets you revalue non-base transactions    GL02.2  GL02.3
                       of an account into the company base       GL100   GL160
                       currency.

                       0 = No
                       1 = Yes

GDT-ACTIVE-STATUS      Alpha 1                                   GL00.3  GL02.1
Element: Active Status The status of the account. If Inactive,   GL02.2  GL02.3
                       no posting can be done to the account.    GL100   GL160

                       A = Active
                       I = Inactive

GDT-SUM-SEQ-NBR        Derived
Summary Sequence       The summary account sequence number.
Number

GDT-DYNAMIC-LIST       Alpha 12                                  GL00.3  GL02.1
Element: Dynamic List  The attribute list associated with the    GL02.2  GL02.3
                       summary account.                          GL100   GL160


GDT-RESTRICT-SYS       Alpha 1                                   GL00.3  GL02.1
Element: Restrict SysteDetermines if system codes are            GL02.2  GL02.3
                       validated every time the account is used  GL03.5  GL100
                       by a system.                              GL160

                       Y = Yes
                       N = No
                       " " = Sum Acct Default

GDT-ACCT-CATEGORY      Alpha 5                                   GL00.3  GL02.1
Element: Account CategoAccount categories are groupings of       GL02.2  GL02.3
                       costs, revenues, or a combination of      GL100   GL160
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

GDT-DAILY-BALANCE      Alpha 1                                   GL00.3  GL02.1
Element: Daily Balance Determines whether transactions can be    GL02.2  GL02.3
                       viewed on a daily basis.                  GL100   GL160

                       Y = Yes
                       N = No

GDT-RELATION           Alpha 15                                  GL00.3  GL02.1
Element: Relation      The user analysis value relation          GL02.2  GL02.3
                       assigned to the detail or summary         GL100
                       account.

                       The relation must exist in SL02.1 (User
                       Analysis Value Relation).

GDT-UNARY-OPER         Alpha 1                                   GL00.3  GL02.1
Element: Unary OperatorThe mathematical operation to             GL02.2  GL02.3
                       consolidate amounts for a natural         GL100   GL160
                       balance. Valid values are  Add,
                       subtract, multiply, and divide. The
                       default is Add.

                       Only used by the OLAP environment.

                       + = Addition
                       - = Subtraction
                       * = Multiplication
                       / = Division
                       % = Percentile
                       " " = Do Nothing

GDT-NAT-BALANCE        Alpha 1                                   GL00.3  GL02.1
Element: Natural BalancThis field determines whether the         GL02.2  GL02.3
                       natural balance is a Debit or Credit.     GL100   GL160
                       This field is not required.

                       This is only used by the OLAP
                       environment.


                       D = Debit
                       C = Credit

GDT-SL-ACCT-FLAG       Alpha 1                                   GL00.3  GL02.1
Element: SL Account FlaThis flag determines whether user         GL02.2  GL02.3
                       analysis values can be assigned to a      GL100   GL160
                       specific account. You can select Yes,
                       No, or use the Summary Account
                       selection.

                       Y = Yes
                       N = No
                       " " = Sum Acct Default

GDT-OBJ-ID             Numeric 12                                GL00.3  GL00.9
Element: Object ID     This is the object identifier. It is      GL02.1  GL02.2
                       used to relate commitments or posted      GL02.3  GL160
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

GDT-LEDGER-GROUP       Alpha 15                                  GL00.3  GL02.1
Element: Ledger Group                                            GL02.2  GL02.3
                                                                 GL100   GL160

GDT-GL-BUD-FL          Alpha 1                                   GL00.3  GL02.1
Element: GL Budget EditThis is the Yes/No flag for budget        GL02.2  GL02.3
                       editing.                                  GL100   GL160
                       N = No
                       Y = Yes
                       " " = Sum Acct Default

                         GLCHARTDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GDTSET1   CHART-NAME                                             AC121   AC123
          SUMRY-ACCT-ID                                          AC130   AC20.1
          ACCOUNT                                                AC20.2  AC20.3
          SUB-ACCOUNT                                            AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB101   FB11.1
                                                                 FB111   FB160
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB60.1  FB95.1
                                                                 FB95.2  FB95.3
                                                                 ...

GDTSET2   CHART-NAME                                             AC191   AC40.4
          ACCOUNT                                                AC41.4  AC42.1
          SUB-ACCOUNT                                            ACVW.1  AP125
                                                                 AP126   AP213
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP284   AP30.2
                                                                 AR286   AR287
                                                                 BR41.4  BR44.1
                                                                 CB10.1  CB15.1
                                                                 CB15.2  CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   CA10.1
                                                                 ...

GDTSET3   CHART-NAME    KeyChange                                GL199   GL215
          CHART-SECTION                                          RW215   GL121
          ACCOUNT                                                GL124   GL14.2
          SUB-ACCOUNT                                            GL14.4  GL160
                                                                 GL20.2  GL20.4
                                                                 GLDM.3  GLOP.1

GDTSET4   ACCOUNT                                                AC121   AC123
          SUB-ACCOUNT                                            AC130   AC20.1
          CHART-NAME                                             AC20.2  AC20.3
          SUMRY-ACCT-ID                                          AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB11.1  FB111
                                                                 FB160   FB20.1
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 ...

GDTSET5   RELATION      KeyChange                                SL02.2
          CHART-NAME
          SUMRY-ACCT-ID
          ACCOUNT
          SUB-ACCOUNT

GDTSET6   OBJ-ID        Subset                                   AC121   AC123
                        Where OBJ-ID != Zeroes                   AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 AM180   CA10.5
                                                                 CA110   FB100
                                                                 FB101   FB11.1
                                                                 FB111   FB160
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB60.1  FB95.1
                                                                 FB95.2  FB95.3
                                                                 ...

GDTSET7   LEDGER-GROUP  KeyChange, Subset
          CHART-NAME    Where LEDGER-GROUP != Spaces
          SUMRY-ACCT-ID
          ACCOUNT
          SUB-ACCOUNT

                         GLCHARTDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Chart Of Accts GLCHART      Required

                            GDT-CHART-NAME       -> GCH-CHART-NAME  (GCHSET1)

Currency Code  CUCODES      Not Required

                            GDT-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Mxlisthdr      MXLISTHDR    Not Required

                            "ACCTU"              -> MLH-OBJ-TYPE
                            GDT-DYNAMIC-LIST     -> MLH-MATRIX-LIST

Sumry Account  GLCHARTSUM   Required

                            GDT-CHART-NAME       -> GCS-CHART-NAME
                            GDT-SUMRY-ACCT-ID    -> GCS-SUMRY-ACCT-ID

Transl Code    TRCODES      Not Required

                            GDT-TRANSL-CODE      -> TRC-TRANSL-CODE

                         GLCHARTDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glacctvld Dtl  GLACCTVLD

                            GDT-CHART-NAME       -> VLD-CHART-NAME
                            GDT-ACCOUNT          -> VLD-ACCOUNT
                            GDT-SUB-ACCOUNT      -> VLD-SUB-ACCOUNT
                                                    VLD-SYSTEM

Glacctvld Glm  GLACCTVLD

                            "M"                  -> VLD-RECORD-TYPE
                            Spaces               -> VLD-CHART-NAME
                            Zeroes               -> VLD-SUMRY-ACCT-ID
                            GDT-ACCOUNT          -> VLD-ACCOUNT
                            GDT-SUB-ACCOUNT      -> VLD-SUB-ACCOUNT
                                                    VLD-COMPANY
                                                    VLD-ACCT-UNIT
                                                    VLD-SYSTEM

Glacctvld Sum  GLACCTVLD

                            "S"                  -> VLD-RECORD-TYPE
                            GDT-CHART-NAME       -> VLD-CHART-NAME
                            GDT-SUMRY-ACCT-ID    -> VLD-SUMRY-ACCT-ID
                            Zeroes               -> VLD-ACCOUNT
                            Zeroes               -> VLD-SUB-ACCOUNT
                            Zeroes               -> VLD-COMPANY
                            Spaces               -> VLD-ACCT-UNIT
                                                    VLD-SYSTEM

Glacctvld Sys  GLACCTVLD

                            "D"                  -> VLD-RECORD-TYPE
                            GDT-CHART-NAME       -> VLD-CHART-NAME
                            GDT-SUMRY-ACCT-ID    -> VLD-SUMRY-ACCT-ID
                            GDT-ACCOUNT          -> VLD-ACCOUNT
                            GDT-SUB-ACCOUNT      -> VLD-SUB-ACCOUNT
                            Zeroes               -> VLD-COMPANY
                            Spaces               -> VLD-ACCT-UNIT
                                                    VLD-SYSTEM

Mxlistmbr      MXLISTMBR

                            "ACCTU"              -> MLM-OBJ-TYPE
                            GDT-DYNAMIC-LIST     -> MLM-MATRIX-LIST
                                                    MLM-SEQ-NUMBER

Other Charts   GLCHARTDTL

                            GDT-ACCOUNT          -> GDT-ACCOUNT
                            GDT-SUB-ACCOUNT      -> GDT-SUB-ACCOUNT
                                                    GDT-CHART-NAME
                                                    GDT-SUMRY-ACCT-ID

Posting Accts  GLMASTER

                            GDT-CHART-NAME       -> GLM-CHART-NAME
                            GDT-ACCOUNT          -> GLM-ACCOUNT
                            GDT-SUB-ACCOUNT      -> GLM-SUB-ACCOUNT
                                                    GLM-COMPANY
                                                    GLM-ACCT-UNIT