MLTRANSREL – ML Transaction Interface
- System
- Multi-Ledger (ML)
- Prefix
MTR- Primary key
RUN-GROUP,SEQ-NUMBER- Fields
- 37
- Updated by
- 2 programs
- Referenced by
- 1 program
MLTRANSREL is the ML Transaction Interface table in Lawson Multi-Ledger (prefix MTR). It is indexed by RUN-GROUP, SEQ-NUMBER (MTRSET1); alternate indexes: MTRSET2 and MTRSET3. It is related 1:1 to GLSYSTEM, CUCODES, GLCOMPREL and GLCODES. It is updated by ML165 and ML65.1 and referenced by ML265. The table has 37 fields, 3 indexes and 5 documented relations.
About MLTRANSREL
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).
Fields (37)
Column = COBOL field name without the MTR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MTR-RUN-GROUP PKRUN_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 PKSEQ_NUMBER | Numeric 6 | A unique number assigned to each transaction to be transferred into the Lawson system. | ML165, ML65.1 |
MTR-LEDGERLEDGER | 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-COMPANYCOMPANY | 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-COMPANYOLD_COMPANY | Alpha 35 | The old company structure from which the records are interfaced. | ML165, ML65.1 |
MTR-OLD-CPY-SHORTOLD_CPY_SHORT | Derived | A short description for the old company. | — |
MTR-STRING-COMPANYSTRING_COMPANY | Derived | This is a derived string represented the old company. | — |
MTR-OLD-ACCT-NBROLD_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-SHORTOLD_ACCT_SHORT | Derived | A short description of the old account. | — |
MTR-SOURCE-CODESOURCE_CODE | Alpha 2 | A two-character code assigned to a transaction to identify where the transaction was created. | ML165, ML65.1 |
MTR-DATEDATE | Numeric 8 (yyyymmdd) | Displays the system creation date. | ML165, ML65.1 |
MTR-REFERENCEREFERENCE | Alpha 10 (Lower Case) | The reference number associated with the transaction. | ML165, ML65.1 |
MTR-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | Displays the transaction description. | ML165, ML65.1 |
MTR-CURRENCY-CODECURRENCY_CODE | Alpha 5 | Displays the transaction currency code. | ML165, ML65.1 |
MTR-UNITS-AMOUNTUNITS_AMOUNT | Signed 15.2 | Displays the transaction unit amount. | ML165, ML65.1 |
MTR-TRAN-AMOUNTTRAN_AMOUNT | Signed 18.2 | Displays the transaction amount in transaction currency | ML165, ML65.1 |
MTR-BASE-AMOUNTBASE_AMOUNT | 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-BASERATEBASERATE | 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-SYSTEMSYSTEM | Alpha 2 | A two-character code representing an application used within the Lawson system (for example, ML). | ML165, ML65.1 |
MTR-PROGRAM-CODEPROGRAM_CODE | Alpha 5 | A program code used to identify where a transaction was created. | ML165, ML65.1 |
MTR-AUTO-REVAUTO_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:
| ML165, ML65.1 |
MTR-POSTING-DATEPOSTING_DATE | Numeric 8 (yyyymmdd) | The date assigned to the journal entry for posting. | ML165, ML65.1 |
MTR-DOCUMENT-NBRDOCUMENT_NBR | Alpha 27 | Displays the document number associated with the transaction. | ML165, ML65.1 |
MTR-TO-BASE-AMTTO_BASE_AMT | Signed 18.2 | Displays the To Company base amount. | ML165, ML65.1 |
MTR-JRNL-BOOK-NBRJRNL_BOOK_NBR | Alpha 12 | Displays the journal book associated with the transaction. | ML165, ML65.1 |
MTR-JBK-SEQ-NBRJBK_SEQ_NBR | Numeric 10 | Displays the journal book sequence number associated with the transaction. | ML165, ML65.1 |
MTR-MX-VALUEMX_VALUE | Alpha 32 Occurs 3 Times ×3 | Contains the attribute value associated with the transaction. | ML165, ML65.1 |
MTR-MX-VALUE1MX_VALUE1 | Derived | The attribute value associated with the transaction. | — |
MTR-MX-VALUE2MX_VALUE2 | Derived | The attribute value associated with the transaction. | — |
MTR-MX-VALUE3MX_VALUE3 | Derived | The attribute value associated with the transaction. | — |
MTR-NEGATIVE-ADJNEGATIVE_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-1RPT_AMOUNT_1 | Signed 18.2 | Displays the transaction amount in Report Currency 1. | ML165, ML65.1 |
MTR-RPT-RATE-1RPT_RATE_1 | Signed 14.7 | Displays the exchange rate between the transaction currency and Report Currency 1. | ML165, ML65.1 |
MTR-RPT-ND-1RPT_ND_1 | Numeric 1 | Contains the number of decimal positions for Report Currency 1. | ML165, ML65.1 |
MTR-RPT-AMOUNT-2RPT_AMOUNT_2 | Signed 18.2 | Displays the transaction amount in Report Currency 2. | ML165, ML65.1 |
MTR-RPT-RATE-2RPT_RATE_2 | Signed 14.7 | Displays the exchange rate between the transaction currency and Report Currency 2. | ML165, ML65.1 |
MTR-RPT-ND-2RPT_ND_2 | Numeric 1 | Contains the number of decimal positions for Report Currency 2. | ML165, ML65.1 |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MTRSET1 | RUN-GROUP, SEQ-NUMBER | Primary | 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 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
Programs
Updated by (2)
Referenced by (1)
- ML265 Ledger Transaction Interface Listing