.png)
TransactionHistory Table (AdventureWorks)
Contains a row of each purchase order, sales order, or work order transaction for the current year.
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. |
