GLESACCT – General Ledger Error Suspense

System
General Ledger Setup (IF)
Prefix
ESA
Primary key
CHART-NAME, SYSTEM
Fields
4
Updated by
1 program
Referenced by
38 programs

GLESACCT is the General Ledger Error Suspense table in Lawson General Ledger Setup (prefix ESA). It is indexed by CHART-NAME, SYSTEM (ESASET1). It is related 1:1 to GLCHART, GLCHARTDTL and GLCHARTSUM. It is updated by GL03.3 and referenced by FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL00.7, GL135 and 30 more. The table has 4 fields, 1 index and 3 documented relations.

About GLESACCT

This file contains error suspense account records defined for each system (Lawson or non-Lawson) that interfaces with the General Ledger system.

Fields (4)

Column = COBOL field name without the ESA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ESA-CHART-NAME PK
CHART_NAME		Alpha 12This is the name assigned to the chart of accounts when you defined your company structure in the Lawson General Ledger system.GL03.3
#ESA-SYSTEM PK
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)GL03.3
#ESA-ES-ACCOUNT
ES_ACCOUNT		Numeric 6The error suspense account number.GL03.3
#ESA-ES-SUB-ACCT
ES_SUB_ACCT		Numeric 4The error suspense subaccount number.GL03.3

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ESASET1
  1. CHART-NAME
  2. SYSTEM
PrimaryFB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL135, GL146 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLCHARTGLCHARTDTLGLCHARTSUMGLESACCT

One to one (3) — lookups and parents

RelationTableRulesConditionField map
GlchartGLCHARTRequired
ESA-CHART-NAME→GCH-CHART-NAME
GlchartdtlGLCHARTDTLRequired
ESA-CHART-NAME→GDT-CHART-NAME
ESA-ES-ACCOUNT→GDT-ACCOUNT
ESA-ES-SUB-ACCT→GDT-SUB-ACCOUNT
GlchartsumGLCHARTSUMRequired
ESA-CHART-NAME→GCS-CHART-NAME
GDT-SUMRY-ACCT-ID→GCS-SUMRY-ACCT-ID

Programs

Updated by (1)

Referenced by (38)