/* Created by free online sql formatter */

CREATE TABLE [dbo].[purchaseorderdetail] (
  [purchaseorderid] [INT]    NOT NULL     REFERENCES Purchasing.PurchaseOrderHeader(PurchaseOrderID),
  [linenumber]      [SMALLINT]    NOT NULL,
  [productid]       [INT]    NULL     REFERENCES Production.Product(ProductID),
  [unitprice]       [MONEY]    NULL,
  [orderqty]        [SMALLINT]    NULL,
  [receivedqty]     [FLOAT]    NULL,
  [rejectedqty]     [FLOAT]    NULL,
  [duedate]         [DATETIME]    NULL,
  [modifieddate]    [DATETIME]    NOT NULL CONSTRAINT [df_purchaseorderdetail_modifieddate] DEFAULT (Getdate()),
  [linetotal]       AS (([UnitPrice] * [OrderQty])),
  [stockedqty]      AS (([ReceivedQty] - [RejectedQty])),
  CONSTRAINT [pk_purchaseorderdetail_purchaseorderid_linenumber] PRIMARY KEY CLUSTERED ( [purchaseorderid],[linenumber] ) WITH ( ignore_dup_key = off ))
ON [primary]