ScrewTurn Wiki

Edit

wikibot

TableSH.TIMES

ColumnData TypeNullableDefaultPKIndex
TIME_IDDATE(7)not null TIMES_PK 
DAY_NAMEVARCHAR2(9)not null   
DAY_NUMBER_IN_WEEKNUMBER(1, 0)not null   
DAY_NUMBER_IN_MONTHNUMBER(2, 0)not null   
CALENDAR_WEEK_NUMBERNUMBER(2, 0)not null   
FISCAL_WEEK_NUMBERNUMBER(2, 0)not null   
WEEK_ENDING_DAYDATE(7)not null   
WEEK_ENDING_DAY_IDNUMBERnot null   
CALENDAR_MONTH_NUMBERNUMBER(2, 0)not null   
FISCAL_MONTH_NUMBERNUMBER(2, 0)not null   
CALENDAR_MONTH_DESCVARCHAR2(8)not null   
CALENDAR_MONTH_IDNUMBERnot null   
FISCAL_MONTH_DESCVARCHAR2(8)not null   
FISCAL_MONTH_IDNUMBERnot null   
DAYS_IN_CAL_MONTHNUMBERnot null   
DAYS_IN_FIS_MONTHNUMBERnot null   
END_OF_CAL_MONTHDATE(7)not null   
END_OF_FIS_MONTHDATE(7)not null   
CALENDAR_MONTH_NAMEVARCHAR2(9)not null   
FISCAL_MONTH_NAMEVARCHAR2(9)not null   
CALENDAR_QUARTER_DESCCHAR(7)not null   
CALENDAR_QUARTER_IDNUMBERnot null   
FISCAL_QUARTER_DESCCHAR(7)not null   
FISCAL_QUARTER_IDNUMBERnot null   
DAYS_IN_CAL_QUARTERNUMBERnot null   
DAYS_IN_FIS_QUARTERNUMBERnot null   
END_OF_CAL_QUARTERDATE(7)not null   
END_OF_FIS_QUARTERDATE(7)not null   
CALENDAR_QUARTER_NUMBERNUMBER(1, 0)not null   
FISCAL_QUARTER_NUMBERNUMBER(1, 0)not null   
CALENDAR_YEARNUMBER(4, 0)not null   
CALENDAR_YEAR_IDNUMBERnot null   
FISCAL_YEARNUMBER(4, 0)not null   
FISCAL_YEAR_IDNUMBERnot null   
DAYS_IN_CAL_YEARNUMBERnot null   
DAYS_IN_FIS_YEARNUMBERnot null   
END_OF_CAL_YEARDATE(7)not null   
END_OF_FIS_YEARDATE(7)not null   



Detail TableColumnReferencing Column
SH.COSTSTIME_IDTIME_ID
SH.SALESTIME_IDTIME_ID

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.