Properties

Owner:	Sales
Creation Date:	04/26/2006
Located On:	PRIMARY
Data Size KB:	9864
Index Size KB:	5144
Rows:	121317
Description:	Individual products associated with a specific sales order. See SalesOrderHeader.

Columns

		Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
		SalesOrderID	int	4					Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
		SalesOrderDetailID	int	4					Primary key. One incremental unique number per product sold.
		CarrierTrackingNumber	nvarchar	25					Shipment tracking number supplied by the shipper.
		OrderQty	smallint	2					Quantity ordered per product.
		ProductID	int	4					Product sold to customer. Foreign key to Product.ProductID.
		SpecialOfferID	int	4					Promotional code. Foreign key to SpecialOffer.SpecialOfferID.
		UnitPrice	money	8					Selling price of a single product.
		UnitPriceDiscount	money	8		((0.0))			Discount amount.
		LineTotal	numeric	17					Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.
		rowguid	uniqueidentifier	16		(newid())			ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
		ModifiedDate	datetime	8		(getdate())			Date and time the record was last updated.

Total: 11 column(s)

Identity column

	Name	Seed	Increment	Not for replication
	SalesOrderDetailID	1	1

Indexes

	Index	Primary	Unique	Description
	PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID			Primary key (clustered) constraint
	IX_SalesOrderDetail_ProductID			Nonclustered index.
	AK_SalesOrderDetail_rowguid			Unique nonclustered index. Used to support replication samples.

Total: 3 index(es)

Triggers

	Name	Owner	Instead Of	Disabled	Table/View	Description
	iduSalesOrderDetail	Sales			Sales.SalesOrderDetail	AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column.

Total: 1 trigger(s)

Check Constraints

	Name	Expression
	CK_SalesOrderDetail_OrderQty	([OrderQty]>(0))
	CK_SalesOrderDetail_UnitPrice	([UnitPrice]>=(0.00))
	CK_SalesOrderDetail_UnitPriceDiscount	([UnitPriceDiscount]>=(0.00))

Total: 3 constraint(s)

Referenced Tables

	Table	Foreign Key	Primary Key or Unique Constraint
	Sales.SalesOrderHeader	FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID	PK_SalesOrderHeader_SalesOrderID
	Sales.SpecialOfferProduct	FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID	PK_SpecialOfferProduct_SpecialOfferID_ProductID

Total: 2 table(s)

Objects that [Sales].[SalesOrderDetail] depends on

	Object Name	Owner	Object Type	Dep Level
	AccountNumber	dbo	User Defined type	1
	Flag	dbo	User Defined type	1
	Name	dbo	User Defined type	1
	NameStyle	dbo	User Defined type	1
	OrderNumber	dbo	User Defined type	1
	Phone	dbo	User Defined type	1
	ufnLeadingZeros	dbo	Function	2
	Contact	Person	Table	2
	CountryRegion	Person	Table	2
	CreditCard	Sales	Table	2
	Currency	Sales	Table	2
	ProductCategory	Production	Table	2
	ProductModel	Production	Table	2
	SalesTerritory	Sales	Table	2
	ShipMethod	Purchasing	Table	2
	SpecialOffer	Sales	Table	2
	UnitMeasure	Production	Table	2
	CurrencyRate	Sales	Table	3
	Customer	Sales	Table	3
	Employee	HumanResources	Table	3
	ProductSubcategory	Production	Table	3
	StateProvince	Person	Table	3
	Address	Person	Table	4
	Product	Production	Table	4
	SalesPerson	Sales	Table	4
	SalesOrderHeader	Sales	Table	5
	SpecialOfferProduct	Sales	Table	5

Total: 27 object(s)

Objects that depend on [Sales].[SalesOrderDetail]

	Object Name	Owner	Object Type	Dep Level
	iduSalesOrderDetail	Sales	Trigger	1

Total: 1 object(s)

SQL

CREATE TABLE [SalesOrderDetail] (
    [SalesOrderID] [int] NOT NULL ,
    [SalesOrderDetailID] [int] IDENTITY (1, 1) NOT NULL ,
    [CarrierTrackingNumber] [nvarchar] (25) COLLATE Latin1_General_CS_AS NULL ,
    [OrderQty] [smallint] NOT NULL ,
    [ProductID] [int] NOT NULL ,
    [SpecialOfferID] [int] NOT NULL ,
    [UnitPrice] [money] NOT NULL ,
    [UnitPriceDiscount] [money] NOT NULL CONSTRAINT [DF_SalesOrderDetail_UnitPriceDiscount] DEFAULT ((0.0)),
    [LineTotal] AS (isnull(([UnitPrice]*((1.0)-[UnitPriceDiscount]))*[OrderQty],(0.0))) ,
    [rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL CONSTRAINT [DF_SalesOrderDetail_rowguid] DEFAULT (newid()),
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_SalesOrderDetail_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID] PRIMARY KEY  CLUSTERED
    (
        [SalesOrderID],
        [SalesOrderDetailID]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID] FOREIGN KEY
    (
        [SalesOrderID]
    ) REFERENCES [SalesOrderHeader] (
        [SalesOrderID]
    ) ON DELETE CASCADE ,
    CONSTRAINT [FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID] FOREIGN KEY
    (
        [SpecialOfferID],
        [ProductID]
    ) REFERENCES [SpecialOfferProduct] (
        [SpecialOfferID],
        [ProductID]
    ),
    CONSTRAINT [CK_SalesOrderDetail_OrderQty] CHECK ([OrderQty]>(0)),
    CONSTRAINT [CK_SalesOrderDetail_UnitPrice] CHECK ([UnitPrice]>=(0.00)),
    CONSTRAINT [CK_SalesOrderDetail_UnitPriceDiscount] CHECK ([UnitPriceDiscount]>=(0.00))
) ON [PRIMARY]
GO

See Also

List of tables