Lawson Insight Technical Documentation

                            ACIACALDIM FILE

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      Alpha 50  (Lower Case)                    ACTD.1  ACTD.3
Element: Cal Dimension

IPY-MBR-TYPE           Alpha 2                                   ACTD.1  ACTD.3
Element: Member Type   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

IPY-MEMBER-PREFIX      Alpha 5  (Lower Case)                     ACTD.1  ACTD.3
Element: Member Prefix

IPY-LTD-MBR-NAME       Alpha 30  (Lower Case)                    ACTD.3
Element: Member Name

IPY-PTD-FLAG           Alpha 1                                   ACTD.1
Element: All Flag

IPY-BEG-BAL-MBR        Alpha 30  (Lower Case)                    ACTD.1
Element: Member Name

IPY-ALIAS-OPTION       Alpha 1                                   ACTD.1  ACTD.3
Element: Account Flag

                         ACIACALDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IPYSET1   CAL-DIMENSION                                          ACBP.1  ACBY.1
          MBR-TYPE                                               ACDL.1  ACDM.1
                                                                 ACTD.2  ACTD.4
                                                                 ACTD.5

IPYSET2   MBR-TYPE                                               ACTD.1  ACTD.3
          CAL-DIMENSION

                         ACIACALDIM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           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