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 AC127 AC130 AC191 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 AC87.1 ACBO.1 ACDL.1 ACVW.1 AM05.1 AM06.1 AM06.2 AM09.1 AM115 AM12.1 AM125 AM135 AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM170 AM190 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM255 AM270 AM30.1 AM30.2 AM40.1 AM40.2 AM40.3 AM500 AM96.1 AM98.1 AP125 AP126 AP20.1 AP20.2 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 CB10.1 CB15.1 CB15.2 CB20.1 CB500 CA05.1 CA10.1 CA10.2 CA10.5 CA10.7 CA10.8 CA110 CA205 CA290 FB100 FB101 FB121 FB141 FB165 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB220 FB230 FB231 FB295 FB30.1 FB31.1 FB65.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 GL135 GL146 GL167 GL170 GL190 GL191 GL195 GL196 GL199 GL230 GL240 GL243 GL256 GL270 GL281 GL290 GL291 GL292 GL293 GL294 GL295 GL296 GL30.2 GL325 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.8 GL40.9 GL43.1 GL44.1 GL45.1 GL50.4 GL500 GL55.1 GL90.1 GL90.4 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 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 IC222 GL03.6 GL08.1 GL08.2 GL10.1 GL121 GL162 GL208 GL21.2 GL21.1 GL210 GL220 GL221 GL222 GL225 GL61.1 GL62.1 GL87.1 GL88.1 GLBL.1 GLCV.1 GLOB.1 GLOP.1 GLVW.1 IFAC.1 IFAU.1 IFGT.1 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1 RQ10.1 SL40.1 SL40.4 FB120 FB195 GL122 GL141 FB700 GL700 RW299 GL223 UPDATED BY GL110 GL120 GL161 GL20.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY GLN-COMPANY Numeric 4 GL110 GL161 Company Required. The identifier of the highest GL20.1 level entity throughout all Lawson applications. Must be defined in the GLSYSTEM file. GLN-ACCT-UNIT Alpha 15 GL161 GL20.1 Accounting Unit Required. The accounting unit is a shorthand notation representing the variable level number. GLN-OLD-COMPANY-D Derived Old Company Contains the old company derived. GLN-VAR-LEVELS Alpha 30 GL120 GL161 Variable Levels Required field if Lawson General Ledger 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) GL161 GL20.1 Description The company description. GLN-SHORT-DESC Derived Short Description The short description. GLN-CHART-SECTION Alpha 1 GL161 GL20.1 Chart Section The chart section. " " = All Sections 1 = Balance Sheet 2 = Income Statement GLN-CURRENCY-CODE Alpha 5 GL161 GL20.1 Currency Code This field contains the company's base currency code. GLN-PERSON-RESP Alpha 15 (Lower Case) GL161 GL20.1 Person Responsible This field is used to store a name of a 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 GL161 GL20.1 Active Status Required. This field is used to 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 Generate Account Indicates if an account is automatically generated against a group of accounting units. GLN-POSTING-FLAG Alpha 1 GL161 GL20.1 Posting This field is used to indicate posting 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 Posting Derived. GLN-VAR-LEVEL-DISP Alpha 34 GL120 GL161 Variable Level Variable level field in display format. GL20.1 Display GLN-VL-DISP-SHORT Derived Short Display Derived. GLN-LEVEL-DEPTH Numeric 1 GL120 GL161 Level Depth The depth assigned to the accounting 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 GL161 Level Detail Identifies the accounting unit location GL20.1 in the company structure. The value of each variable level determines how the general ledger combines the accounting units. GLN-MY-ZONE Derived My Zone The zone value. GLN-MY-ZONE-GROUP Derived My Zone Group The zone group. GLN-ZONE-EXISTS Derived 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 GL161 Object ID The object ID. GL20.1 GLN-PARENT-OBJ-ID Numeric 12 GL110 GL120 Parent Object ID The parent object ID. GL161 GL20.1 GLN-ADDRESS-EXIST Derived Address Exists Indicates address information exists. 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 AC127 AC130 variable levels. AC191 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 AC87.1 ACBO.1 ACDL.1 ACVW.1 AM05.1 AM06.1 AM06.2 AM09.1 AM115 AM12.1 AM125 AM135 AM145 AM15.1 AM15.2 AM15.3 AM15.4 ... GLNSET2 COMPANY This path is used to retrieve records ACBO.1 AM05.1 VAR-LEVELS by either variable level without an AM06.1 AM06.2 ACCT-UNIT accounting unit, or by accounting unit AM09.1 AM115 under a variable level. AM12.1 AM125 AM135 AM145 KeyChange AM15.1 AM15.2 AM15.3 AM15.4 AM170 AM190 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM255 AM270 AM30.1 AM30.2 AM40.1 AM40.2 AM40.3 ... GLNSET3 VAR-LEVELS KeyChange, Subset CA110 FB95.1 COMPANY Where POSTING-FLAG = "P" FB95.2 FB95.3 ACCT-UNIT FB95.4 FB95.5 FB95.6 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 ... GLNSET4 COMPANY KeyChange GL190 GL199 LEVEL-DEPTH ACCT-UNIT GLNSET5 COMPANY KeyChange FB95.1 FB95.2 LEVEL-DEPTH FB95.3 FB95.4 VAR-LEVELS FB95.5 FB95.6 ACCT-UNIT 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 ... GLNSET6 OBJ-ID AC121 AC123 AC127 AC130 AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2 AC30.3 AC32.1 ACBO.1 ACVW.1 CA10.1 CA10.5 CA10.8 CA110 FB100 FB101 FB141 FB20.1 FB20.6 FB20.7 FB21.1 FB700 FB95.1 FB95.2 FB95.3 FB95.4 ... GLNSET7 PARENT-OBJ-ID KeyChange COMPANY ACCT-UNIT GLNAMES FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Company GLSYSTEM Required GLN-COMPANY -> GLS-COMPANY (GLSSET1) Gladdress GLADDRESS Not Required, Delete Cascades GLN-COMPANY -> GAD-COMPANY GLN-ACCT-UNIT -> GAD-ACCT-UNIT Spaces -> GAD-ADDR-TYPE 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 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 |