SH FWEEK_PSCAT_SALES_MV (table)
wikibot
¶
Table
SH.FWEEK_PSCAT_SALES_MV
Columns
¶
Column
Data Type
Nullable
Default
Description
WEEK_ENDING_DAY
DATE(7)
not null
PROD_SUBCATEGORY
VARCHAR2(50)
not null
DOLLARS
NUMBER
null
CHANNEL_ID
NUMBER
not null
PROMO_ID
NUMBER
not null
Indexes
¶
Index
Type
Columns
FW_PSC_S_MV_CHAN_BIX
CHANNEL_ID
FW_PSC_S_MV_PROMO_BIX
PROMO_ID
FW_PSC_S_MV_SUBCAT_BIX
PROD_SUBCATEGORY
FW_PSC_S_MV_WD_BIX
WEEK_ENDING_DAY
Check Constraints
¶
Check Constraint
Expression
Description
SYS_C005198
"WEEK_ENDING_DAY" IS NOT NULL
SYS_C005199
"PROD_SUBCATEGORY" IS NOT NULL
SYS_C005200
"CHANNEL_ID" IS NOT NULL
SYS_C005201
"PROMO_ID" IS NOT NULL