Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IACALCMBR


                             IACALCMBR FILE

UPDATED BY

ACBA.1    ACBC.1    ACBP.1    ACBR.1    ACBS.1    ACBU.1
ACBY.1    AMAS.1    AMBK.1    AMCV.1    AMLF.1    AMMD.1
AMME.1    AMPD.1    AMYR.1    HCAG.1    HCCP.1    HCEM.1
HCHM.1    HCJC.1    HCMS.1    HCPO.1    HCRV.1    HCSC.1
HCSU.1    HCYR.1    IA120     IA150     IAMB.1    IATM.1
IAVO.1    IAYR.1    GLBA.1    GLBD.1    GLBP.1    GLBT.1
GLBY.1    IFBA.1    IFBC.1    IFBO.1    IFBS.1    POAB.1
POAM.1    POAO.1    POAP.1    SACU.1    SALO.1    SAMM.1
SAOR.1    SASC.1    SATE.1    WOME.1    WOOR.1    WOPR.1
WOSC.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CCM-DIM-OBJ-ID         Numeric 12                                ACBA.1  ACBC.1
Element: Dim Obj Id    The Dimension Object Identifier field     ACBP.1  ACBR.1
                       contains a unique numeric identifier      ACBS.1  ACBU.1
                       assigned to the dimension, which          ACBY.1  AMAS.1
                       associates this record to the member      AMBK.1  AMCV.1
                       records.                                  AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAMB.1
                                                                 IATM.1  IAVO.1
                                                                 IAYR.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

CCM-MEMBER-NAME        Alpha 50  (Lower Case)                    ACBA.1  ACBC.1
Element: Member Name   This is an override member name for       ACBP.1  ACBR.1
                       Data Mart dimensions with no association  ACBS.1  ACBU.1
                       to a Budget dimension.                    ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAMB.1
                                                                 IATM.1  IAVO.1
                                                                 IAYR.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

CCM-PARENT-NAME        Alpha 50  (Lower Case)                    ACBA.1  ACBC.1
Element: Member Name                                             ACBP.1  ACBR.1
                                                                 ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAMB.1
                                                                 IATM.1  IAVO.1
                                                                 IAYR.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

CCM-ALIAS-NAME         Alpha 80  (Lower Case)                    ACBA.1  ACBC.1
Element: Alias Name    The Alias Name field contains an alias    ACBP.1  ACBR.1
                       name for the dimension.                   ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAMB.1
                                                                 IATM.1  IAVO.1
                                                                 IAYR.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

CCM-RECORD-OWNER       Alpha 1                                   ACBA.1  ACBC.1
Element: Record Owner  The Record Owner field contains the       ACBP.1  ACBR.1
                       name of the record owner.                 ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                       Valid values are:                         AMBK.1  AMCV.1
                       L = Lawson                                AMLF.1  AMMD.1
                       U = User                                  AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAMB.1
                                                                 IATM.1  IAVO.1
                                                                 IAYR.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

CCM-LAST-UPD-DATE      Numeric 8  (yyyymmdd)                     ACBA.1  ACBC.1
Element: Last Update DaThe Last Update Date field contains the   ACBP.1  ACBR.1
                       date the member was last updated.         ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAMB.1
                                                                 IATM.1  IAVO.1
                                                                 IAYR.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

CCM-LAST-UPD-TIME      Numeric 6  (hhmmss)                       ACBA.1  ACBC.1
Element: Last Upd Time The Last Update Time field contains the   ACBP.1  ACBR.1
                       time the member was last updated.         ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAMB.1
                                                                 IATM.1  IAVO.1
                                                                 IAYR.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

CCM-MS-CALCULATION     Alpha 1000  (Lower Case)                  ACBA.1  ACBC.1
Element: Ms Calculation                                          ACBP.1  ACBR.1
                                                                 ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  GLBA.1
                                                                 GLBD.1  GLBP.1
                                                                 GLBT.1  GLBY.1
                                                                 HCAG.1  HCCP.1
                                                                 HCEM.1  HCHM.1
                                                                 HCJC.1  HCMS.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSU.1
                                                                 HCYR.1  IA120
                                                                 IA150   IAMB.1
                                                                 IATM.1  IAVO.1
                                                                 IAYR.1  IFBA.1
                                                                 IFBC.1  IFBO.1
                                                                 IFBS.1  POAB.1
                                                                 POAM.1  POAO.1
                                                                 POAP.1  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

                         IACALCMBR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CCMSET1   DIM-OBJ-ID                                             ACBA.1  ACBC.1
          MEMBER-NAME                                            ACBP.1  ACBR.1
                                                                 ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  HCAG.1
                                                                 HCCP.1  HCEM.1
                                                                 HCHM.1  HCJC.1
                                                                 HCMS.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSU.1  HCYR.1
                                                                 IA120   IA150
                                                                 IAMB.1  IATM.1
                                                                 ...

CCMSET2   DIM-OBJ-ID
          RECORD-OWNER
          MEMBER-NAME