Sales Invoice Entity Aggregate

Dynamics 365 BC Table ReferenceTablesCompany TablesSSales Invoice Entity Aggregate

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5475

Table Type: Company

Table Name: Sales Invoice Entity Aggregate
Database Table Name: CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5475

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Sales Invoice Entity Aggregate can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Document Type]
   ,[Sell-to Customer No_]
   ,[No_]
   ,[Bill-to Customer No_]
   ,[Bill-to Name]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to City]
   ,[Bill-to Contact]
   ,[Your Reference]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[Posting Date]
   ,[Payment Terms Code]
   ,[Due Date]
   ,[Shipment Method Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Posting Group]
   ,[Currency Code]
   ,[Prices Including VAT]
   ,[Salesperson Code]
   ,[Order No_]
   ,[Amount]
   ,[Amount Including VAT]
   ,[VAT Registration No_]
   ,[Sell-to Customer Name]
   ,[Sell-to Address]
   ,[Sell-to Address 2]
   ,[Sell-to City]
   ,[Sell-to Contact]
   ,[Bill-to Post Code]
   ,[Bill-to County]
   ,[Bill-to Country_Region Code]
   ,[Sell-to Post Code]
   ,[Sell-to County]
   ,[Sell-to Country_Region Code]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[Ship-to Country_Region Code]
   ,[Document Date]
   ,[External Document No_]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[Invoice Discount Calculation]
   ,[Invoice Discount Value]
   ,[Last Email Sent Status]
   ,[IsTest]
   ,[Sell-to Phone No_]
   ,[Sell-to E-Mail]
   ,[Cust_ Ledger Entry No_]
   ,[Invoice Discount Amount]
   ,[Sell-to Contact No_]
   ,[Id]
   ,[Total Tax Amount]
   ,[Status]
   ,[Posted]
   ,[Subtotal Amount]
   ,[Discount Applied Before Tax]
   ,[Last Modified Date Time]
   ,[Customer Id]
   ,[Order Id]
   ,[Contact Graph Id]
   ,[Currency Id]
   ,[Payment Terms Id]
   ,[Shipment Method Id]
   ,[Tax Area ID]
   ,[Bill-to Customer Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Sales Invoice Entity Aggregate].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Sales Invoice Entity Aggregate].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Sales Invoice Entity Aggregate].[Document Type] = [Sales Header].[Document Type]
      AND
         [Sales Invoice Entity Aggregate].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Invoice Entity Aggregate].[Bill-to Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Invoice Entity Aggregate].[Bill-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Sales Invoice Entity Aggregate].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Invoice Entity Aggregate].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Sales Invoice Entity Aggregate].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Sales Invoice Entity Aggregate].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Sales Invoice Entity Aggregate].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Sales Invoice Entity Aggregate].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Sales Invoice Entity Aggregate].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Sales Invoice Entity Aggregate].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Sales Invoice Entity Aggregate].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Invoice Entity Aggregate].[Sell-to Customer Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Invoice Entity Aggregate].[Sell-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Invoice Entity Aggregate].[Bill-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Invoice Entity Aggregate].[Sell-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Invoice Entity Aggregate].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Sales Invoice Entity Aggregate].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Invoice Entity Aggregate].[Customer Id] = [Customer].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
      ON
         [Sales Invoice Entity Aggregate].[Order Id] = [Shpfy Order Header].[Shopify Order Id]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Sales Invoice Entity Aggregate].[Currency Id] = [Currency].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Sales Invoice Entity Aggregate].[Payment Terms Id] = [Payment Terms].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Sales Invoice Entity Aggregate].[Shipment Method Id] = [Shipment Method].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Invoice Entity Aggregate].[Bill-to Customer Id] = [Customer].[$systemId]
LEFT JOIN
   [User] AS [User]
      ON
         [Sales Invoice Entity Aggregate].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Sales Invoice Entity Aggregate].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Sales Invoice Entity Aggregate table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
  • “Blanket Order”
  • “Return Order”
2Sell-to Customer No. SearchSell-to Customer No.NormalCode20Sell-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Invoice Entity Aggregate].[Sell-to Customer No_] = [Customer].[No_]
3No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
4Bill-to Customer No. SearchBill-to Customer No.NormalCode20Bill-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Invoice Entity Aggregate].[Bill-to Customer No_] = [Customer].[No_]
5Bill-to Name SearchBill-to NameNormalText100Bill-to Namenvarchar(200)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Bill-to Name]
       ,[Customer].[Name]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Invoice Entity Aggregate].[Bill-to Name] = [Customer].[Name]
7Bill-to Address SearchBill-to AddressNormalText100Bill-to Addressnvarchar(200)
8Bill-to Address 2 SearchBill-to Address 2NormalText50Bill-to Address 2nvarchar(100)
9Bill-to City SearchBill-to CityNormalText30Bill-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Bill-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Invoice Entity Aggregate].[Bill-to City] = [Post Code].[City]
10Bill-to Contact SearchBill-to ContactNormalText100Bill-to Contactnvarchar(200)
11Your Reference SearchYour ReferenceNormalText35Your Referencenvarchar(70)
12Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Sales Invoice Entity Aggregate].[Ship-to Code] = [Ship-to Address].[Code]
13Ship-to Name SearchShip-to NameNormalText100Ship-to Namenvarchar(200)
15Ship-to Address SearchShip-to AddressNormalText100Ship-to Addressnvarchar(200)
16Ship-to Address 2 SearchShip-to Address 2NormalText50Ship-to Address 2nvarchar(100)
17Ship-to City SearchShip-to CityNormalText30Ship-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Ship-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Invoice Entity Aggregate].[Ship-to City] = [Post Code].[City]
18Ship-to Contact SearchShip-to ContactNormalText100Ship-to Contactnvarchar(200)
20Posting Date SearchPosting DateNormalDate4Posting Datedatetime
23Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Sales Invoice Entity Aggregate].[Payment Terms Code] = [Payment Terms].[Code]
24Due Date SearchDue DateNormalDate4Due Datedatetime
27Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Sales Invoice Entity Aggregate].[Shipment Method Code] = [Shipment Method].[Code]
29Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Sales Invoice Entity Aggregate].[Shortcut Dimension 1 Code] = [Dimension].[Code]
30Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Sales Invoice Entity Aggregate].[Shortcut Dimension 2 Code] = [Dimension].[Code]
31Customer Posting Group SearchCustomer Posting GroupNormalCode20Customer Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Customer Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Sales Invoice Entity Aggregate].[Customer Posting Group] = [Customer Posting Group].[Code]
32Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Sales Invoice Entity Aggregate].[Currency Code] = [Currency].[Code]
35Prices Including VAT SearchPrices Including TaxNormalBoolean4Prices Including VATtinyint
43Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Salesperson Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Sales Invoice Entity Aggregate].[Salesperson Code] = [Salesperson/Purchaser].[Code]
44Order No. SearchOrder No.NormalCode20Order No_nvarchar(40)
56Recalculate Invoice Disc. SearchRecalculate Invoice Disc.FlowFieldBoolean4
60Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
61Amount Including VAT SearchAmount Including TaxNormalDecimal12Amount Including VATdecimal(38,38)
70VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
79Sell-to Customer Name SearchSell-to Customer NameNormalText100Sell-to Customer Namenvarchar(200)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Sell-to Customer Name]
       ,[Customer].[Name]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Invoice Entity Aggregate].[Sell-to Customer Name] = [Customer].[Name]
81Sell-to Address SearchSell-to AddressNormalText100Sell-to Addressnvarchar(200)
82Sell-to Address 2 SearchSell-to Address 2NormalText50Sell-to Address 2nvarchar(100)
83Sell-to City SearchSell-to CityNormalText30Sell-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Sell-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Invoice Entity Aggregate].[Sell-to City] = [Post Code].[City]
84Sell-to Contact SearchSell-to ContactNormalText100Sell-to Contactnvarchar(200)
85Bill-to Post Code SearchBill-to ZIP CodeNormalCode20Bill-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Bill-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Invoice Entity Aggregate].[Bill-to Post Code] = [Post Code].[Code]
86Bill-to County SearchBill-to StateNormalText30Bill-to Countynvarchar(60)
87Bill-to Country/Region Code SearchBill-to Country/Region CodeNormalCode10Bill-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Bill-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Sales Invoice Entity Aggregate].[Bill-to Country_Region Code] = [Country/Region].[Code]
88Sell-to Post Code SearchSell-to ZIP CodeNormalCode20Sell-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Sell-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Invoice Entity Aggregate].[Sell-to Post Code] = [Post Code].[Code]
89Sell-to County SearchSell-to StateNormalText30Sell-to Countynvarchar(60)
90Sell-to Country/Region Code SearchSell-to Country/Region CodeNormalCode10Sell-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Sell-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Sales Invoice Entity Aggregate].[Sell-to Country_Region Code] = [Country/Region].[Code]
91Ship-to Post Code SearchShip-to ZIP CodeNormalCode20Ship-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Ship-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Invoice Entity Aggregate].[Ship-to Post Code] = [Post Code].[Code]
92Ship-to County SearchShip-to StateNormalText30Ship-to Countynvarchar(60)
93Ship-to Country/Region Code SearchShip-to Country/Region CodeNormalCode10Ship-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Ship-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Sales Invoice Entity Aggregate].[Ship-to Country_Region Code] = [Country/Region].[Code]
99Document Date SearchDocument DateNormalDate4Document Datedatetime
100External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
114Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Sales Invoice Entity Aggregate].[Tax Area Code] = [Tax Area].[Code]
115Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
116VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Sales Invoice Entity Aggregate].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
121Invoice Discount Calculation SearchInvoice Discount CalculationNormalOption4Invoice Discount Calculationint
Available options are:
  • “None”
  • “%”
  • “Amount”
122Invoice Discount Value SearchInvoice Discount ValueNormalDecimal12Invoice Discount Valuedecimal(38,38)
167Last Email Sent Status SearchLast Email Sent StatusNormalOption4Last Email Sent Statusint
Available options are:
  • “Not Sent”
  • “In Process”
  • “Finished”
  • “Error”
170IsTest SearchIsTestNormalBoolean4IsTesttinyint
171Sell-to Phone No. SearchSell-to Phone No.NormalText30Sell-to Phone No_nvarchar(60)
172Sell-to E-Mail SearchEmailNormalText80Sell-to E-Mailnvarchar(160)
1304Cust. Ledger Entry No. SearchCust. Ledger Entry No.NormalInteger4Cust_ Ledger Entry No_int
Key to join to the Cust. Ledger Entry table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Cust_ Ledger Entry No_]
       ,[Cust. Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
              ON
                     [Sales Invoice Entity Aggregate].[Cust_ Ledger Entry No_] = [Cust. Ledger Entry].[Entry No_]
1305Invoice Discount Amount SearchInvoice Discount AmountNormalDecimal12Invoice Discount Amountdecimal(38,38)
5052Sell-to Contact No. SearchSell-to Contact No.NormalCode20Sell-to Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Sell-to Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Sales Invoice Entity Aggregate].[Sell-to Contact No_] = [Contact].[No_]
8000Id SearchIdNormalGUID16Iduniqueidentifier
9600Total Tax Amount SearchTotal Tax AmountNormalDecimal12Total Tax Amountdecimal(38,38)
9601Status SearchStatusNormalOption4Statusint
Available options are:
  • ” “
  • “Draft”
  • “In Review”
  • “Open”
  • “Paid”
  • “Canceled”
  • “Corrective”
9602Posted Primary Key SearchPostedNormalBoolean4Postedtinyint
9603Subtotal Amount SearchSubtotal AmountNormalDecimal12Subtotal Amountdecimal(38,38)
9624Discount Applied Before Tax SearchDiscount Applied Before TaxNormalBoolean4Discount Applied Before Taxtinyint
9630Last Modified Date Time SearchLast Modified Date TimeNormalDateTime8Last Modified Date Timedatetime
9631Customer Id SearchCustomer IdNormalGUID16Customer Iduniqueidentifier
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Customer Id]
       ,[Customer].[$systemId]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Invoice Entity Aggregate].[Customer Id] = [Customer].[$systemId]
9632Order Id SearchOrder IdNormalGUID16Order Iduniqueidentifier
Key to join to the Shpfy Order Header table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Order Id]
       ,[Shpfy Order Header].[Shopify Order Id]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Shpfy Order Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Header]
              ON
                     [Sales Invoice Entity Aggregate].[Order Id] = [Shpfy Order Header].[Shopify Order Id]
9633Contact Graph Id SearchContact Graph IdNormalText250Contact Graph Idnvarchar(500)
9634Currency Id SearchCurrency IdNormalGUID16Currency Iduniqueidentifier
Key to join to the Currency table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Currency Id]
       ,[Currency].[$systemId]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Sales Invoice Entity Aggregate].[Currency Id] = [Currency].[$systemId]
9635Payment Terms Id SearchPayment Terms IdNormalGUID16Payment Terms Iduniqueidentifier
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Payment Terms Id]
       ,[Payment Terms].[$systemId]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Sales Invoice Entity Aggregate].[Payment Terms Id] = [Payment Terms].[$systemId]
9636Shipment Method Id SearchShipment Method IdNormalGUID16Shipment Method Iduniqueidentifier
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Shipment Method Id]
       ,[Shipment Method].[$systemId]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Sales Invoice Entity Aggregate].[Shipment Method Id] = [Shipment Method].[$systemId]
9637Tax Area ID SearchTax Area IDNormalGUID16Tax Area IDuniqueidentifier
9638Bill-to Customer Id SearchBill-to Customer IdNormalGUID16Bill-to Customer Iduniqueidentifier
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[Bill-to Customer Id]
       ,[Customer].[$systemId]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Invoice Entity Aggregate].[Bill-to Customer Id] = [Customer].[$systemId]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [User] AS [User]
              ON
                     [Sales Invoice Entity Aggregate].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Sales Invoice Entity Aggregate].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Sales Invoice Entity Aggregate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Entity Aggregate]
LEFT JOIN
       [User] AS [User]
              ON
                     [Sales Invoice Entity Aggregate].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Sales Invoice Entity Aggregate table

CurrencyCustomer Posting GroupPayment TermsSales HeaderSales Header ArchiveSalesperson/PurchaserSalesperson/PurchaserShip-to AddressShipment MethodTax Area
Dynamics 365 BC Table ReferenceTablesCompany TablesSSales Invoice Entity Aggregate

Leave a Reply

Your email address will not be published. Required fields are marked *