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