ACIADIM – The Activity Analyzer Dimensions data file stores the definition of each dimension that has been defined by AC87.1…
- System
- Activity Management (AC)
- Prefix
DIM- Primary key
DATA-MART-NAME- Fields
- 9
- Updated by
- 1 program
- Referenced by
- 7 programs
ACIADIM is the The Activity Analyzer Dimensions data file stores the definition of each dimension that has been defined by AC87.1… table in Lawson Activity Management (prefix DIM). It is indexed by DATA-MART-NAME (DIMSET1). It is updated by ACDM.1 and referenced by ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBU.1, ACBY.1 and ACDL.1. The table has 9 fields, 1 index and 0 documented relations.
About ACIADIM
The Activity Analyzer Dimensions data file stores the definition of each dimension that has been defined by AC87.1 (Analyzer Definition).
Fields (9)
Column = COBOL field name without the DIM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
DIM-DATA-MART-NAME PKDATA_MART_NAME | Alpha 20 (Lower Case) | This field contains the name of the data mart. | ACDM.1 |
DIM-ACV-DIMENSIONACV_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.1 |
DIM-CAT-DIMENSIONCAT_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.1 |
DIM-ORG-DIMENSIONORG_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.1 |
DIM-YER-DIMENSIONYER_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.1 |
DIM-PER-DIMENSIONPER_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.1 |
DIM-AMT-DIMENSIONAMT_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.1 |
DIM-SCN-DIMENSIONSCN_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.1 |
DIM-RES-DIMENSIONRES_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.1 |
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 |
|---|---|---|---|---|
DIMSET1 | DATA-MART-NAME | Primary | ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBU.1, ACBY.1, ACDL.1, ACDM.1 |
Programs
Updated by (1)
- ACDM.1 Activity Management Data Mart Setup