MBRSHARES – No description in the Lawson data dictionary
- System
- Analytic Architect (IA)
- Prefix
MBS- Primary key
MBR-OBJ-ID,PARENT-OBJ-ID- Fields
- 6
- Updated by
- 4 programs
- Referenced by
- 0 programs
MBRSHARES is a Lawson Analytic Architect table (prefix MBS); no description in the lawson data dictionary. It is indexed by MBR-OBJ-ID, PARENT-OBJ-ID (MBSSET1); alternate indexes: MBSSET2. It is updated by IA120, IA15.1, IA300 and IAMB.1. The table has 6 fields, 2 indexes and 0 documented relations.
About MBRSHARES
No description in the Lawson data dictionary.
Fields (6)
Column = COBOL field name without the MBS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MBS-MBR-OBJ-ID PKMBR_OBJ_ID | Numeric 12 | The Member Object Identifier field contains a unique numeric identifier assigned to a member, which associates this record to the appropriate MEMBER file record. | IAMB.1 |
MBS-PARENT-OBJ-ID PKPARENT_OBJ_ID | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | IAMB.1 |
MBS-LAST-UPD-DATELAST_UPD_DATE | Numeric 8 (yyyymmdd) | The Last Update Date field contains the date the member was last updated. | IAMB.1 |
MBS-LAST-UPD-TIMELAST_UPD_TIME | Numeric 6 (hhmmss) | The Last Update Time field contains the time the member was last updated. | IAMB.1 |
MBS-DATA-MART-NAMEDATA_MART_NAME | Alpha 20 (Lower Case) | This field contains the name of the data mart. | IAMB.1 |
MBS-DIM-OBJ-IDDIM_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 |
Indexes (2)
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 |
|---|---|---|---|---|
MBSSET1 | MBR-OBJ-ID, PARENT-OBJ-ID | Primary, KeyChange | IA120, IA15.1, IA300, IAMB.1 | |
MBSSET2 | DIM-OBJ-ID, LAST-UPD-DATE, LAST-UPD-TIME, MBR-OBJ-ID, PARENT-OBJ-ID | KeyChange | IA120 |