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 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
AD50.1 AD90.1 AD95.1 AD96.1 AD97.1 AD97.2
AD97.3 AD98.1 AD98.2 AD98.3 AM135 AM180
AM214 AM220 AM221 AM230 AM240 AM255
AM260 AM267 AM270 AM275 AM278 AM280
AM282 AM287 AP125 AP126 AP131 AP170
AP190 AP193 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP510
AP520 API1.1 API2.1 ARLL.1 BN150 BN66.1
BR41.4 BR44.1 CB10.1 CB15.1 CB15.2 CB150
CB180 CB191 CB20.1 CB222 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
CA05.1 CA10.1 CA10.2 CA10.4 CA10.5 CA10.6
CA10.7 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 FB325
FB40.1 FB40.2 FB40.3 FB45.1 FB60.1 FB95.1
FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 GL100
GL111 GL122 GL135 GL146 GL148 GL165
GL167 GL170 GL190 GL191 GL194 GL195
GL196 GL197 GL199 GL230 GL238 GL240
GL243 GL256 GL281 GL290 GL291 GL292
GL293 GL294 GL295 GL296 GL298 GL299
GL30.2 GL322 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 GL76.1
GL90.1 GL90.4 GL90.6 GL90.7 GL93.1 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
PR521 DR100 IC12.1 IC140 IC141 IC142
IC145 IC222 IC243 IC282 IC330 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 CU00.1 CU01.1
CU01.2 CU02.1 CU02.2 CU03.1 CU10.1 CU10.2
CU20.1 CU20.2 CU20.3 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 GL08.1
GL08.2 GL10.1 GL10.2 GL121 GL123 GL14.8
GL16.4 GL160 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
IFBD.2 IFBO.1 IFEB.1 IFEO.1 IFGT.1 IFOS.1
IFOS.3 IFUC.1 LP130 MA180 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA53.1 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 ML146 ML165 ML167 ML190 ML191
ML195 ML196 ML199 ML240 ML290 ML291
ML292 ML293 ML325 ML327 ML330 ML40.1
ML40.2 ML40.3 ML40.7 ML40.8 ML44.1 ML45.1
ML50.4 ML65.1 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 PA182 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD230 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO135 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO18.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO220 PO222 PO224 PO225 PO229 PO23.1
PO23.5 PO230 PO234 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO251 PO253 PO26.2 PO26.3
PO26.4 PO26.5 PO26.6 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO278
PO28.2 PO280 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
PO536 PO54.5 POCP.1 POD0.1 POI3.1 POID.1
POIF.1 POII.1 POIJ.1 POIK.1 POIM.1 PR128
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 PR36.4 PR37.1 PR38.1 PR45.1 PR529
PR530 PR560 PR582 PR80.1 PR80.4 PR82.1
PR85.1 PR89.1 PRAT.1 UK102 MM280 MM80.1
MM80.2 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQ94.1 RQD0.1 RQIB.1
RQIF.1 RQII.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 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 FB120 FB121 FB195 GL141 GLRV.1
MLRV.1 SNAU.1 RW299 MX135 MX202 MX223


UPDATED BY
GL110 GL120 GL124 GL125 GL161 GL20.1
CA110

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
GLN-CREATED-BY
Element: Operator
Alpha 10
GL124 GL161
GL20.1
GLN-LAST-UPDT-DATE
Element: Date
Numeric 8 (yyyymmdd)
GL110 GL120
GL124 GL125
GL161 GL20.1
GLN-LAST-UPDT-TIME
Element: Time
Numeric 8
GL120 GL124
GL125 GL161
GL20.1
GLN-LAST-UPDATE-BY
Element: Operator
Alpha 10
GL110 GL120
GL124 GL125
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
Glnamesbod GLNAMESBOD Not Required, Delete Cascades
GLN-COMPANY->YBX-COMPANY
GLN-ACCT-UNIT->YBX-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 02:20:45 2016

Home
Contact Us



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