MBRATTRIB – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
MAT
Primary key
DIM-OBJ-ID, ATTRIBUTE-NAME, ATTRIB-VALUE
Fields
5
Updated by
1 program
Referenced by
1 program

MBRATTRIB is a Lawson Analytic Architect table (prefix MAT); no description in the lawson data dictionary. It is indexed by DIM-OBJ-ID, ATTRIBUTE-NAME, ATTRIB-VALUE (MATSET1). It is updated by IAMB.1 and referenced by IA120. The table has 5 fields, 1 index and 0 documented relations.

About MBRATTRIB

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the MAT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MAT-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.IAMB.1
#MAT-ATTRIBUTE-NAME PK
ATTRIBUTE_NAME		Alpha 50 (Lower Case)—IAMB.1
#MAT-ATTRIB-VALUE PK
ATTRIB_VALUE		Alpha 50 (Lower Case)—IAMB.1
#MAT-LAST-UPD-DATE
LAST_UPD_DATE		Numeric 8 (yyyymmdd)The Last Update Date field contains the date the member was last updated.IAMB.1
#MAT-LAST-UPD-TIME
LAST_UPD_TIME		Numeric 6 (hhmmss)The Last Update Time field contains the time the member was last updated.IAMB.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MATSET1
  1. DIM-OBJ-ID
  2. ATTRIBUTE-NAME
  3. ATTRIB-VALUE
Primary, KeyChangeIA120, IAMB.1

Programs

Updated by (1)

Referenced by (1)