Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLNAMES


                              GLNAMES FILE

                          General Ledger Names

This file contains information about accounting units and their corresponding
levels. This information represents the hierarchical structure of each company
defined in the Lawson General Ledger System. All Lawson subsystems verify the
existence of the accounting unit against this file.


REFERENCED BY

AC121     AC123     AC130     AC191     AC20.1    AC20.2
AC20.3    AC20.4    AC20.5    AC32.1    AC34.1    AC35.1
AC36.1    AC37.1    AC40.4    AC41.4    AC42.1    AC490
AC541     AC542     AC550     ACDL.1    ACVW.1    AM180
AM214     AM220     AM221     AM230     AM240     AM255
AM260     AM267     AM270     AM278     AM280     AM282
AM287     AP125     AP126     AP131     AP170     AP193
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.2
AP30.4    AP32.2    AP520     API1.1    API2.1    AR115
AR124     AR190     AR20.1    AR21.1    AR21.2    AR21.3
AR24.1    AR29.2    AR30.1    AR30.2    AR30.4    AR42.1
AR42.2    AR42.7    AR43.1    AR560     AR570     AR575
AR580     BN150     BN66.1    BR41.4    CB10.1    CB15.1
CB15.2    CB180     CB191     CB20.1    CB30.1    CB500
CB80.1    CXCP.1    EE135     EE35.1    EE35.2    EE520
CA05.1    CA10.1    CA10.2    CA10.5    CA10.6    CA10.7
CA110     CA195     CA205     CA290     FB100     FB101
FB11.1    FB111     FB141     FB145     FB190     FB20.1
FB20.3    FB20.4    FB20.6    FB20.7    FB21.1    FB211
FB220     FB230     FB231     FB295     FB296     FB30.1
FB31.1    FB40.1    FB40.2    FB40.3    FB45.1    FB95.1
FB95.2    FB95.3    FB95.4    FB95.5    FB95.6    GL135
GL146     GL165     GL167     GL170     GL190     GL191
GL195     GL196     GL197     GL199     GL230     GL238
GL240     GL243     GL256     GL281     GL290     GL291
GL292     GL293     GL294     GL295     GL296     GL298
GL30.2    GL325     GL327     GL330     GL40.1    GL40.2
GL40.3    GL40.7    GL40.8    GL43.1    GL44.1    GL45.1
GL50.4    GL500     GL55.1    GL65.1    GL75.1    GL90.1
GL90.4    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
GLSR.1    RW00.1    RW10.2    RW10.3    RW10.4    RW10.6
RW10.7    RW100     RW20.5    RW20.6    RW230     RW270
RW30.1    RW60.1    RW60.4    RW70.1    RW80.1    HCGL.1
HGLN.1    ZR621     DR100     IC140     IC222     IC28.1
IC282     IC531     IC83.1    GL03.6    GL08.1    GL08.2
GL10.1    GL121     GL123     GL14.8    GL16.4    GL162
GL208     GL21.2    GL21.1    GL210     GL220     GL221
GL222     GL223     GL225     GL23.1    GL24.1    GL61.1
GL62.1    GLAV.1    GLBL.1    GLCV.1    GLOP.1    GLVW.1
IFAC.1    IFAU.1    IFBO.1    IFEO.1    IFGT.1    IFOS.1
IFOS.3    MA180     MA41.2    MA41.7    MA43.1    MA43.2
MA43.3    MA43.9    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA66.2    MA66.3    MA67.1    MA67.2
MA70.1    MA75.1    MA80.1    MAI1.1    PO100     PO101
PO122     PO131     PO135     PO150     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.1
PO23.5    PO25.1    PO25.5    PO25.6    PO25.7    PO27.2
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    PO33.1    PO34.1    PO35.1    PO36.1
PO36.2    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     PO536     POCP.1    POD0.1    POI3.1
POID.1    POIF.1    POII.1    POIJ.1    POIM.1    PR128
PR130     PR131     PR132     PR134     PR136     PR137
PR140     PR189     PR195     PR197     PR29.1    PR32.1
PR32.2    PR33.1    PR33.2    PR33.3    PR35.1    PR35.2
PR35.3    PR35.4    PR35.5    PR35.6    PR35.8    PR36.1
PR37.1    PR38.1    PR45.1    PR529     PR530     PR560
PR80.1    PR82.1    PR85.1    PR89.1    PRSA.1    UK102
UK330     UK560     MM280     MM80.1    MM80.2    RQ10.1
RQ10.2    RQ10.3    RQ11.1    RQ12.1    RQ13.1    RQ140
RQ300     RQ35.1    RQ40.1    RQ41.1    RQ42.1    RQ44.1
RQ44.2    RQ500     RQD0.1    RQIE.1    RQIF.1    SL40.4
SLVW.1    TA147     UK120     WH130     WH132     WH190
WH20.2    WH20.7    WH222     WH25.1    WH25.2    WH30.1
WH30.2    WH30.3    WH30.4    WH31.1    WH31.2    WH31.3
WH31.4    WH32.1    WH32.2    WH32.3    WH32.4    WH33.1
WH33.2    WH33.3    WH33.4    WH33.5    WH33.6    WH33.8
WH33.9    WH34.1    WH34.2    WH34.3    WH34.4    WH40.1
WH40.2    WH520     WH830     WO132     WO140     FB120
FB121     FB195     GL122     GL141     GLRV.1    MLRV.1
RW299     MX135     MX202     MX223

UPDATED BY

GL110     GL120     GL124     GL161     GL20.1    GL721

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GLN-COMPANY            Numeric 4                                 GL110   GL124
Element: Company       Required. The identifier of the highest   GL161   GL20.1
                       level entity throughout all Lawson
                       applications. Must be defined in the
                       GLSYSTEM file.


GLN-ACCT-UNIT          Alpha 15                                  GL124   GL161
Element: Accounting UniRequired. The accounting unit is a        GL20.1
                       shorthand notation representing the
                       variable level number.


GLN-OLD-COMPANY-D      Derived
Element: Old Company   Contains the old company derived.

GLN-VAR-LEVELS         Alpha 30                                  GL120   GL124
Element: Variable LevelRequired field if Lawson General Ledger   GL161   GL20.1
                       user. The variable level number is tied
                       directly to the accounting unit. It is
                       used to indicate an accounting unit's
                       position within the company hierarchy,
                       establishing its consolidation
                       relationship with other units.


GLN-DESCRIPTION        Alpha 30  (Lower Case)                    GL124   GL161
Element: Description   The company description.                  GL20.1

GLN-SHORT-DESC         Derived
Element: Short DescriptThe short description.

GLN-CHART-SECTION      Alpha 1                                   GL124   GL161
Element: Chart Section The chart section.                        GL20.1
                       " " = All Sections
                       1 = Balance Sheet
                       2 = Income Statement

GLN-CURRENCY-CODE      Alpha 5                                   GL124   GL161
Element: Currency Code This field contains the company's base    GL20.1
                       currency code.


GLN-PERSON-RESP        Alpha 15  (Lower Case)                    GL124   GL161
Element: Person ResponsThis field is used to store a name of a   GL20.1
                       person responsible for an accounting
                       unit. This field is not edited in any
                       way. Used in Lawson's Report Writer.


GLN-ACTIVE-STATUS      Alpha 1                                   GL124   GL161
Element: Active Status Required. This field is used to           GL20.1
                       indicate if an accounting unit is active
                       or inactive. If an accounting unit is
                       inactive, all associated accounts are
                       also inactive and no posting can occur.

                       A = Active
                       I = Inactive

GLN-ACCT-GENERATE      Alpha 1
Element: Ac Usage      Indicates if an account is
                       automatically generated against a group
                       of accounting units.


GLN-POSTING-FLAG       Alpha 1                                   GL124   GL161
Element: Posting Flag  This field is used to indicate posting    GL20.1
                       accounting units and summary level
                       accounting units. Posting levels may
                       have a chart of accounts and transaction
                       activity. Summary levels are used to
                       consolidate information from lower level
                       accounting units. Summary levels do not
                       have a chart of accounts, nor do they
                       allow transaction activity. They are
                       created to meet reporting needs.

                       P = Posting
                       S = Summary

GLN-POSTING-FLG-1      Derived
Element: Posting Flg 1 Derived.

GLN-VAR-LEVEL-DISP     Alpha 34                                  GL120   GL124
Variable Level         Variable level field in display format.   GL161   GL20.1
Display

GLN-VL-DISP-SHORT      Derived
Element: Short Display Derived.

GLN-LEVEL-DEPTH        Numeric 1                                 GL120   GL124
Element: Level Depth   The depth assigned to the accounting      GL161   GL20.1
                       unit.

                       1 = Level 1
                       2 = Level 2
                       3 = Level 3
                       4 = Level 4
                       5 = Level 5

GLN-LEVEL-DETAIL       Numeric 15 Occurs 5 Times                 GL120   GL124
Element: Level Detail  Identifies the accounting unit location   GL161   GL20.1
                       in the company structure. The value of
                       each variable level determines how the
                       general ledger combines the accounting
                       units.


GLN-ADDRESS-EXIST      Derived
Element: Address Exist Indicates address information exists.

GLN-MY-ZONE            Derived
Element: My Zone       The zone value.

GLN-MY-ZONE-GROUP      Derived
Element: My Zone Group The zone group.

GLN-ZONE-EXISTS        Derived
Element: Zone Exists   Indicates company zone balancing
                       exists.


GLN-OBJ-TYPE-ACCTU     Derived
Object Type            The accounting unit object type.
Accounting Unit

GLN-OBJ-ID             Numeric 12                                GL110   GL124
Element: Object ID     The object ID.                            GL161   GL20.1

GLN-PARENT-OBJ-ID      Numeric 12                                GL110   GL120
Element: Parent Object The parent object ID.                     GL124   GL161
                                                                 GL20.1  GL721

                         GLNAMES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLNSET1   COMPANY       This path is used to retrieve            AC121   AC123
          ACCT-UNIT     accounting units without a need for      AC130   AC191
                        variable levels.                         AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC32.1
                                                                 AC34.1  AC35.1
                                                                 AC36.1  AC37.1
                                                                 AC40.4  AC41.4
                                                                 AC42.1  AC490
                                                                 AC541   AC542
                                                                 AC550   ACDL.1
                                                                 ACVW.1  AM180
                                                                 AM214   AM220
                                                                 AM221   AM230
                                                                 AM240   AM255
                                                                 ...

GLNSET2   COMPANY       This path is used to retrieve records    AC191   ACVW.1
          VAR-LEVELS    by either variable level without an      AP125   AP126
          ACCT-UNIT     accounting unit, or by accounting unit   AP20.1  AP20.2
                        under a variable level.                  AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                        KeyChange                                AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  FB11.1
                                                                 FB111   FB120
                                                                 FB121   FB141
                                                                 FB195   FB211
                                                                 FB230   FB295
                                                                 FB296   FB95.1
                                                                 FB95.2  FB95.3
                                                                 ...

GLNSET3   VAR-LEVELS    KeyChange, Subset                        CA110   FB11.1
          COMPANY       Where POSTING-FLAG = "P"                 FB111   FB211
          ACCT-UNIT                                              FB296   FB95.1
                                                                 FB95.2  FB95.3
                                                                 FB95.4  FB95.5
                                                                 FB95.6  GL298
                                                                 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
                                                                 ...

GLNSET4   COMPANY       KeyChange                                GL190   GL196
          LEVEL-DEPTH                                            GL199
          ACCT-UNIT

GLNSET5   COMPANY       KeyChange                                FB11.1  FB111
          LEVEL-DEPTH                                            FB211   FB296
          VAR-LEVELS                                             FB95.1  FB95.2
          ACCT-UNIT                                              FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   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
                                                                 ...

GLNSET6   OBJ-ID                                                 AC121   AC123
                                                                 AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC34.1
                                                                 AC35.1  AC36.1
                                                                 AC37.1  AC490
                                                                 ACVW.1  AM180
                                                                 AM214   AM220
                                                                 AM221   AM230
                                                                 AM240   AM255
                                                                 AM260   AM267
                                                                 AM270   AM278
                                                                 AM280   AM282
                                                                 AM287   CA10.1
                                                                 ...

GLNSET7   PARENT-OBJ-ID KeyChange
          COMPANY
          ACCT-UNIT

                         GLNAMES FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Audit Pending  GLAUDIT      Not Required

                            GLN-COMPANY          -> GLA-COMPANY  (GLASET1)
                            GLN-ACCT-UNIT        -> GLA-ACCT-UNIT
                            Zeroes               -> GLA-PROCESS-DATE
                            Zeroes               -> GLA-PROCESS-TIME

Company        GLSYSTEM     Required

                            GLN-COMPANY          -> GLS-COMPANY

Gladdress      GLADDRESS    Not Required, Delete Cascades

                            GLN-COMPANY          -> GAD-COMPANY
                            GLN-ACCT-UNIT        -> GAD-ACCT-UNIT

Glzone         GLZONE       Not Required

                            GLN-COMPANY          -> GLZ-COMPANY
                            GLN-MY-ZONE-GROUP    -> GLZ-ZONE

Object Id      OBJID        Not Required

                            "ACCTU"              -> OBI-OBJ-TYPE

Parent         GLNAMES      Not Required

                            GLN-PARENT-OBJ-ID    -> GLN-OBJ-ID

                         GLNAMES FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accts Au       GLMASTER     Delete Restricted
                            Valid When GLN-POSTING-FLAG = "P"

                            GLN-COMPANY          -> GLM-COMPANY
                            GLN-ACCT-UNIT        -> GLM-ACCT-UNIT
                                                    GLM-ACCOUNT
                                                    GLM-SUB-ACCOUNT

Aumxconv       AUMXCONV

                            GLN-OLD-COMPANY-D    -> AUC-OLD-COMPANY
                                                    AUC-RUN-GROUP
                                                    AUC-MATRIX-CAT
                                                    AUC-EFFECTIVE-DATE

Aumxvalue      AUMXVALUE    Delete Cascades

                            GLN-OBJ-ID           -> AMV-OBJ-ID
                                                    AMV-MATRIX-CAT

Aumxvalue User AUMXVALUE

                            GLN-OBJ-ID           -> AMV-OBJ-ID
                                                    AMV-MATRIX-CAT

Change Audit   GLAUDIT      Delete Cascades

                            GLN-COMPANY          -> GLA-COMPANY
                            GLN-ACCT-UNIT        -> GLA-ACCT-UNIT
                                                    GLA-PROCESS-DATE
                                                    GLA-PROCESS-TIME

Children       GLNAMES

                            GLN-OBJ-ID           -> GLN-PARENT-OBJ-ID
                                                    GLN-COMPANY
                                                    GLN-ACCT-UNIT

Glacctvld Sys  GLACCTVLD

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

Glconsol       GLCONSOL

                            GLN-COMPANY          -> GCN-COMPANY
                            "A"                  -> GCN-TRANS-TYPE
                            Zeroes               -> GCN-BUDGET-NBR
                            GLS-FISCAL-YEAR      -> GCN-FISCAL-YEAR
                            GLN-VAR-LEVELS       -> GCN-VAR-LEVELS
                                                    GCN-ACCOUNT
                                                    GCN-SUB-ACCOUNT
                                                    GCN-CURRENCY-CODE
                                                    GCN-LEVEL-DEPTH

Glnames        GLNAMES

                            GLN-COMPANY          -> GLN-COMPANY
                                                    GLN-VAR-LEVELS
                                                    GLN-ACCT-UNIT

Glzones Many   GLZONE

                            GLN-COMPANY          -> GLZ-COMPANY
                                                    GLZ-ZONE

Member In List MXLISTMBR    Delete Cascades

                            "ACCTU"              -> MLM-OBJ-TYPE
                            GLN-OBJ-ID           -> MLM-OBJ-ID
                                                    MLM-MATRIX-LIST

My Lvl 1 Au    GLNAMES      Required

                            GLN-COMPANY          -> GLN-COMPANY
                            "1"                  -> GLN-LEVEL-DEPTH
                            GLN-MY-ZONE-GROUP    -> GLN-VAR-LEVELS
                                                    GLN-ACCT-UNIT

My Zone        GLNAMES

                            GLN-COMPANY          -> GLN-COMPANY
                            1                    -> GLN-LEVEL-DEPTH
                            GLN-MY-ZONE-GROUP    -> GLN-VAR-LEVELS
                                                    GLN-ACCT-UNIT