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
ACDL.1 ACVW.1 AM180 AM214 AM220 AM221
AM230 AM240 AM255 AM260 AM267 AM270
AM278 AM280 AM282 AM287 AP125 AP126
AP131 AP170 AP193 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 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 BR41.4 BR44.1 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 CA205 CA290 FB100 FB101
FB11.1 FB111 FB141 FB145 FB160 FB190
FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1
FB211 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 HCHP.1 HGLN.1 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 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 MA180
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 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE81.1
OE810 OE830 OE90.1 OE90.2 PA182 PO100
PO101 PO122 PO131 PO135 PO150 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO23.5 PO25.1 PO25.6 PO25.7 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 POCP.1
POI3.1 POID.1 POIE.1 POIF.1 POII.1 POIJ.1
POIM.1 PR128 PR130 PR131 PR132 PR134
PR136 PR137 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
PR82.1 PR85.1 PRSA.1 UK102 UK330 MM280
RQ10.1 RQ10.2 RQ12.1 RQ13.1 RQ13.2 RQ140
RQ300 RQ35.1 RQ40.1 RQ41.1 RQ42.1 RQ44.1
RQ44.2 RQ500 RQIF.1 SL40.4 SLVW.1 TA147
TP135 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
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 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
ACDL.1 ACVW.1
AM180 AM214
AM220 AM221
AM230 AM240
AM255 AM260
AM267 AM270
...
GLNSET2 COMPANY This path is used to retrieve records ACVW.1 FB11.1
VAR-LEVELS by either variable level without an FB111 FB120
ACCT-UNIT accounting unit, or by accounting unit FB121 FB141
under a variable level. FB160 FB195
FB211 FB230
KeyChange FB295 FB296
FB60.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL110
GL120 GL122
GL141 GL195
GL230 GL256
GL281 GL290
GL291 GL292
...
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 AM180
AM214 AM220
AM221 AM230
AM240 AM255
AM260 AM267
AM270 AM278
AM280 AM282
AM287 CA10.1
...
GLNSET7 PARENT-OBJ-ID KeyChange
COMPANY
ACCT-UNIT
GLNSET99 ACCT-UNIT
COMPANY
ACTIVE-STATUS
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
|