Warehouse.StockItemTransactions

Generated using SQL Data Dictionary demo version.

Transactions covering all movements of all stock items

	Column	Data Type	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()

PK_Warehouse_StockItemTransactions
- (Primary Key)
- (< 0.01% Selectivity)
- StockItemTransactionID

FK_Warehouse_StockItemTransactions_CustomerID
- (0.15% Selectivity)
Auto-created to support a foreign key
- CustomerID

FK_Warehouse_StockItemTransactions_InvoiceID
- (< 0.01% Selectivity)
Auto-created to support a foreign key
- InvoiceID

FK_Warehouse_StockItemTransactions_PurchaseOrderID
- (0.05% Selectivity)
Auto-created to support a foreign key
- PurchaseOrderID

FK_Warehouse_StockItemTransactions_StockItemID
- (0.44% Selectivity)
Auto-created to support a foreign key
- StockItemID

FK_Warehouse_StockItemTransactions_SupplierID
- (12.5% Selectivity)
Auto-created to support a foreign key
- SupplierID

FK_Warehouse_StockItemTransactions_TransactionTypeID
- (33.33% Selectivity)
Auto-created to support a foreign key
- TransactionTypeID