|
|
MLCALMAP FILE
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
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 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
UPDATED BY
GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MCM-LEDGER Alpha 15
Element: Ledger The ledger related to the mapped
calendar.
MCM-COMPANY Numeric 4
Element: Company This is the company the ledger is
linked to
MCM-FISCAL-YEAR Numeric 4
Element: Last Closed YeThis is the fiscal year assigned to
this Ledger and Company combination.
This field is updated by Ledger Period
Closing (ML199).
MCM-CURRENT-YR-FL Alpha 1
Element: Current Yr Fl 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 Numeric 8 (yyyymmdd) Occurs 13 Times
Element: Period End DatRequired 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 Alpha 1 Occurs 13 Times
Element: Period End CodThis 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 Numeric 2 Occurs 13 Times GL500
Element: Gl Mapped Per This is the corresponding GL period the
ML period is mapped to.
MCM-GL-MAPPED-FY Numeric 4 Occurs 13 Times GL500
Element: Gl Mapped Fy This is the GL fiscal year in which
the mapped period is assigned.
MCM-BACKPOST Alpha 1 Occurs 13 Times
Element: Backpost 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 Numeric 2 Occurs 13 Times
Element: Message Seq The number of close occurences for the
period.
MCM-PER-END-DATE1 Derived
Element: Per End Date1
MCM-PER-END-DATE2 Derived
Element: Per End Date2
MCM-PER-END-DATE3 Derived
Element: Per End Date3
MCM-PER-END-DATE4 Derived
Element: Per End Date4
MCM-PER-END-DATE5 Derived
Element: Per End Date5
MCM-PER-END-DATE6 Derived
Element: Per End Date6
MCM-PER-END-DATE7 Derived
Element: Per End Date7
MCM-PER-END-DATE8 Derived
Element: Per End Date8
MCM-PER-END-DATE9 Derived
Element: Per End Date9
MCM-PER-END-DATE10 Derived
Element: Per End Date10
MCM-PER-END-DATE11 Derived
Element: Per End Date11
MCM-PER-END-DATE12 Derived
Element: Per End Date12
MCM-PER-END-DATE13 Derived
Element: Per End Date13
MCM-PER-END-CODE1 Derived
Element: Per End Code1
MCM-PER-END-CODE2 Derived
Element: Per End Code2
MCM-PER-END-CODE3 Derived
Element: Per End Code3
MCM-PER-END-CODE4 Derived
Element: Per End Code4
MCM-PER-END-CODE5 Derived
Element: Per End Code5
MCM-PER-END-CODE6 Derived
Element: Per End Code6
MCM-PER-END-CODE7 Derived
Element: Per End Code7
MCM-PER-END-CODE8 Derived
Element: Per End Code8
MCM-PER-END-CODE9 Derived
Element: Per End Code9
MCM-PER-END-CODE10 Derived
Element: Per End Code10
MCM-PER-END-CODE11 Derived
Element: Per End Code11
MCM-PER-END-CODE12 Derived
Element: Per End Code12
MCM-PER-END-CODE13 Derived
Element: Per End Code13
MCM-GL-MAP-PER1 Derived
Element: Gl Map Per1
MCM-GL-MAP-PER2 Derived
Element: Gl Map Per2
MCM-GL-MAP-PER3 Derived
Element: Gl Map Per3
MCM-GL-MAP-PER4 Derived
Element: Gl Map Per4
MCM-GL-MAP-PER5 Derived
Element: Gl Map Per5
MCM-GL-MAP-PER6 Derived
Element: Gl Map Per6
MCM-GL-MAP-PER7 Derived
Element: Gl Map Per7
MCM-GL-MAP-PER8 Derived
Element: Gl Map Per8
MCM-GL-MAP-PER9 Derived
Element: Gl Map Per9
MCM-GL-MAP-PER10 Derived
Element: Gl Map Per10
MCM-GL-MAP-PER11 Derived
Element: Gl Map Per11
MCM-GL-MAP-PER12 Derived
Element: Gl Map Per12
MCM-GL-MAP-PER13 Derived
Element: Gl Map Per13
MCM-GL-MAP-FY1 Derived
Element: Gl Map Fy1
MCM-GL-MAP-FY2 Derived
Element: Gl Map Fy2
MCM-GL-MAP-FY3 Derived
Element: Gl Map Fy3
MCM-GL-MAP-FY4 Derived
Element: Gl Map Fy4
MCM-GL-MAP-FY5 Derived
Element: Gl Map Fy5
MCM-GL-MAP-FY6 Derived
Element: Gl Map Fy6
MCM-GL-MAP-FY7 Derived
Element: Gl Map Fy7
MCM-GL-MAP-FY8 Derived
Element: Gl Map Fy8
MCM-GL-MAP-FY9 Derived
Element: Gl Map Fy9
MCM-GL-MAP-FY10 Derived
Element: Gl Map Fy10
MCM-GL-MAP-FY11 Derived
Element: Gl Map Fy11
MCM-GL-MAP-FY12 Derived
Element: Gl Map Fy12
MCM-GL-MAP-FY13 Derived
Element: Gl Map Fy13
MCM-BLANK Derived
Element: Blank 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 AC121 AC123
COMPANY AC130 AC20.1
FISCAL-YEAR AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 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
...
MCMSET2 CURRENT-YR-FL KeyChange, Subset GL165 GL65.1
LEDGER Where CURRENT-YR-FL = "Y"
COMPANY
FISCAL-YEAR
MCMSET3 COMPANY KeyChange, Subset
LEDGER Where CURRENT-YR-FL = "Y"
CURRENT-YR-FL
MLCALMAP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
