Welcome Guest, you are in: <root> • Login

Page History: Purchasing PurchaseOrderDetail (table)

Compare Page Revisions

4 3 2 1 0 Current 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/01/09 18:03

wikibot ¶

Table	Purchasing.PurchaseOrderDetail
Description	Individual products associated with a specific purchase order. See PurchaseOrderHeader.

Column	Data Type	Nullable	Default	Description / PK / Index
PurchaseOrderID	int	not null		Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID. PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
PurchaseOrderDetailID	int	not null		Primary key. One line number per purchased product. PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
DueDate	datetime	not null		Date the product is expected to be received.
OrderQty	smallint	not null		Quantity ordered.
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID. IX_PurchaseOrderDetail_ProductID
UnitPrice	money	not null		Vendor's selling price of a single product.
LineTotal				Per product subtotal. Computed as OrderQty * UnitPrice.
ReceivedQty	decimal(8, 2)	not null		Quantity actually received from the vendor.
RejectedQty	decimal(8, 2)	not null		Quantity rejected during inspection.
StockedQty				Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

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

Triggers	Type
iPurchaseOrderDetail	ON INSERT
uPurchaseOrderDetail	ON UPDATE

Dependency Type	Object Type	Referenced Object	Child Type	Child Object
Insert	Table	Production.TransactionHistory	Trigger	iPurchaseOrderDetail
Insert	Table	Production.TransactionHistory	Trigger	uPurchaseOrderDetail
Select	Table	Purchasing.PurchaseOrderDetail	Trigger	uPurchaseOrderDetail
Select	Table	Purchasing.PurchaseOrderDetail	Trigger	iPurchaseOrderDetail
Update	Table	Purchasing.PurchaseOrderDetail	Trigger	uPurchaseOrderDetail
Select	Table	Purchasing.PurchaseOrderHeader	Trigger	iPurchaseOrderDetail
Update	Table	Purchasing.PurchaseOrderHeader	Trigger	iPurchaseOrderDetail
Update	Table	Purchasing.PurchaseOrderHeader	Trigger	uPurchaseOrderDetail
Execute	Procedure	dbo.uspLogError	Trigger	iPurchaseOrderDetail
Execute	Procedure	dbo.uspLogError	Trigger	uPurchaseOrderDetail
Execute	Procedure	dbo.uspPrintError	Trigger	uPurchaseOrderDetail
Execute	Procedure	dbo.uspPrintError	Trigger	iPurchaseOrderDetail

Reference Type	Object Type	Referencing Object	Child Type	Child Object
Select	Table	Purchasing.PurchaseOrderDetail	Trigger	iPurchaseOrderDetail
Select	Table	Purchasing.PurchaseOrderDetail	Trigger	uPurchaseOrderDetail
Update	Table	Purchasing.PurchaseOrderDetail	Trigger	uPurchaseOrderDetail