SalesOrderDetail Table (AdventureWorks)
Contains individual products associated with a specific sales order. A sales order may include orders for multiple products. The general, or parent, information for each sales order is stored in SalesOrderHeader. Each product that is ordered, or child, is stored in SalesOrderDetail.
The SalesOrderDetail table is contained in the Sales schema.
Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
Primary key. A sequential number used to ensure data uniqueness..
Shipment tracking number supplied by the shipper.
Quantity ordered per product.
Product sold to customer. Foreign key to Product.ProductID.
Promotional code. Foreign key to SpecialOffer.SpecialOfferID.
Selling price of a single product.
Computed as OrderQty * UnitPrice
Per product subtotal.
ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.
Date and time the row was last updated.