MLRPTDEF – Multi Ledger Report Definition
- System
- Multi-Ledger (ML)
- Prefix
MLR- Primary key
LEDGER,COMPANY,REPORT-NAME- Fields
- 16
- Updated by
- 6 programs
- Referenced by
- 1 program
MLRPTDEF is the Multi Ledger Report Definition table in Lawson Multi-Ledger (prefix MLR). It is indexed by LEDGER, COMPANY, REPORT-NAME (MLRSET1). It is related 1:1 to GLSYSTEM and MLCOLEDGER and 1:M to MLRPTSEL. It is updated by ML110, ML290, ML50.1, ML50.2, ML50.4 and ML50.5 and referenced by ML250. The table has 16 fields, 1 index and 3 documented relations.
About MLRPTDEF
This file contains report parameters defined in Ledger Report Setup (ML50.1) and inputs the parameters into Ledger Report (ML290) for report processing.
Fields (16)
Column = COBOL field name without the MLR- 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 |
|---|---|---|---|
#MLR-LEDGER PKLEDGER | Alpha 15 | The ledger for which the report is defined. | ML110, ML50.1, ML50.2, ML50.5 |
#MLR-COMPANY PKCOMPANY | Numeric 4 | The company for which the report is defined. | ML50.1, ML50.2, ML50.5 |
#MLR-REPORT-NAME PKREPORT_NAME | Alpha 20 | The name that identifies the report. | ML50.1, ML50.2, ML50.5 |
#MLR-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The report description. | ML50.2, ML50.5 |
#MLR-CREATORCREATOR | Alpha 15 | The ID for the person that created the report. | ML50.2, ML50.5 |
#MLR-LAST-RUN-DATELAST_RUN_DATE | Numeric 8 (yyyymmdd) | The last date the report was run. | ML290, ML50.5 |
#MLR-PRIMARY-SORTPRIMARY_SORT | Numeric 1 | The primary report sort order. | ML50.2 |
#MLR-TRANS-TYPETRANS_TYPE | Alpha 1 | Determines if amounts or units are processed in each transaction. | ML290, ML50.2 |
#MLR-ACCT-ACTIVITYACCT_ACTIVITY | Alpha 1 | Determines the type of account activity to be included in the report. | ML50.2 |
#MLR-COMPLETE-FLAGCOMPLETE_FLAG | Alpha 1 | Indicates if the record is complete. | ML50.1 |
#MLR-LAST-ITEM-SEQLAST_ITEM_SEQ | Numeric 4 | The last item sequence number. | ML50.4 |
#MLR-TRN-DTL-SLECTTRN_DTL_SLECT | Numeric 2 Occurs 31 Times ×31 | Indicates the order that transaction detail is selected. | ML50.1 |
#MLR-SORT-ORDERSORT_ORDER | Numeric 1 Occurs 4 Times ×4 | The report sort order. | ML50.1, ML50.2 |
#MLR-PRT-TOTAL-FLGPRT_TOTAL_FLG | Alpha 1 Occurs 3 Times ×3 | Indicates if totals are printed in the report. | ML50.1 |
#MLR-PG-BREAK-FLAGPG_BREAK_FLAG | Alpha 1 Occurs 2 Times ×2 | Indicates if page breaks occur at the variable or account level. | ML50.1 |
#MLR-RUNNING-BALRUNNING_BAL | Alpha 1 | Indicates if running balances are included in the report. | ML50.2 |
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 |
|---|---|---|---|---|
MLRSET1 |
| Primary | ML110, ML250, ML290, ML50.1, ML50.2, ML50.4, ML50.5 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | GLSYSTEM | Required |
| |||||||
| Ledger | MLCOLEDGER | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selection | MLRPTSEL |
|
Programs
Updated by (6)
- ML110 Ledger Company Copy Delete
- ML290 Ledger Report
- ML50.1 Ledger Report Setup
- ML50.2 Define Ledger Report
- ML50.4 Filters
- ML50.5 Copy
Referenced by (1)
- ML250 Ledger Report Listing