MLRPTSEL – ML Report Selection
- System
- Multi-Ledger (ML)
- Prefix
MRS- Primary key
LEDGER,COMPANY,REPORT-NAME,OR-GROUP,ITEM-NUMBER,SEQUENCE-NBR- Fields
- 9
- Updated by
- 4 programs
- Referenced by
- 2 programs
MLRPTSEL is the ML Report Selection table in Lawson Multi-Ledger (prefix MRS). It is indexed by LEDGER, COMPANY, REPORT-NAME, OR-GROUP, ITEM-NUMBER, SEQUENCE-NBR (MRSSET1). It is related 1:1 to MLRPTDEF. It is updated by ML110, ML50.2, ML50.4 and ML50.5 and referenced by ML250 and ML290. The table has 9 fields, 1 index and 1 documented relation.
About MLRPTSEL
This file contains field selection values for Ledger Report Setup (GL50.1). The values are used for report processing in Ledger Report (GL290).
Fields (9)
Column = COBOL field name without the MRS- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#MRS-LEDGER PKLEDGER | Alpha 15 | The ledger for which the report is defined. | ML110, ML50.4, ML50.5 |
#MRS-COMPANY PKCOMPANY | Numeric 4 | The company for which the report is defined. | ML50.4, ML50.5 |
#MRS-REPORT-NAME PKREPORT_NAME | Alpha 20 | The name that identifies the report. | ML50.4, ML50.5 |
#MRS-OR-GROUP PKOR_GROUP | Alpha 1 | A single value used to group multiple selections together. Each group of value selections will be treated internally as an 'and' and externally as an 'or.' | ML50.4 |
#MRS-ITEM-NUMBER PKITEM_NUMBER | Numeric 2 | Indicates items to be used for filtering report information. | ML50.4 |
#MRS-SEQUENCE-NBR PKSEQUENCE_NBR | Numeric 4 | The user-assigned sequence number to keep the records unique and to determine order. | ML50.4 |
#MRS-SELECT-OMITSELECT_OMIT | Alpha 1 | Determines whether the item number and value range are included in the report | ML50.4 |
#MRS-FR-VALUEFR_VALUE | Alpha 30 | The beginning value to include or exclude in the report. | ML50.4 |
#MRS-TH-VALUETH_VALUE | Alpha 30 | The ending value to include or exclude in the report. | ML50.4 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MRSSET1 |
| Primary | ML110, ML250, ML290, ML50.1, ML50.2, ML50.4, ML50.5 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mlrptdef | MLRPTDEF | Required |
|