GLMASTERAU – Account Master Audit

System
General Ledger Setup (IF)
Prefix
GLK
Primary key
COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, ACTION, DATE, TIME, UNIQUE-I-D
Fields
15
Updated by
114 programs
Referenced by
2 programs

GLMASTERAU is the Account Master Audit table in Lawson General Ledger Setup (prefix GLK). It is indexed by COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, ACTION, DATE, TIME, UNIQUE-I-D (GLKSET1); alternate indexes: GLKSET2, GLKSET3, GLKSET4, GLKSET5 and GLKUID. It is updated by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 106 more and referenced by GL278 and GL91.7. The table has 15 fields, 6 indexes and 0 documented relations.

About GLMASTERAU

No description in the Lawson data dictionary.

Fields (15)

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

Field / columnTypeDescription & valuesUpdated by
GLK-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
GLK-COMPANY PK
COMPANY		Numeric 4—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-ACCT-UNIT PK
ACCT_UNIT		Alpha 15—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-ACCOUNT PK
ACCOUNT		Numeric 6—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-ACTION PK
ACTION		Alpha 1—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-OPERATOR
OPERATOR		Alpha 10—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-DATE PK
DATE		Numeric 8 (yyyymmdd)—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-TIME PK
TIME		Numeric 6 (hhmmss)—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-PROGRAM
PROGRAM		Alpha 5—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-FIELD-NAME
FIELD_NAME		Alpha 15—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-FIELD-ID
FIELD_ID		Numeric 3—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-OLD-VALUE
OLD_VALUE		Alpha 20—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GLK-CHART-NAME
CHART_NAME		Alpha 60 (Lower Case)——

Indexes (6)

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

IndexKeysFlagsConditionUsed in
GLKSET1COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, ACTION, DATE, TIME, UNIQUE-I-DPrimaryGL278, GL305, GL91.7
GLKSET2COMPANY, FIELD-NAME, ACTION, DATE, TIME, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, UNIQUE-I-DGL278
GLKSET3COMPANY, OPERATOR, ACCOUNT, SUB-ACCOUNT, ACTION, ACCT-UNIT, DATE, TIME, UNIQUE-I-DGL278
GLKSET4COMPANY, DATE, TIME, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, UNIQUE-I-DGL278, GL305
GLKSET5COMPANY, ACCOUNT, SUB-ACCOUNT, ACTION, OPERATOR, DATE, TIME, UNIQUE-I-DGL278
GLKUIDUNIQUE-I-D—

Programs

Updated by (114)

Referenced by (2)