PurchaseOrderDetail Table (AdventureWorks)
Contains the products to be purchased with each purchase order. A purchase order may include orders for multiple products. The general, or parent, information for each purchase order is stored in PurchaseOrderHeader Table. Each product that is ordered, or child, is stored in PurchaseOrderDetail.
The PurchaseOrderDetail table is contained in the Purchasing schema.
Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.
Primary key. A sequential number used to ensure data uniqueness.
Date the product is expected to be received from the vendor.
Product identification number of the ordered product. Foreign key to Product.ProductID.
Price of a single product.
Computed as OrderQty * UnitPrice
Product cost subtotal.
Quantity actually received from the vendor.
Quantity rejected during inspection.
Computed as ReceiveQty - RejectedQty
Quantity accepted into inventory.
Date and time the row was last updated.