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
ACDL.1    ACVW.1    AM180     AM214     AM220     AM221
AM230     AM240     AM255     AM260     AM267     AM270
AM278     AM280     AM282     AM287     AP125     AP126
AP131     AP170     AP193     AP25.1    AP25.2    AP26.1
AP27.1    AP30.2    AP30.4    AP520     API1.1    API2.1
AR115     AR124     AR190     AR20.1    AR21.1    AR21.2
AR21.3    AR24.1    AR29.2    AR30.1    AR34.1    AR42.1
AR42.2    AR42.7    AR43.1    AR560     AR570     AR575
AR580     ARLL.1    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    BN150     BR41.4    BR44.1    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     CA205     CA290     FB100     FB101
FB11.1    FB111     FB141     FB145     FB160     FB190
FB20.1    FB20.3    FB20.4    FB20.6    FB20.7    FB21.1
FB211     FB220     FB230     FB231     FB235     FB295
FB296     FB30.1    FB31.1    FB40.1    FB40.2    FB40.3
FB45.1    FB60.1    FB95.1    FB95.2    FB95.3    FB95.4
FB95.5    FB95.6    GL135     GL146     GL148     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    GL70.1    GL70.2    GL70.3    GL70.5
GL70.6    GL75.1    GL90.1    GL90.4    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    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    HCHP.1    HGLN.1    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    IF20.1    IF20.3    IF20.4
IF20.5    IF20.6    IF20.7    IF20.2    IFAC.1    IFAU.1
IFBO.1    IFEO.1    IFGT.1    IFOS.1    IFOS.3    MA180
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    OE10.1    OE10.2    OE10.3    OE10.4
OE10.5    OE10.6    OE10.7    OE10.8    OE11.1    OE11.4
OE11.8    OE11.9    OE110     OE111     OE113     OE114
OE116     OE129     OE13.2    OE13.3    OE13.5    OE13.6
OE14.4    OE30.1    OE30.2    OE30.3    OE30.4    OE30.5
OE30.6    OE30.7    OE30.9    OE510     OE530     OE81.1
OE810     OE830     OE90.1    OE90.2    PA182     PO100
PO101     PO122     PO131     PO135     PO150     PO20.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.1
PO23.5    PO25.1    PO25.6    PO25.7    PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.2
PO33.1    PO34.1    PO35.1    PO38.1    PO39.1    PO39.2
PO44.1    PO50.1    PO52.1    PO520     PO536     POCP.1
POI3.1    POID.1    POIE.1    POIF.1    POII.1    POIJ.1
POIM.1    PR128     PR130     PR131     PR132     PR134
PR136     PR137     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    PR35.9    PR36.1
PR37.1    PR38.1    PR45.1    PR529     PR530     PR560
PR82.1    PR85.1    PRSA.1    UK102     UK330     MM280
RQ10.1    RQ10.2    RQ12.1    RQ13.1    RQ13.2    RQ140
RQ300     RQ35.1    RQ40.1    RQ41.1    RQ42.1    RQ44.1
RQ44.2    RQ500     RQIF.1    SL40.4    SLVW.1    TA147
TP135     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

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

                         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
                                                                 ACDL.1  ACVW.1
                                                                 AM180   AM214
                                                                 AM220   AM221
                                                                 AM230   AM240
                                                                 AM255   AM260
                                                                 AM267   AM270
                                                                 ...

GLNSET2   COMPANY       This path is used to retrieve records    ACVW.1  FB11.1
          VAR-LEVELS    by either variable level without an      FB111   FB120
          ACCT-UNIT     accounting unit, or by accounting unit   FB121   FB141
                        under a variable level.                  FB160   FB195
                                                                 FB211   FB230
                        KeyChange                                FB295   FB296
                                                                 FB60.1  FB95.1
                                                                 FB95.2  FB95.3
                                                                 FB95.4  FB95.5
                                                                 FB95.6  GL110
                                                                 GL120   GL122
                                                                 GL141   GL195
                                                                 GL230   GL256
                                                                 GL281   GL290
                                                                 GL291   GL292
                                                                 ...

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

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

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

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

GLNSET99  ACCT-UNIT
          COMPANY
          ACTIVE-STATUS

                         GLNAMES FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Addrdata       ADDRDATA     Not Required

                            GAD-ADDR-CODE        -> GDD-ADDR-CODE  (GDDSET1)

Audit Pending  GLAUDIT      Not Required

                            GLN-COMPANY          -> GLA-COMPANY
                            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