FBSPREADAU – Budget Spread Code Audit

System
General Ledger (GL)
Prefix
FSA
Primary key
COMPANY, FISCAL-YEAR, SPREAD-CODE, ACTION, DATE, TIME, UNIQUE-I-D
Fields
13
Updated by
40 programs
Referenced by
109 programs

FBSPREADAU is the Budget Spread Code Audit table in Lawson General Ledger (prefix FSA). It is indexed by COMPANY, FISCAL-YEAR, SPREAD-CODE, ACTION, DATE, TIME, UNIQUE-I-D (FSASET1); alternate indexes: FSASET2, FSASET3, FSASET4 and FSAUID. It is related 1:1 to FBSPREAD. 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 13 fields, 5 indexes and 1 documented relation.

About FBSPREADAU

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
FSA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
FSA-COMPANY PK
COMPANY		Numeric 4—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FSA-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FSA-SPREAD-CODE PK
SPREAD_CODE		Alpha 3—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FSA-ACTION PK
ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FSA-OPERATOR
OPERATOR		Alpha 10—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FSA-DATE PK
DATE		Numeric 8 (yyyymmdd)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FSA-TIME PK
TIME		Numeric 6 (hhmmss)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FSA-PROGRAM
PROGRAM		Alpha 5—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FSA-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FSA-FIELD-ID
FIELD_ID		Numeric 3—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FSA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
FSA-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
FSASET1COMPANY, FISCAL-YEAR, SPREAD-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)
FSASET2OPERATOR, ACTION, DATE, COMPANY, FISCAL-YEAR, SPREAD-CODE, UNIQUE-I-D—
FSASET3ACTION, DATE, COMPANY, FISCAL-YEAR, SPREAD-CODE, UNIQUE-I-D—
FSASET4DATE, COMPANY, ACTION, FISCAL-YEAR, SPREAD-CODE, UNIQUE-I-DFB305
FSAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
FbspreadFBSPREADRequiredFSA-COMPANY → FBS-COMPANY (FBSSET1), FSA-FISCAL-YEAR → FBS-FISCAL-YEAR, FSA-SPREAD-CODE → FBS-SPREAD-CODE

Programs

Updated by (40)

Referenced by (109)