ML Transactions
The Multi Book Ledger Transaction file contains the journal entry detail information to be posted to the Lawson Multi Book Ledger application. The transactions are not deleted when posted and Multi Ledger History Delete (ML300) should be run to clear out information no longer needed.
REFERENCED BY
ML10.1 | ML12.1 | ML145 | ML170 | ML240 | ML241 |
ML41.1 | ML41.3 | ML290 | ML325 | ML327 |
GL120 | GL310 | ML110 | ML146 | ML167 | ML190 |
ML191 | ML196 | ML199 | ML300 | ML40.1 | ML40.2 |
ML40.3 | ML40.6 | ML40.7 | ML40.8 | ML44.1 | ML45.1 |
ML90.4 | MLIT.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MLT-LEDGER Element: Ledger | Alpha 15 The ledger to which journal entries are posted. |
|
||||||||||||||||||||||
MLT-COMPANY Element: Company | Numeric 4 The company to which journal entries are posted. It must be defined as a ledger company on Ledger Setup (ML10.1). |
|
||||||||||||||||||||||
MLT-FISCAL-YEAR Element: Year | Numeric 4 The year for which the journal entry is posted. |
|
||||||||||||||||||||||
MLT-ACCT-PERIOD Element: Acct Period | Numeric 2 The period for which the journal entry is posted. |
|
||||||||||||||||||||||
MLT-CONTROL-GROUP Element: Control Group | Numeric 8 This field contains the journal entry number used for process control of the journal entry detail. |
|
||||||||||||||||||||||
MLT-SYSTEM Element: System | Alpha 2 The system code associated with the journal entry. |
|
||||||||||||||||||||||
MLT-JE-TYPE Element: Je Type | Alpha 1 The journal entry type (Normal or Intercompany). |
|
||||||||||||||||||||||
MLT-JE-TYPE-1 Element: Je Type 1 | Derived The derived journal entry type. |
|
||||||||||||||||||||||
MLT-JE-SEQUENCE Element: Je Sequence | Numeric 2 The journal entry sequence number. |
|
||||||||||||||||||||||
MLT-LINE-NBR Element: Line Nbr | Numeric 6 The journal entry line number. |
|
||||||||||||||||||||||
MLT-OBJ-ID Element: Obj Id | Numeric 12 Contains the object ID sequence number for the transaction. |
|
||||||||||||||||||||||
MLT-STATUS Element: Status | Numeric 1 This field displays the status of the transaction. |
|
||||||||||||||||||||||
MLT-VAR-LEVELS Element: Var Levels | Alpha 30 The variable level to which the journal entry is posted. A level represents the location of an accounting unit in an organization's level structure. |
|
||||||||||||||||||||||
MLT-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit to which the journal entry is posted. |
|
||||||||||||||||||||||
MLT-ACCOUNT Element: Account | Numeric 6 The account to which the journal entry is posted. |
|
||||||||||||||||||||||
MLT-SUB-ACCOUNT Element: Sub Acct | Numeric 4 The subaccount to which the journal entry is posted. |
|
||||||||||||||||||||||
MLT-SOURCE-CODE Element: Source Code | Alpha 2 A two-character code assigned to a transaction to identify where the transaction was created (for example, ME). |
|
||||||||||||||||||||||
MLT-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the system creation date. |
|
||||||||||||||||||||||
MLT-REFERENCE Element: Reference | Alpha 10 (Lower Case) Displays the reference number associated with the transaction. |
|
||||||||||||||||||||||
MLT-DESCRIPTION Element: Description | Alpha 30 (Lower Case) Displays the transaction description. |
|
||||||||||||||||||||||
MLT-SHORT-DESC Element: Short Desc | Derived Contains the transaction short description. |
|
||||||||||||||||||||||
MLT-BASE-AMOUNT Element: Intl Amt | Signed 18.2 Displays the transaction amount in base currency. |
|
||||||||||||||||||||||
MLT-BASE-ND Element: Base Nd | Numeric 1 Indicates the number of positions defined for the company base currency. |
|
||||||||||||||||||||||
MLT-UNITS-AMOUNT Element: Units Amount | Signed 15.2 Displays the units amount associated with the transaction. |
|
||||||||||||||||||||||
MLT-AUTO-REV Element: Auto Rev | Alpha 1 When the Auto Reversal field is set to Yes, the Ledger Period Closing (ML199) creates an opposite entry for this transaction in the next period. |
|
||||||||||||||||||||||
MLT-TO-COMPANY Element: Company | Numeric 4 The company number to which the transaction line is posted. |
|
||||||||||||||||||||||
MLT-BASE-ZONE Element: Zone | Alpha 15 The zone within the Lawson General Ledger application where the transaction originated. |
|
||||||||||||||||||||||
MLT-POSTING-DATE Element: Posting Date | Numeric 8 (yyyymmdd) The date assigned to the journal entry for posting. |
|
||||||||||||||||||||||
MLT-CURRENCY-CODE Element: Transaction Currency | Alpha 5 This field displays the transaction currency code used for the journal entry. |
|
||||||||||||||||||||||
MLT-BASERATE Element: Curr Rate | Signed 14.7 This field displays the exchange rate from the transaction currency to the company base currency. |
|
||||||||||||||||||||||
MLT-TRAN-AMOUNT Transaction Currency Amount | Signed 18.2 This field displays the amount in transaction currency to be posted. |
|
||||||||||||||||||||||
MLT-TRAN-ND Element: Acct Nd | Numeric 1 Indicates the number of positions defined for the transaction currency. |
|
||||||||||||||||||||||
MLT-ACCT-CURRENCY Element: Currency Code | Alpha 5 This is the account currency, if applicable. |
|
||||||||||||||||||||||
MLT-ACCT-RATE Element: Curr Rate | Signed 14.7 This is the exchange rate from the transaction currency to the account currency. |
|
||||||||||||||||||||||
MLT-ACCT-AMOUNT Element: Intl Amt | Signed 18.2 The transaction amount in account currency. |
|
||||||||||||||||||||||
MLT-ACCT-ND Element: Acct Nd | Numeric 1 Indicates the number of positions defined for the account currency. |
|
||||||||||||||||||||||
MLT-ORIG-COMPANY Element: Company | Numeric 4 The originating company number. |
|
||||||||||||||||||||||
MLT-ORIG-PROGRAM Element: Program | Alpha 5 The originating program number. |
|
||||||||||||||||||||||
MLT-OPERATOR Element: Operator | Alpha 10 This field is used to store the login ID of the person who entered the record. |
|
||||||||||||||||||||||
MLT-TO-BASE-AMT Element: Intl Amt | Signed 18.2 To company base amount |
|
||||||||||||||||||||||
MLT-TO-BASE-ND Element: Acct Nd | Numeric 1 To company base number of decimals. |
|
||||||||||||||||||||||
MLT-TO-BASERATE Element: Curr Rate | Signed 14.7 To company base currency exchange rate. |
|
||||||||||||||||||||||
MLT-TO-BASE-CURR Element: Currency Code | Alpha 5 To company base currency. |
|
||||||||||||||||||||||
MLT-RECONCILE Element: Reconcile | Alpha 2 Indicates the reconciliation transactions. |
|
||||||||||||||||||||||
MLT-NEGATIVE-ADJ Element: Negative Adj | Alpha 1 Indicates a negative adjustment. |
|
||||||||||||||||||||||
MLT-UPDATE-DATE Element: Date | Numeric 8 (yyyymmdd) This field contains the date the record was posted. |
|
||||||||||||||||||||||
MLT-SEQ-TRNS-NBR Element: Seq Trns Nbr | Numeric 10 Contains the journal entry transaction sequence number. |
|
||||||||||||||||||||||
MLT-JBK-TRNS-NBR Element: Jbk Trns Nbr | Numeric 10 Contains the journal book transaction sequence number. |
|
||||||||||||||||||||||
MLT-RPT-AMOUNT-1 Element: Intl Amt | Signed 18.2 The transaction amount for Report Currency 1. |
|
||||||||||||||||||||||
MLT-RPT-RATE-1 Element: Curr Rate | Signed 14.7 The exchange rate to convert the transaction to report currency 1. |
|
||||||||||||||||||||||
MLT-RPT-ND-1 Element: Acct Nd | Numeric 1 The number of decimal positions for Report Currency 1. |
|
||||||||||||||||||||||
MLT-RPT-AMOUNT-2 Element: Intl Amt | Signed 18.2 The transaction amount for Report Currency 2. |
|
||||||||||||||||||||||
MLT-RPT-RATE-2 Element: Curr Rate | Signed 14.7 The exchange rate to convert the transaction to report currency 2. |
|
||||||||||||||||||||||
MLT-RPT-ND-2 Element: Acct Nd | Numeric 1 The number of decimal positions for Report Currency 2. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MLTSET1 |
OBJ-ID |
|
| ||||||||||||||||||||||||||||||||
MLTSET2 |
LEDGER COMPANY FISCAL-YEAR ACCT-PERIOD SYSTEM JE-TYPE CONTROL-GROUP JE-SEQUENCE LINE-NBR OBJ-ID |
|
| ||||||||||||||||||||||||||||||||
MLTSET3 |
LEDGER TO-COMPANY FISCAL-YEAR ACCT-PERIOD ACCT-UNIT ACCOUNT SUB-ACCOUNT OBJ-ID |
|
| ||||||||||||||||||||||||||||||||
MLTSET4 |
LEDGER TO-COMPANY ACCOUNT SUB-ACCOUNT ACCT-UNIT FISCAL-YEAR ACCT-PERIOD OBJ-ID |
|
| ||||||||||||||||||||||||||||||||
MLTSET7 |
LEDGER TO-COMPANY FISCAL-YEAR ACCT-PERIOD ACCOUNT SUB-ACCOUNT ACCT-UNIT OBJ-ID |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Account | GLMASTER |
Required
| ||||||||||||||||||||||||
Company | GLSYSTEM |
Required
| ||||||||||||||||||||||||
Glsrccode | GLSRCCODE |
Required
| ||||||||||||||||||||||||
Glsystem | GLSYSTEM |
Required
| ||||||||||||||||||||||||
Mlcoledger | MLCOLEDGER |
Required
| ||||||||||||||||||||||||
Mlcontrol | MLCONTROL |
Required
| ||||||||||||||||||||||||
Mlrjcntrl | MLRJCNTRL |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Mlmxvalue | MLMXVALUE |
Delete Cascades
| ||||||||||||||||||||||||||||||
Mltrans | MLTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.