SH FWEEK_PSCAT_SALES_MV (table)

wikibot

TableSH.FWEEK_PSCAT_SALES_MV

Columns

ColumnData TypeNullableDefaultDescription
WEEK_ENDING_DAYDATE(7)not null  
PROD_SUBCATEGORYVARCHAR2(50)not null  
DOLLARSNUMBERnull  
CHANNEL_IDNUMBERnot null  
PROMO_IDNUMBERnot null  

Indexes

IndexTypeColumns
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 ConstraintExpressionDescription
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