GLCLSAUDIT – GL Closing Audit

System: General Ledger (GL)
Prefix: GCA
Primary key: COMPANY, FISCAL-YEAR, ACCT-PERIOD, CLOSE-SEQ
Fields: 7
Updated by: 3 programs
Referenced by: 0 programs

GLCLSAUDIT is the GL Closing Audit table in Lawson General Ledger (prefix GCA). It is indexed by COMPANY, FISCAL-YEAR, ACCT-PERIOD, CLOSE-SEQ (GCASET1). It is related 1:1 to GLSYSTEM and 1:M to GLCONTROL. It is updated by GL110, GL199 and GL500. The table has 7 fields, 1 index and 2 documented relations.

About GLCLSAUDIT

No description in the Lawson data dictionary.

Fields (7)

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

Field / column	Type	Description & values	Updated by
`GCA-COMPANY` PK COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	GL199, GL500
`GCA-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	Contains the fiscal year for the data stored on this record.	GL199, GL500
`GCA-ACCT-PERIOD` PK ACCT_PERIOD	Numeric 2	This is the current accounting period. This field is updated by GL199 (Period Closing).	GL199, GL500
`GCA-CLOSE-SEQ` PK CLOSE_SEQ	Numeric 2	The General Ledger close sequence.	GL199, GL500
`GCA-CLOSE-DATE` CLOSE_DATE	Numeric 8 (yyyymmdd)	The General Ledger period close date.	GL199, GL500
`GCA-CLOSE-TIME` CLOSE_TIME	Numeric 6 (hhmmss)	The General Ledger period close time.	GL199, GL500
`GCA-PER-END-CODE` PER_END_CODE	Alpha 1	The General Ledger period closing option. `L` Limited `F` Final	GL199, GL500

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`GCASET1`	`COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `CLOSE-SEQ`	Primary		GL110, GL199, GL500

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	GLSYSTEM	Required		`GCA-COMPANY` → `GLS-COMPANY`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Glcontrol	GLCONTROL			`GCA-COMPANY` → `GLC-COMPANY`, `GCA-FISCAL-YEAR` → `GLC-FISCAL-YEAR`, `GCA-ACCT-PERIOD` → `GLC-ACCT-PERIOD`, `GCA-CLOSE-SEQ` → `GLC-CLOSE-SEQ`, → `GLC-SYSTEM`, → `GLC-JE-TYPE`, → `GLC-CONTROL-GROUP`, → `GLC-JE-SEQUENCE`

Programs

Updated by (3)

GL110 Company Copy Delete
GL199 Period Closing
GL500 Fiscal Year Change