Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLCHARTSUM


                            GLCHARTSUM FILE

                      General Ledger Chart Summary

This file contains chart summary records including summary account
information and report options defined in GL00.1 (Chart of Accounts) and the
Summary Account Options subform.


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    FB21.1    FB211     FB296     FB60.1    FB95.1
FB95.2    FB95.3    FB95.4    FB95.5    FB95.6    GL100
GL191     GL256     GL298     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     RW215     RW230
RW270     RW30.1    RW70.1    RW80.1    GL16.4    GL16.1
GL16.2    GL16.3    GLAV.1    GLCV.1    GLVW.1    IFBA.1
SLVW.1    AC34.1    GL292     GL293     GL55.1    RW00.1
RW10.2    RW10.3    RW10.4    RW10.6    RW10.7    RW20.5
RW20.6    RW20.1    RW20.2    RW298     RW60.1    RW60.4
GL02.1    GL02.2    GL02.3    GL02.6    GL121     GL200
GL22.2    GL22.1    GLAC.1    MX123     AC191     AC40.4
AC41.4    AC42.1    AP125     AP126     AP25.1    AP25.2
AP26.1    AP27.1    AP30.2    BR41.4    BR44.1    CB10.1
CB15.1    CB15.2    CB191     CB20.1    CB30.1    CB500
EE135     EE35.1    EE35.2    EE520     CA210     CA240
FB141     FB145     FB190     FB40.1    FB40.2    FB40.3
FB45.1    GL146     GL165     GL170     GL197     GL199
GL281     GL288     GL294     GL326     GL328     GL40.1
GL40.2    GL40.3    GL40.7    GL40.8    GL44.1    GL45.1
GL65.1    GL70.1    GL70.2    GL70.3    GL70.5    GL70.6
GL75.1    RW200     RW210     RW220     RW299     IC222
GL20.2    IFAC.1    MX202     PO150     PO25.1    PO25.6
PO25.7    PO536     POIM.1    SLSE.1    SL02.2    MX223

UPDATED BY

GL00.1    GL00.2    GL00.8    GL00.9    GL03.2    GL03.4
GL160

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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


GCS-CHART-SECTION      Alpha 1                                   GL00.1  GL03.2
Element: Chart Section The chart section.                        GL160
                       1 = Balance Sheet
                       2 = Income Statement

GCS-SEQ-NUMBER         Numeric 6                                 GL00.1  GL03.2
Element: Sequence NumbeA unique number assigned to the summary   GL160
                       account.


GCS-SUMMARY-ACCT       Alpha 12                                  GL00.1  GL00.8
Element: Summary AccounThe summary account.                      GL03.2  GL160

GCS-ACCOUNT-DESC       Alpha 60  (Lower Case)                    GL00.1  GL03.2
Element: Account DescriThe account description.                  GL160

GCS-TOTAL-DESC         Alpha 60  (Lower Case)                    GL00.1  GL03.2
Element: Total DescriptThe description that appears next to
                       the transaction total.


GCS-DEPTH              Numeric 2                                 GL00.1  GL03.2
Element: Depth         Indicates the order of account            GL160
                       totaling. For example, each account
                       assigned a depth of 2, totals to the
                       previous account assigned a depth of 1.

                       01 = Depth 1
                       02 = Depth 2
                       03 = Depth 3
                       04 = Depth 4
                       05 = Depth 5
                       06 = Depth 6
                       07 = Depth 7
                       08 = Depth 8
                       09 = Depth 9

GCS-SUMRY-ACCT-ID      Numeric 6                                 GL00.1  GL03.2
Element: Summary AccounThe summary account.                      GL160

GCS-SPACE-CODE         Numeric 1                                 GL00.1  GL03.2
Element: Space Code    Indicates the number of spaces you want   GL160   GL281
                       to advance on a report after the
                       heading.

                       1 = Advance 1 Line
                       2 = Advance 2 Lines
                       3 = Advance 3 Lines
                       9 = Advance to Next Page

GCS-SIGN-CODE          Alpha 1                                   GL00.1  GL03.2
Element: Sign Code     This field determines whether the sign    GL160
                       following an account balance is
                       reversed. The default is No.

                       This field is for appearance only, it
                       does not change the amount balance.


                       N = No
                       Y = Yes

GCS-SPACE-CODE-TTL     Numeric 1                                 GL00.1  GL03.2
Element: Space Code TotThe number of spaces appearing after      GL160
                       the summary account total.

                       1 = Advance 1 Line
                       2 = Advance 2 Lines
                       3 = Advance 3 Lines
                       9 = Advance to Next Page

GCS-UNDERLINE-B4       Alpha 1                                   GL00.1  GL03.2
Element: Underline BefoThe underline appearing before the        GL160   GL281
                       total.

                       S = Single
                       D = Double
                       N = None

GCS-UNDERLINE-AFT      Alpha 1                                   GL00.1  GL03.2
Element: Underline AfteThe underline appearing after the         GL160   GL281
                       total.

                       S = Single
                       D = Double
                       N = None

GCS-PRINT-HEADING      Alpha 1                                   GL00.1  GL03.2
Element: Print Heading Indicates if the heading is printed for
                       financial statements.

                       Y = Yes
                       N = No

GCS-PARENT-OBJ-ID      Numeric 12                                GL00.1  GL03.2
Element: Parent Object The ID of the parent object.              GL160

GCS-DYNAMIC-LIST       Alpha 12                                  GL00.1  GL03.2
Element: Dynamic List  A valid accounting unit attribute list.   GL160
                       Detail accounts are created for the
                       accounting unit after transactions are
                       entered.


GCS-RESTRICT-SYS       Alpha 1                                   GL00.1  GL03.2
Element: Restrict SysteIndicates if system codes are validated   GL03.4
                       every time the account is used by a
                       system.

                       N = No
                       Y = Yes

GCS-ACCT-CATEGORY      Alpha 5                                   GL00.1  GL03.2
Element: Account CategoAccount categories are groupings of       GL160
                       costs, revenues, or a combination of
                       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

GCS-DAILY-BALANCE      Alpha 1                                   GL00.1  GL03.2
Element: Daily Balance Determines whether transactions can be    GL160
                       viewed on a daily basis.

                       Y = Yes
                       N = No
                       " "

GCS-RELATION           Alpha 15                                  GL00.1  GL03.2
Element: Relation      The user analysis value relation
                       assigned to the detail or summary
                       account.

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

GCS-UNARY-OPER         Alpha 1                                   GL00.1  GL03.2
Element: Unary OperatorThe mathematical operation to             GL160
                       consolidate amounts for a natural
                       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

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

                       This is only used by the OLAP
                       environment.


                       D = Debit
                       C = Credit
                       " " = Blank

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


GCS-OBJ-ID             Numeric 12                                GL00.1  GL00.9
Element: Object Id     This is the unique object identifier.     GL03.2  GL160

GCS-LEDGER-GROUP       Alpha 15                                  GL00.1  GL03.2
Element: Ledger Group                                            GL160

GCS-GL-BUD-FL          Alpha 1                                   GL00.1  GL03.2
Element: GL Budget EditThis is the Yes/No flag for budget        GL160
                       editing.
                       N = No Edit
                       Y = Yes

                         GLCHARTSUM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCSSET1   CHART-NAME                                             AC121   AC123
          CHART-SECTION                                          AC130   AC20.1
          SEQ-NUMBER                                             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
                                                                 ...

GCSSET2   CHART-NAME    KeyChange                                AC34.1  ACVW.1
          SUMMARY-ACCT                                           CA10.1  CA10.7
                                                                 FB11.1  FB111
                                                                 FB160   FB211
                                                                 FB296   FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL100   GL191
                                                                 GL256   GL292
                                                                 GL293   GL298
                                                                 GL55.1  GL90.6
                                                                 GL94.1  GL94.2
                                                                 GL94.3  GL94.4
                                                                 GL94.5  GL94.6
                                                                 ...

GCSSET3   CHART-NAME    KeyChange                                GL00.1  GL160
          CHART-SECTION
          SUMMARY-ACCT

GCSSET4   CHART-NAME    KeyChange
          PARENT-OBJ-ID
          CHART-SECTION
          SEQ-NUMBER

GCSSET5   CHART-NAME                                             AC121   AC123
          SUMRY-ACCT-ID                                          AC130   AC191
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC32.1
                                                                 AC37.1  AC40.4
                                                                 AC41.4  AC42.1
                                                                 AC490   ACVW.1
                                                                 AM180   AP125
                                                                 AP126   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 BR41.4  BR44.1
                                                                 CB10.1  CB15.1
                                                                 CB15.2  CB191
                                                                 ...

GCSSET6   RELATION      KeyChange                                SL02.2
          CHART-NAME
          CHART-SECTION
          SEQ-NUMBER

GCSSET7   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
                                                                 ...

GCSSET8   LEDGER-GROUP  KeyChange, Subset
          CHART-NAME    Where LEDGER-GROUP != Spaces
          CHART-SECTION
          SEQ-NUMBER

                         GLCHARTSUM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Chart Of Accts GLCHART      Required

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

Mxlisthdr      MXLISTHDR    Not Required

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

Parent         GLCHARTSUM   Not Required

                            GCS-CHART-NAME       -> GCS-CHART-NAME
                            GCS-PARENT-OBJ-ID    -> GCS-SUMRY-ACCT-ID

                         GLCHARTSUM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Children       GLCHARTSUM

                            GCS-CHART-NAME       -> GCS-CHART-NAME
                            GCS-SUMRY-ACCT-ID    -> GCS-PARENT-OBJ-ID
                                                    GCS-CHART-SECTION
                                                    GCS-SEQ-NUMBER

Detail Accts   GLCHARTDTL   Delete Restricted

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

Glacctvld Sys  GLACCTVLD

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

Mxlistmbr      MXLISTMBR

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