Purchasing.PurchaseOrderDetail

Columns

• //

  ${escapify(column.description)}
  PurchaseOrderID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  PurchaseOrderDetailID
  [int] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  DueDate
  [datetime] NOT NULL
• //

  ${escapify(column.description)}
  OrderQty
  [smallint] NOT NULL

  //

  CONSTRAINT: Check constraint [OrderQty] > (0)

  ([OrderQty]>(0))
• //

  ${escapify(column.description)}
  ProductID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  UnitPrice
  [money] NOT NULL

  //

  CONSTRAINT: Check constraint [UnitPrice] >= (0.00)

  ([UnitPrice]>=(0.00))
• //

  ${escapify(column.description)}
  LineTotal
  [money] NOT NULL
• //

  ${escapify(column.description)}
  ReceivedQty
  [decimal](8, 2) NOT NULL

  //

  CONSTRAINT: Check constraint [ReceivedQty] >= (0.00)

  ([ReceivedQty]>=(0.00))
• //

  ${escapify(column.description)}
  RejectedQty
  [decimal](8, 2) NOT NULL

  //

  CONSTRAINT: Check constraint [RejectedQty] >= (0.00)

  ([RejectedQty]>=(0.00))
• //

  ${escapify(column.description)}
  StockedQty
  [decimal](9, 2) NOT NULL
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
  UNIQUE CLUSTERED
  PurchaseOrderID , PurchaseOrderDetailID
• //

  Nonclustered index.
  IX_PurchaseOrderDetail_ProductID
  NONCLUSTERED
  ProductID

Foreign Keys

• //

  Foreign key constraint referencing Product.ProductID.
  FK_PurchaseOrderDetail_Product_ProductID
  Production.Product
  ProductID ⥱ ProductID
• //

  Foreign key constraint referencing PurchaseOrderHeader.PurchaseOrderID.
  FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID
  Purchasing.PurchaseOrderHeader
  PurchaseOrderID ⥱ PurchaseOrderID

Sample Data