FBDETAILAU – Budget Detail Audit

System
General Ledger (GL)
Prefix
FDA
Primary key
COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, ACTION, DATE, TIME, UNIQUE-I-D
Fields
16
Updated by
40 programs
Referenced by
109 programs

FBDETAILAU is the Budget Detail Audit table in Lawson General Ledger (prefix FDA). It is indexed by COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, ACTION, DATE, TIME, UNIQUE-I-D (FDASET1); alternate indexes: FDASET2, FDASET3, FDASET4, FDASET5 and FDAUID. It is related 1:1 to FBDETAIL. 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 16 fields, 6 indexes and 1 documented relation.

About FBDETAILAU

No description in the Lawson data dictionary.

Fields (16)

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

Field / columnTypeDescription & valuesUpdated by
FDA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
FDA-COMPANY PK
COMPANY		Numeric 4—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-BUDGET-NBR PK
BUDGET_NBR		Numeric 3—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-ACCT-UNIT PK
ACCT_UNIT		Alpha 15—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-ACCOUNT PK
ACCOUNT		Numeric 6—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-ACTION PK
ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-OPERATOR
OPERATOR		Alpha 10—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-DATE PK
DATE		Numeric 8 (yyyymmdd)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-TIME PK
TIME		Numeric 6 (hhmmss)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-PROGRAM
PROGRAM		Alpha 5—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-FIELD-ID
FIELD_ID		Numeric 3—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FDA-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
FDASET1COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, ACTION, DATE, TIME, UNIQUE-I-DPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
FDASET2COMPANY, BUDGET-NBR, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, ACTION, DATE, TIME, UNIQUE-I-D—
FDASET3OPERATOR, ACTION, DATE, COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, UNIQUE-I-D—
FDASET4ACTION, DATE, COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, UNIQUE-I-D—
FDASET5DATE, COMPANY, ACTION, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, UNIQUE-I-DFB305
FDAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
FbdetailFBDETAILRequiredFDA-COMPANY → FBD-COMPANY (FBDSET1), FDA-FISCAL-YEAR → FBD-FISCAL-YEAR, FDA-BUDGET-NBR → FBD-BUDGET-NBR, FDA-ACCT-UNIT → FBD-ACCT-UNIT, FDA-ACCOUNT → FBD-ACCOUNT, FDA-SUB-ACCOUNT → FBD-SUB-ACCOUNT

Programs

Updated by (40)

Referenced by (109)