SH.TIMES (table)

wikibot

Table

SH.TIMES

Column	Data Type	Nullable	Default	PK	Index
TIME_ID	DATE(7)	not null		TIMES_PK
DAY_NAME	VARCHAR2(9)	not null
DAY_NUMBER_IN_WEEK	NUMBER(1, 0)	not null
DAY_NUMBER_IN_MONTH	NUMBER(2, 0)	not null
CALENDAR_WEEK_NUMBER	NUMBER(2, 0)	not null
FISCAL_WEEK_NUMBER	NUMBER(2, 0)	not null
WEEK_ENDING_DAY	DATE(7)	not null
WEEK_ENDING_DAY_ID	NUMBER	not null
CALENDAR_MONTH_NUMBER	NUMBER(2, 0)	not null
FISCAL_MONTH_NUMBER	NUMBER(2, 0)	not null
CALENDAR_MONTH_DESC	VARCHAR2(8)	not null
CALENDAR_MONTH_ID	NUMBER	not null
FISCAL_MONTH_DESC	VARCHAR2(8)	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(7)	not null
END_OF_FIS_MONTH	DATE(7)	not null
CALENDAR_MONTH_NAME	VARCHAR2(9)	not null
FISCAL_MONTH_NAME	VARCHAR2(9)	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(7)	not null
END_OF_FIS_QUARTER	DATE(7)	not null
CALENDAR_QUARTER_NUMBER	NUMBER(1, 0)	not null
FISCAL_QUARTER_NUMBER	NUMBER(1, 0)	not null
CALENDAR_YEAR	NUMBER(4, 0)	not null
CALENDAR_YEAR_ID	NUMBER	not null
FISCAL_YEAR	NUMBER(4, 0)	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(7)	not null
END_OF_FIS_YEAR	DATE(7)	not null

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