Export (0) Print
Expand All
Expand Minimize

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.

Community Additions

ADD
Show:
© 2014 Microsoft