Sales.Invoices

Columns

• //

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

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

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

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

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

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

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

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

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

  ${escapify(column.description)}
  InvoiceDate
  [date] NOT NULL
• //

  ${escapify(column.description)}
  CustomerPurchaseOrderNumber
  [nvarchar](20) NULL
• //

  ${escapify(column.description)}
  IsCreditNote
  [bit] NOT NULL
• //

  ${escapify(column.description)}
  CreditNoteReason
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  Comments
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  DeliveryInstructions
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  InternalComments
  [nvarchar](MAX) NULL
• //

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

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

  ${escapify(column.description)}
  DeliveryRun
  [nvarchar](5) NULL
• //

  ${escapify(column.description)}
  RunPosition
  [nvarchar](5) NULL
• //

  ${escapify(column.description)}
  ReturnedDeliveryData
  [nvarchar](MAX) NULL

  //

  CONSTRAINT

  ([ReturnedDeliveryData] IS NULL OR isjson([ReturnedDeliveryData])<>(0))
• //

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

  ${escapify(column.description)}
  ConfirmedReceivedBy
  [nvarchar](4000) NULL
• LastEditedBy
  [int] NOT NULL
• LastEditedWhen
  [datetime2](8) NOT NULL DEFAULT (sysdatetime())

Indexes

• PK_Sales_Invoices
  UNIQUE CLUSTERED
  InvoiceID
• //

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

  Auto-created to support a foreign key
  FK_Sales_Invoices_BillToCustomerID
  NONCLUSTERED
  BillToCustomerID
• //

  Auto-created to support a foreign key
  FK_Sales_Invoices_OrderID
  NONCLUSTERED
  OrderID
• //

  Auto-created to support a foreign key
  FK_Sales_Invoices_DeliveryMethodID
  NONCLUSTERED
  DeliveryMethodID
• //

  Auto-created to support a foreign key
  FK_Sales_Invoices_ContactPersonID
  NONCLUSTERED
  ContactPersonID
• //

  Auto-created to support a foreign key
  FK_Sales_Invoices_AccountsPersonID
  NONCLUSTERED
  AccountsPersonID
• //

  Auto-created to support a foreign key
  FK_Sales_Invoices_SalespersonPersonID
  NONCLUSTERED
  SalespersonPersonID
• //

  Auto-created to support a foreign key
  FK_Sales_Invoices_PackedByPersonID
  NONCLUSTERED
  PackedByPersonID
• //

  Allows quick retrieval of invoices confirmed to have been delivered in a given time period
  IX_Sales_Invoices_ConfirmedDeliveryTime
  NONCLUSTERED
  ConfirmedDeliveryTime , ConfirmedReceivedBy

Foreign Keys

• FK_Sales_Invoices_AccountsPersonID_Application_People
  Application.People
  AccountsPersonID ⥱ PersonID
• FK_Sales_Invoices_Application_People
  Application.People
  LastEditedBy ⥱ PersonID
• FK_Sales_Invoices_BillToCustomerID_Sales_Customers
  Sales.Customers
  BillToCustomerID ⥱ CustomerID
• FK_Sales_Invoices_ContactPersonID_Application_People
  Application.People
  ContactPersonID ⥱ PersonID
• FK_Sales_Invoices_CustomerID_Sales_Customers
  Sales.Customers
  CustomerID ⥱ CustomerID
• FK_Sales_Invoices_DeliveryMethodID_Application_DeliveryMethods
  Application.DeliveryMethods
  DeliveryMethodID ⥱ DeliveryMethodID
• FK_Sales_Invoices_OrderID_Sales_Orders
  Sales.Orders
  OrderID ⥱ OrderID
• FK_Sales_Invoices_PackedByPersonID_Application_People
  Application.People
  PackedByPersonID ⥱ PersonID
• FK_Sales_Invoices_SalespersonPersonID_Application_People
  Application.People
  SalespersonPersonID ⥱ PersonID

Sample Data