Production.TransactionHistory (table)

wikibot

Table

Production.TransactionHistory

Column	Data Type	Nullable	Default	PK	Index
TransactionID	int	not null		PK_TransactionHistory_TransactionID
ProductID	int	not null			IX_TransactionHistory_ProductID
ReferenceOrderID	int	not null			IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
ReferenceOrderLineID	int	not null	((0))		IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
TransactionDate	datetime	not null	(getdate())
TransactionType	nchar(1)	not null
Quantity	int	not null
ActualCost	money	not null
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Production.Product	ProductID	ProductID

automatically generated

Table	Production.TransactionHistory
Description	Record of each purchase order, sales order, or work order transaction year to date.

Column	Data Type	Nullable	Default	Description / PK / Index
TransactionID	int	not null		Primary key for TransactionHistory records. PK_TransactionHistory_TransactionID
ProductID	int	not null		Product identification number. Foreign key to Product.ProductID. IX_TransactionHistory_ProductID
ReferenceOrderID	int	not null		Purchase order, sales order, or work order identification number. IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
ReferenceOrderLineID	int	not null	(0)	Line number associated with the purchase order, sales order, or work order. IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
TransactionDate	datetime	not null	(GETDATE())	Date and time of the transaction.
TransactionType	nchar(1)	not null		W = WorkOrder, S = SalesOrder, P = PurchaseOrder
Quantity	int	not null		Product quantity.
ActualCost	money	not null		Product cost.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Production.Product	ProductID	ProductID

Referencing Object	Object Type	Reference Type
Production.WorkOrder	Table	Insert
Production.WorkOrder	Table	Insert
Purchasing.PurchaseOrderDetail	Table	Insert
Purchasing.PurchaseOrderDetail	Table	Insert
Sales.SalesOrderDetail	Table	Insert