FBCNTRLAU – Budget Journal Control Audit

System
General Ledger (GL)
Prefix
FCA
Primary key
COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP, ACTION, DATE, TIME, UNIQUE-I-D
Fields
15
Updated by
40 programs
Referenced by
109 programs

FBCNTRLAU is the Budget Journal Control Audit table in Lawson General Ledger (prefix FCA). It is indexed by COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP, ACTION, DATE, TIME, UNIQUE-I-D (FCASET1); alternate indexes: FCASET2, FCASET3, FCASET4, FCASET5 and FCAUID. It is related 1:1 to FBCONTROL. 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 15 fields, 6 indexes and 1 documented relation.

About FBCNTRLAU

No description in the Lawson data dictionary.

Fields (15)

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

Field / columnTypeDescription & valuesUpdated by
FCA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
FCA-COMPANY PK
COMPANY		Numeric 4—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-BUDGET-NBR PK
BUDGET_NBR		Numeric 3—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-JE-TYPE PK
JE_TYPE		Alpha 1—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-CONTROL-GROUP PK
CONTROL_GROUP		Numeric 8—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-ACTION PK
ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-OPERATOR
OPERATOR		Alpha 10—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-DATE PK
DATE		Numeric 8 (yyyymmdd)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-TIME PK
TIME		Numeric 6 (hhmmss)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-PROGRAM
PROGRAM		Alpha 5—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-FIELD-ID
FIELD_ID		Numeric 3—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FCA-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more

Indexes (6)

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

IndexKeysFlagsConditionUsed in
FCASET1COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP, ACTION, DATE, TIME, UNIQUE-I-DPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
FCASET2COMPANY, FISCAL-YEAR, JE-TYPE, CONTROL-GROUP, BUDGET-NBR, ACTION, DATE, TIME, UNIQUE-I-D—
FCASET3OPERATOR, ACTION, DATE, COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP, UNIQUE-I-D—
FCASET4ACTION, DATE, COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP, UNIQUE-I-D—
FCASET5DATE, COMPANY, ACTION, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP, UNIQUE-I-DFB305
FCAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
FbcontrolFBCONTROLRequiredFCA-COMPANY → FLC-COMPANY (FLCSET1), FCA-FISCAL-YEAR → FLC-FISCAL-YEAR, FCA-BUDGET-NBR → FLC-BUDGET-NBR, FCA-JE-TYPE → FLC-JE-TYPE, FCA-CONTROL-GROUP → FLC-CONTROL-GROUP

Programs

Updated by (40)

Referenced by (109)