From dbscript Online Help
wikibot
Table
|
Sales.SpecialOffer
|
Description
|
Sale discounts lookup table.
|
Columns
Column
|
Data Type
|
Nullable
|
Default
|
Description
|
SpecialOfferID
|
int
|
not null
|
|
Primary key for SpecialOffer records.
|
Description
|
nvarchar(255)
|
not null
|
|
Discount description.
|
DiscountPct
|
smallmoney
|
not null
|
((0.00))
|
Discount precentage.
|
Type
|
nvarchar(50)
|
not null
|
|
Discount type category.
|
Category
|
nvarchar(50)
|
not null
|
|
Group the discount applies to such as Reseller or Customer.
|
StartDate
|
datetime
|
not null
|
|
Discount start date.
|
EndDate
|
datetime
|
not null
|
|
Discount end date.
|
MinQty
|
int
|
not null
|
((0))
|
Minimum discount percent allowed.
|
MaxQty
|
int
|
null
|
|
Maximum discount percent allowed.
|
rowguid
|
uniqueidentifier
|
not null
|
(newid())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
ModifiedDate
|
datetime
|
not null
|
(getdate())
|
Date and time the record was last updated.
|
Primary Key
Primary Key
|
Columns
|
PK_SpecialOffer_SpecialOfferID
|
SpecialOfferID
|
Indexes
Index
|
Type
|
Columns
|
AK_SpecialOffer_rowguid
|
Unique
|
rowguid
|
Check Constraints
Check Constraint
|
Expression
|
Description
|
CK_SpecialOffer_DiscountPct
|
([DiscountPct]>=(0.00))
|
Check constraint [DiscountPct] >= (0.00)
|
CK_SpecialOffer_EndDate
|
([EndDate]>=[StartDate])
|
Check constraint [EndDate] >= [StartDate]
|
CK_SpecialOffer_MaxQty
|
([MaxQty]>=(0))
|
Check constraint [MaxQty] >= (0)
|
CK_SpecialOffer_MinQty
|
([MinQty]>=(0))
|
Check constraint [MinQty] >= (0)
|
Detail Tables
References
Dependency Type
|
Object Type
|
Referenced Object
|
Schema
|
Schema
|
Sales
|
automatically generated
Table
|
Sales.SpecialOffer
|
Description
|
Sale discounts lookup table.
|
Column
|
Data Type
|
Nullable
|
Default
|
Description / PK / Index
|
SpecialOfferID
|
int
|
not null
|
|
Primary key for SpecialOffer records. PK_SpecialOffer_SpecialOfferID
|
Description
|
nvarchar(255)
|
not null
|
|
Discount description.
|
DiscountPct
|
smallmoney
|
not null
|
(0.00)
|
Discount precentage.
|
Type
|
nvarchar(50)
|
not null
|
|
Discount type category.
|
Category
|
nvarchar(50)
|
not null
|
|
Group the discount applies to such as Reseller or Customer.
|
StartDate
|
datetime
|
not null
|
|
Discount start date.
|
EndDate
|
datetime
|
not null
|
|
Discount end date.
|
MinQty
|
int
|
not null
|
(0)
|
Minimum discount percent allowed.
|
MaxQty
|
int
|
null
|
|
Maximum discount percent allowed.
|
rowguid
|
uniqueidentifier
|
not null
|
(NEWID())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. AK_SpecialOffer_rowguid
|
ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|
Dependency Type
|
Object Type
|
Referenced Object
|
Schema
|
Schema
|
Sales
|