MLRPTDEF

Multi Ledger 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 02:23:57 2016

Home
Contact Us



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