Sales.SpecialOffer

Field Name Data Type Size Original Type Default Nullable Description Check

SpecialOfferID int identity int Not null Primary key for SpecialOffer records.

Description nvarchar 255 Not null Discount description.

DiscountPct smallmoney 10,4 decimal(10,4) (0.00) Not null Discount precentage. ([DiscountPct]>=(0.00))

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 (0) Not null Minimum discount percent allowed. ([MinQty]>=(0))

MaxQty int Null Maximum discount percent allowed. ([MaxQty]>=(0))

rowguid uniqueidentifier newid() Not null ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
SpecialOfferID	int identity		int		Not null	Primary key for SpecialOffer records.
Description	nvarchar	255			Not null	Discount description.
DiscountPct	smallmoney	10,4	decimal(10,4)	(0.00)	Not null	Discount precentage.	([DiscountPct]>=(0.00))
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			(0)	Not null	Minimum discount percent allowed.	([MinQty]>=(0))
MaxQty	int				Null	Maximum discount percent allowed.	([MaxQty]>=(0))
rowguid	uniqueidentifier			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SpecialOffer'

Primary Key Name Field Name

PK_SpecialOffer_SpecialOfferID SpecialOfferID

There are no Foreign Keys for this table.

Primary Key Name	Field Name
PK_SpecialOffer_SpecialOfferID	SpecialOfferID

Indexes for table 'Sales.SpecialOffer', 2 items

Index Name Description Clustered Unique Fields

PK_SpecialOffer_SpecialOfferID Clustered index created by a primary key constraint. Yes Yes SpecialOfferID

AK_SpecialOffer_rowguid Unique nonclustered index. Used to support replication samples. No Yes rowguid

Index Name	Description	Clustered	Unique	Fields
PK_SpecialOffer_SpecialOfferID	Clustered index created by a primary key constraint.	Yes	Yes	SpecialOfferID
AK_SpecialOffer_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid

Triggers for table 'Sales.SpecialOffer', 1 item

Name Description Type Enabled

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

Name	Description	Type	Enabled
uSpecialOffer	AFTER 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 Name Type Field Name

Sales.CK_SpecialOffer_DiscountPct check cns N/A

Sales.CK_SpecialOffer_EndDate check cns N/A

Sales.CK_SpecialOffer_MaxQty check cns N/A

Sales.CK_SpecialOffer_MinQty check cns N/A

Sales.uSpecialOffer trigger N/A