AMIACALDIX – No description in the Lawson data dictionary

System
Asset Management (AM)
Prefix
ITX
Primary key
CAL-DIMENSION, MBR-TYPE, YEAR, QUARTER, PERIOD
Fields
7
Updated by
3 programs
Referenced by
3 programs

AMIACALDIX is a Lawson Asset Management table (prefix ITX); no description in the lawson data dictionary. It is indexed by CAL-DIMENSION, MBR-TYPE, YEAR, QUARTER, PERIOD (ITXSET1); alternate indexes: ITXSET2. It is related 1:1 to AMIACALDIM. It is updated by AM88.4, AM88.5 and AM88.6 and referenced by AMDL.1, AMPD.1 and AMYR.1. The table has 7 fields, 2 indexes and 1 documented relation.

About AMIACALDIX

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the ITX- 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
#ITX-CAL-DIMENSION PK
CAL_DIMENSION		Alpha 50 (Lower Case)—AM88.4, AM88.5, AM88.6
#ITX-MBR-TYPE PK
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, AM88.6
#ITX-SEQUENCE
SEQUENCE		Numeric 6The Sequence field show the sequence of a member as it is entered in either the Budget Member Names or Fiscal Year Variances subforms in AC87.1 (Financial OLAP Dimensions).—
#ITX-YEAR PK
YEAR		Numeric 4Contains the fiscal year for the data stored on this record.AM88.4, AM88.5, AM88.6
#ITX-QUARTER PK
QUARTER		Numeric 1Contains the fiscal quarter for the data stored in this record.AM88.4, AM88.5, AM88.6
#ITX-PERIOD PK
PERIOD		Numeric 2This is the period for the record.AM88.4, AM88.5, AM88.6
#ITX-MEMBER-NAME
MEMBER_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.AM88.4, AM88.5, AM88.6

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
ITXSET1
  1. CAL-DIMENSION
  2. MBR-TYPE
  3. YEAR
  4. QUARTER
  5. PERIOD
PrimaryAM88.4, AM88.5, AM88.6, AMPD.1, AMYR.1
ITXSET2
  1. CAL-DIMENSION
  2. MBR-TYPE
  3. YEAR ↓
  4. QUARTER ↓
  5. PERIOD ↓
AMDL.1

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmiacaldimAMIACALDIMRequired
ITX-CAL-DIMENSION→ITD-CAL-DIMENSION

Programs

Updated by (3)

Referenced by (3)