TransactionHistory Table (AdventureWorks)

Contains a row of each purchase order, sales order, or work order transaction for the current year.

TransactionHistory Table Definition

The TransactionHistory table is contained in the Production schema.

Column	Data type	Nullability	Description
TransactionID	int	Not null	Primary key.
ProductID	int	Not null	Product identification number. Foreign key to Product.ProductID.
ReferenceOrderID	int	Not null	Purchase order, sales order, or work order identification number.
ReferenceOrderLineNumber	int	Not null	Line number associated with the purchase order, sales order, or work order.
TransactionDate	datetime	Not null	Date and time of the transaction.
TransactionType	nchar(1)	Not null	Type of transaction. P = Purchase order S = Sales order W = Work order
Quantity	int	Not null	Product quantity.
ActualCost	money	Not null	Product cost.
ModifiedDate	datetime	Not null	Date and time the row was last updated.