SH.FWEEK PSCAT SALES MV (table)
From dbscript Online Help
Contents |
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_SUBCAT_BIX | PROD_SUBCATEGORY | |
| FW_PSC_S_MV_WD_BIX | WEEK_ENDING_DAY | |
| FW_PSC_S_MV_CHAN_BIX | CHANNEL_ID | |
| FW_PSC_S_MV_PROMO_BIX | PROMO_ID |
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 |
