GLNAMES

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
AM180 AP131 AP170 AP190 AP193 AP30.2
AP30.4 AP520 BN150 BN66.1 CB10.1 CB15.1
CB15.2 CB150 CB180 CB191 CB20.1 CB30.1
CB45.1 CB46.1 CB50.1 CB500 CB543 CB544
CB55.1 CB554 CB80.1 CB82.1 EE135 EE35.1
EE35.2 EE520 CA05.1 CA190 CA195 CA205
CA290 FB100 FB101 FB145 FB190 FB20.1
FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB231
FB235 FB30.1 FB31.1 FB325 FB40.1 FB40.2
FB40.3 FB45.1 GL100 GL135 GL146 GL165
GL167 GL170 GL197 GL238 GL240 GL243
GL295 GL322 GL325 GL327 GL330 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL43.1 GL44.1
GL45.1 GL500 GL55.1 GL65.1 GL70.1 GL70.2
GL70.3 GL70.5 GL70.6 GL75.1 GL76.1 GL93.1
GLSR.1 RW00.1 RW10.2 RW10.3 RW10.4 RW10.6
RW10.7 RW20.5 RW20.6 RW230 RW270 RW30.1
RW60.1 RW60.4 RW70.1 HCDL.1 HCHP.1 PR521
EX175 EX542 EX545 EXI2.1 EXI4.1 GL00.2
GL00.3 GL00.6 GL00.7 GL00.9 GL02.1 GL02.2
GL02.3 GL02.6 GL03.6 GL08.1 GL08.2 GL123
GL14.8 GL16.4 GL160 GL162 GL208 GL21.2
GL21.1 GL210 GL221 GL222 GL223 GL225
GL23.1 GL24.1 GL62.1 GLOP.1 IFEB.1 IFEO.1
IFGT.1 IFOS.1 IFOS.3 IFUC.1 LP130 LP140
PA182 PO136 PO190 PO300 PO520 POCP.1
POI3.1 POIF.1 POII.1 POIJ.1 POIM.1 PR128
PR130 PR131 PR132 PR134 PR135 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
PR35.9 PR36.1 PR37.1 PR38.1 PR45.1 PR529
PR530 PR560 PR582 PR80.1 PR80.4 PR82.1
PR85.1 PR89.1 UK102 UK330 UK560 MM280
SL40.4 SN60.2 SN70.2 SNFL.1 SNOA.1 SNRA.1
SNSA.1 TA147 RW299 MX135 MX202 MX223


UPDATED BY
GL110 GL120 GL124 GL125 GL161 GL20.1
GL20.5 GL20.9 ACVW.1 AM214 AM220 AM221
AM230 AM240 AM255 AM260 AM267 AM270
AM278 AM280 AM282 AM287 AP125 AP126
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
API1.1 API2.1 CA10.1 CA10.7 CA110 FB11.1
FB111 FB141 FB160 FB211 FB215 FB220
FB230 FB295 FB296 FB60.1 FB95.1 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 GL122 GL148
GL190 GL191 GL195 GL196 GL199 GL230
GL256 GL281 GL290 GL291 GL292 GL293
GL294 GL296 GL298 GL299 GL30.2 GL50.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
RW100 RW80.1 HGLN.1 GL10.1 GL121 GL220
GL61.1 GLAV.1 GLBL.1 GLCV.1 GLVW.1 IF20.2
IFAC.1 IFAU.1 IFBO.1 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MAI1.1 SLVW.1 SNGL.1 SNOD.1 FB120 FB121
FB195 GL141 GLRV.1 MLRV.1 SNAU.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLN-COMPANY
Element: Company
Numeric 4
Required. The identifier of the highest level entity throughout all Lawson applications. Must be defined in the GLSYSTEM file.
GL110 GL124
GL161 GL20.1
GLN-ACCT-UNIT
Element: Accounting Unit
Alpha 15
Required. The accounting unit is a shorthand notation representing the variable level number.
GL124 GL161
GL20.1
GLN-OLD-COMPANY-D
Element: Old Company
Derived
Contains the old company derived.
GLN-VAR-LEVELS
Element: Variable Levels
Alpha 30
Required field if Lawson General Ledger 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.
GL120 GL124
GL161 GL20.1
GLN-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The company description.
GL124 GL161
GL20.1
GLN-SHORT-DESC
Element: Short Description
Derived
The short description.
GLN-CHART-SECTION
Element: Chart Section
Alpha 1
The chart section.
" " = All Sections
1 = Balance Sheet
2 = Income Statement
GL124 GL161
GL20.1
GLN-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company's base currency code.
GL124 GL125
GL161 GL20.1
GLN-PERSON-RESP
Element: Person Responsible
Alpha 15 (Lower Case)
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.
GL124 GL125
GL161 GL20.1
GLN-ACTIVE-STATUS
Element: Active Status
Alpha 1
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
GL124 GL125
GL161 GL20.1
GLN-ACCT-GENERATE
Element: Ac Usage
Alpha 1
Indicates if an account is automatically generated against a group of accounting units.
GLN-POSTING-FLAG
Element: Posting Flag
Alpha 1
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
GL124 GL161
GL20.1
GLN-POSTING-FLG-1
Element: Posting Flg 1
Derived
Derived.
GLN-VAR-LEVEL-DISP
Variable Level
Display
Alpha 34
Variable level field in display format.
GL120 GL124
GL161 GL20.1
GLN-VL-DISP-SHORT
Element: Short Display
Derived
Derived.
GLN-LEVEL-DEPTH
Element: Level Depth
Numeric 1
The depth assigned to the accounting unit.
1 = Level 1
2 = Level 2
3 = Level 3
4 = Level 4
5 = Level 5
GL120 GL124
GL161 GL20.1
GLN-LEVEL-DETAIL
Element: Level Detail
Numeric 15 Occurs 5 Times
Identifies the accounting unit location in the company structure. The value of each variable level determines how the general ledger combines the accounting units.
GL120 GL124
GL161 GL20.1
GLN-ADDRESS-EXIST
Element: Address Exist
Derived
Indicates address information exists.
GLN-MY-ZONE
Element: My Zone
Derived
The zone value.
GLN-MY-ZONE-GROUP
Element: My Zone Group
Derived
The zone group.
GLN-ZONE-EXISTS
Element: Zone Exists
Derived
Indicates company zone balancing exists.
GLN-OBJ-TYPE-ACCTU
Object Type
Accounting Unit
Derived
The accounting unit object type.
GLN-OBJ-ID
Element: Object ID
Numeric 12
The object ID.
GL110 GL124
GL161 GL20.1
GLN-PARENT-OBJ-ID
Element: Parent Object ID
Numeric 12
The parent object ID.
GL110 GL120
GL124 GL161
GL20.1


GLNAMES FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLNSET1 COMPANY
ACCT-UNIT
...
ACVW.1 AM180
AM214 AM220
AM221 AM230
AM240 AM255
AM260 AM267
AM270 AM278
AM280 AM282
AM287 AP125
AP126 AP131
AP170 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
GLNSET2 COMPANY
VAR-LEVELS
ACCT-UNIT
KeyChange
...
ACVW.1 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 CA110
FB11.1 FB111
FB120 FB121
FB141 FB160
FB195 FB211
FB215 FB220
FB230 FB295
GLNSET3 VAR-LEVELS
COMPANY
ACCT-UNIT
KeyChange, Subset
WherePOSTING-FLAG ="P"
...
CA110 FB11.1
FB111 FB160
FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 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
GLNSET4 COMPANY
LEVEL-DEPTH
ACCT-UNIT
KeyChange
GL148 GL190
GL196 GL199
GLNSET5 COMPANY
LEVEL-DEPTH
VAR-LEVELS
ACCT-UNIT
KeyChange
...
FB11.1 FB111
FB160 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL299
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
GLNSET6 OBJ-ID
...
ACVW.1 AM180
AM214 AM220
AM221 AM230
AM240 AM255
AM260 AM267
AM270 AM278
AM280 AM282
AM287 CA10.1
CA10.5 CA10.7
CA110 FB100
FB101 FB11.1
FB111 FB141
FB160 FB20.1
FB20.6 FB20.7
FB21.1 FB211
GLNSET7 PARENT-OBJ-ID
COMPANY
ACCT-UNIT
KeyChange


GLNAMES FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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
Acctunitaudit GLNAMESAU
GLN-COMPANY->GNA-COMPANY
GLN-ACCT-UNIT->GNA-ACCT-UNIT
  GNA-ACTION
  GNA-DATE
  GNA-TIME
  GNA-UNIQUE-I-D
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


File created: Wed Jun 08 20:49:45 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.