Table: 'Sales.SpecialOffer'

11 fields. 798 bytes.

Sale discounts lookup table.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
SpecialOfferIDint identity int Not nullPrimary key for SpecialOffer records. 
Descriptionnvarchar255  Not nullDiscount description. 
DiscountPctsmallmoney10,4decimal(10,4)(0.00)Not nullDiscount precentage.([DiscountPct]>=(0.00))
Typenvarchar50  Not nullDiscount type category. 
Categorynvarchar50  Not nullGroup the discount applies to such as Reseller or Customer. 
StartDatedatetime   Not nullDiscount start date. 
EndDatedatetime   Not nullDiscount end date. 
MinQtyint  (0)Not nullMinimum discount percent allowed.([MinQty]>=(0))
MaxQtyint   NullMaximum discount percent allowed.([MaxQty]>=(0))
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SpecialOffer'

Primary Key NameField Name
There are no Foreign Keys for this table.

Indexes for table 'Sales.SpecialOffer', 2 items

Index NameDescriptionClusteredUniqueFields
PK_SpecialOffer_SpecialOfferIDClustered index created by a primary key constraint.YesYesSpecialOfferID
AK_SpecialOffer_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid

Triggers for table 'Sales.SpecialOffer', 1 item

uSpecialOfferAFTER UPDATE trigger setting the ModifiedDate column in the SpecialOffer table to the current date.after Update Yes

Dependencies for table 'Sales.SpecialOffer', 5 items

Object NameTypeField Name
Sales.CK_SpecialOffer_DiscountPctcheck cnsN/A
Sales.CK_SpecialOffer_EndDatecheck cnsN/A
Sales.CK_SpecialOffer_MaxQtycheck cnsN/A
Sales.CK_SpecialOffer_MinQtycheck cnsN/A