Lawson Insight Technical Documentation |
|
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
|