Calendars (CALENDAR)

The Calendars (meta_md_calendar) view allows you to define the yearly calendar that is used to specify work days and non-work days. For more information on setting up calendars, please see the How to Setup Calendars topic.

The calendars, work and non-work/holiday days that are created using the calendars view are used in the following programs:

• Sales Offices and Warehouses (ibis_cc96) - calendars are assigned to sales offices/warehouses via CC96.

• System Dates (ibis_cc30) - holidays or non-work days are skipped when automatically calculating the next working date. Dates are entered at the beginning of each year and last year's holidays must be deleted. If the holidays are not entered, the calculated next working day needs to be changed in CC30 for each holiday manually. For more information, please see the System Dates topic.

• Order Management Allocations (ibis_om30) - utilizes the calendar and calendar_day tables in iTopia.

Important PFE Note: The Update Calendar utility in Fiscal Date Entry (ibis_cc90) in PFE will automatically populate the calendar tables (md_calendar and md_calendar_day) in iTopia. Once you create a new fiscal year in PFE, you must run the Update Calendar utility in CC90. For more information, please see the CC90 help topic.

The following list defines every field available in the calendars (md_calendar) table in alphabetical order:

• Add Days for Year - enter the year to which you want to add days.

• Calendar - enter the calendar name. The name can be a maximum of 30 alpha numeric characters in length. Once the record is created, you cannot modify this field.

• Calendar Work Day Update - an expression column that includes a hyperlink to the Calendar Work Day Update view, which allows you to update work days associated with a particular calendar. For more information, see the Calendar Work Day Update topic.

• Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

• Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

• Custom Character 1-10 - used for potential customization purposes.

• Custom Date 1-5 - used for potential customization purposes.

• Custom Numeric 1-5 - used for potential customization purposes.

• Description 1 - a description in the first language, for example English.

• Description 2 - a description in the second language, for example French or Spanish.

• Modification Counter - this field is not maintainable. The date and time the record was last modified.

• Modified By - this field is not maintainable. The user or system process that last modified the record.

• Modified On - this field is not maintainable. The date on which the record was last modified.

• Start Day in Week - from the drop list, select the first day representing the start of the work week. The following are valid options:
  • 1 - Sunday
  • 2 - Monday (default)
  • 3 - Tuesday
  • 4 - Wednesday
  • 5 - Thursday
  • 6 - Friday
  • 7 - Saturday

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.