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.

Field / column	Type	Description & values	Updated by
`ITX-CAL-DIMENSION` PK CAL_DIMENSION	Alpha 50 (Lower Case)	—	AM88.4, AM88.5, AM88.6
`ITX-MBR-TYPE` PK MBR_TYPE	Alpha 2	The 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 6	The 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 4	Contains the fiscal year for the data stored on this record.	AM88.4, AM88.5, AM88.6
`ITX-QUARTER` PK QUARTER	Numeric 1	Contains the fiscal quarter for the data stored in this record.	AM88.4, AM88.5, AM88.6
`ITX-PERIOD` PK PERIOD	Numeric 2	This 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`ITXSET1`	`CAL-DIMENSION`, `MBR-TYPE`, `YEAR`, `QUARTER`, `PERIOD`	Primary		AM88.4, AM88.5, AM88.6, AMPD.1, AMYR.1
`ITXSET2`	`CAL-DIMENSION`, `MBR-TYPE`, `YEAR`, `QUARTER`, `PERIOD*`			AMDL.1

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Amiacaldim	AMIACALDIM	Required		`ITX-CAL-DIMENSION` → `ITD-CAL-DIMENSION`

AMIACALDIX – No description in the Lawson data dictionary

About AMIACALDIX

Fields (7)

Indexes (2)

Relations

One to one (1) — lookups and parents

Programs

Updated by (3)

Referenced by (3)