CDDBOD – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
CFB
Primary key
CALENDAR-NAME, FISCAL-YEAR, PERIOD
Fields
10
Updated by
1 program
Referenced by
19 programs

CDDBOD is a Lawson Activity Management table (prefix CFB); no description in the lawson data dictionary. It is indexed by CALENDAR-NAME, FISCAL-YEAR, PERIOD (CFBSET1); alternate indexes: CFBSET2. It is related 1:1 to ACCALX. It is updated by ACBD.1 and referenced by AC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 and 11 more. The table has 10 fields, 2 indexes and 1 documented relation.

About CDDBOD

No description in the Lawson data dictionary.

Fields (10)

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

Field / columnTypeDescription & valuesUpdated by
CFB-CALENDAR-NAME PK
CALENDAR_NAME		Alpha 12—ACBD.1
CFB-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4—ACBD.1
CFB-PERIOD PK
PERIOD		Numeric 2—ACBD.1
CFB-PER-END-DATE
PER_END_DATE		Numeric 8 (yyyymmdd)——
CFB-BOD-ACCT-ENT
BOD_ACCT_ENT		Alpha 22 (Lower Case)—ACBD.1
CFB-BOD-LOCATION
BOD_LOCATION		Alpha 22 (Lower Case)—ACBD.1
CFB-BOD-DOC-ID
BOD_DOC_ID		Alpha 100 (Lower Case)—ACBD.1
CFB-BOD-SOR
BOD_SOR		Alpha 1—ACBD.1
CFB-BOD-REVISION
BOD_REVISION		Alpha 22 (Lower Case)—ACBD.1
CFB-BOD-VAR-ID
BOD_VAR_ID		Alpha 22 (Lower Case)—ACBD.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
CFBSET1CALENDAR-NAME, FISCAL-YEAR, PERIODPrimaryAC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +13 more
CFBSET2BOD-DOC-ID, BOD-ACCT-ENT, BOD-LOCATION, BOD-REVISIONACBD.1, ACBD.2

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AccalxACCALXRequiredCFB-CALENDAR-NAME → CDD-CALENDAR-NAME, CFB-FISCAL-YEAR → CDD-FISCAL-YEAR, CFB-PERIOD → CDD-PERIOD

Programs

Updated by (1)

Referenced by (19)