GLACCTREL – GL Account Relationships

System
General Ledger Setup (IF)
Prefix
GAR
Primary key
OLD-ACCT-NBR
Fields
4
Updated by
2 programs
Referenced by
23 programs

GLACCTREL is the GL Account Relationships table in Lawson General Ledger Setup (prefix GAR). It is indexed by OLD-ACCT-NBR (GARSET1). It is related 1:M to GLCHARTDTL and GLMASTER. It is updated by GL09.1 and GL09.2 and referenced by AC527, CA160, CA60.1, FB165, FB195, FB265, FB65.1, GL162 and 15 more. The table has 4 fields, 1 index and 2 documented relations.

About GLACCTREL

This file contains the information needed to create the Lawson accounts when converting from non-Lawson systems.

Fields (4)

Column = COBOL field name without the GAR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GAR-OLD-ACCT-NBR PK
OLD_ACCT_NBR		Alpha 25This is the old account structure to be associated with the new account/subaccount within the Lawson system.GL09.1, GL09.2
GAR-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.GL09.1, GL09.2
GAR-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored.GL09.1, GL09.2
GAR-OLD-ACCT-SHORT
OLD_ACCT_SHORT		DerivedThe short description.—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GARSET1OLD-ACCT-NBRPrimaryAC527, CA160, CA60.1, FB165, FB195, FB265, FB65.1, GL165 +17 more

Relations

One to many (2) — child tables

RelationTableRulesConditionField map
GlchartdtlGLCHARTDTLGAR-ACCOUNT → GDT-ACCOUNT, GAR-SUB-ACCOUNT → GDT-SUB-ACCOUNT, → GDT-CHART-NAME, → GDT-SUMRY-ACCT-ID
GlmasterGLMASTERGAR-ACCOUNT → GLM-ACCOUNT, GAR-SUB-ACCOUNT → GLM-SUB-ACCOUNT, → GLM-VAR-LEVELS, → GLM-COMPANY, → GLM-ACCT-UNIT

Programs

Updated by (2)

Referenced by (23)