ACHSTDTBOD – No description in the Lawson data dictionary
- System
- Activity Management (AC)
- Prefix
YAL- Primary key
OBJ-ID,LINE-NBR- Fields
- 8
- Updated by
- 1 program
- Referenced by
- 0 programs
ACHSTDTBOD is a Lawson Activity Management table (prefix YAL); no description in the lawson data dictionary. It is indexed by OBJ-ID, LINE-NBR (YALSET1); alternate indexes: YALSET2. It is related 1:1 to ACHISTDTL. It is updated by BRBD.1. The table has 8 fields, 2 indexes and 1 documented relation.
About ACHSTDTBOD
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the YAL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
YAL-OBJ-ID PKOBJ_ID | Numeric 12 | — | BRBD.1 |
YAL-LINE-NBR PKLINE_NBR | Numeric 6 | — | BRBD.1 |
YAL-BOD-ACCT-ENTBOD_ACCT_ENT | Alpha 22 (Lower Case) | — | BRBD.1 |
YAL-BOD-LOCATIONBOD_LOCATION | Alpha 22 (Lower Case) | — | BRBD.1 |
YAL-BOD-DOC-IDBOD_DOC_ID | Alpha 100 (Lower Case) | — | BRBD.1 |
YAL-BOD-SORBOD_SOR | Alpha 1 | — | BRBD.1 |
YAL-BOD-REVISIONBOD_REVISION | Alpha 22 (Lower Case) | — | BRBD.1 |
YAL-BOD-VAR-IDBOD_VAR_ID | Alpha 22 (Lower Case) | — | BRBD.1 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
YALSET1 | OBJ-ID, LINE-NBR | Primary | BRBD.1 | |
YALSET2 | BOD-DOC-ID, BOD-ACCT-ENT, BOD-LOCATION, BOD-REVISION | BRBD.1, BRBD.2 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Achistdtl | ACHISTDTL | Required | YAL-OBJ-ID → HDT-OBJ-ID, YAL-LINE-NBR → HDT-LINE-NBR |
Programs
Updated by (1)
- BRBD.1 BR BOD Maintenance