SpecialOfferProduct Table (AdventureWorks)

Is a cross-reference table that maps the products to the sales discounts.

SpecialOfferProduct Table Definition

The SpecialOfferProduct table is contained in the Sales schema.

Column	Data type	Nullability	Description
SpecialOfferID	int	Not null	Primary key.
ProductID	int	Not Null	Product identification number. Foreign key to Product.ProductID.
rowguid	uniqueidentifier	Not null	ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.
ModifiedDate	datetime	Not null	Date and time the row was last updated.