MLRPTDEF

ML Report Definition

This file contains report parameters defined in Ledger Report Setup (ML50.1) and inputs the parameters into Ledger Report (ML290) for report processing.

REFERENCED BY
ML250


UPDATED BY
ML110 ML290 ML50.1 ML50.2 ML50.4 ML50.5

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLR-LEDGER
Element: Ledger
Alpha 15
The ledger for which the report is defined.
ML110 ML50.1
ML50.2 ML50.5
MLR-COMPANY
Element: Company
Numeric 4
The company for which the report is defined.
ML50.1 ML50.2
ML50.5
MLR-REPORT-NAME
Element: Report Name
Alpha 20
The name that identifies the report.
ML50.1 ML50.2
ML50.5
MLR-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The report description.
ML50.2 ML50.5
MLR-CREATOR
Element: Creator
Alpha 15
The ID for the person that created the report.
ML50.2 ML50.5
MLR-LAST-RUN-DATE
Element: Last Run Date
Numeric 8 (yyyymmdd)
The last date the report was run.
ML290 ML50.5
MLR-PRIMARY-SORT
Element: Primary Sort
Numeric 1
The primary report sort order.
ML50.2
MLR-TRANS-TYPE
Element: Trans Type
Alpha 1
Determines if amounts or units are processed in each transaction.
ML290 ML50.2
MLR-ACCT-ACTIVITY
Element: Acct Activity
Alpha 1
Determines the type of account activity to be included in the report.
ML50.2
MLR-COMPLETE-FLAG
Element: Complete Flag
Alpha 1
Indicates if the record is complete.
ML50.1
MLR-LAST-ITEM-SEQ
Element: Seq Nbr
Numeric 4
The last item sequence number.
ML50.4
MLR-TRN-DTL-SLECT
Element: Trn Dtl Slect
Numeric 2 Occurs 31 Times
Indicates the order that transaction detail is selected.
ML50.1
MLR-SORT-ORDER
Element: Sort Order
Numeric 1 Occurs 4 Times
The report sort order.
ML50.1 ML50.2
MLR-PRT-TOTAL-FLG
Element: Prt Total Flg
Alpha 1 Occurs 3 Times
Indicates if totals are printed in the report.
ML50.1
MLR-PG-BREAK-FLAG
Element: Pg Break Flag
Alpha 1 Occurs 2 Times
Indicates if page breaks occur at the variable or account level.
ML50.1
MLR-RUNNING-BAL
Element: All Flag
Alpha 1
Indicates if running balances are included in the report.
ML50.2


MLRPTDEF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLRSET1 LEDGER
COMPANY
REPORT-NAME
ML110 ML250
ML290 ML50.1
ML50.2 ML50.4
ML50.5


MLRPTDEF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
MLR-COMPANY->GLS-COMPANY
Ledger MLCOLEDGER Required
MLR-COMPANY->MLE-COMPANY
MLR-LEDGER->MLE-LEDGER


MLRPTDEF FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Selection MLRPTSEL
MLR-LEDGER->MRS-LEDGER
MLR-COMPANY->MRS-COMPANY
MLR-REPORT-NAME->MRS-REPORT-NAME
  MRS-OR-GROUP
  MRS-ITEM-NUMBER
  MRS-SEQUENCE-NBR


File created: Thu Jun 09 11:21:16 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.