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

Field / columnTypeDescription & valuesUpdated by
#ITD-CAL-DIMENSION PK
CAL_DIMENSION		Alpha 50 (Lower Case)—AM88.4, AM88.5
#ITD-MBR-TYPE SET2
MBR_TYPE		Alpha 2The Asset Member Type field specifies the member type. Valid values are:
  • YR Year
  • PD Period
  • QR Quarter
AM88.4, AM88.5
#ITD-MEMBER-PREFIX
MEMBER_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-OPTION
ALIAS_OPTION		Alpha 1——
#ITD-NBR-PERIODS
NBR_PERIODS		Numeric 2The 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 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
ITDSET1
  1. CAL-DIMENSION
PrimaryAM88.4, AM88.5, AMYR.1
ITDSET2
  1. MBR-TYPE
  2. CAL-DIMENSION
AM88.4, AM88.5, AMDL.1, AMDM.1, AMPD.1

Relations

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

One to many (1) — child tables

RelationTableRulesConditionField map
AmiacaldixAMIACALDIX
ITD-CAL-DIMENSION→ITX-CAL-DIMENSION
ITD-MBR-TYPE→ITX-MBR-TYPE
—→ITX-YEAR
—→ITX-QUARTER
—→ITX-PERIOD

Programs

Updated by (2)

Referenced by (4)