ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
SH.FWEEK_PSCAT_SALES_MV_(table)
Print
RSS
Modified: 2010/06/24 06:53 by
wikibot
-
Uncategorized
(10)
»
HR.LOCATIONS_(table)
»
Sales.SalesOrderDetail_(table)
»
SH.FWEEK_PSCAT_SALES_MV_(table)
[X]
»
IX.STREAMS_QUEUE_TABLE_(table)
»
HumanResources.JobCandidate_(table)
»
IX.ORDERS_QUEUETABLE_(table)
»
public.vulnplugins_(table)
»
SH.CHANNELS_(table)
»
HumanResources.Department_(table)
»
HR.COUNTRIES_(table)
»
HR.LOCATIONS_(table)
»
Sales.SalesOrderDetail_(table)
»
SH.FWEEK_PSCAT_SALES_MV_(table)
Edit
wikibot
Table
SH.FWEEK_PSCAT_SALES_MV
Edit
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
Edit
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
Edit
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 2.0.36. Some of the icons created by
FamFamFam
.