 |
Lawson Insight Technical Documentation |
|
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 AC490 AC541 AC542 AC550 ACDL.1
ACVW.1 AM180 AM214 AM220 AM221 AM230
AM240 AM255 AM260 AM267 AM270 AM278
AM280 AM282 AM287 AP125 AP126 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 CB10.1 CB15.1
CB15.2 CB180 CB191 CB20.1 CB30.1 CB500
CB80.1 EE135 EE35.1 EE35.2 EE520 CA05.1
CA10.1 CA10.2 CA10.5 CA10.6 CA10.7 CA110
CA205 CA290 DA290 FB100 FB101 FB11.1
FB141 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 IC222 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 MX135 MA41.2 MA43.2 MA61.1
MA70.1 MAI1.1 PO100 PO23.5 POIF.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 SLVW.1 TA147 UK120 WH20.7
FB120 FB121 FB195 GL122 GL141 GLRV.1
MLRV.1 RW299 MX202 MX223
UPDATED BY
GL110 GL120 GL124 GL161 GL20.1 GL721
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLN-COMPANY Numeric 4 GL110 GL124
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
Accounting Unit Required. The accounting unit is a GL20.1
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 GL124
Variable Levels Required 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
Description The company description. GL20.1
GLN-SHORT-DESC Derived
Short Description The short description.
GLN-CHART-SECTION Alpha 1 GL124 GL161
Chart Section The chart section. GL20.1
" " = All Sections
1 = Balance Sheet
2 = Income Statement
GLN-CURRENCY-CODE Alpha 5 GL124 GL161
Currency Code This field contains the company's base GL20.1
currency code.
GLN-PERSON-RESP Alpha 15 (Lower Case) GL124 GL161
Person Responsible This 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
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
Acct Generate Indicates if an account is
automatically generated against a group
of accounting units.
GLN-POSTING-FLAG Alpha 1 GL124 GL161
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
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
Short Display Derived.
GLN-LEVEL-DEPTH Numeric 1 GL120 GL124
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
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
Address Exist Indicates address information exists.
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 GL124
Object ID The object ID. GL161 GL20.1
GLN-PARENT-OBJ-ID Numeric 12 GL110 GL120
Parent Object ID 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 AC490
AC541 AC542
AC550 ACDL.1
ACVW.1 AM180
AM214 AM220
AM221 AM230
AM240 AM255
AM260 AM267
AM270 AM278
...
GLNSET2 COMPANY This path is used to retrieve records ACVW.1 FB11.1
VAR-LEVELS by either variable level without an FB120 FB121
ACCT-UNIT accounting unit, or by accounting unit FB141 FB195
under a variable level. FB211 FB230
FB295 FB296
KeyChange FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL110 GL120
GL122 GL141
GL195 GL230
GL256 GL281
GL290 GL291
GL292 GL293
GL294 GL296
...
GLNSET3 VAR-LEVELS KeyChange, Subset CA110 FB11.1
COMPANY Where POSTING-FLAG = "P" FB211 FB296
ACCT-UNIT 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 GL96.3
...
GLNSET4 COMPANY KeyChange GL190 GL196
LEVEL-DEPTH GL199
ACCT-UNIT
GLNSET5 COMPANY KeyChange FB11.1 FB211
LEVEL-DEPTH FB296 FB95.1
VAR-LEVELS FB95.2 FB95.3
ACCT-UNIT 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 GL96.4
...
GLNSET6 OBJ-ID AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC34.1
AC35.1 AC36.1
AC490 ACVW.1
AM180 AM214
AM220 AM221
AM230 AM240
AM255 AM260
AM267 AM270
AM278 AM280
AM282 AM287
CA10.1 CA10.5
...
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
|