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 / column | Type | Description & values | Updated by |
|---|---|---|---|
YAO-ACTIVITY-GRP PKACTIVITY_GRP | Alpha 15 | — | ACBD.1 |
YAO-ACTIVITY PKACTIVITY | Alpha 15 | — | ACBD.1 |
YAO-ACCT-CATEGORY PKACCT_CATEGORY | Alpha 5 | — | ACBD.1 |
YAO-COMPANY PKCOMPANY | Numeric 4 | — | ACBD.1 |
YAO-ACCT-UNIT PKACCT_UNIT | Alpha 15 | — | ACBD.1 |
YAO-ACCOUNT PKACCOUNT | Numeric 6 | — | ACBD.1 |
YAO-SUB-ACCOUNT PKSUB_ACCOUNT | Numeric 4 | — | ACBD.1 |
YAO-OBJ-ID PKOBJ_ID | Numeric 12 | — | ACBD.1 |
YAO-BOD-ACCT-ENTBOD_ACCT_ENT | Alpha 22 (Lower Case) | — | ACBD.1 |
YAO-BOD-LOCATIONBOD_LOCATION | Alpha 22 (Lower Case) | — | ACBD.1 |
YAO-BOD-DOC-IDBOD_DOC_ID | Alpha 100 (Lower Case) | — | ACBD.1 |
YAO-BOD-SORBOD_SOR | Alpha 1 | — | ACBD.1 |
YAO-BOD-REVISIONBOD_REVISION | Alpha 22 (Lower Case) | — | ACBD.1 |
YAO-BOD-VAR-IDBOD_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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
YAOSET1 | ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, OBJ-ID | Primary | AC750, ACBD.1 | |
YAOSET2 | BOD-DOC-ID, BOD-ACCT-ENT, BOD-LOCATION, BOD-REVISION | ACBD.1, ACBD.2 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Actrans | ACTRANS | Required | YAO-ACTIVITY-GRP → ATN-ACTIVITY-GRP, YAO-ACTIVITY → ATN-ACTIVITY, YAO-ACCT-CATEGORY → ATN-ACCT-CATEGORY, YAO-COMPANY → ATN-COMPANY, YAO-ACCT-UNIT → ATN-ACCT-UNIT, YAO-ACCOUNT → ATN-ACCOUNT, YAO-SUB-ACCOUNT → ATN-SUB-ACCOUNT, YAO-OBJ-ID → ATN-OBJ-ID |
Programs
Updated by (1)
- ACBD.1 AC BOD Maintenance
Referenced by (1)
- AC750 AC shell program for BOD files