Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Purchasing PurchaseOrderDetail (table)

Compare Page Revisions



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


Page Revision: 2010/01/09 17:05


wikibot

TablePurchasing.PurchaseOrderDetail
DescriptionIndividual products associated with a specific purchase order. See PurchaseOrderHeader.

ColumnData TypeNullableDefaultDescription / PK / Index
PurchaseOrderIDintnot null Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.
PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
PurchaseOrderDetailIDintnot null Primary key. One line number per purchased product.
PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
DueDatedatetimenot null Date the product is expected to be received.
OrderQtysmallintnot null Quantity ordered.
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
IX_PurchaseOrderDetail_ProductID
UnitPricemoneynot null Vendor's selling price of a single product.
LineTotal   Per product subtotal. Computed as OrderQty * UnitPrice.
ReceivedQtydecimal(8, 2)not null Quantity actually received from the vendor.
RejectedQtydecimal(8, 2)not null Quantity rejected during inspection.
StockedQty   Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Production.ProductProductIDProductID
Purchasing.PurchaseOrderHeaderPurchaseOrderIDPurchaseOrderID

TriggersType
iPurchaseOrderDetailON INSERT
uPurchaseOrderDetailON UPDATE

Dependency TypeObject TypeReferenced ObjectChild TypeChild Object
InsertTableProduction.TransactionHistoryTriggeriPurchaseOrderDetail
InsertTableProduction.TransactionHistoryTriggeruPurchaseOrderDetail
SelectTablePurchasing.PurchaseOrderDetailTriggeruPurchaseOrderDetail
SelectTablePurchasing.PurchaseOrderDetailTriggeriPurchaseOrderDetail
UpdateTablePurchasing.PurchaseOrderDetailTriggeruPurchaseOrderDetail
SelectTablePurchasing.PurchaseOrderHeaderTriggeriPurchaseOrderDetail
UpdateTablePurchasing.PurchaseOrderHeaderTriggeriPurchaseOrderDetail
UpdateTablePurchasing.PurchaseOrderHeaderTriggeruPurchaseOrderDetail
ExecuteProceduredbo.uspLogErrorTriggeriPurchaseOrderDetail
ExecuteProceduredbo.uspLogErrorTriggeruPurchaseOrderDetail
ExecuteProceduredbo.uspPrintErrorTriggeruPurchaseOrderDetail
ExecuteProceduredbo.uspPrintErrorTriggeriPurchaseOrderDetail

Reference TypeObject TypeReferencing ObjectChild TypeChild Object
SelectTablePurchasing.PurchaseOrderDetailTriggeriPurchaseOrderDetail
SelectTablePurchasing.PurchaseOrderDetailTriggeruPurchaseOrderDetail
UpdateTablePurchasing.PurchaseOrderDetailTriggeruPurchaseOrderDetail

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.