ACIAMXDIM – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
AXD
Primary key
DIMENSION-NAME, MX-DIM-TYPE, MATRIX-CAT, LEVEL-NBR
Fields
5
Updated by
1 program
Referenced by
1 program

ACIAMXDIM is a Lawson Activity Management table (prefix AXD); no description in the lawson data dictionary. It is indexed by DIMENSION-NAME, MX-DIM-TYPE, MATRIX-CAT, LEVEL-NBR (AXDSET1); alternate indexes: AXDSET2. It is updated by ACDM.9 and referenced by ACBA.1. The table has 5 fields, 2 indexes and 0 documented relations.

About ACIAMXDIM

No description in the Lawson data dictionary.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
AXD-DIMENSION-NAME PK
DIMENSION_NAME		Alpha 50 (Lower Case)The Dimension Name field contains the dimension name that is used by the OLAP database. Valid values are: Year Period Measures Scenario Compton Territory Customer ItemsACDM.9
AXD-MX-DIM-TYPE PK
MX_DIM_TYPE		Alpha 10—ACDM.9
AXD-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis.ACDM.9
AXD-LEVEL-NBR PK
LEVEL_NBR		Numeric 3—ACDM.9
AXD-MEMBER-NAME
MEMBER_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.ACDM.9

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AXDSET1DIMENSION-NAME, MX-DIM-TYPE, MATRIX-CAT, LEVEL-NBRPrimaryACBA.1, ACDM.2, ACDM.8, ACDM.9
AXDSET2DIMENSION-NAME, MEMBER-NAME, MX-DIM-TYPE, MATRIX-CAT, LEVEL-NBRKeyChangeACDM.9

Programs

Updated by (1)

Referenced by (1)