Sales.SalesOrderDetail (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:37Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:56Z

Show changes

Bot at 21:55, 28 December 2009

2009-12-28T21:55:13Z

Show changes

Bot at 05:59, 30 November 2009

2009-11-30T05:59:56Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:18Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:34Z

Bot at 23:13, 26 November 2009

2009-11-26T23:13:24Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:47Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:01Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:13Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.SalesOrderDetail
@@ Line 8: / Line 8: @@
 | '''Description
 | Individual products associated with a specific sales order. See SalesOrderHeader.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | SalesOrderID
@@ Line 94: / Line 92: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
 | SalesOrderID, SalesOrderDetailID
@@ Line 105: / Line 103: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_SalesOrderDetail_rowguid
 | Unique
 | rowguid
-|-
+|- valign="top"
 | IX_SalesOrderDetail_ProductID
+|
@@ Line 122: / Line 120: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_SalesOrderDetail_OrderQty
 | ([OrderQty]>(0))
 | Check constraint [OrderQty] > (0)
-|-
+|- valign="top"
 | CK_SalesOrderDetail_UnitPrice
 | ([UnitPrice]>=(0.00))
 | Check constraint [UnitPrice] >= (0.00)
-|-
+|- valign="top"
 | CK_SalesOrderDetail_UnitPriceDiscount
 | ([UnitPriceDiscount]>=(0.00))
@@ Line 143: / Line 141: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | SalesOrderID
 | SalesOrderID
-|-
+|- valign="top"
 | [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]]
 | SpecialOfferID
@@ Line 157: / Line 155: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
-| '''Triggers
+| '''Trigger
 | '''Type
-−
-|-
+|- valign="top"
 | iduSalesOrderDetail
 | ON INSERT UPDATE DELETE
 |}
-	Trigger iduSalesOrderDetail
+==== Trigger iduSalesOrderDetail ====
 <pre>
 CREATE TRIGGER [Sales].[iduSalesOrderDetail] ON [Sales].[SalesOrderDetail]
@@ Line 247: / Line 245: @@
 END;
 </pre>
-−
 === References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
@@ Line 258: / Line 256: @@
 | '''Child Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 265: / Line 263: @@
+|
+|
-|-
+|- valign="top"
 | Insert
 | Table
@@ Line 272: / Line 270: @@
 | Trigger
 | iduSalesOrderDetail
-|-
+|- valign="top"
 | Update
 | Table
@@ Line 279: / Line 277: @@
 | Trigger
 | iduSalesOrderDetail
-|-
+|- valign="top"
 | Select
 | Table
@@ Line 286: / Line 284: @@
 | Trigger
 | iduSalesOrderDetail
-|-
+|- valign="top"
 | Select
 | Table
@@ Line 293: / Line 291: @@
 | Trigger
 | iduSalesOrderDetail
-|-
+|- valign="top"
 | Update
 | Table
@@ Line 300: / Line 298: @@
 | Trigger
 | iduSalesOrderDetail
-|-
+|- valign="top"
 | Execute
 | Procedure
@@ Line 307: / Line 305: @@
 | Trigger
 | iduSalesOrderDetail
-|-
+|- valign="top"
 | Execute
 | Procedure
@@ Line 326: / Line 324: @@
 | '''Child Object
-|-
+|- valign="top"
 | Select
 | Table

@@ Line 132: / Line 132: @@
 | Sales.SalesOrderDetail
 |- valign="top"
 | '''Description
 | Individual products associated with a specific sales order. See SalesOrderHeader.
 |-
 |}

@@ Line 248: / Line 248: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
-| '''Object Type
-| '''Dependency Type
+| '''Child Type
 |-
 | Schema
 | Schema
 |-
 | [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
-| Table
 | Trigger
 | iduSalesOrderDetail
 |-
 | [[Sales.Individual_(table)|Sales.Individual]]
-| Table
 | Trigger
 | iduSalesOrderDetail
 |-
 | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
-| Table
 | Trigger
 | iduSalesOrderDetail
 |-
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
-| Table
 | Trigger
 | iduSalesOrderDetail
 |-
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
-| Table
 | Trigger
 | iduSalesOrderDetail
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
-| Procedure
 | Trigger
 | iduSalesOrderDetail
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
-| Procedure
 | Trigger
 | iduSalesOrderDetail
@@ Line 303: / Line 316: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
-| '''Object Type
-| '''Reference Type
+| '''Child Type
 |-
 | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
-| Table
 | Trigger
 | iduSalesOrderDetail
 |}

@@ Line 251: / Line 251: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[Production.TransactionHistory_(table)|Production.TransactionHistory]]
 | Table
 | Insert
 |-
 | [[Sales.Individual_(table)|Sales.Individual]]
 | Table
 | Update
 |-
 | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 | Table
 | Select
 |-
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | Table
 | Select
 |-
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | Table
 | Update
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 | Procedure
 | Execute
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
 | Procedure
 | Execute
 |}
@@ Line 288: / Line 306: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 | Table
 | Select
 |}

@@ Line 131: / Line 131: @@
 | '''Table
 | Sales.SalesOrderDetail
-|-
+|- valign="top"
 | '''Description

@@ Line 153: / Line 153: @@
 | not null
+|
-| Primary key. Foreign key to SalesOrderHeader.SalesOrderID.PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
+| Primary key. Foreign key to SalesOrderHeader.SalesOrderID.<br />PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
 |- valign="top"
 | SalesOrderDetailID
@@ Line 159: / Line 159: @@
 | not null
+|
-| Primary key. One incremental unique number per product sold.PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
+| Primary key. One incremental unique number per product sold.<br />PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
 |- valign="top"
 | CarrierTrackingNumber
@@ Line 165: / Line 165: @@
 | null
+|
-| Shipment tracking number supplied by the shipper.
+| Shipment tracking number supplied by the shipper.<br />
 |- valign="top"
 | OrderQty
@@ Line 171: / Line 171: @@
 | not null
+|
-| Quantity ordered per product.
+| Quantity ordered per product.<br />
 |- valign="top"
 | ProductID
@@ Line 177: / Line 177: @@
 | not null
+|
-| Product sold to customer. Foreign key to Product.ProductID.IX_SalesOrderDetail_ProductID
+| Product sold to customer. Foreign key to Product.ProductID.<br />IX_SalesOrderDetail_ProductID
 |- valign="top"
 | SpecialOfferID
@@ Line 183: / Line 183: @@
 | not null
+|
-| Promotional code. Foreign key to SpecialOffer.SpecialOfferID.
+| Promotional code. Foreign key to SpecialOffer.SpecialOfferID.<br />
 |- valign="top"
 | UnitPrice
@@ Line 189: / Line 189: @@
 | not null
+|
-| Selling price of a single product.
+| Selling price of a single product.<br />
 |- valign="top"
 | UnitPriceDiscount
@@ Line 195: / Line 195: @@
 | not null
 | (0.0)
-| Discount amount.
+| Discount amount.<br />
 |- valign="top"
 | LineTotal
@@ Line 201: / Line 201: @@
+|
+|
-| Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.
+| Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.<br />
 |- valign="top"
 | rowguid
@@ Line 207: / Line 207: @@
 | not null
 | (NEWID())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.AK_SalesOrderDetail_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SalesOrderDetail_rowguid
 |- valign="top"
 | ModifiedDate
@@ Line 213: / Line 213: @@
 | not null
 | (GETDATE())
-| Date and time the record was last updated.
+| Date and time the record was last updated.<br />
 |}

@@ Line 94: / Line 94: @@
 | (getdate())
+|
+|
 |}