Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
SH FWEEK_PSCAT_SALES_MV (table)
Print
RSS
Modified on 2011/08/27 12:11
by
wikibot
Categorized as
Uncategorized
public application_service_map (table)
public ipinterface (table)
public location_specific_status_changes (table)
public node (table)
public outages (table)
public service (table)
public location_monitor_details (table)
public location_specific_status_changes (table)
OE PRODUCT_INFORMATION (table)
dbo uspLogError (procedure)
dbo uspPrintError (procedure)
Production TransactionHistory (table)
Sales (schema)
Sales Individual (table)
Sales SalesOrderHeader (table)
Sales SpecialOfferProduct (table)
Sales (schema)
Sales SalesPerson (table)
Sales SalesTerritory (table)
public location_monitors (table)
Sales (schema)
Sales Individual (table)
SH COSTS (table)
SH SALES (table)
HumanResources Employee (table)
HumanResources EmployeeAddress (table)
Person Address (table)
Person Contact (table)
Person CountryRegion (table)
Person StateProvince (table)
Sales (schema)
Sales SalesPerson (table)
Sales SalesTerritory (table)
public application_service_map (table)
public ipinterface (table)
public location_specific_status_changes (table)
public node (table)
public outages (table)
public service (table)
public location_monitor_details (table)
public location_specific_status_changes (table)
(10)
»
public location_monitors (table)
»
public ifservices (table)
»
SH FWEEK_PSCAT_SALES_MV (table)
[X]
»
Sales vSalesPerson (view)
»
SH PRODUCTS (table)
»
Sales vIndividualDemographics (view)
»
public location_monitor_details (table)
»
Sales SalesTerritoryHistory (table)
»
Sales SalesOrderDetail (table)
»
OE PRODUCT_DESCRIPTIONS (table)
»
public location_monitors (table)
»
public ifservices (table)
»
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
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.