SH.TIMES (table)

wikibot

Table

SH.TIMES

Column	Data Type	Nullable	Default	PK	Index
TIME_ID	DATE	not null		TIMES_PK
DAY_NAME	VARCHAR2	not null
DAY_NUMBER_IN_WEEK	NUMBER	not null
DAY_NUMBER_IN_MONTH	NUMBER	not null
CALENDAR_WEEK_NUMBER	NUMBER	not null
FISCAL_WEEK_NUMBER	NUMBER	not null
WEEK_ENDING_DAY	DATE	not null
WEEK_ENDING_DAY_ID	NUMBER	not null
CALENDAR_MONTH_NUMBER	NUMBER	not null
FISCAL_MONTH_NUMBER	NUMBER	not null
CALENDAR_MONTH_DESC	VARCHAR2	not null
CALENDAR_MONTH_ID	NUMBER	not null
FISCAL_MONTH_DESC	VARCHAR2	not null
FISCAL_MONTH_ID	NUMBER	not null
DAYS_IN_CAL_MONTH	NUMBER	not null
DAYS_IN_FIS_MONTH	NUMBER	not null
END_OF_CAL_MONTH	DATE	not null
END_OF_FIS_MONTH	DATE	not null
CALENDAR_MONTH_NAME	VARCHAR2	not null
FISCAL_MONTH_NAME	VARCHAR2	not null
CALENDAR_QUARTER_DESC	CHAR(7)	not null
CALENDAR_QUARTER_ID	NUMBER	not null
FISCAL_QUARTER_DESC	CHAR(7)	not null
FISCAL_QUARTER_ID	NUMBER	not null
DAYS_IN_CAL_QUARTER	NUMBER	not null
DAYS_IN_FIS_QUARTER	NUMBER	not null
END_OF_CAL_QUARTER	DATE	not null
END_OF_FIS_QUARTER	DATE	not null
CALENDAR_QUARTER_NUMBER	NUMBER	not null
FISCAL_QUARTER_NUMBER	NUMBER	not null
CALENDAR_YEAR	NUMBER	not null
CALENDAR_YEAR_ID	NUMBER	not null
FISCAL_YEAR	NUMBER	not null
FISCAL_YEAR_ID	NUMBER	not null
DAYS_IN_CAL_YEAR	NUMBER	not null
DAYS_IN_FIS_YEAR	NUMBER	not null
END_OF_CAL_YEAR	DATE	not null
END_OF_FIS_YEAR	DATE	not null

Detail Table	Column	Referencing Column
SH.COSTS	TIME_ID	TIME_ID
SH.SALES	TIME_ID	TIME_ID