Purchasing.PurchaseOrderDetail (table)

wikibot

Table

Purchasing.PurchaseOrderDetail

Column	Data Type	Nullable	Default	PK	Index
PurchaseOrderID	int	not null		PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
PurchaseOrderDetailID	int	not null		PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
DueDate	datetime	not null
OrderQty	smallint	not null
ProductID	int	not null			IX_PurchaseOrderDetail_ProductID
UnitPrice	money	not null
LineTotal
ReceivedQty	decimal(8, 2)	not null
RejectedQty	decimal(8, 2)	not null
StockedQty
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Production.Product	ProductID	ProductID
Purchasing.PurchaseOrderHeader	PurchaseOrderID	PurchaseOrderID

Triggers	Type
iPurchaseOrderDetail	ON INSERT
uPurchaseOrderDetail	ON UPDATE