GLNAMES

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 AC197
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC32.1
AC37.1 AC40.4 AC41.4 AC42.1 AC45.1 AC490
AM180 AP131 AP170 AP190 AP193 AP30.2
AP30.4 AP520 ARLL.1 BN150 BN66.1 BR41.4
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 CB57.1 CB80.1
CB82.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 EE135
EE35.1 EE35.2 EE520 CA195 CA290 FB145
FB190 FB40.1 FB40.2 FB40.3 FB45.1 GL100
GL111 GL146 GL165 GL167 GL170 GL197
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1
GL45.1 GL500 GL65.1 GL70.1 GL70.2 GL70.3
GL70.5 GL70.6 GL75.1 GL76.1 GL93.1 RW10.2
RW10.3 RW10.4 RW10.6 RW10.7 HCDL.1 PR521
IC140 IC282 IC66.1 CU01.1 CU01.2 CU02.1
CU02.2 CU03.1 CU10.1 CU10.2 EX12.1 EX175
EX542 EX545 EXI2.1 EXI4.1 GL00.1 GL00.2
GL00.3 GL00.6 GL00.7 GL00.8 GL00.9 GL02.1
GL02.2 GL02.3 GL02.6 GL03.2 GL03.4 GL03.6
GL160 GL162 IFEB.1 IFGT.1 IFUC.1 MX202
MX223 LP130 MA180 MA530 MA531 MA60.2
MA60.3 MA60.5 MA66.2 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 ML146
ML165 ML240 ML40.1 ML40.2 ML40.3 ML40.7
ML40.8 ML44.1 ML45.1 ML65.1 PA182 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO135 PO136 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO222
PO23.1 PO23.5 PO24.1 PO26.2 PO26.3 PO26.4
PO26.5 PO26.6 PO26.7 PO26.9 PO27.2 PO278
PO28.2 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
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 PO54.5
POCP.1 POD0.1 POI3.1 POID.1 POIF.1 POII.1
POIJ.1 POIK.1 POIM.1 PR128 PR130 PR131
PR132 PR134 PR135 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
PR582 PR80.1 PR80.4 PR82.1 PR85.1 PR89.1
UK102 UK330 UK560 ZP530 MM280 MM80.1
MM80.2 RQ12.1 RQD0.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 WH32.5 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 ZW130 AC34.1 AC35.1
AC36.1 ACDL.1 ACVW.1 ATVW.1 AD120 AD191
AD220 AD290 AD320 AD50.1 AD90.1 AD95.1
AD96.1 AD97.1 AD97.2 AD97.3 AD98.1 AD98.2
AD98.3 AM214 AM282 CA05.1 CA190 CA205
FB100 FB101 FB141 FB20.1 FB20.3 FB20.4
FB20.6 FB20.7 FB21.1 FB215 FB230 FB231
FB235 FB295 FB30.1 FB31.1 FB325 GL135
GL148 GL191 GL195 GL230 GL238 GL240
GL243 GL281 GL294 GL295 GL296 GL30.2
GL322 GL325 GL327 GL330 GL43.1 GL50.4
GL55.1 GLSR.1 RW00.1 RW20.5 RW20.6 RW230
RW270 RW30.1 RW60.1 RW60.4 RW70.1 RW80.1
HCHP.1 HGLN.1 GL08.1 GL08.2 GL121 GL123
GL14.8 GL16.4 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 IFBO.1 IFEO.1 IFOS.1
IFOS.3 ML167 ML190 ML191 ML195 ML196
ML290 ML291 ML292 ML293 ML325 ML327
ML330 ML50.4 ML90.1 ML90.4 ML94.1 ML94.2
ML94.3 ML94.4 ML95.1 ML95.2 ML95.3 ML95.4
ML95.5 ML95.6 ML95.7 ML95.8 ML95.9 ML96.1
ML96.2 ML96.3 ML96.4 ML96.5 ML97.1 ML97.2
ML97.3 ML97.4 ML97.5 ML97.6 ML97.7 ML97.8
ML97.9 ML98.1 ML98.2 ML98.3 ML98.4 ML98.5
ML99.1 ML99.2 ML99.3 ML99.4 ML99.5 ML99.6
MLIT.1 SL40.4 SLVW.1 SN60.2 SN70.2 SNFL.1
SNGL.1 SNOA.1 SNOD.1 SNRA.1 SNSA.1 FB120
FB195 GL141 SNAU.1 RW299 MX135


UPDATED BY
AC191 AM220 AM221 AM230 AM240 AM255
AM260 AM267 AM270 AM275 AM278 AM280
AM287 AP125 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
CB222 CA10.1 CA10.7 CA110 FB11.1 FB111
FB121 FB160 FB211 FB220 FB296 FB60.1
FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
GL110 GL120 GL122 GL190 GL194 GL196
GL199 GL256 GL290 GL291 GL292 GL293
GL298 GL299 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 RW100 DR100 IC141 IC142
IC222 IC83.1 GL10.1 GL124 GL125 GL161
GL20.1 GL20.5 GL20.9 GLRV.1 IFAC.1 IFAU.1
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA44.1 MA44.2 MA61.1 MAI1.1 ML199 MLRV.1
PD230 PO150 PO25.1 PO25.6 PO25.7 PO253
PO536 RQ10.1 RQ10.3 RQ11.1 RQ13.2 RQ35.1
RQ500 RQIB.1 RQIF.1 RQIJ.1 WACP.1 WAOP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLN-COMPANY
Element: Company
Numeric 4
Required. The identifier of the highest level entity throughout all Lawson applications. Must be defined in the GLSYSTEM file.
GL110 GL124
GL161 GL20.1
GLN-ACCT-UNIT
Element: Accounting Unit
Alpha 15
Required. The accounting unit is a shorthand notation representing the variable level number.
GL124 GL161
GL20.1
GLN-OLD-COMPANY-D
Element: Old Company
Derived
Contains the old company derived.
GLN-VAR-LEVELS
Element: Variable Levels
Alpha 30
Required field if Lawson General Ledger 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.
GL120 GL124
GL161 GL20.1
GLN-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The company description.
GL124 GL161
GL20.1
GLN-SHORT-DESC
Element: Short Description
Derived
The short description.
GLN-CHART-SECTION
Element: Chart Section
Alpha 1
The chart section.
" " = All Sections
1 = Balance Sheet
2 = Income Statement
GL124 GL161
GL20.1
GLN-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company's base currency code.
GL124 GL125
GL161 GL20.1
GLN-PERSON-RESP
Element: Person Responsible
Alpha 15 (Lower Case)
This field is used to store a name of a person responsible for an accounting unit. This field is not edited in any way. Used in Lawson's Report Writer.
GL124 GL125
GL161 GL20.1
GLN-ACTIVE-STATUS
Element: Active Status
Alpha 1
Required. This field is used to 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
GL124 GL125
GL161 GL20.1
GLN-ACCT-GENERATE
Element: Ac Usage
Alpha 1
Indicates if an account is automatically generated against a group of accounting units.
GLN-POSTING-FLAG
Element: Posting Flag
Alpha 1
This field is used to indicate posting 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
GL124 GL161
GL20.1
GLN-POSTING-FLG-1
Element: Posting Flg 1
Derived
Derived.
GLN-VAR-LEVEL-DISP
Variable Level
Display
Alpha 34
Variable level field in display format.
GL120 GL124
GL161 GL20.1
GLN-VL-DISP-SHORT
Element: Short Display
Derived
Derived.
GLN-LEVEL-DEPTH
Element: Level Depth
Numeric 1
The depth assigned to the accounting unit.
1 = Level 1
2 = Level 2
3 = Level 3
4 = Level 4
5 = Level 5
GL120 GL124
GL161 GL20.1
GLN-LEVEL-DETAIL
Element: Level Detail
Numeric 15 Occurs 5 Times
Identifies the accounting unit location in the company structure. The value of each variable level determines how the general ledger combines the accounting units.
GL120 GL124
GL161 GL20.1
GLN-ADDRESS-EXIST
Element: Address Exist
Derived
Indicates address information exists.
GLN-MY-ZONE
Element: My Zone
Derived
The zone value.
GLN-MY-ZONE-GROUP
Element: My Zone Group
Derived
The zone group.
GLN-ZONE-EXISTS
Element: Zone Exists
Derived
Indicates company zone balancing exists.
GLN-OBJ-TYPE-ACCTU
Object Type
Accounting Unit
Derived
The accounting unit object type.
GLN-OBJ-ID
Element: Object ID
Numeric 12
The object ID.
GL110 GL124
GL161 GL20.1
GLN-PARENT-OBJ-ID
Element: Parent Object ID
Numeric 12
The parent object ID.
GL110 GL120
GL124 GL161
GL20.1


GLNAMES FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLNSET1 COMPANY
ACCT-UNIT
...
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 AD120
AD191 AD220
AD290 AD320
GLNSET2 COMPANY
VAR-LEVELS
ACCT-UNIT
KeyChange
...
AC191 ACVW.1
ATVW.1 AD120
AP125 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 CB222
CA110 FB11.1
FB111 FB120
FB121 FB141
FB160 FB195
GLNSET3 VAR-LEVELS
COMPANY
ACCT-UNIT
KeyChange, Subset
WherePOSTING-FLAG ="P"
...
FB11.1 FB111
FB160 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL299
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
LEVEL-DEPTH
ACCT-UNIT
KeyChange
GL148 GL190
GL196 GL199
ML190 ML196
ML199
GLNSET5 COMPANY
LEVEL-DEPTH
VAR-LEVELS
ACCT-UNIT
KeyChange
...
FB11.1 FB111
FB160 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL299
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
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
AD191 AD290
AD50.1 AD95.1
AD96.1 AD97.1
AD97.2 AD97.3
AD98.1 AD98.2
AD98.3 AM180
AM214 AM220
GLNSET7 PARENT-OBJ-ID
COMPANY
ACCT-UNIT
KeyChange


GLNAMES FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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
Acctunitaudit GLNAMESAU
GLN-COMPANY->GNA-COMPANY
GLN-ACCT-UNIT->GNA-ACCT-UNIT
  GNA-ACTION
  GNA-DATE
  GNA-TIME
  GNA-UNIQUE-I-D
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


File created: Thu Jun 09 11:18:41 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.