TransactionHistoryArchive Table (AdventureWorks)

Contains a record of each purchase order, sales order, or work order transaction from the years prior to the current year.

TransactionHistoryArchive Table Definition

The TransactionHistoryArchive 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.

See Also

Reference

PurchaseOrderDetail Table (AdventureWorks)

SalesOrderDetail Table (AdventureWorks)

TransactionHistory Table (AdventureWorks)

WorkOrder Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary