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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#CFB-CALENDAR-NAME PKCALENDAR_NAME | Alpha 12 | — | ACBD.1 |
#CFB-FISCAL-YEAR PKFISCAL_YEAR | Numeric 4 | — | ACBD.1 |
#CFB-PERIOD PKPERIOD | Numeric 2 | — | ACBD.1 |
#CFB-PER-END-DATEPER_END_DATE | Numeric 8 (yyyymmdd) | — | — |
#CFB-BOD-ACCT-ENT SET2BOD_ACCT_ENT | Alpha 22 (Lower Case) | — | ACBD.1 |
#CFB-BOD-LOCATION SET2BOD_LOCATION | Alpha 22 (Lower Case) | — | ACBD.1 |
#CFB-BOD-DOC-ID SET2BOD_DOC_ID | Alpha 100 (Lower Case) | — | ACBD.1 |
#CFB-BOD-SORBOD_SOR | Alpha 1 | — | ACBD.1 |
#CFB-BOD-REVISION SET2BOD_REVISION | Alpha 22 (Lower Case) | — | ACBD.1 |
#CFB-BOD-VAR-IDBOD_VAR_ID | Alpha 22 (Lower Case) | — | ACBD.1 |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CFBSET1 |
| Primary | AC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +13 more | |
CFBSET2 |
| ACBD.1, ACBD.2 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Accalx | ACCALX | Required |
|
Programs
Updated by (1)
- ACBD.1 AC BOD Maintenance
Referenced by (19)
- AC00.1 Activity Group
- AC00.2 Calendar
- AC00.3 Activity Group Purge Status
- AC02.1 Status
- AC05.2 Account Category Group
- AC05.3 Account Category Mass Addition
- AC08.1 Category Structure
- AC08.2 Define Category Structure
- AC08.3 Account Category Detail
- AC08.4 Copy Category Structure
- AC08.5 Account Category Load
- AC08.6 Move Summary Account Category
- AC08.7 Move Detail Account Category
- AC10.1 Activity
- AC20.1 Life Only Budget
- AC20.2 Annual Budget
- AC20.3 Period Budget
- AC20.4 Activity Budgets by Activity
- AC20.5 Activity Budgets by Account Category