FBADJCODAU – Budget Adjustment Code Audit

System
General Ledger (GL)
Prefix
FJA
Primary key
ADJ-CODE, ACTION, DATE, TIME, UNIQUE-I-D
Fields
11
Updated by
40 programs
Referenced by
109 programs

FBADJCODAU is the Budget Adjustment Code Audit table in Lawson General Ledger (prefix FJA). It is indexed by ADJ-CODE, ACTION, DATE, TIME, UNIQUE-I-D (FJASET1); alternate indexes: FJASET2, FJASET3, FJASET4 and FJAUID. It is related 1:1 to FBADJCODE. It is updated by CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 and 32 more and referenced by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 101 more. The table has 11 fields, 5 indexes and 1 documented relation.

About FBADJCODAU

No description in the Lawson data dictionary.

Fields (11)

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

Field / columnTypeDescription & valuesUpdated by
FJA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
FJA-ADJ-CODE PK
ADJ_CODE		Alpha 3—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FJA-ACTION PK
ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FJA-OPERATOR
OPERATOR		Alpha 10—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FJA-DATE PK
DATE		Numeric 8 (yyyymmdd)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FJA-TIME PK
TIME		Numeric 6 (hhmmss)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FJA-PROGRAM
PROGRAM		Alpha 5—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FJA-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FJA-FIELD-ID
FIELD_ID		Numeric 3—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FJA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FJA-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more

Indexes (5)

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

IndexKeysFlagsConditionUsed in
FJASET1ADJ-CODE, ACTION, DATE, TIME, UNIQUE-I-DPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
FJASET2OPERATOR, ACTION, DATE, ADJ-CODE, UNIQUE-I-D—
FJASET3ACTION, DATE, ADJ-CODE, UNIQUE-I-D—
FJASET4DATE, ADJ-CODE, ACTION, UNIQUE-I-DFB305
FJAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
FbadjcodeFBADJCODERequiredFJA-ADJ-CODE → FJC-ADJ-CODE (FJCSET1)

Programs

Updated by (40)

Referenced by (109)