ACTRANSBOD – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
YAO
Primary key
ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, OBJ-ID
Fields
14
Updated by
1 program
Referenced by
1 program

ACTRANSBOD is a Lawson Activity Management table (prefix YAO); no description in the lawson data dictionary. It is indexed by ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, OBJ-ID (YAOSET1); alternate indexes: YAOSET2. It is related 1:1 to ACTRANS. It is updated by ACBD.1 and referenced by AC750. The table has 14 fields, 2 indexes and 1 documented relation.

About ACTRANSBOD

No description in the Lawson data dictionary.

Fields (14)

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

Field / columnTypeDescription & valuesUpdated by
YAO-ACTIVITY-GRP PK
ACTIVITY_GRP
Alpha 15ACBD.1
YAO-ACTIVITY PK
ACTIVITY
Alpha 15ACBD.1
YAO-ACCT-CATEGORY PK
ACCT_CATEGORY
Alpha 5ACBD.1
YAO-COMPANY PK
COMPANY
Numeric 4ACBD.1
YAO-ACCT-UNIT PK
ACCT_UNIT
Alpha 15ACBD.1
YAO-ACCOUNT PK
ACCOUNT
Numeric 6ACBD.1
YAO-SUB-ACCOUNT PK
SUB_ACCOUNT
Numeric 4ACBD.1
YAO-OBJ-ID PK
OBJ_ID
Numeric 12ACBD.1
YAO-BOD-ACCT-ENT
BOD_ACCT_ENT
Alpha 22 (Lower Case)ACBD.1
YAO-BOD-LOCATION
BOD_LOCATION
Alpha 22 (Lower Case)ACBD.1
YAO-BOD-DOC-ID
BOD_DOC_ID
Alpha 100 (Lower Case)ACBD.1
YAO-BOD-SOR
BOD_SOR
Alpha 1ACBD.1
YAO-BOD-REVISION
BOD_REVISION
Alpha 22 (Lower Case)ACBD.1
YAO-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
YAOSET1ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, OBJ-IDPrimaryAC750, ACBD.1
YAOSET2BOD-DOC-ID, BOD-ACCT-ENT, BOD-LOCATION, BOD-REVISIONACBD.1, ACBD.2

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ActransACTRANSRequiredYAO-ACTIVITY-GRPATN-ACTIVITY-GRP, YAO-ACTIVITYATN-ACTIVITY, YAO-ACCT-CATEGORYATN-ACCT-CATEGORY, YAO-COMPANYATN-COMPANY, YAO-ACCT-UNITATN-ACCT-UNIT, YAO-ACCOUNTATN-ACCOUNT, YAO-SUB-ACCOUNTATN-SUB-ACCOUNT, YAO-OBJ-IDATN-OBJ-ID

Programs

Updated by (1)

Referenced by (1)