ML Transaction Interface

The Multi Book Ledger Transaction Interface file (MLTRANSREL) contains the information needed to create transaction within the Lawson General Ledger system when interfacing a non-Lawson application transaction file. You can view and modify the contents of MLTRANSREL by using Transaction Interface Maintenance (ML65.1).

REFERENCED BY

ML265

UPDATED BY

ML165

ML65.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
MTR-RUN-GROUP Element: Run Group	Alpha 15 Run Group and Seq Number are the keys to the MLTRANSREL file. They should be used to group records together for interfacing.	ML165 ML65.1
MTR-SEQ-NUMBER Element: Seq Number	Numeric 6 A unique number assigned to each transaction to be transferred into the Lawson system.	ML165 ML65.1
MTR-LEDGER Element: Ledger	Alpha 15 This is the ledger into which the transactions are to be interfaced. It must be defined using Ledger Setup (ML10.1).	ML165 ML65.1
MTR-COMPANY Element: Company	Numeric 4 This is the company into which the transactions are to be interfaced. It must be defined using Company (GL10.1), and linked with the ledger on Ledger Setup (ML10.1).	ML165 ML65.1
MTR-OLD-COMPANY Element: Old Company	Alpha 35 The old company structure from which the records are interfaced.	ML165 ML65.1
MTR-OLD-CPY-SHORT Element: Old Cpy Short	Derived A short description for the old company.
MTR-STRING-COMPANY Element: String Company	Derived This is a derived string represented the old company.
MTR-OLD-ACCT-NBR Element: Old Acct Nbr	Alpha 25 This is the old account number to be associated with the new account/subaccount within the Lawson system.	ML165 ML65.1
MTR-OLD-ACCT-SHORT Element: Old Acct Short	Derived A short description of the old account.
MTR-SOURCE-CODE Element: Source Code	Alpha 2 A two-character code assigned to a transaction to identify where the transaction was created.	ML165 ML65.1
MTR-DATE Element: Date	Numeric 8 (yyyymmdd) Displays the system creation date.	ML165 ML65.1
MTR-REFERENCE Element: Reference	Alpha 10 (Lower Case) The reference number associated with the transaction.	ML165 ML65.1
MTR-DESCRIPTION Element: Description	Alpha 30 (Lower Case) Displays the transaction description.	ML165 ML65.1
MTR-CURRENCY-CODE Element: Currency Code	Alpha 5 Displays the transaction currency code.	ML165 ML65.1
MTR-UNITS-AMOUNT Element: Units Amount	Signed 15.2 Displays the transaction unit amount.	ML165 ML65.1
MTR-TRAN-AMOUNT Element: Intl Amt	Signed 18.2 Displays the transaction amount in transaction currency	ML165 ML65.1
MTR-BASE-AMOUNT Element: Intl Amt	Signed 18.2 Displays the transaction amount in base currency. If left blank, the interfacing program will use the currency routine to calculate the base amount using the transaction amount and transaction currency exchange rate.	ML165 ML65.1
MTR-BASERATE Element: Curr Rate	Signed 14.7 Displays the exchange rate between the transaction currency and the base currency. If left blank, the currency table exchange rate will default.	ML165 ML65.1
MTR-SYSTEM Element: System	Alpha 2 A two-character code representing an application used within the Lawson system (for example, ML).	ML165 ML65.1
MTR-PROGRAM-CODE Element: Program Code	Alpha 5 A program code used to identify where a transaction was created.	ML165 ML65.1
MTR-AUTO-REV Element: Auto Rev	Alpha 1 Auto reversal is the process of reversing the transaction. If you select auto reverse, Ledger Period Closing (ML199) creates a reversing journal entry in the next period for this transaction. Valid values are: Y = Yes N = No	ML165 ML65.1
MTR-POSTING-DATE Element: Posting Date	Numeric 8 (yyyymmdd) The date assigned to the journal entry for posting.	ML165 ML65.1
MTR-DOCUMENT-NBR Element: Document Nbr	Alpha 27 Displays the document number associated with the transaction.	ML165 ML65.1
MTR-TO-BASE-AMT Element: Intl Amt	Signed 18.2 Displays the To Company base amount.	ML165 ML65.1
MTR-JRNL-BOOK-NBR Element: Jrnl Book Nbr	Alpha 12 Displays the journal book associated with the transaction.	ML165 ML65.1
MTR-JBK-SEQ-NBR Element: Jbk Seq Nbr	Numeric 10 Displays the journal book sequence number associated with the transaction.	ML165 ML65.1
MTR-MX-VALUE Element: Mx Value	Alpha 32 Occurs 3 Times Contains the attribute value associated with the transaction.	ML165 ML65.1
MTR-MX-VALUE1 Element: Mx Value1	Derived The attribute value associated with the transaction.
MTR-MX-VALUE2 Element: Mx Value2	Derived The attribute value associated with the transaction.
MTR-MX-VALUE3 Element: Mx Value3	Derived The attribute value associated with the transaction.
MTR-NEGATIVE-ADJ Element: Negative Adj	Alpha 1 Indicates a negative adjustment for auto-reversing interfaced transactions; used if you have defined your company as requiring single type accounts.	ML65.1
MTR-RPT-AMOUNT-1 Element: Intl Amt	Signed 18.2 Displays the transaction amount in Report Currency 1.	ML165 ML65.1
MTR-RPT-RATE-1 Element: Curr Rate	Signed 14.7 Displays the exchange rate between the transaction currency and Report Currency 1.	ML165 ML65.1
MTR-RPT-ND-1 Element: Acct Nd	Numeric 1 Contains the number of decimal positions for Report Currency 1.	ML165 ML65.1
MTR-RPT-AMOUNT-2 Element: Intl Amt	Signed 18.2 Displays the transaction amount in Report Currency 2.	ML165 ML65.1
MTR-RPT-RATE-2 Element: Curr Rate	Signed 14.7 Displays the exchange rate between the transaction currency and Report Currency 2.	ML165 ML65.1
MTR-RPT-ND-2 Element: Acct Nd	Numeric 1 Contains the number of decimal positions for Report Currency 2.	ML165 ML65.1

MLTRANSREL FILE INDEX

MLTRANSREL FILE RELATIONS

ONE TO ONE RELATIONS

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