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