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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET3 SET5
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 SET2
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 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
GLKSET1
  1. COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. ACTION
  6. DATE
  7. TIME
  8. UNIQUE-I-D
PrimaryGL278, GL305, GL91.7
GLKSET2
  1. COMPANY
  2. FIELD-NAME
  3. ACTION
  4. DATE
  5. TIME
  6. ACCT-UNIT
  7. ACCOUNT
  8. SUB-ACCOUNT
  9. UNIQUE-I-D
GL278
GLKSET3
  1. COMPANY
  2. OPERATOR
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. ACTION
  6. ACCT-UNIT
  7. DATE
  8. TIME
  9. UNIQUE-I-D
GL278
GLKSET4
  1. COMPANY
  2. DATE
  3. TIME
  4. ACCT-UNIT
  5. ACCOUNT
  6. SUB-ACCOUNT
  7. UNIQUE-I-D
GL278, GL305
GLKSET5
  1. COMPANY
  2. ACCOUNT
  3. SUB-ACCOUNT
  4. ACTION
  5. OPERATOR
  6. DATE
  7. TIME
  8. UNIQUE-I-D
GL278
GLKUID
  1. UNIQUE-I-D
—

Programs

Updated by (114)

Referenced by (2)