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 AC145 AC190 AC191
AC197 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 AC45.1 AC490 ACDL.1 ACVW.1
ATVW.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
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP520
API1.1 API2.1 AR115 AR124 AR190 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1
AR32.1 AR34.1 AR42.1 AR42.2 AR42.7 AR43.1
AR560 AR570 AR575 AR580 ARLL.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 BN150
BN66.1 BR41.4 BR44.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 CXCP.1 EE135 EE35.1
EE35.2 EE520 ET530 ET700 ETI2.1 CA05.1
CA10.1 CA10.2 CA10.5 CA10.6 CA10.7 CA110
CA190 CA195 CA205 CA290 FB100 FB101
FB11.1 FB111 FB141 FB145 FB160 FB190
FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1
FB211 FB215 FB220 FB230 FB231 FB235
FB295 FB296 FB30.1 FB31.1 FB40.1 FB40.2
FB40.3 FB45.1 FB60.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL135 GL146 GL148
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 GL70.1 GL70.2 GL70.3
GL70.5 GL70.6 GL75.1 GL90.1 GL90.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 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 HCDL.1 HCHP.1
HGLN.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 IF20.1 IF20.3
IF20.4 IF20.5 IF20.6 IF20.7 IF20.2 IFAC.1
IFAU.1 IFBO.1 IFEO.1 IFGT.1 IFOS.1 IFOS.3
LP130 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PA182 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD230 PO100
PO101 PO122 PO131 PO135 PO150 PO190
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO23.5 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO253 PO27.2 PO278 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO32.4 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 PR35.9
PR36.1 PR37.1 PR38.1 PR45.1 PR529 PR530
PR560 PR80.1 PR82.1 PR85.1 PR89.1 UK102
UK330 UK560 MM280 MM80.1 MM80.2 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQD0.1 RQIB.1 RQIF.1 RQIJ.1
SL40.4 SLVW.1 SN60.2 SN70.2 SNFL.1 SNGL.1
SNOA.1 SNOD.1 SNRA.1 SNSA.1 TA147 WH130
WH132 WH190 WH20.2 WH20.7 WH222 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 FB120 FB121 FB195
GL122 GL141 GLRV.1 MLRV.1 SNAU.1 RW299
MX135 MX202 MX223
UPDATED BY
GL110 GL120 GL124 GL161 GL20.1
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
GLNAMES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLNSET1 COMPANY AC121 AC123
ACCT-UNIT AC130 AC145
AC190 AC191
AC197 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
AC45.1 AC490
ACDL.1 ACVW.1
ATVW.1 AM180
AM214 AM220
AM221 AM230
...
GLNSET2 COMPANY KeyChange AC191 ACVW.1
VAR-LEVELS ATVW.1 AP125
ACCT-UNIT 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 BR44.1
CA110 FB11.1
FB111 FB120
FB121 FB141
FB160 FB195
FB211 FB230
...
GLNSET3 VAR-LEVELS KeyChange, Subset CA110 FB11.1
COMPANY Where POSTING-FLAG = "P" FB111 FB160
ACCT-UNIT FB211 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL298
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
...
GLNSET4 COMPANY KeyChange GL148 GL190
LEVEL-DEPTH GL196 GL199
ACCT-UNIT
GLNSET5 COMPANY KeyChange FB11.1 FB111
LEVEL-DEPTH FB160 FB211
VAR-LEVELS FB296 FB60.1
ACCT-UNIT FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 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
...
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 ATVW.1
AM180 AM214
AM220 AM221
AM230 AM240
AM255 AM260
AM267 AM270
AM278 AM280
AM282 AM287
...
GLNSET7 PARENT-OBJ-ID KeyChange
COMPANY
ACCT-UNIT
GLNAMES FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 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
|