Lawson Insight Technical Documentation |
|
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
AC541 AC542 AC550 ACDL.1 ACVW.1 AM180
AM214 AM220 AM221 AM230 AM240 AM255
AM260 AM267 AM270 AM278 AM280 AM282
AM287 AP125 AP126 AP131 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 BR41.4 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 CA195 CA205 CA290 FB100 FB101
FB11.1 FB111 FB141 FB145 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 ZR621 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
IFAC.1 IFAU.1 IFBO.1 IFEO.1 IFGT.1 IFOS.1
IFOS.3 MA180 MA41.2 MA41.7 MA43.1 MA43.2
MA43.3 MA43.9 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 PO100 PO101
PO122 PO131 PO135 PO150 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO23.5 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 POCP.1 POD0.1 POI3.1
POID.1 POIF.1 POII.1 POIJ.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 UK560 MM280 MM80.1 MM80.2 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ140
RQ300 RQ35.1 RQ40.1 RQ41.1 RQ42.1 RQ44.1
RQ44.2 RQ500 RQD0.1 RQIE.1 RQIF.1 SL40.4
SLVW.1 TA147 UK120 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 GL721
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 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 AC37.1
AC40.4 AC41.4
AC42.1 AC490
AC541 AC542
AC550 ACDL.1
ACVW.1 AM180
AM214 AM220
AM221 AM230
AM240 AM255
...
GLNSET2 COMPANY This path is used to retrieve records AC191 ACVW.1
VAR-LEVELS by either variable level without an AP125 AP126
ACCT-UNIT accounting unit, or by accounting unit AP20.1 AP20.2
under a variable level. AP20.3 AP20.4
AP20.5 AP20.7
KeyChange AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 FB11.1
FB111 FB120
FB121 FB141
FB195 FB211
FB230 FB295
FB296 FB95.1
FB95.2 FB95.3
...
GLNSET3 VAR-LEVELS KeyChange, Subset CA110 FB11.1
COMPANY Where POSTING-FLAG = "P" FB111 FB211
ACCT-UNIT FB296 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
...
GLNSET4 COMPANY KeyChange GL190 GL196
LEVEL-DEPTH GL199
ACCT-UNIT
GLNSET5 COMPANY KeyChange FB11.1 FB111
LEVEL-DEPTH FB211 FB296
VAR-LEVELS FB95.1 FB95.2
ACCT-UNIT 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
...
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
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
|