AMIACALDIM FILE
REFERENCED BY
AMYR.1 AMDL.1 AMDM.1 AMPD.1
UPDATED BY
AM88.4 AM88.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITD-CAL-DIMENSION Alpha 50 (Lower Case) AM88.4 AM88.5
Element: Cal Dimension
ITD-MBR-TYPE Alpha 2 AM88.4 AM88.5
Element: Mbr Type The Asset Member Type field specifies
the member type.
Valid values are:
YR = Year
PD = Period
QR = Quarter
ITD-MEMBER-PREFIX Alpha 5 (Lower Case)
Element: Member Prefix 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 Alpha 1
Element: Account Flag
ITD-NBR-PERIODS Numeric 2 AM88.5
Element: Nbr Periods 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.
AMIACALDIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITDSET1 CAL-DIMENSION AM88.4 AM88.5
AMYR.1
ITDSET2 MBR-TYPE AM88.4 AM88.5
CAL-DIMENSION AMDL.1 AMDM.1
AMPD.1
AMIACALDIM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amiacaldix AMIACALDIX
ITD-CAL-DIMENSION -> ITX-CAL-DIMENSION
ITD-MBR-TYPE -> ITX-MBR-TYPE
ITX-YEAR
ITX-QUARTER
ITX-PERIOD
|
