Difference between revisions of "SH.FWEEK PSCAT SALES MV (table)"

From dbscript Online Help
Jump to: navigation, search
 
Line 55: Line 55:
 
| '''Columns
 
| '''Columns
  
 +
|- valign="top"
 +
| FW_PSC_S_MV_CHAN_BIX
 +
|
 +
| CHANNEL_ID
 +
|- valign="top"
 +
| FW_PSC_S_MV_PROMO_BIX
 +
|
 +
| PROMO_ID
 
|- valign="top"
 
|- valign="top"
 
| FW_PSC_S_MV_SUBCAT_BIX
 
| FW_PSC_S_MV_SUBCAT_BIX
Line 63: Line 71:
 
|  
 
|  
 
| WEEK_ENDING_DAY
 
| WEEK_ENDING_DAY
|- valign="top"
 
| FW_PSC_S_MV_CHAN_BIX
 
|
 
| CHANNEL_ID
 
|- valign="top"
 
| FW_PSC_S_MV_PROMO_BIX
 
|
 
| PROMO_ID
 
 
|}
 
|}
  

Latest revision as of 10:36, 27 August 2011

wikibot[edit]

Table SH.FWEEK_PSCAT_SALES_MV

Columns[edit]

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[edit]

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[edit]

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