MLCUCNTRL – Ml Ledger Currency Control

System
Multi-Ledger (ML)
Prefix
MCC
Primary key
LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, AMT-TYPE, CURRENCY-CODE
Fields
14
Updated by
18 programs
Referenced by
0 programs

MLCUCNTRL is the Ml Ledger Currency Control table in Lawson Multi-Ledger (prefix MCC). It is indexed by LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, AMT-TYPE, CURRENCY-CODE (MCCSET1). It is updated by GL310, ML110, ML146, ML167, ML190, ML191, ML196, ML199 and 10 more. The table has 14 fields, 1 index and 0 documented relations.

About MLCUCNTRL

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the MCC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MCC-LEDGER PK
LEDGER		Alpha 15The ledger being posted to.ML110, ML146, ML167, ML190, ML191, ML196, ML199, ML40.1 +8 more
MCC-COMPANY PK
COMPANY		Numeric 4The Multi Book Ledger company for which you are posting transactions.ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +7 more
MCC-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4This is the current fiscal year. This field is updated by Ledger Period Closing (ML199).ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +7 more
MCC-ACCT-PERIOD PK
ACCT_PERIOD		Numeric 2This is the current accounting period. This field is updated by Ledger Period Closing (ML199).ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +7 more
MCC-SYSTEM PK
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. (for example, GL = General Ledger, AP = Accounts Payable, and so on).ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +7 more
MCC-JE-TYPE PK
JE_TYPE		Alpha 1The type of journal entry. Valid values are Normal and Intercompany.ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +7 more
MCC-CONTROL-GROUP PK
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, ML40.1, ML40.2 +7 more
MCC-JE-SEQUENCE PK
JE_SEQUENCE		Numeric 2The journal entry sequence number.ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +7 more
MCC-CURRENCY-CODE PK
CURRENCY_CODE		Alpha 5The field containing the transaction currency code.ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +7 more
MCC-AMT-TYPE PK
AMT_TYPE		Numeric 1The amount type can be either Report Currency One or Report Currency Two.ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +7 more
MCC-ENTRY-DB
ENTRY_DB		Signed 18.2Displays the total debit amount for the journal entry in transaction currency.ML146, ML167, ML190, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +3 more
MCC-ENTRY-CR
ENTRY_CR		Signed 18.2Displays the total credit amount for the journal entry in transaction currency.ML146, ML167, ML190, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +3 more
MCC-AUTO-DB
AUTO_DB		Signed 18.2This field will store the Auto Reverse Total Debits for a Journal Entry for Report Currency 1 and Report Currency 2.ML40.1, ML40.2, ML40.3, ML40.6, ML40.7, ML40.8, ML45.1
MCC-AUTO-CR
AUTO_CR		Signed 18.2This field will store the Auto Reverse Total Credits for a Journal Entry for Report Currency 1 and Report Currency 2.ML40.1, ML40.2, ML40.3, ML40.6, ML40.7, ML40.8, ML45.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MCCSET1LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, AMT-TYPE, CURRENCY-CODEPrimaryGL310, ML110, ML146, ML167, ML190, ML191, ML196, ML199 +10 more

Programs

Updated by (18)