GLNAMESAU – General Ledger Names Audit

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

GLNAMESAU is the General Ledger Names Audit table in Lawson General Ledger Setup (prefix GNA). It is indexed by COMPANY, ACCT-UNIT, ACTION, DATE, TIME, UNIQUE-I-D (GNASET1); alternate indexes: GNASET2, GNASET3, GNASET4, GNASET5 and GNAUID. It is related 1:1 to GLNAMES and IFDICT. 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.3. The table has 12 fields, 6 indexes and 2 documented relations.

About GLNAMESAU

No description in the Lawson data dictionary.

Fields (12)

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

Field / columnTypeDescription & valuesUpdated by
GNA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
GNA-COMPANY PK
COMPANY		Numeric 4—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GNA-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)
GNA-ACTION PK
ACTION		Alpha 1—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GNA-OPERATOR
OPERATOR		Alpha 10—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GNA-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)
GNA-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)
GNA-PROGRAM
PROGRAM		Alpha 5—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GNA-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)
GNA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
GNA-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)
GNA-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)

Indexes (6)

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

IndexKeysFlagsConditionUsed in
GNASET1COMPANY, ACCT-UNIT, ACTION, DATE, TIME, UNIQUE-I-DPrimaryGL278, GL91.3
GNASET2COMPANY, DATE, TIME, ACTION, ACCT-UNIT, UNIQUE-I-DGL278, GL305
GNASET3COMPANY, OPERATOR, ACTION, ACCT-UNIT, DATE, TIME, UNIQUE-I-DGL278
GNASET4COMPANY, FIELD-NAME, ACTION, DATE, TIME, ACCT-UNIT, UNIQUE-I-DGL278
GNASET5COMPANY, ACTION, DATE, TIME, ACCT-UNIT, UNIQUE-I-DGL278
GNAUIDUNIQUE-I-D—

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
Account UnitGLNAMESRequiredGNA-COMPANY → GLN-COMPANY (GLNSET1), GNA-ACCT-UNIT → GLN-ACCT-UNIT
IfdictIFDICTRequired"GNA" → IFD-DB-FILE, GNA-FIELD-ID → IFD-FLD-NBR

Programs

Updated by (114)

Referenced by (2)