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. |
See Also
Reference
Product Table (AdventureWorks)
SpecialOffer Table (AdventureWorks)
SalesOrderDetail Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary