Generated using SQL Data Dictionary demo version.


Table Production.TransactionHistoryArchive (89,253 rows)


Transactions for previous years.


  Column Data Type Identity Nullable Default
PK TransactionID int
Primary key for TransactionHistoryArchive records.
ProductID int
Product identification number. Foreign key to Product.ProductID.
ReferenceOrderID int
Purchase order, sales order, or work order identification number.
ReferenceOrderLineID int 0
Line number associated with the purchase order, sales order, or work order.
TransactionDate datetime getdate()
Date and time of the transaction.
TransactionType nchar(1)
W = Work Order, S = Sales Order, P = Purchase Order
Quantity int
Product quantity.
ActualCost money
Product cost.
ModifiedDate datetime getdate()
Date and time the record was last updated.

Indexes: