MLCALMAP FILE
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 AC30.2 AC30.3 AC32.1 AC490
ACVW.1 AM180 CA10.5 CA110 FB100 FB20.1
FB20.6 FB20.7 FB21.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL165 GL65.1 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MCM-LEDGER Alpha 15
Ledger The ledger being posted to.
MCM-COMPANY Numeric 4
Company This is the company the ledger is
linked to
MCM-FISCAL-YEAR Numeric 4
Fiscal Year 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 Alpha 1
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
Period End Date 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 Alpha 1 Occurs 13 Times
Period End Code 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 Numeric 2 Occurs 13 Times
Gl Mapped Per This is the corresponding GL period the
ML period is mapped to.
MCM-GL-MAPPED-FY Numeric 4 Occurs 13 Times
Gl Mapped Fy This is the GL fiscal year in which
the mapped period is assigned.
MCM-BACKPOST Alpha 1 Occurs 13 Times
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
Closing Sequence The sequence number of the entry.
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
AC30.2 AC30.3
AC32.1 AC490
ACVW.1 AM180
CA10.5 CA110
FB100 FB20.1
FB20.6 FB20.7
FB21.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL165
GL65.1 GL95.1
...
MCMSET2 CURRENT-YR-FL KeyChange, Subset GL165 GL65.1
LEDGER Where CURRENT-YR-FL = "Y"
COMPANY
FISCAL-YEAR
|
