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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MAT-DIM-OBJ-ID PKDIM_OBJ_ID | Numeric 12 | The 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 PKATTRIBUTE_NAME | Alpha 50 (Lower Case) | — | IAMB.1 |
MAT-ATTRIB-VALUE PKATTRIB_VALUE | Alpha 50 (Lower Case) | — | IAMB.1 |
MAT-LAST-UPD-DATELAST_UPD_DATE | Numeric 8 (yyyymmdd) | The Last Update Date field contains the date the member was last updated. | IAMB.1 |
MAT-LAST-UPD-TIMELAST_UPD_TIME | Numeric 6 (hhmmss) | The Last Update Time field contains the time the member was last updated. | IAMB.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MATSET1 | DIM-OBJ-ID, ATTRIBUTE-NAME, ATTRIB-VALUE | Primary, KeyChange | IA120, IAMB.1 |
Programs
Updated by (1)
- IAMB.1 Lawson Member List Update
Referenced by (1)
- IA120 Data Mart Load