MLTRANSREL

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MTRSET1 RUN-GROUP
SEQ-NUMBER
ML165 ML265
ML65.1
MTRSET2 LEDGER
COMPANY
OLD-COMPANY
OLD-ACCT-NBR
RUN-GROUP
SEQ-NUMBER
KeyChange
ML165
MTRSET3 RUN-GROUP
LEDGER
COMPANY
OLD-COMPANY
OLD-ACCT-NBR
SEQ-NUMBER
KeyChange
ML165


MLTRANSREL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
MTR-COMPANY->GLS-COMPANY
Currency Code CUCODES Not Required
MTR-CURRENCY-CODE->CUC-CURRENCY-CODE
Old Company GLCOMPREL Required
MTR-OLD-COMPANY->GCR-OLD-COMPANY
Source Code GLCODES Not Required
MTR-SOURCE-CODE->GCD-SOURCE-CODE
System Code GLCODES Not Required
MTR-COMPANY->GCD-COMPANY
MTR-SYSTEM->GCD-SYSTEM


File created: Thu Jun 09 02:23:59 2016

Home
Contact Us



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