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.PROMOTIONS_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
(6)
»
OE.PROMOTIONS_(table)
»
HumanResources.Employee_(table)
»
SH.PROMOTIONS_(table)
[X]
»
Sales.SalesPersonQuotaHistory_(table)
»
Production.ProductReview_(table)
»
Sales.Individual_(table)
»
OE.PROMOTIONS_(table)
»
HumanResources.Employee_(table)
»
SH.PROMOTIONS_(table)
Edit
wikibot
Table
SH.PROMOTIONS
Column
Data Type
Nullable
Default
PK
Index
PROMO_ID
NUMBER(6, 0)
not null
PROMO_PK
PROMO_NAME
VARCHAR2(30)
not null
PROMO_SUBCATEGORY
VARCHAR2(30)
not null
PROMO_SUBCATEGORY_ID
NUMBER
not null
PROMO_CATEGORY
VARCHAR2(30)
not null
PROMO_CATEGORY_ID
NUMBER
not null
PROMO_COST
NUMBER(10, 2)
not null
PROMO_BEGIN_DATE
DATE(7)
not null
PROMO_END_DATE
DATE(7)
not null
PROMO_TOTAL
VARCHAR2(15)
not null
PROMO_TOTAL_ID
NUMBER
not null
Detail Table
Column
Referencing Column
SH.COSTS
PROMO_ID
PROMO_ID
SH.SALES
PROMO_ID
PROMO_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.