MLCALMAP

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MCMSET1 LEDGER
COMPANY
FISCAL-YEAR
...
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
GL500 GL65.1
GL90.6 GL94.1
GL94.2 GL94.3
MCMSET2 CURRENT-YR-FL
LEDGER
COMPANY
FISCAL-YEAR
KeyChange, Subset
WhereCURRENT-YR-FL ="Y"
GL165 GL65.1
MCMSET3 COMPANY
LEDGER
CURRENT-YR-FL
KeyChange, Subset
WhereCURRENT-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)
Mlcoledger MLCOLEDGER Not Required
MCM-COMPANY->MLE-COMPANY
MCM-LEDGER->MLE-LEDGER


File created: Wed Jun 08 20:50:15 2016

Home
Contact Us



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