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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IAMSET1
  1. AMT-DIMENSION
PrimaryACBU.1, ACDL.1, ACDM.1, ACDM.4, ACDM.6

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACIAMBRACIAAMTDIM

One to many (1) — child tables

RelationTableRulesConditionField map
Aciambr CuACIAMBR
IAM-AMT-DIMENSION→MEM-MBR-DIMENSION
"CU"→MEM-MBR-TYPE
—→MEM-SEQUENCE
—→MEM-BUDGET-NBR
—→MEM-MBR-NAME

Programs

Updated by (1)

Referenced by (2)