FND Design Data [Home] [Help]

Table: MSC_CALENDAR_SHIFTS

Product: MSC - Advanced Supply Chain Planning
Description: Workday calendar shifts
Implementation/DBA Data: TableMSC.MSC_CALENDAR_SHIFTS
Primary Key: MSC_CALENDAR_SHIFTS_PK
  1. ColumnCALENDAR_CODE
  2. ColumnSR_INSTANCE_ID
  3. ColumnSHIFT_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
TableMSC_SHIFT_DATES FK Joins to MSC_CALENDAR_SHIFTS MSC_SHIFT_DATES.SR_INSTANCE_ID
MSC_SHIFT_DATES.CALENDAR_CODE
MSC_SHIFT_DATES.SHIFT_NUM
TableMSC_SHIFT_EXCEPTIONS FK Joins to MSC_CALENDAR_SHIFTS MSC_SHIFT_EXCEPTIONS.SR_INSTANCE_ID
MSC_SHIFT_EXCEPTIONS.CALENDAR_CODE
MSC_SHIFT_EXCEPTIONS.SHIFT_NUM