GLAUDIT – General Ledger Audit
- System
- General Ledger (GL)
- Prefix
GLA- Primary key
COMPANY,ACCT-UNIT,PROCESS-DATE,PROCESS-TIME- Fields
- 13
- Updated by
- 4 programs
- Referenced by
- 0 programs
GLAUDIT is the General Ledger Audit table in Lawson General Ledger (prefix GLA). It is indexed by COMPANY, ACCT-UNIT, PROCESS-DATE, PROCESS-TIME (GLASET1); alternate indexes: GLASET2 and GLASET3. It is related 1:1 to GLNAMES and GLSYSTEM and 1:M to GLMASTER. It is updated by GL110, GL120, GL20.1 and GL24.1. The table has 13 fields, 3 indexes and 3 documented relations.
About GLAUDIT
No description in the Lawson data dictionary.
Fields (13)
Column = COBOL field name without the GLA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GLA-COMPANY PKCOMPANY | Numeric 4 | The company number represents an established General Ledger company. | GL110, GL20.1, GL24.1 |
GLA-ACCT-UNIT PKACCT_UNIT | Alpha 15 | The accounting unit name associated with the move record. | GL20.1, GL24.1 |
GLA-PROCESS-DATE PKPROCESS_DATE | Numeric 8 (yyyymmdd) | The date the record was processed. | GL120, GL20.1, GL24.1 |
GLA-PROCESS-TIME PKPROCESS_TIME | Numeric 6 (hhmmss) | — | GL120, GL20.1, GL24.1 |
GLA-DATE-CHANGEDDATE_CHANGED | Numeric 8 (yyyymmdd) | The system date the record was last changed in GL20 (Accounting Units). | GL20.1, GL24.1 |
GLA-OLD-LEVELSOLD_LEVELS | Alpha 30 | The previous variable level address of the accounting unit. | GL20.1 |
GLA-NEW-LEVELSNEW_LEVELS | Alpha 30 | The new variable level address of the accounting unit. | GL20.1, GL24.1 |
GLA-OBJ-IDOBJ_ID | Numeric 12 | This is the object identifier. It is a unique number assigned to each accounting unit. | GL20.1, GL24.1 |
GLA-PARENT-OBJ-IDPARENT_OBJ_ID | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | GL20.1, GL24.1 |
GLA-NEW-PAR-OBJ-IDNEW_PAR_OBJ_ID | Numeric 12 | The new parent object identifier is used on the reorganization process to identify where the subordinate members will be moved. | GL20.1, GL24.1 |
GLA-LEVEL-DEPTHLEVEL_DEPTH | Numeric 1 | The new variable level depth related to this record. | GL20.1, GL24.1 |
GLA-LEVEL-DETAILLEVEL_DETAIL | Numeric 15 Occurs 5 Times ×5 | The breakdown of the variable levels realted to this record. | GL20.1, GL24.1 |
GLA-MOVED-BY-AUMOVED_BY_AU | Alpha 15 | The accounting unit that initiated the move. | GL20.1 |
Indexes (3)
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 |
|---|---|---|---|---|
GLASET1 | COMPANY, ACCT-UNIT, PROCESS-DATE, PROCESS-TIME | Primary | GL110, GL20.1, GL24.1 | |
GLASET2 | COMPANY, PROCESS-DATE, PROCESS-TIME, ACCT-UNIT | KeyChange | GL120 | |
GLASET3 | COMPANY, NEW-LEVELS, ACCT-UNIT | KeyChange, Subset | Where PROCESS-DATE = Zeroes | GL20.1, GL24.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acct Unit | GLNAMES | Required | GLA-COMPANY → GLN-COMPANY, GLA-ACCT-UNIT → GLN-ACCT-UNIT | |
| Company | GLSYSTEM | Required | GLA-COMPANY → GLS-COMPANY |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Account | GLMASTER | Delete Restricted | GLA-COMPANY → GLM-COMPANY, GLA-ACCT-UNIT → GLM-ACCT-UNIT, GLM-ACCOUNT, GLM-SUB-ACCOUNT |