SLCALDTL FILE
PL Calendar Detail
The Strategic Ledger Calendar Detail (SLCALDTL) file stores calendar detail
information defined in SL51.1 (Strategic Ledger Calendar).
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CDT-CALENDAR Alpha 15
Calendar The name that identifies the calendar.
CDT-FISCAL-YEAR Numeric 4
Fiscal Year This is the current fiscal year. This
field is updated by Period Closing
(GL199).
CDT-END-DATE Numeric 8 (yyyymmdd)
Period End Date The ending date in a range of dates.
CDT-CAL-PERIOD Numeric 3
Calendar Period The strategic ledger calendar
accounting period.
CDT-DESCRIPTION Alpha 30 (Lower Case)
Calendar Description This field displays the description.
SLCALDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDTSET1 CALENDAR
FISCAL-YEAR
END-DATE
CDTSET2 CALENDAR
END-DATE
FISCAL-YEAR
CDTSET3 CALENDAR
FISCAL-YEAR
CAL-PERIOD
END-DATE
SLCALDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Slcaldtl SLCALDTL Required
CDT-CALENDAR -> CDT-CALENDAR (CDTSET1)
CDT-FISCAL-YEAR -> CDT-FISCAL-YEAR
CDT-END-DATE -> CDT-END-DATE
|
