ACIACALDIM

REFERENCED BY
ACBP.1 ACBY.1 ACDL.1 ACDM.1


UPDATED BY
ACTD.1 ACTD.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IPY-CAL-DIMENSION
Element: Cal Dimension
Alpha 50 (Lower Case)
ACTD.1 ACTD.3
IPY-MBR-TYPE
Element: Mbr Type
Alpha 2
The Member Type field specifies the member type. Valid values are: BD = Budget BV = Budget Variance CH = Alternate Chart FY = Fiscal Year PD = Period PY = Period Year-to-Date QR = Quarter QY = Quarter Year-to-Date SA = Subaccount VW = View YV = Year Variance
YR = Year
ACTD.1 ACTD.3
IPY-MEMBER-PREFIX
Element: 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.
ACTD.1 ACTD.3
IPY-LTD-MBR-NAME
Element: Mbr Name
Alpha 30 (Lower Case)
The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind.
ACTD.3
IPY-PTD-FLAG
Element: All Flag
Alpha 1
ACTD.1
IPY-BEG-BAL-MBR
Element: Mbr Name
Alpha 30 (Lower Case)
The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind.
ACTD.1
IPY-ALIAS-OPTION
Element: Account Flag
Alpha 1
ACTD.1 ACTD.3


ACIACALDIM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IPYSET1 CAL-DIMENSION
MBR-TYPE
ACBP.1 ACBY.1
ACDL.1 ACDM.1
ACTD.2 ACTD.4
ACTD.5
IPYSET2 MBR-TYPE
CAL-DIMENSION
ACTD.1 ACTD.3


ACIACALDIM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Aciambr Pr ACIAMBR
IPY-CAL-DIMENSION->MEM-MBR-DIMENSION
"PR"->MEM-MBR-TYPE
  MEM-SEQUENCE
  MEM-BUDGET-NBR
  MEM-MBR-NAME
Aciambr Yr ACIAMBR
IPY-CAL-DIMENSION->MEM-MBR-DIMENSION
"YR"->MEM-MBR-TYPE
  MEM-SEQUENCE
  MEM-BUDGET-NBR
  MEM-MBR-NAME
Aciambr Yv ACIAMBR
IPY-CAL-DIMENSION->MEM-MBR-DIMENSION
"YV"->MEM-MBR-TYPE
  MEM-SEQUENCE
  MEM-BUDGET-NBR
  MEM-MBR-NAME


File created: Thu Jun 09 11:04:08 2016

Home
Contact Us



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