Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMIACALDIM


                            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: Member 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

ITD-ALIAS-OPTION       Alpha 1
Element: Account Flag

ITD-NBR-PERIODS        Numeric 2                                 AM88.5
Element: Number Fields

                         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