Difference between revisions of "Sales.SalesOrderDetail (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.SalesOrderDetail |- |} {| border="1" cellpadding="5" cellspacing="0" s...)
(No difference)

Revision as of 13:34, 3 January 2009

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