Sales.SalesOrderDetail (table)

wikibot

Table

Sales.SalesOrderDetail

Column	Data Type	Nullable	Default	PK	Index
SalesOrderID	int	not null		PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
SalesOrderDetailID	int	not null		PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
CarrierTrackingNumber	nvarchar(25)	null
OrderQty	smallint	not null
ProductID	int	not null			IX_SalesOrderDetail_ProductID
SpecialOfferID	int	not null
UnitPrice	money	not null
UnitPriceDiscount	money	not null	((0.0))
LineTotal
rowguid	uniqueidentifier	not null	(newid())		AK_SalesOrderDetail_rowguid
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Sales.SalesOrderHeader	SalesOrderID	SalesOrderID
Sales.SpecialOfferProduct	SpecialOfferID	SpecialOfferID

Triggers	Type
iduSalesOrderDetail	ON INSERT UPDATE DELETE