Share via


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.

See Also

Reference

PurchaseOrderDetail Table (AdventureWorks)
SalesOrderDetail Table (AdventureWorks)
WorkOrder Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance