Generated using SQL Data Dictionary demo version.

Table Warehouse.StockItemTransactions (236,667 rows)

Transactions covering all movements of all stock items

  Column Data Type Identity Nullable Default
PK StockItemTransactionID int NEXT VALUE FOR [Sequences].[TransactionID]
Numeric ID used to refer to a stock item transaction within the database
FK StockItemID int
StockItem for this transaction
FK TransactionTypeID int
Type of transaction
FK CustomerID int X
Customer for this transaction (if applicable)
FK InvoiceID int X
ID of an invoice (for transactions associated with an invoice)
FK SupplierID int X
Supplier for this stock transaction (if applicable)
FK PurchaseOrderID int X
ID of an purchase order (for transactions associated with a purchase order)
TransactionOccurredWhen datetime2
Date and time when the transaction occurred
Quantity decimal(18,3)
Quantity of stock movement (positive is incoming stock, negative is outgoing)
FK LastEditedBy int
LastEditedWhen datetime2 sysdatetime()



Used by: