Production TransactionHistory (table)

wikibot

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

Columns

ColumnData TypeNullableDefaultDescription
TransactionIDintnot null Primary key for TransactionHistory records.
ProductIDintnot null Product identification number. Foreign key to Product.ProductID.
ReferenceOrderIDintnot null Purchase order, sales order, or work order identification number.
ReferenceOrderLineIDintnot null((0))Line number associated with the purchase order, sales order, or work order.
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.

Primary Key

Primary KeyColumns
PK_TransactionHistory_TransactionIDTransactionID

Indexes

IndexTypeColumns
IX_TransactionHistory_ProductID ProductID
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID ReferenceOrderID, ReferenceOrderLineID

Check Constraints

Check ConstraintExpressionDescription
CK_TransactionHistory_TransactionType(upper(TransactionType)='P' OR upper(TransactionType)='S' OR upper(TransactionType)='W')Check constraint TransactionType='p' OR TransactionType='s' OR TransactionType='w' OR TransactionType='P' OR TransactionType='S' OR TransactionType='W')

Foreign Keys

RelationColumnReferenced Column
Production.ProductProductIDProductID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

Dependencies

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