FND Design Data [Home] [Help]

Table: BOM_SHIFT_DATES

Product: BOM - Bills of Material
Description: Workday calendar shift dates
Implementation/DBA Data: TableBOM.BOM_SHIFT_DATES
Primary Key: BOM_SHIFT_DATES_PK
  1. ColumnCALENDAR_CODE
  2. ColumnEXCEPTION_SET_ID
  3. ColumnSHIFT_NUM
  4. ColumnSHIFT_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
BOM_SHIFT_DATES FK Joins to TableBOM_CALENDAR_SHIFTS BOM_SHIFT_DATES.CALENDAR_CODE
BOM_SHIFT_DATES.SHIFT_NUM
BOM_SHIFT_DATES FK Joins to TableBOM_EXCEPTION_SETS BOM_SHIFT_DATES.EXCEPTION_SET_ID
TableCRP_CAL_SHIFT_DELTA FK Joins to BOM_SHIFT_DATES CRP_CAL_SHIFT_DELTA.CALENDAR_CODE
CRP_CAL_SHIFT_DELTA.EXCEPTION_SET_ID
CRP_CAL_SHIFT_DELTA.SHIFT_NUM
CRP_CAL_SHIFT_DELTA.CALENDAR_DATE