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 / column | Type | Description & values | Updated by |
|---|---|---|---|
IAM-AMT-DIMENSION PKAMT_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-PREFIXAMT_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-OPTAMT_ALIAS_OPT | Alpha 1 | — | — |
IAM-BASE-MBR-NAMEBASE_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-NAMECURR_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-NAMEUNIT_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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
IAMSET1 | AMT-DIMENSION | Primary | ACBU.1, ACDL.1, ACDM.1, ACDM.4, ACDM.6 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Aciambr Cu | ACIAMBR | IAM-AMT-DIMENSION → MEM-MBR-DIMENSION, "CU" → MEM-MBR-TYPE, → MEM-SEQUENCE, → MEM-BUDGET-NBR, → MEM-MBR-NAME |
Programs
Updated by (1)
- ACDM.4 Amounts Dimension Definition