Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLAMOUNTSX


                            GLAMOUNTSX FILE

                      General Ledger Amounts-Daily

The General Ledger Amounts-Daily file contains daily account balances by
accounting unit, account, and subaccount for the date specified.


REFERENCED BY

GLOP.1    GL243     GL43.1

UPDATED BY

GL110     GL120     GL146     GL148     GL167     GL190
GL197     GL300     GL326     GL40.1    GL40.2    GL40.3
GL40.7    GL40.8    GL44.1    GL45.1    GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GAX-COMPANY            Numeric 4                                 GL110   GL146
Element: Company       The Company field contains the company    GL148   GL167
                       number this is used in the Organization   GL190   GL197
                       dimension.                                GL326   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

GAX-DATE               Numeric 8  (yyyymmdd)                     GL146   GL148
Element: Date          The Date field contains the system date   GL167   GL190
                       this was created. The Date format used    GL197   GL326
                       is YYYYMMDD.                              GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1

GAX-ACCT-UNIT          Alpha 15                                  GL146   GL148
Element: Accounting UniThe Accounting Unit field contains the    GL167   GL190
                       name of the accounting unit that is used  GL197   GL326
                       in the Organization dimension. If this    GL40.1  GL40.2
                       field is blank, all accounting units are  GL40.3  GL40.7
                       included as members in the dimension      GL40.8  GL44.1
                       outline. This name can contain up to 15   GL45.1
                       alphabetic characters.


GAX-ACCOUNT            Numeric 6                                 GL146   GL148
Element: Account       This field along with the accounting      GL167   GL190
                       unit and subaccount make up the location  GL197   GL326
                       (account) where amounts and other         GL40.1  GL40.2
                       account information is stored.            GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1

GAX-SUB-ACCOUNT        Numeric 4                                 GL146   GL148
Element: Subaccount    This field along with the accounting      GL167   GL190
                       unit and subaccount make up the location  GL197   GL326
                       (account) where amounts and other         GL40.1  GL40.2
                       account information is stored.            GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1

GAX-VAR-LEVELS         Alpha 30                                  GL120   GL146
Element: Variable LevelA level that represents the location of   GL148   GL167
                       an accounting unit in an organization's   GL190   GL197
                       level structure.                          GL326   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

GAX-CHART-NAME         Alpha 12                                  GL146   GL148
Element: Chart Name    The Chart of Accounts Name field          GL167   GL190
                       contains the name of the chart of         GL197   GL326
                       accounts that is used by the              GL40.1  GL40.2
                       Organization dimension. This name can     GL40.3  GL40.7
                       contain up to 12 alphabetic characters.   GL40.8  GL44.1
                                                                 GL45.1

GAX-DB-AMOUNT          Signed 18.2                               GL110   GL146
Element: Intl Amt      The Debit Amount field contains the       GL148   GL167
                       debit amount.                             GL190   GL197
                                                                 GL326   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

GAX-CR-AMOUNT          Signed 18.2                               GL110   GL146
Element: Intl Amt      The Credit Amount field contains the      GL148   GL167
                       credit amount.                            GL190   GL197
                                                                 GL326   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

GAX-FISCAL-YEAR        Numeric 4                                 GL146   GL148
Element: Last Closed YeThe Fiscal Year field contains the        GL167   GL190
                       numeric fiscal year. This field can       GL197   GL326
                       contain up to four numeric characters.    GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

GAX-ACCT-PERIOD        Numeric 2                                 GL146   GL148
Element: Account PeriodThis is the current accounting period.    GL167   GL190
                       This field is updated by GL199 (Period    GL197   GL326
                       Closing).                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

GAX-MAINT-DATE         Numeric 8  (yyyymmdd)                     GL120   GL146
Element: Maintenance DaThe Maintenance Date field contains the   GL148   GL167
                       date that this file was last updated.     GL190   GL197
                       The date format used is YYYYMMDD.         GL326   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

GAX-MAINT-TIME         Numeric 6  (hhmmss)                       GL120   GL146
Element: Sys Time      The Maintenance Time field contains the   GL148   GL167
                       time that this file was last updated.     GL190   GL197
                       The time format used is HHMMSS.           GL326   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

GAX-NET-AMOUNT         Derived
Element: Net Amount    The net daily base amount. This amount
                       is the debit amount added to the credit

                       amount.

                         GLAMOUNTSX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GAXSET1   COMPANY                                                GL146   GL148
          DATE                                                   GL167   GL190
          ACCT-UNIT                                              GL197   GL326
          ACCOUNT                                                GL40.1  GL40.2
          SUB-ACCOUNT                                            GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLOP.1

GAXSET2   MAINT-DATE    KeyChange                                GLOP.1
          MAINT-TIME
          COMPANY
          DATE
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT

GAXSET3   COMPANY       KeyChange                                GL110   GL300
          FISCAL-YEAR
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          DATE

GAXSET4   COMPANY                                                GL120   GL243
          ACCT-UNIT                                              GL43.1
          ACCOUNT
          SUB-ACCOUNT
          DATE

                         GLAMOUNTSX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Gltrans        GLTRANS

                            GAX-COMPANY        -> GLT-TO-COMPANY
                            GAX-FISCAL-YEAR    -> GLT-FISCAL-YEAR
                            GAX-ACCT-PERIOD    -> GLT-ACCT-PERIOD
                            GAX-ACCT-UNIT      -> GLT-ACCT-UNIT
                            GAX-ACCOUNT        -> GLT-ACCOUNT
                            GAX-SUB-ACCOUNT    -> GLT-SUB-ACCOUNT
                            GAX-DATE           -> GLT-POSTING-DATE
                                                  GLT-SYSTEM
                                                  GLT-CONTROL-GROUP
                                                  GLT-JE-TYPE
                                                  GLT-LINE-NBR
                                                  GLT-COMPANY
                                                  GLT-JE-SEQUENCE