Lawson - Lawson Software Technical Library - Data File Text for MLCALMAP

MLCALMAP

Multi-Book Ledger Calendar Map

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

REFERENCED BY

AC121 AC123 AC130 AC20.1 AC20.2 AC20.3

AC20.4 AC20.5 AC32.1 AC37.1 AC490 ACVW.1

ATVW.1 AD191 AM180 CA10.5 CA110 FB100

FB11.1 FB111 FB160 FB20.1 FB20.6 FB20.7

FB21.1 FB211 FB296 FB60.1 FB95.1 FB95.2

FB95.3 FB95.4 FB95.5 FB95.6 GL165 GL298

GL299 GL65.1 GL90.6 GL94.1 GL94.2 GL94.3

GL94.4 GL94.5 GL94.6 GL94.7 GL95.1 GL95.2

GL95.3 GL95.4 GL95.5 GL95.6 GL95.7 GL95.8

GL95.9 GL96.1 GL96.2 GL96.3 GL96.4 GL96.5

GL97.1 GL97.2 GL97.3 GL97.4 GL97.5 GL97.6

GL97.7 GL97.8 GL97.9 GL98.1 GL98.2 GL98.3

GL98.4 GL98.5 GL99.1 GL99.2 GL99.3 GL99.4

GL99.5 GL99.6 RW100 RW230 RW270 RW30.1

RW70.1 RW80.1 GLAV.1 GLCV.1 GLVW.1 ML10.1

ML145 ML146 ML165 ML170 ML191 ML195

ML196 ML212 ML240 ML241 ML245 ML250

ML267 ML270 ML275 ML290 ML291 ML292

ML293 ML300 ML320 ML325 ML327 ML330

ML40.1 ML40.2 ML40.3 ML40.4 ML40.5 ML40.6

ML40.7 ML40.8 ML41.1 ML41.3 ML41.4 ML42.1

ML44.1 ML45.1 ML50.1 ML50.2 ML50.4 ML50.5

ML65.1 ML65.3 ML67.1 ML70.1 ML70.2 ML70.3

ML70.5 ML70.6 ML75.1 ML90.1 ML90.2 ML90.3

ML90.4 ML90.5 ML94.1 ML94.2 ML94.3 ML94.4

ML95.1 ML95.2 ML95.3 ML95.4 ML95.5 ML95.6

ML95.7 ML95.8 ML95.9 ML96.1 ML96.2 ML96.3

ML96.4 ML96.5 ML97.1 ML97.2 ML97.3 ML97.4

ML97.5 ML97.6 ML97.7 ML97.8 ML97.9 ML98.1

ML98.2 ML98.3 ML98.4 ML98.5 ML99.1 ML99.2

ML99.3 ML99.4 ML99.5 ML99.6 MLBD.1 MLBD.2

MLFC.1 MLIT.1 SLVW.1 SNOA.1 SNRA.1 SNSA.1

UPDATED BY

GL500 ML110 ML111 ML12.1 ML12.2 ML167

ML190 ML199

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY

MCM-LEDGER
Element: Ledger Alpha 15
The ledger related to the mapped calendar.

ML110 ML12.1

ML199

MCM-COMPANY
Element: Company Numeric 4
This is the company the ledger is linked to

ML12.1 ML199

MCM-FISCAL-YEAR
Element: Year Numeric 4
This 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
Element: Current Yr Fl Alpha 1
This 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
Element: Per End Date Numeric 8 (yyyymmdd) Occurs 13 Times
Required 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
Element: Per End Code Alpha 1 Occurs 13 Times
This 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
Element: Gl Mapped Per Numeric 2 Occurs 13 Times
This is the corresponding GL period the ML period is mapped to.

GL500 ML110

ML12.1 ML199

MCM-GL-MAPPED-FY
Element: Gl Mapped Fy Numeric 4 Occurs 13 Times
This is the GL fiscal year in which the mapped period is assigned.

GL500 ML110

ML12.1 ML199

MCM-BACKPOST
Element: Backpost Alpha 1 Occurs 13 Times
This 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
Element: Message Seq Numeric 2 Occurs 13 Times
The number of close occurences for the period.

ML110 ML12.1

ML167 ML199

MCM-PER-END-DATE1
Element: Per End Date1 Derived

MCM-PER-END-DATE2
Element: Per End Date2 Derived

MCM-PER-END-DATE3
Element: Per End Date3 Derived

MCM-PER-END-DATE4
Element: Per End Date4 Derived

MCM-PER-END-DATE5
Element: Per End Date5 Derived

MCM-PER-END-DATE6
Element: Per End Date6 Derived

MCM-PER-END-DATE7
Element: Per End Date7 Derived

MCM-PER-END-DATE8
Element: Per End Date8 Derived

MCM-PER-END-DATE9
Element: Per End Date9 Derived

MCM-PER-END-DATE10
Element: Per End Date10 Derived

MCM-PER-END-DATE11
Element: Per End Date11 Derived

MCM-PER-END-DATE12
Element: Per End Date12 Derived

MCM-PER-END-DATE13
Element: Per End Date13 Derived

MCM-PER-END-CODE1
Element: Per End Code1 Derived

MCM-PER-END-CODE2
Element: Per End Code2 Derived

MCM-PER-END-CODE3
Element: Per End Code3 Derived

MCM-PER-END-CODE4
Element: Per End Code4 Derived

MCM-PER-END-CODE5
Element: Per End Code5 Derived

MCM-PER-END-CODE6
Element: Per End Code6 Derived

MCM-PER-END-CODE7
Element: Per End Code7 Derived

MCM-PER-END-CODE8
Element: Per End Code8 Derived

MCM-PER-END-CODE9
Element: Per End Code9 Derived

MCM-PER-END-CODE10
Element: Per End Code10 Derived

MCM-PER-END-CODE11
Element: Per End Code11 Derived

MCM-PER-END-CODE12
Element: Per End Code12 Derived

MCM-PER-END-CODE13
Element: Per End Code13 Derived

MCM-GL-MAP-PER1
Element: Gl Map Per1 Derived

MCM-GL-MAP-PER2
Element: Gl Map Per2 Derived

MCM-GL-MAP-PER3
Element: Gl Map Per3 Derived

MCM-GL-MAP-PER4
Element: Gl Map Per4 Derived

MCM-GL-MAP-PER5
Element: Gl Map Per5 Derived

MCM-GL-MAP-PER6
Element: Gl Map Per6 Derived

MCM-GL-MAP-PER7
Element: Gl Map Per7 Derived

MCM-GL-MAP-PER8
Element: Gl Map Per8 Derived

MCM-GL-MAP-PER9
Element: Gl Map Per9 Derived

MCM-GL-MAP-PER10
Element: Gl Map Per10 Derived

MCM-GL-MAP-PER11
Element: Gl Map Per11 Derived

MCM-GL-MAP-PER12
Element: Gl Map Per12 Derived

MCM-GL-MAP-PER13
Element: Gl Map Per13 Derived

MCM-GL-MAP-FY1
Element: Gl Map Fy1 Derived

MCM-GL-MAP-FY2
Element: Gl Map Fy2 Derived

MCM-GL-MAP-FY3
Element: Gl Map Fy3 Derived

MCM-GL-MAP-FY4
Element: Gl Map Fy4 Derived

MCM-GL-MAP-FY5
Element: Gl Map Fy5 Derived

MCM-GL-MAP-FY6
Element: Gl Map Fy6 Derived

MCM-GL-MAP-FY7
Element: Gl Map Fy7 Derived

MCM-GL-MAP-FY8
Element: Gl Map Fy8 Derived

MCM-GL-MAP-FY9
Element: Gl Map Fy9 Derived

MCM-GL-MAP-FY10
Element: Gl Map Fy10 Derived

MCM-GL-MAP-FY11
Element: Gl Map Fy11 Derived

MCM-GL-MAP-FY12
Element: Gl Map Fy12 Derived

MCM-GL-MAP-FY13
Element: Gl Map Fy13 Derived

MCM-BLANK
Element: Blank Derived
This derived field is always blank. It is used in the Drill Around feature for column headings.

MLCALMAP FILE INDEX

NAME

KEY FIELDS

DESCRIPTION / SUBSET CONDITION

USED IN

MCMSET1

LEDGER
COMPANY
FISCAL-YEAR

...

AC121	AC123
AC130	AC20.1
AC20.2	AC20.3
AC20.4	AC20.5
AC32.1	AC37.1
AC490	ACVW.1
ATVW.1	AD191
AM180	CA10.5
CA110	FB100
FB11.1	FB111
FB160	FB20.1
FB20.6	FB20.7
FB21.1	FB211
FB296	FB60.1
FB95.1	FB95.2

MCMSET2

CURRENT-YR-FL
LEDGER
COMPANY
FISCAL-YEAR

KeyChange, Subset
Where		CURRENT-YR-FL	=	"Y"

...

GL165	GL65.1
ML10.1	ML110
ML12.1	ML12.2
ML145	ML146
ML165	ML167
ML170	ML190
ML191	ML195
ML196	ML199
ML240	ML241
ML245	ML250
ML267	ML270
ML275	ML290
ML291	ML292
ML293	ML300
ML320	ML325

MCMSET3

COMPANY
LEDGER
CURRENT-YR-FL

KeyChange, Subset
Where		CURRENT-YR-FL	=	"Y"

MLCALMAP FILE RELATIONS

ONE TO ONE RELATIONS

RELATION
NAME

RELATED FILE

INTEGRITY RULES / FIELD MATCH

Company

GLSYSTEM

Not Required

MCM-COMPANY

GLS-COMPANY (GLSSET1)

Mcmbod

MCMBOD

Not Required, Delete Cascades

MCM-LEDGER	->	MBD-LEDGER
MCM-COMPANY	->	MBD-COMPANY
MCM-FISCAL-YEAR	->	MBD-FISCAL-YEAR

Mlcoledger

MLCOLEDGER

Not Required

MCM-COMPANY	->	MLE-COMPANY
MCM-LEDGER	->	MLE-LEDGER

File created: Thu Jun 09 02:23:52 2016

Home
Contact Us

All trademarks and registered trademarks are the property of their respective owners.