| Column | Data Type | Nullable | Default | Description / PK / Index |
| TransactionID | int | not null | | Primary key for TransactionHistory records.
PK_TransactionHistory_TransactionID |
| ProductID | int | not null | | Product identification number. Foreign key to Product.ProductID.
IX_TransactionHistory_ProductID |
| ReferenceOrderID | int | not null | | Purchase order, sales order, or work order identification number.
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID |
| ReferenceOrderLineID | int | not null | ((0)) | Line number associated with the purchase order, sales order, or work order.
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID |
| TransactionDate | datetime | not null | (getdate()) | Date and time of the transaction.
|
| TransactionType | nchar(1) | not null | | W = WorkOrder, S = SalesOrder, P = PurchaseOrder
|
| Quantity | int | not null | | Product quantity.
|
| ActualCost | money | not null | | Product cost.
|
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|