AMIACALDIM – No description in the Lawson data dictionary
- System
- Asset Management (AM)
- Prefix
ITD- Primary key
CAL-DIMENSION- Fields
- 5
- Updated by
- 2 programs
- Referenced by
- 4 programs
AMIACALDIM is a Lawson Asset Management table (prefix ITD); no description in the lawson data dictionary. It is indexed by CAL-DIMENSION (ITDSET1); alternate indexes: ITDSET2. It is related 1:M to AMIACALDIX. It is updated by AM88.4 and AM88.5 and referenced by AMDL.1, AMDM.1, AMPD.1 and AMYR.1. The table has 5 fields, 2 indexes and 1 documented relation.
About AMIACALDIM
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the ITD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ITD-CAL-DIMENSION PKCAL_DIMENSION | Alpha 50 (Lower Case) | — | AM88.4, AM88.5 |
ITD-MBR-TYPEMBR_TYPE | Alpha 2 | The Asset Member Type field specifies the member type. Valid values are:
| AM88.4, AM88.5 |
ITD-MEMBER-PREFIXMEMBER_PREFIX | Alpha 5 (Lower Case) | The Member Prefix field contains a unique prefix to differentiate the dimension name from other like-named dimensions. This user-defined name can contain up to five characters of any kind. | — |
ITD-ALIAS-OPTIONALIAS_OPTION | Alpha 1 | — | — |
ITD-NBR-PERIODSNBR_PERIODS | Numeric 2 | The Number of Periods field contains the number of periods that are included when the outline is built. This field can contain up to two numeric values. | AM88.5 |
Indexes (2)
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 |
|---|---|---|---|---|
ITDSET1 | CAL-DIMENSION | Primary | AM88.4, AM88.5, AMYR.1 | |
ITDSET2 | MBR-TYPE, CAL-DIMENSION | AM88.4, AM88.5, AMDL.1, AMDM.1, AMPD.1 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Amiacaldix | AMIACALDIX | ITD-CAL-DIMENSION → ITX-CAL-DIMENSION, ITD-MBR-TYPE → ITX-MBR-TYPE, ITX-YEAR, ITX-QUARTER, ITX-PERIOD |