IACALCMBR – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
CCM
Primary key
DIM-OBJ-ID, MEMBER-NAME, RECORD-OWNER
Fields
8
Updated by
51 programs
Referenced by
0 programs

IACALCMBR is a Lawson Analytic Architect table (prefix CCM); no description in the lawson data dictionary. It is indexed by DIM-OBJ-ID, MEMBER-NAME, RECORD-OWNER (CCMSET1); alternate indexes: CCMSET2. It is updated by ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 and 43 more. The table has 8 fields, 2 indexes and 0 documented relations.

About IACALCMBR

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the CCM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CCM-DIM-OBJ-ID PK
DIM_OBJ_ID		Numeric 12The Dimension Object Identifier field contains a unique numeric identifier assigned to the dimension, which associates this record to the member records.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
CCM-MEMBER-NAME PK
MEMBER_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
CCM-PARENT-NAME
PARENT_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
CCM-ALIAS-NAME
ALIAS_NAME		Alpha 80 (Lower Case)The Alias Name field contains an alias name for the dimension.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
CCM-RECORD-OWNER PK
RECORD_OWNER		Alpha 1The Record Owner field contains the name of the record owner. Valid values are:
  • L Lawson
  • U User
ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
CCM-LAST-UPD-DATE
LAST_UPD_DATE		Numeric 8 (yyyymmdd)The Last Update Date field contains the date the member was last updated.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
CCM-LAST-UPD-TIME
LAST_UPD_TIME		Numeric 6 (hhmmss)The Last Update Time field contains the time the member was last updated.ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more
CCM-MS-CALCULATION
MS_CALCULATION		Alpha 1000 (Lower Case)—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +43 more

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CCMSET1DIM-OBJ-ID, MEMBER-NAME, RECORD-OWNERPrimaryACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +22 more (list truncated in source)
CCMSET2DIM-OBJ-ID, RECORD-OWNER, MEMBER-NAMEIA150

Programs

Updated by (51)