MLTRANS – ML Transactions

System
Multi-Ledger (ML)
Prefix
MLT
Primary key
OBJ-ID
Fields
54
Updated by
20 programs
Referenced by
11 programs

MLTRANS is the ML Transactions table in Lawson Multi-Ledger (prefix MLT). It is indexed by OBJ-ID (MLTSET1); alternate indexes: MLTSET2, MLTSET3, MLTSET4 and MLTSET7. It is related 1:1 to GLMASTER, GLSYSTEM, GLSRCCODE, MLCOLEDGER, MLCONTROL and MLRJCNTRL and 1:M to MLMXVALUE and MLTRANS. It is updated by GL120, GL310, ML110, ML146, ML167, ML190, ML191, ML196 and 12 more and referenced by ML10.1, ML12.1, ML145, ML170, ML240, ML241, ML290, ML325 and 3 more. The table has 54 fields, 5 indexes and 9 documented relations.

About MLTRANS

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.

Fields (54)

Column = COBOL field name without the MLT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MLT-LEDGER SET2 SET3 SET4 SET7
LEDGER		Alpha 15The ledger to which journal entries are posted.ML110, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +9 more
#MLT-COMPANY SET2
COMPANY		Numeric 4The company to which journal entries are posted. It must be defined as a ledger company on Ledger Setup (ML10.1).ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-FISCAL-YEAR SET2 SET3 SET4 SET7
FISCAL_YEAR		Numeric 4The year for which the journal entry is posted.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-ACCT-PERIOD SET2 SET3 SET4 SET7
ACCT_PERIOD		Numeric 2The period for which the journal entry is posted.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-CONTROL-GROUP SET2
CONTROL_GROUP		Numeric 8This field contains the journal entry number used for process control of the journal entry detail.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-SYSTEM SET2
SYSTEM		Alpha 2The system code associated with the journal entry.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-JE-TYPE SET2
JE_TYPE		Alpha 1The journal entry type (Normal or Intercompany).ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-JE-TYPE-1
JE_TYPE_1		DerivedThe derived journal entry type.—
#MLT-JE-SEQUENCE SET2
JE_SEQUENCE		Numeric 2The journal entry sequence number.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-LINE-NBR SET2
LINE_NBR		Numeric 6The journal entry line number.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +7 more
#MLT-OBJ-ID PK
OBJ_ID		Numeric 12Contains the object ID sequence number for the transaction.ML110, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +9 more
#MLT-STATUS
STATUS		Numeric 1This field displays the status of the transaction.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-VAR-LEVELS
VAR_LEVELS		Alpha 30The variable level to which the journal entry is posted. A level represents the location of an accounting unit in an organization's level structure.GL120, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +8 more
#MLT-ACCT-UNIT SET3 SET4 SET7
ACCT_UNIT		Alpha 15The accounting unit to which the journal entry is posted.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +7 more
#MLT-ACCOUNT SET3 SET4 SET7
ACCOUNT		Numeric 6The account to which the journal entry is posted.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +7 more
#MLT-SUB-ACCOUNT SET3 SET4 SET7
SUB_ACCOUNT		Numeric 4The subaccount to which the journal entry is posted.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +7 more
#MLT-SOURCE-CODE
SOURCE_CODE		Alpha 2A two-character code assigned to a transaction to identify where the transaction was created (for example, ME).ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +7 more
#MLT-DATE
DATE		Numeric 8 (yyyymmdd)Contains the system creation date.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-REFERENCE
REFERENCE		Alpha 10 (Lower Case)Displays the reference number associated with the transaction.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Displays the transaction description.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-SHORT-DESC
SHORT_DESC		DerivedContains the transaction short description.—
#MLT-BASE-AMOUNT
BASE_AMOUNT		Signed 18.2Displays the transaction amount in base currency.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +13 more
#MLT-BASE-ND
BASE_ND		Numeric 1Indicates the number of positions defined for the company base currency.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +7 more
#MLT-UNITS-AMOUNT
UNITS_AMOUNT		Signed 15.2Displays the units amount associated with the transaction.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +13 more
#MLT-AUTO-REV
AUTO_REV		Alpha 1When the Auto Reversal field is set to Yes, the Ledger Period Closing (ML199) creates an opposite entry for this transaction in the next period.ML146, ML167, ML190, ML191, ML199, ML290, ML40.1, ML40.2 +6 more
#MLT-TO-COMPANY SET3 SET4 SET7
TO_COMPANY		Numeric 4The company number to which the transaction line is posted.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-BASE-ZONE
BASE_ZONE		Alpha 15The zone within the Lawson General Ledger application where the transaction originated.ML146, ML167, ML190, ML191, ML199, ML290, ML40.1, ML40.2 +6 more
#MLT-POSTING-DATE
POSTING_DATE		Numeric 8 (yyyymmdd)The date assigned to the journal entry for posting.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field displays the transaction currency code used for the journal entry.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-BASERATE
BASERATE		Signed 14.7This field displays the exchange rate from the transaction currency to the company base currency.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-TRAN-AMOUNT
TRAN_AMOUNT		Signed 18.2This field displays the amount in transaction currency to be posted.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +14 more
#MLT-TRAN-ND
TRAN_ND		Numeric 1Indicates the number of positions defined for the transaction currency.ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +6 more
#MLT-ACCT-CURRENCY
ACCT_CURRENCY		Alpha 5This is the account currency, if applicable.ML146, ML167, ML190, ML191, ML196, ML290, ML40.1, ML40.2 +7 more
#MLT-ACCT-RATE
ACCT_RATE		Signed 14.7This is the exchange rate from the transaction currency to the account currency.ML146, ML167, ML190, ML191, ML196, ML290, ML40.1, ML40.2 +7 more
#MLT-ACCT-AMOUNT
ACCT_AMOUNT		Signed 18.2The transaction amount in account currency.ML146, ML167, ML190, ML191, ML196, ML290, ML40.1, ML40.2 +9 more
#MLT-ACCT-ND
ACCT_ND		Numeric 1Indicates the number of positions defined for the account currency.ML146, ML167, ML190, ML191, ML196, ML40.1, ML40.2, ML40.3 +5 more
#MLT-ORIG-COMPANY
ORIG_COMPANY		Numeric 4The originating company number.ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +6 more
#MLT-ORIG-PROGRAM
ORIG_PROGRAM		Alpha 5The originating program number.ML146, ML167, ML191, ML196, ML290, ML40.1, ML40.2, ML40.3 +5 more
#MLT-OPERATOR
OPERATOR		Alpha 10This field is used to store the login ID of the person who entered the record.ML146, ML167, ML190, ML191, ML196, ML199, ML290, ML40.1 +8 more
#MLT-TO-BASE-AMT
TO_BASE_AMT		Signed 18.2To company base amountML146, ML40.1, ML40.2, ML40.3, ML40.5, ML40.6, ML40.7, ML40.8 +5 more
#MLT-TO-BASE-ND
TO_BASE_ND		Numeric 1To company base number of decimals.ML146, ML240, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7, ML40.8 +3 more
#MLT-TO-BASERATE
TO_BASERATE		Signed 14.7To company base currency exchange rate.ML146, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7, ML40.8, ML44.1 +2 more
#MLT-TO-BASE-CURR
TO_BASE_CURR		Alpha 5To company base currency.ML146, ML167, ML190, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +4 more
#MLT-RECONCILE
RECONCILE		Alpha 2Indicates the reconciliation transactions.ML290, ML90.4
#MLT-NEGATIVE-ADJ
NEGATIVE_ADJ		Alpha 1Indicates a negative adjustment.ML146, ML167, ML190, ML196, ML290, ML40.1, ML40.2, ML40.3 +5 more
#MLT-UPDATE-DATE
UPDATE_DATE		Numeric 8 (yyyymmdd)This field contains the date the record was posted.ML146, ML190, ML199, ML290, ML40.1, ML40.2, ML40.3, ML40.7 +3 more
#MLT-SEQ-TRNS-NBR
SEQ_TRNS_NBR		Numeric 10Contains the journal entry transaction sequence number.ML146, ML190, ML199, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8 +2 more
#MLT-JBK-TRNS-NBR
JBK_TRNS_NBR		Numeric 10Contains the journal book transaction sequence number.ML146, ML190, ML199, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8 +2 more
#MLT-RPT-AMOUNT-1
RPT_AMOUNT_1		Signed 18.2The transaction amount for Report Currency 1.GL310, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +12 more
#MLT-RPT-RATE-1
RPT_RATE_1		Signed 14.7The exchange rate to convert the transaction to report currency 1.GL310, ML146, ML167, ML190, ML191, ML199, ML290, ML40.1 +8 more
#MLT-RPT-ND-1
RPT_ND_1		Numeric 1The number of decimal positions for Report Currency 1.GL310, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +9 more
#MLT-RPT-AMOUNT-2
RPT_AMOUNT_2		Signed 18.2The transaction amount for Report Currency 2.GL310, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +12 more
#MLT-RPT-RATE-2
RPT_RATE_2		Signed 14.7The exchange rate to convert the transaction to report currency 2.GL310, ML146, ML167, ML190, ML191, ML199, ML290, ML40.1 +8 more
#MLT-RPT-ND-2
RPT_ND_2		Numeric 1The number of decimal positions for Report Currency 2.GL310, ML146, ML167, ML190, ML191, ML196, ML199, ML290 +9 more

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MLTSET1
  1. OBJ-ID
PrimaryML146, ML190, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8, ML44.1 +2 more
MLTSET2
  1. LEDGER
  2. COMPANY
  3. FISCAL-YEAR
  4. ACCT-PERIOD
  5. SYSTEM
  6. JE-TYPE
  7. CONTROL-GROUP
  8. JE-SEQUENCE
  9. LINE-NBR
  10. OBJ-ID
KeyChangeGL310, ML10.1, ML110, ML12.1, ML145, ML146, ML170, ML190 +18 more
MLTSET3
  1. LEDGER
  2. TO-COMPANY
  3. FISCAL-YEAR
  4. ACCT-PERIOD
  5. ACCT-UNIT
  6. ACCOUNT
  7. SUB-ACCOUNT
  8. OBJ-ID
KeyChange, SubsetWhere STATUS != 8GL120, ML199, ML290, ML325, ML327
MLTSET4
  1. LEDGER
  2. TO-COMPANY
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. ACCT-UNIT
  6. FISCAL-YEAR
  7. ACCT-PERIOD
  8. OBJ-ID
KeyChange, SubsetWhere STATUS != 8GL120, ML90.1, ML90.2, ML90.4, ML90.5
MLTSET7
  1. LEDGER
  2. TO-COMPANY
  3. FISCAL-YEAR
  4. ACCT-PERIOD
  5. ACCOUNT
  6. SUB-ACCOUNT
  7. ACCT-UNIT
  8. OBJ-ID
KeyChange, SubsetWhere STATUS != 8ML290

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERGLSYSTEMGLSRCCODEMLCOLEDGERMLCONTROLMLRJCNTRLMLMXVALUEMLTRANSMLTRANS

One to one (7) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequired
MLT-TO-COMPANY→GLM-COMPANY
MLT-ACCT-UNIT→GLM-ACCT-UNIT
MLT-ACCOUNT→GLM-ACCOUNT
MLT-SUB-ACCOUNT→GLM-SUB-ACCOUNT
CompanyGLSYSTEMRequired
MLT-COMPANY→GLS-COMPANY
GlsrccodeGLSRCCODERequired
MLT-SOURCE-CODE→GSR-SOURCE-CODE
GlsystemGLSYSTEMRequired
MLT-COMPANY→GLS-COMPANY
MlcoledgerMLCOLEDGERRequired
MLT-LEDGER→MLE-LEDGER
MLT-COMPANY→MLE-COMPANY
MlcontrolMLCONTROLRequired
MLT-LEDGER→MLC-LEDGER
MLT-COMPANY→MLC-COMPANY
MLT-FISCAL-YEAR→MLC-FISCAL-YEAR
MLT-ACCT-PERIOD→MLC-ACCT-PERIOD
MLT-SYSTEM→MLC-SYSTEM
MLT-JE-TYPE→MLC-JE-TYPE
MLT-CONTROL-GROUP→MLC-CONTROL-GROUP
MLT-JE-SEQUENCE→MLC-JE-SEQUENCE
MlrjcntrlMLRJCNTRLNot Required
MLT-LEDGER→MRC-LEDGER
MLT-COMPANY→MRC-COMPANY
MLT-JE-TYPE→MRC-JE-TYPE
MLT-CONTROL-GROUP→MRC-REC-GROUP

One to many (2) — child tables

RelationTableRulesConditionField map
MlmxvalueMLMXVALUEDelete Cascades
MLT-OBJ-ID→MLV-OBJ-ID
—→MLV-MATRIX-CAT
MltransMLTRANS
MLT-LEDGER→MLT-LEDGER
MLT-COMPANY→MLT-COMPANY
MLT-FISCAL-YEAR→MLT-FISCAL-YEAR
MLT-ACCT-PERIOD→MLT-ACCT-PERIOD
MLT-SYSTEM→MLT-SYSTEM
MLT-JE-TYPE→MLT-JE-TYPE
MLT-CONTROL-GROUP→MLT-CONTROL-GROUP
MLT-JE-SEQUENCE→MLT-JE-SEQUENCE
—→MLT-LINE-NBR
—→MLT-OBJ-ID

Programs

Updated by (20)

Referenced by (11)