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.