Sales.SalesOrderDetail

Table: 'Sales.SalesOrderDetail'

11 fields. 182 bytes.

Individual products associated with a specific sales order. See SalesOrderHeader.

Field Name Data Type Size Original Type Default Nullable Description Check

SalesOrderID int Not null Primary key. Foreign key to SalesOrderHeader.SalesOrderID.

SalesOrderDetailID int identity int Not null Primary key. One incremental unique number per product sold.

CarrierTrackingNumber nvarchar 25 Null Shipment tracking number supplied by the shipper.

OrderQty smallint Not null Quantity ordered per product. ([OrderQty]>(0))

ProductID int Not null Product sold to customer. Foreign key to Product.ProductID.

SpecialOfferID int Not null Promotional code. Foreign key to SpecialOffer.SpecialOfferID.

UnitPrice money 19,4 decimal(19,4) Not null Selling price of a single product. ([UnitPrice]>=(0.00))

UnitPriceDiscount money 19,4 decimal(19,4) (0.0) Not null Discount amount. ([UnitPriceDiscount]>=(0.00))

LineTotal numeric 38,6 Not null Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.

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
SalesOrderID	int				Not null	Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
SalesOrderDetailID	int identity		int		Not null	Primary key. One incremental unique number per product sold.
CarrierTrackingNumber	nvarchar	25			Null	Shipment tracking number supplied by the shipper.
OrderQty	smallint				Not null	Quantity ordered per product.	([OrderQty]>(0))
ProductID	int				Not null	Product sold to customer. Foreign key to Product.ProductID.
SpecialOfferID	int				Not null	Promotional code. Foreign key to SpecialOffer.SpecialOfferID.
UnitPrice	money	19,4	decimal(19,4)		Not null	Selling price of a single product.	([UnitPrice]>=(0.00))
UnitPriceDiscount	money	19,4	decimal(19,4)	(0.0)	Not null	Discount amount.	([UnitPriceDiscount]>=(0.00))
LineTotal	numeric	38,6			Not null	Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.
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.SalesOrderDetail'

Primary Key Name Field Names

PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID SalesOrderID, SalesOrderDetailID

Primary Key Name	Field Names
PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID	SalesOrderID, SalesOrderDetailID

Foreign keys for table 'Sales.SalesOrderDetail', 3 items

Foreign Primary Key Name

SalesOrderDetail.SalesOrderID SalesOrderHeader.SalesOrderID FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID

SalesOrderDetail.SpecialOfferID SpecialOfferProduct.SpecialOfferID FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID

SalesOrderDetail.ProductID SpecialOfferProduct.ProductID FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID

Foreign	Primary	Key Name
SalesOrderDetail.SalesOrderID	SalesOrderHeader.SalesOrderID	FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID
SalesOrderDetail.SpecialOfferID	SpecialOfferProduct.SpecialOfferID	FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID
SalesOrderDetail.ProductID	SpecialOfferProduct.ProductID	FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID

Indexes for table 'Sales.SalesOrderDetail', 3 items

Index Name Description Clustered Unique Fields

PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID Clustered index created by a primary key constraint. Yes Yes SalesOrderID, SalesOrderDetailID

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

IX_SalesOrderDetail_ProductID Nonclustered index. No No ProductID

Index Name	Description	Clustered	Unique	Fields
PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID	Clustered index created by a primary key constraint.	Yes	Yes	SalesOrderID, SalesOrderDetailID
AK_SalesOrderDetail_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid
IX_SalesOrderDetail_ProductID	Nonclustered index.	No	No	ProductID

Triggers for table 'Sales.SalesOrderDetail', 1 item

Name Description Type Enabled

iduSalesOrderDetail AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column. after Insert Update Delete Yes

Name	Description	Type	Enabled
iduSalesOrderDetail	AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column.	after Insert Update Delete	Yes

Dependencies for table 'Sales.SalesOrderDetail', 3 items

Object Name Type Field Name

Sales.SalesOrderDetail user table OrderQty

Sales.SalesOrderDetail user table UnitPrice

Sales.SalesOrderDetail user table UnitPriceDiscount

Object Name	Type	Field Name
Sales.SalesOrderDetail	user table	OrderQty
Sales.SalesOrderDetail	user table	UnitPrice
Sales.SalesOrderDetail	user table	UnitPriceDiscount