Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production TransactionHistory (table)

Compare Page Revisions



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


Page Revision: 2010/01/09 17:49


wikibot

TableProduction.TransactionHistory
DescriptionRecord of each purchase order, sales order, or work order transaction year to date.

ColumnData TypeNullableDefaultDescription / PK / Index
TransactionIDintnot null Primary key for TransactionHistory records.
PK_TransactionHistory_TransactionID
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
IX_TransactionHistory_ProductID
ReferenceOrderIDintnot null Purchase order, sales order, or work order identification number.
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
ReferenceOrderLineIDintnot null((0))Line number associated with the purchase order, sales order, or work order.
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
TransactionDatedatetimenot null(getdate())Date and time of the transaction.
TransactionTypenchar(1)not null W = WorkOrder, S = SalesOrder, P = PurchaseOrder
Quantityintnot null Product quantity.
ActualCostmoneynot null Product cost.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
Production.ProductProductIDProductID

Reference TypeObject TypeReferencing ObjectChild TypeChild Object
InsertTableProduction.WorkOrderTriggeriWorkOrder
InsertTableProduction.WorkOrderTriggeruWorkOrder
InsertTablePurchasing.PurchaseOrderDetailTriggeriPurchaseOrderDetail
InsertTablePurchasing.PurchaseOrderDetailTriggeruPurchaseOrderDetail
InsertTableSales.SalesOrderDetailTriggeriduSalesOrderDetail

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