Warehouse.StockItemTransactions

Columns

• //

  ${escapify(column.description)}
  StockItemTransactionID
  [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[TransactionID])
• //

  ${escapify(column.description)}
  StockItemID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  TransactionTypeID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  CustomerID
  [int] NULL
• //

  ${escapify(column.description)}
  InvoiceID
  [int] NULL
• //

  ${escapify(column.description)}
  SupplierID
  [int] NULL
• //

  ${escapify(column.description)}
  PurchaseOrderID
  [int] NULL
• //

  ${escapify(column.description)}
  TransactionOccurredWhen
  [datetime2](8) NOT NULL
• //

  ${escapify(column.description)}
  Quantity
  [decimal](18, 3) NOT NULL
• LastEditedBy
  [int] NOT NULL
• LastEditedWhen
  [datetime2](8) NOT NULL DEFAULT (sysdatetime())

Indexes

• CCX_Warehouse_StockItemTransactions
  CLUSTERED COLUMNSTORE
  StockItemTransactionID , StockItemID , TransactionTypeID , CustomerID , InvoiceID , SupplierID , PurchaseOrderID , TransactionOccurredWhen , Quantity , LastEditedBy , LastEditedWhen
• //

  Auto-created to support a foreign key
  FK_Warehouse_StockItemTransactions_StockItemID
  NONCLUSTERED
  StockItemID
• //

  Auto-created to support a foreign key
  FK_Warehouse_StockItemTransactions_TransactionTypeID
  NONCLUSTERED
  TransactionTypeID
• //

  Auto-created to support a foreign key
  FK_Warehouse_StockItemTransactions_CustomerID
  NONCLUSTERED
  CustomerID
• //

  Auto-created to support a foreign key
  FK_Warehouse_StockItemTransactions_InvoiceID
  NONCLUSTERED
  InvoiceID
• //

  Auto-created to support a foreign key
  FK_Warehouse_StockItemTransactions_SupplierID
  NONCLUSTERED
  SupplierID
• //

  Auto-created to support a foreign key
  FK_Warehouse_StockItemTransactions_PurchaseOrderID
  NONCLUSTERED
  PurchaseOrderID
• PK_Warehouse_StockItemTransactions
  UNIQUE NONCLUSTERED
  StockItemTransactionID

Foreign Keys

• FK_Warehouse_StockItemTransactions_Application_People
  Application.People
  LastEditedBy ⥱ PersonID
• FK_Warehouse_StockItemTransactions_CustomerID_Sales_Customers
  Sales.Customers
  CustomerID ⥱ CustomerID
• FK_Warehouse_StockItemTransactions_InvoiceID_Sales_Invoices
  Sales.Invoices
  InvoiceID ⥱ InvoiceID
• FK_Warehouse_StockItemTransactions_PurchaseOrderID_Purchasing_PurchaseOrders
  Purchasing.PurchaseOrders
  PurchaseOrderID ⥱ PurchaseOrderID
• FK_Warehouse_StockItemTransactions_StockItemID_Warehouse_StockItems
  Warehouse.StockItems
  StockItemID ⥱ StockItemID
• FK_Warehouse_StockItemTransactions_SupplierID_Purchasing_Suppliers
  Purchasing.Suppliers
  SupplierID ⥱ SupplierID
• FK_Warehouse_StockItemTransactions_TransactionTypeID_Application_TransactionTypes
  Application.TransactionTypes
  TransactionTypeID ⥱ TransactionTypeID

Sample Data