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 |
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. |
|
||
MTR-SEQ-NUMBER Element: Seq Number | Numeric 6 A unique number assigned to each transaction to be transferred into the Lawson system. |
|
||
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). |
|
||
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). |
|
||
MTR-OLD-COMPANY Element: Old Company | Alpha 35 The old company structure from which the records are interfaced. |
|
||
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. |
|
||
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. |
|
||
MTR-DATE Element: Date | Numeric 8 (yyyymmdd) Displays the system creation date. |
|
||
MTR-REFERENCE Element: Reference | Alpha 10 (Lower Case) The reference number associated with the transaction. |
|
||
MTR-DESCRIPTION Element: Description | Alpha 30 (Lower Case) Displays the transaction description. |
|
||
MTR-CURRENCY-CODE Element: Currency Code | Alpha 5 Displays the transaction currency code. |
|
||
MTR-UNITS-AMOUNT Element: Units Amount | Signed 15.2 Displays the transaction unit amount. |
|
||
MTR-TRAN-AMOUNT Element: Intl Amt | Signed 18.2 Displays the transaction amount in transaction currency |
|
||
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. |
|
||
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. |
|
||
MTR-SYSTEM Element: System | Alpha 2 A two-character code representing an application used within the Lawson system (for example, ML). |
|
||
MTR-PROGRAM-CODE Element: Program Code | Alpha 5 A program code used to identify where a transaction was created. |
|
||
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 |
|
||
MTR-POSTING-DATE Element: Posting Date | Numeric 8 (yyyymmdd) The date assigned to the journal entry for posting. |
|
||
MTR-DOCUMENT-NBR Element: Document Nbr | Alpha 27 Displays the document number associated with the transaction. |
|
||
MTR-TO-BASE-AMT Element: Intl Amt | Signed 18.2 Displays the To Company base amount. |
|
||
MTR-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 Displays the journal book associated with the transaction. |
|
||
MTR-JBK-SEQ-NBR Element: Jbk Seq Nbr | Numeric 10 Displays the journal book sequence number associated with the transaction. |
|
||
MTR-MX-VALUE Element: Mx Value | Alpha 32 Occurs 3 Times Contains the attribute value associated with the transaction. |
|
||
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. |
|
||
MTR-RPT-AMOUNT-1 Element: Intl Amt | Signed 18.2 Displays the transaction amount in Report Currency 1. |
|
||
MTR-RPT-RATE-1 Element: Curr Rate | Signed 14.7 Displays the exchange rate between the transaction currency and Report Currency 1. |
|
||
MTR-RPT-ND-1 Element: Acct Nd | Numeric 1 Contains the number of decimal positions for Report Currency 1. |
|
||
MTR-RPT-AMOUNT-2 Element: Intl Amt | Signed 18.2 Displays the transaction amount in Report Currency 2. |
|
||
MTR-RPT-RATE-2 Element: Curr Rate | Signed 14.7 Displays the exchange rate between the transaction currency and Report Currency 2. |
|
||
MTR-RPT-ND-2 Element: Acct Nd | Numeric 1 Contains the number of decimal positions for Report Currency 2. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MTRSET1 |
RUN-GROUP SEQ-NUMBER |
|
| ||||||||||
MTRSET2 |
LEDGER COMPANY OLD-COMPANY OLD-ACCT-NBR RUN-GROUP SEQ-NUMBER |
|
| ||||||||||
MTRSET3 |
RUN-GROUP LEDGER COMPANY OLD-COMPANY OLD-ACCT-NBR SEQ-NUMBER |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Company | GLSYSTEM |
Required
| ||||||
Currency Code | CUCODES |
Not Required
| ||||||
Old Company | GLCOMPREL |
Required
| ||||||
Source Code | GLCODES |
Not Required
| ||||||
System Code | GLCODES |
Not Required
|
All trademarks and registered trademarks are the property of their
respective owners.