ACIAACVDIM – No description in the Lawson data dictionary
- System
- Activity Management (AC)
- Prefix
IAV- Primary key
ACV-DIMENSION- Fields
- 11
- Updated by
- 1 program
- Referenced by
- 4 programs
ACIAACVDIM is a Lawson Activity Management table (prefix IAV); no description in the lawson data dictionary. It is indexed by ACV-DIMENSION (IAVSET1). It is related 1:1 to ACACTGRP, ACACTIVITY and MXVIEWHDR. It is updated by ACDM.2 and referenced by ACBA.1, ACDL.1, HC02.1 and HCHP.1. The table has 11 fields, 1 index and 4 documented relations.
About ACIAACVDIM
No description in the Lawson data dictionary.
Fields (11)
Column = COBOL field name without the IAV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
IAV-ACV-DIMENSION PKACV_DIMENSION | Alpha 50 (Lower Case) | The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind. | ACDM.2 |
IAV-ACV-PREFIXACV_PREFIX | Alpha 5 (Lower Case) | The Type Prefix field contains a unique prefix name that differentiates the members in the Type dimension with similar members in other dimensions. This prefix can contain up to five characters of any kind. | ACDM.2 |
IAV-GROUP-PREFIXGROUP_PREFIX | Alpha 5 (Lower Case) | The Type Prefix field contains a unique prefix name that differentiates the members in the Type dimension with similar members in other dimensions. This prefix can contain up to five characters of any kind. | ACDM.2 |
IAV-ACV-ALIAS-OPTACV_ALIAS_OPT | Alpha 1 | — | ACDM.2 |
IAV-ACTIVITY-GRPACTIVITY_GRP | Alpha 15 | The activity group is the overall project. | ACDM.2 |
IAV-AG-MATRIX-LISTAG_MATRIX_LIST | Alpha 12 | Activity Group List | ACDM.2 |
IAV-ACTIVITYACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | ACDM.2 |
IAV-ACV-VIEW-1ACV_VIEW_1 | Alpha 12 | — | ACDM.2 |
IAV-ACV-VIEW-2ACV_VIEW_2 | Alpha 12 | — | ACDM.2 |
IAV-TYPETYPE | Alpha 2 | This identifies whether this record is created because of a picking transaction, or because of a return. Valid values are: "IS" = Picking transaction. "RR" = Return. ~$1 VENDOR The vendor's identification code. | ACDM.2 |
IAV-LEVELLEVEL | Numeric 1 | — | ACDM.2 |
Indexes (1)
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 |
|---|---|---|---|---|
IAVSET1 | ACV-DIMENSION | Primary | ACBA.1, ACDL.1, ACDM.1, ACDM.2, ACDM.9, HC02.1, HCHP.1 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acactgrp | ACACTGRP | Required | IAV-ACTIVITY-GRP → AGP-ACTIVITY-GRP | |
| Acactivity | ACACTIVITY | Not Required | IAV-ACTIVITY → ACV-ACTIVITY | |
| Mxviewhdr 1 | MXVIEWHDR | Not Required | "ACTVY" → MVH-OBJ-TYPE, IAV-ACV-VIEW-1 → MVH-MATRIX-VIEW | |
| Mxviewhdr 2 | MXVIEWHDR | Not Required | "ACTVY" → MVH-OBJ-TYPE, IAV-ACV-VIEW-2 → MVH-MATRIX-VIEW |
Programs
Updated by (1)
- ACDM.2 Activity Dimension Definition