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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
IAVSET1 |
| 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 |
| |||||||
| Acactivity | ACACTIVITY | Not Required |
| |||||||
| Mxviewhdr 1 | MXVIEWHDR | Not Required |
| |||||||
| Mxviewhdr 2 | MXVIEWHDR | Not Required |
|
Programs
Updated by (1)
- ACDM.2 Activity Dimension Definition