Multi-Book Ledger Calendar Map

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

REFERENCED BY

ACVW.1	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	SLVW.1	SNOA.1
SNRA.1	SNSA.1

UPDATED BY

GL500

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
MCM-LEDGER Element: Ledger	Alpha 15 The ledger related to the mapped calendar.
MCM-COMPANY Element: Company	Numeric 4 This is the company the ledger is linked to
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).
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).
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.
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.
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
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
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.
MCM-CLOSE-SEQ Element: Message Seq	Numeric 2 Occurs 13 Times The number of close occurences for the period.
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

MLCALMAP FILE RELATIONS

ONE TO ONE RELATIONS

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