 |
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 AC30.2 AC30.3 AC32.1
AC34.1 AC35.1 AC36.1 AC490 AC550 AC750
ACDL.1 ACVW.1 AM180 AM220 AM221 AM230
AM240 AM255 AM260 AM270 AM278 AM280
AM282 AP30.2 AP30.4 AP32.2 CB10.1 CB15.1
CB15.2 CB20.1 CB500 CA05.1 CA10.1 CA10.2
CA10.5 CA10.6 CA10.7 CA110 CA205 CA290
FB100 FB101 FB141 FB20.1 FB20.3 FB20.4
FB20.6 FB20.7 FB21.1 FB220 FB230 FB231
FB295 FB30.1 FB31.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL135 GL146 GL167
GL190 GL191 GL195 GL196 GL199 GL230
GL238 GL240 GL243 GL256 GL281 GL290
GL291 GL292 GL293 GL294 GL295 GL296
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 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 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
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 IF720 IFAC.1 IFAU.1 IFBO.1 IFEO.1
IFGT.1 IFOS.1 MX135 SLVW.1 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 AC30.2
AC30.3 AC32.1
AC34.1 AC35.1
AC36.1 AC490
AC550 AC750
ACDL.1 ACVW.1
AM180 AM220
AM221 AM230
AM240 AM255
AM260 AM270
AM278 AM280
...
GLNSET2 COMPANY This path is used to retrieve records ACVW.1 FB120
VAR-LEVELS by either variable level without an FB121 FB141
ACCT-UNIT accounting unit, or by accounting unit FB195 FB230
under a variable level. FB295 FB95.1
FB95.2 FB95.3
KeyChange FB95.4 FB95.5
FB95.6 GL110
GL120 GL122
GL141 GL195
GL230 GL256
GL281 GL290
GL291 GL292
GL293 GL294
GL296 GL30.2
GL50.4 GL95.1
...
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
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC30.2 AC30.3
AC32.1 AC34.1
AC35.1 AC36.1
AC490 ACVW.1
AM180 AM220
AM221 AM230
AM240 AM255
AM260 AM270
AM278 AM280
AM282 CA10.1
CA10.5 CA10.7
...
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
|