ACIAAMTDIM – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
IAM
Primary key
AMT-DIMENSION
Fields
6
Updated by
1 program
Referenced by
2 programs

ACIAAMTDIM is a Lawson Activity Management table (prefix IAM); no description in the lawson data dictionary. It is indexed by AMT-DIMENSION (IAMSET1). It is related 1:M to ACIAMBR. It is updated by ACDM.4 and referenced by ACBU.1 and ACDL.1. The table has 6 fields, 1 index and 1 documented relation.

About ACIAAMTDIM

No description in the Lawson data dictionary.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
IAM-AMT-DIMENSION PK
AMT_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.4
IAM-AMT-PREFIX
AMT_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.4
IAM-AMT-ALIAS-OPT
AMT_ALIAS_OPT
Alpha 1
IAM-BASE-MBR-NAME
BASE_MBR_NAME
Alpha 30 (Lower Case)The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind.ACDM.4
IAM-CURR-MBR-NAME
CURR_MBR_NAME
Alpha 30 (Lower Case)The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind.
IAM-UNIT-MBR-NAME
UNIT_MBR_NAME
Alpha 30 (Lower Case)The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind.ACDM.4

Indexes (1)

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

IndexKeysFlagsConditionUsed in
IAMSET1AMT-DIMENSIONPrimaryACBU.1, ACDL.1, ACDM.1, ACDM.4, ACDM.6

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
Aciambr CuACIAMBRIAM-AMT-DIMENSIONMEM-MBR-DIMENSION, "CU"MEM-MBR-TYPE, MEM-SEQUENCE, MEM-BUDGET-NBR, MEM-MBR-NAME

Programs

Updated by (1)

Referenced by (2)