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 / columnTypeDescription & valuesUpdated by
YAL-OBJ-ID PK
OBJ_ID
Numeric 12BRBD.1
YAL-LINE-NBR PK
LINE_NBR
Numeric 6BRBD.1
YAL-BOD-ACCT-ENT
BOD_ACCT_ENT
Alpha 22 (Lower Case)BRBD.1
YAL-BOD-LOCATION
BOD_LOCATION
Alpha 22 (Lower Case)BRBD.1
YAL-BOD-DOC-ID
BOD_DOC_ID
Alpha 100 (Lower Case)BRBD.1
YAL-BOD-SOR
BOD_SOR
Alpha 1BRBD.1
YAL-BOD-REVISION
BOD_REVISION
Alpha 22 (Lower Case)BRBD.1
YAL-BOD-VAR-ID
BOD_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.

IndexKeysFlagsConditionUsed in
YALSET1OBJ-ID, LINE-NBRPrimaryBRBD.1
YALSET2BOD-DOC-ID, BOD-ACCT-ENT, BOD-LOCATION, BOD-REVISIONBRBD.1, BRBD.2

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AchistdtlACHISTDTLRequiredYAL-OBJ-IDHDT-OBJ-ID, YAL-LINE-NBRHDT-LINE-NBR

Programs

Updated by (1)