MLCALMAP – Multi-Book Ledger Calendar Map

System
Multi-Ledger (ML)
Prefix
MCM
Primary key
LEDGER, COMPANY, FISCAL-YEAR
Fields
63
Updated by
8 programs
Referenced by
192 programs

MLCALMAP is the Multi-Book Ledger Calendar Map table in Lawson Multi-Ledger (prefix MCM). It is indexed by LEDGER, COMPANY, FISCAL-YEAR (MCMSET1); alternate indexes: MCMSET2 and MCMSET3. It is related 1:1 to GLSYSTEM, MCMBOD and MLCOLEDGER. It is updated by GL500, ML110, ML111, ML12.1, ML12.2, ML167, ML190 and ML199 and referenced by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 184 more. The table has 63 fields, 3 indexes and 3 documented relations.

About MLCALMAP

The Multi-Ledger Calendar Map file stores calendar mapping information for a ledger and company.

Fields (63)

Column = COBOL field name without the MCM- 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
#MCM-LEDGER PK
LEDGER		Alpha 15The ledger related to the mapped calendar.ML110, ML12.1, ML199
#MCM-COMPANY PK
COMPANY		Numeric 4This is the company the ledger is linked toML12.1, ML199
#MCM-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4This is the fiscal year assigned to this Ledger and Company combination. This field is updated by Ledger Period Closing (ML199).ML110, ML12.1, ML199
#MCM-CURRENT-YR-FL SET2 SET3
CURRENT_YR_FL		Alpha 1This flag indicates which record is the current year. A Yes in this field will indicate that the fiscal year in this record is the current year for the ledger. This field is updated by Ledger Period Closing (ML199).ML110, ML12.1, ML199
#MCM-PER-END-DATE
PER_END_DATE		Numeric 8 (yyyymmdd) Occurs 13 Times ×13Required for the number of account periods for the current year in the ledger. The period end date is used to determine the period to which the transactions are posted. These dates are changed by GL199 if the ML Close flag on the ledger is set to "N" or it is changed by Ledger Period Closing (ML199). if the same flag is set to "Y", when closing period 12 of the current year.ML110, ML12.1, ML199
#MCM-PER-END-CODE
PER_END_CODE		Alpha 1 Occurs 13 Times ×13This field is used to indicate the closing status for each period. Occurrence 1-13 = Current year period ending code. Occurrence 14-26 = Last year period ending code. These fields are changed by GL199 (if the ML Close flag on the ledger is set to "N" ), ML199 (if the same flag is set to "Y"), or Backpost Control. If closing the period, the period end code is set to indicate a limited close or a final close. If closing for a year, the period end code will be set to indicate a limited or final close and also current year is changed to last year.ML110, ML111, ML12.1, ML12.2, ML167, ML199
#MCM-GL-MAPPED-PER
GL_MAPPED_PER		Numeric 2 Occurs 13 Times ×13This is the corresponding GL period the ML period is mapped to.GL500, ML110, ML12.1, ML199
#MCM-GL-MAPPED-FY
GL_MAPPED_FY		Numeric 4 Occurs 13 Times ×13This is the GL fiscal year in which the mapped period is assigned.GL500, ML110, ML12.1, ML199
#MCM-BACKPOST
BACKPOST		Alpha 1 Occurs 13 Times ×13This field is used to indicate if backposting has occurred for a period. Occurrence 1-13 = Current year periods. Occurrence 14-26 = Last year periods.ML110, ML12.1, ML190, ML199
#MCM-CLOSE-SEQ
CLOSE_SEQ		Numeric 2 Occurs 13 Times ×13The number of close occurences for the period.ML110, ML12.1, ML167, ML199
#MCM-PER-END-DATE1
PER_END_DATE1		Derived——
#MCM-PER-END-DATE2
PER_END_DATE2		Derived——
#MCM-PER-END-DATE3
PER_END_DATE3		Derived——
#MCM-PER-END-DATE4
PER_END_DATE4		Derived——
#MCM-PER-END-DATE5
PER_END_DATE5		Derived——
#MCM-PER-END-DATE6
PER_END_DATE6		Derived——
#MCM-PER-END-DATE7
PER_END_DATE7		Derived——
#MCM-PER-END-DATE8
PER_END_DATE8		Derived——
#MCM-PER-END-DATE9
PER_END_DATE9		Derived——
#MCM-PER-END-DATE10
PER_END_DATE10		Derived——
#MCM-PER-END-DATE11
PER_END_DATE11		Derived——
#MCM-PER-END-DATE12
PER_END_DATE12		Derived——
#MCM-PER-END-DATE13
PER_END_DATE13		Derived——
#MCM-PER-END-CODE1
PER_END_CODE1		Derived——
#MCM-PER-END-CODE2
PER_END_CODE2		Derived——
#MCM-PER-END-CODE3
PER_END_CODE3		Derived——
#MCM-PER-END-CODE4
PER_END_CODE4		Derived——
#MCM-PER-END-CODE5
PER_END_CODE5		Derived——
#MCM-PER-END-CODE6
PER_END_CODE6		Derived——
#MCM-PER-END-CODE7
PER_END_CODE7		Derived——
#MCM-PER-END-CODE8
PER_END_CODE8		Derived——
#MCM-PER-END-CODE9
PER_END_CODE9		Derived——
#MCM-PER-END-CODE10
PER_END_CODE10		Derived——
#MCM-PER-END-CODE11
PER_END_CODE11		Derived——
#MCM-PER-END-CODE12
PER_END_CODE12		Derived——
#MCM-PER-END-CODE13
PER_END_CODE13		Derived——
#MCM-GL-MAP-PER1
GL_MAP_PER1		Derived——
#MCM-GL-MAP-PER2
GL_MAP_PER2		Derived——
#MCM-GL-MAP-PER3
GL_MAP_PER3		Derived——
#MCM-GL-MAP-PER4
GL_MAP_PER4		Derived——
#MCM-GL-MAP-PER5
GL_MAP_PER5		Derived——
#MCM-GL-MAP-PER6
GL_MAP_PER6		Derived——
#MCM-GL-MAP-PER7
GL_MAP_PER7		Derived——
#MCM-GL-MAP-PER8
GL_MAP_PER8		Derived——
#MCM-GL-MAP-PER9
GL_MAP_PER9		Derived——
#MCM-GL-MAP-PER10
GL_MAP_PER10		Derived——
#MCM-GL-MAP-PER11
GL_MAP_PER11		Derived——
#MCM-GL-MAP-PER12
GL_MAP_PER12		Derived——
#MCM-GL-MAP-PER13
GL_MAP_PER13		Derived——
#MCM-GL-MAP-FY1
GL_MAP_FY1		Derived——
#MCM-GL-MAP-FY2
GL_MAP_FY2		Derived——
#MCM-GL-MAP-FY3
GL_MAP_FY3		Derived——
#MCM-GL-MAP-FY4
GL_MAP_FY4		Derived——
#MCM-GL-MAP-FY5
GL_MAP_FY5		Derived——
#MCM-GL-MAP-FY6
GL_MAP_FY6		Derived——
#MCM-GL-MAP-FY7
GL_MAP_FY7		Derived——
#MCM-GL-MAP-FY8
GL_MAP_FY8		Derived——
#MCM-GL-MAP-FY9
GL_MAP_FY9		Derived——
#MCM-GL-MAP-FY10
GL_MAP_FY10		Derived——
#MCM-GL-MAP-FY11
GL_MAP_FY11		Derived——
#MCM-GL-MAP-FY12
GL_MAP_FY12		Derived——
#MCM-GL-MAP-FY13
GL_MAP_FY13		Derived——
#MCM-BLANK
BLANK		DerivedThis derived field is always blank. It is used in the Drill Around feature for column headings.—

Indexes (3)

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
MCMSET1
  1. LEDGER
  2. COMPANY
  3. FISCAL-YEAR
PrimaryAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
MCMSET2
  1. CURRENT-YR-FL
  2. LEDGER
  3. COMPANY
  4. FISCAL-YEAR
KeyChange, SubsetWhere CURRENT-YR-FL = "Y"GL165, GL65.1, ML10.1, ML110, ML12.1, ML12.2, ML145, ML146 +22 more (list truncated in source)
MCMSET3
  1. COMPANY
  2. LEDGER
  3. CURRENT-YR-FL
KeyChange, SubsetWhere CURRENT-YR-FL = "Y"—

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMNot Required
MCM-COMPANY→GLS-COMPANY (GLSSET1)
McmbodMCMBODNot Required, Delete Cascades
MCM-LEDGER→MBD-LEDGER
MCM-COMPANY→MBD-COMPANY
MCM-FISCAL-YEAR→MBD-FISCAL-YEAR
MlcoledgerMLCOLEDGERNot Required
MCM-COMPANY→MLE-COMPANY
MCM-LEDGER→MLE-LEDGER

Programs

Updated by (8)

Referenced by (192)