AMIAMXDIM – No description in the Lawson data dictionary
- System
- Asset Management (AM)
- Prefix
AMA- Primary key
DIMENSION-NAME,MX-DIM-TYPE,MATRIX-CAT- Fields
- 6
- Updated by
- 2 programs
- Referenced by
- 2 programs
AMIAMXDIM is a Lawson Asset Management table (prefix AMA); no description in the lawson data dictionary. It is indexed by DIMENSION-NAME, MX-DIM-TYPE, MATRIX-CAT (AMASET1). It is updated by AM88.8 and AMDM.2 and referenced by AMAS.1 and AMBK.1. The table has 6 fields, 1 index and 0 documented relations.
About AMIAMXDIM
No description in the Lawson data dictionary.
Fields (6)
Column = COBOL field name without the AMA- 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 |
|---|---|---|---|
#AMA-DIMENSION-NAME PKDIMENSION_NAME | Alpha 50 (Lower Case) | The Dimension Name field contains the dimension name that the attribute belongs to | AM88.8, AMDM.2 |
#AMA-MX-DIM-TYPE PKMX_DIM_TYPE | Alpha 10 | The Mx Dim Type is the type of dimension that the attribute belongs to | AM88.8, AMDM.2 |
#AMA-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | This is th MX name for the attribute Attribute 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. | AM88.8, AMDM.2 |
#AMA-MEMBER-NAMEMEMBER_NAME | Alpha 50 (Lower Case) | This is an override member name for Data Mart dimensions with no association to a Budget dimension. | AM88.8, AMDM.2 |
#AMA-CATEGORY-TYPECATEGORY_TYPE | Alpha 1 | This Field is is an L for Lawson defined attribute, U for user-defined attributes | — |
#AMA-OBJ-TYPEOBJ_TYPE | Alpha 5 | This field will determine the type of object that is being used by the Attribute. These values are not user maintainable. | — |
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 |
|---|---|---|---|---|
AMASET1 |
| Primary | AM88.1, AM88.2, AM88.8, AMAS.1, AMBK.1, AMDM.2 |