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
Cal Dimension

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

IPY-LTD-MBR-NAME     Alpha 30  (Lower Case)                      ACTD.3
Ltd Mbr Name

IPY-PTD-FLAG         Alpha 1                                     ACTD.1
Ptd Flag

IPY-BEG-BAL-MBR      Alpha 30  (Lower Case)                      ACTD.1
Member Beginning     The Beginning Balance Member field
Balance              contains the user-defined name of the
                     beginning balance member. This name can
                     contain up to 30 characters of any kind.



                         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