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.SALES_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
(10)
»
IX.AQ$_STREAMS_QUEUE_TABLE_S_(table)
»
public.setifservicekeysonupdate_(trigger_function)
»
SH.SALES_(table)
[X]
»
Production.Illustration_(table)
»
Person.Contact_(table)
»
Purchasing.ShipMethod_(table)
»
public.reportlocator_(table)
»
Production.ProductDescription_(table)
»
OE.CATEGORIES_TAB_(table)
»
HumanResources.Shift_(table)
»
IX.AQ$_STREAMS_QUEUE_TABLE_S_(table)
»
public.setifservicekeysonupdate_(trigger_function)
»
SH.SALES_(table)
Edit
wikibot
Table
SH.SALES
Column
Data Type
Nullable
Default
PK
Index
PROD_ID
NUMBER
not null
SALES_PROD_BIX
CUST_ID
NUMBER
not null
SALES_CUST_BIX
TIME_ID
DATE(7)
not null
SALES_TIME_BIX
CHANNEL_ID
NUMBER
not null
SALES_CHANNEL_BIX
PROMO_ID
NUMBER
not null
SALES_PROMO_BIX
QUANTITY_SOLD
NUMBER(10, 2)
not null
AMOUNT_SOLD
NUMBER(10, 2)
not null
Relation
Column
Referenced Column
SH.CHANNELS
CHANNEL_ID
CHANNEL_ID
SH.CUSTOMERS
CUST_ID
CUST_ID
SH.PRODUCTS
PROD_ID
PROD_ID
SH.PROMOTIONS
PROMO_ID
PROMO_ID
SH.TIMES
TIME_ID
TIME_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.