AMIACALDIX

REFERENCED BY
AMPD.1 AMYR.1 AMDL.1


UPDATED BY
AM88.4 AM88.5 AM88.6

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITX-CAL-DIMENSION
Element: Cal Dimension		Alpha 50 (Lower Case)
AM88.4 AM88.5
AM88.6
ITX-MBR-TYPE
Element: 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
Element: 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
Element: Year		Numeric 4
Contains the fiscal year for the data stored on this record.
AM88.4 AM88.5
AM88.6
ITX-QUARTER
Element: Quarter		Numeric 1
Contains the fiscal quarter for the data stored in this record.
AM88.4 AM88.5
AM88.6
ITX-PERIOD
Element: Period		Numeric 2
This is the period for the record.
AM88.4 AM88.5
AM88.6
ITX-MEMBER-NAME
Element: 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


AMIACALDIX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITXSET1 CAL-DIMENSION
MBR-TYPE
YEAR
QUARTER
PERIOD
AM88.4 AM88.5
AM88.6 AMPD.1
AMYR.1
ITXSET2 CAL-DIMENSION
MBR-TYPE
YEAR*
QUARTER*
PERIOD*
AMDL.1


AMIACALDIX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Amiacaldim AMIACALDIM Required
ITX-CAL-DIMENSION->ITD-CAL-DIMENSION

File created: Thu Jun 09 11:06:03 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.