Sales Invoice Entity Aggregate – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SSales 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: “Quote” “Order” “Invoice” “Credit Memo” “Blanket Order” “Return Order”
2	Sell-to Customer No.	Sell-to Customer No.	Normal	Code	20	Sell-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_]
3	No.	No.	Normal	Code	20	No_	nvarchar(40)
4	Bill-to Customer No.	Bill-to Customer No.	Normal	Code	20	Bill-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_]
5	Bill-to Name	Bill-to Name	Normal	Text	100	Bill-to Name	nvarchar(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]
7	Bill-to Address	Bill-to Address	Normal	Text	100	Bill-to Address	nvarchar(200)
8	Bill-to Address 2	Bill-to Address 2	Normal	Text	50	Bill-to Address 2	nvarchar(100)
9	Bill-to City	Bill-to City	Normal	Text	30	Bill-to City	nvarchar(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]
10	Bill-to Contact	Bill-to Contact	Normal	Text	100	Bill-to Contact	nvarchar(200)
11	Your Reference	Your Reference	Normal	Text	35	Your Reference	nvarchar(70)
12	Ship-to Code	Ship-to Code	Normal	Code	10	Ship-to Code	nvarchar(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]
13	Ship-to Name	Ship-to Name	Normal	Text	100	Ship-to Name	nvarchar(200)
15	Ship-to Address	Ship-to Address	Normal	Text	100	Ship-to Address	nvarchar(200)
16	Ship-to Address 2	Ship-to Address 2	Normal	Text	50	Ship-to Address 2	nvarchar(100)
17	Ship-to City	Ship-to City	Normal	Text	30	Ship-to City	nvarchar(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]
18	Ship-to Contact	Ship-to Contact	Normal	Text	100	Ship-to Contact	nvarchar(200)
20	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
23	Payment Terms Code	Payment Terms Code	Normal	Code	10	Payment Terms Code	nvarchar(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]
24	Due Date	Due Date	Normal	Date	4	Due Date	datetime
27	Shipment Method Code	Shipment Method Code	Normal	Code	10	Shipment Method Code	nvarchar(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]
29	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(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]
30	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(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]
31	Customer Posting Group	Customer Posting Group	Normal	Code	20	Customer Posting Group	nvarchar(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]
32	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
35	Prices Including VAT	Prices Including Tax	Normal	Boolean	4	Prices Including VAT	tinyint
43	Salesperson Code	Salesperson Code	Normal	Code	20	Salesperson Code	nvarchar(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]
44	Order No.	Order No.	Normal	Code	20	Order No_	nvarchar(40)
56	Recalculate Invoice Disc.	Recalculate Invoice Disc.	FlowField	Boolean	4
60	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
61	Amount Including VAT	Amount Including Tax	Normal	Decimal	12	Amount Including VAT	decimal(38,38)
70	VAT Registration No.	Tax Registration No.	Normal	Text	20	VAT Registration No_	nvarchar(40)
79	Sell-to Customer Name	Sell-to Customer Name	Normal	Text	100	Sell-to Customer Name	nvarchar(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]
81	Sell-to Address	Sell-to Address	Normal	Text	100	Sell-to Address	nvarchar(200)
82	Sell-to Address 2	Sell-to Address 2	Normal	Text	50	Sell-to Address 2	nvarchar(100)
83	Sell-to City	Sell-to City	Normal	Text	30	Sell-to City	nvarchar(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]
84	Sell-to Contact	Sell-to Contact	Normal	Text	100	Sell-to Contact	nvarchar(200)
85	Bill-to Post Code	Bill-to ZIP Code	Normal	Code	20	Bill-to Post Code	nvarchar(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]
86	Bill-to County	Bill-to State	Normal	Text	30	Bill-to County	nvarchar(60)
87	Bill-to Country/Region Code	Bill-to Country/Region Code	Normal	Code	10	Bill-to Country_Region Code	nvarchar(20)
88	Sell-to Post Code	Sell-to ZIP Code	Normal	Code	20	Sell-to Post Code	nvarchar(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]
89	Sell-to County	Sell-to State	Normal	Text	30	Sell-to County	nvarchar(60)
90	Sell-to Country/Region Code	Sell-to Country/Region Code	Normal	Code	10	Sell-to Country_Region Code	nvarchar(20)
91	Ship-to Post Code	Ship-to ZIP Code	Normal	Code	20	Ship-to Post Code	nvarchar(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]
92	Ship-to County	Ship-to State	Normal	Text	30	Ship-to County	nvarchar(60)
93	Ship-to Country/Region Code	Ship-to Country/Region Code	Normal	Code	10	Ship-to Country_Region Code	nvarchar(20)
99	Document Date	Document Date	Normal	Date	4	Document Date	datetime
100	External Document No.	External Document No.	Normal	Code	35	External Document No_	nvarchar(70)
114	Tax Area Code	Tax Area Code	Normal	Code	20	Tax Area Code	nvarchar(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]
115	Tax Liable	Tax Liable	Normal	Boolean	4	Tax Liable	tinyint
116	VAT Bus. Posting Group	VAT Bus. Posting Group	Normal	Code	20	VAT Bus_ Posting Group	nvarchar(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]
121	Invoice Discount Calculation	Invoice Discount Calculation	Normal	Option	4	Invoice Discount Calculation	int
	Available options are: “None” “%” “Amount”
122	Invoice Discount Value	Invoice Discount Value	Normal	Decimal	12	Invoice Discount Value	decimal(38,38)
167	Last Email Sent Status	Last Email Sent Status	Normal	Option	4	Last Email Sent Status	int
	Available options are: “Not Sent” “In Process” “Finished” “Error”
170	IsTest	IsTest	Normal	Boolean	4	IsTest	tinyint
171	Sell-to Phone No.	Sell-to Phone No.	Normal	Text	30	Sell-to Phone No_	nvarchar(60)
172	Sell-to E-Mail	Email	Normal	Text	80	Sell-to E-Mail	nvarchar(160)
1304	Cust. Ledger Entry No.	Cust. Ledger Entry No.	Normal	Integer	4	Cust_ 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_]
1305	Invoice Discount Amount	Invoice Discount Amount	Normal	Decimal	12	Invoice Discount Amount	decimal(38,38)
5052	Sell-to Contact No.	Sell-to Contact No.	Normal	Code	20	Sell-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_]
8000	Id	Id	Normal	GUID	16	Id	uniqueidentifier
9600	Total Tax Amount	Total Tax Amount	Normal	Decimal	12	Total Tax Amount	decimal(38,38)
9601	Status	Status	Normal	Option	4	Status	int
	Available options are: ” “ “Draft” “In Review” “Open” “Paid” “Canceled” “Corrective”
9602	Posted	Posted	Normal	Boolean	4	Posted	tinyint
9603	Subtotal Amount	Subtotal Amount	Normal	Decimal	12	Subtotal Amount	decimal(38,38)
9624	Discount Applied Before Tax	Discount Applied Before Tax	Normal	Boolean	4	Discount Applied Before Tax	tinyint
9630	Last Modified Date Time	Last Modified Date Time	Normal	DateTime	8	Last Modified Date Time	datetime
9631	Customer Id	Customer Id	Normal	GUID	16	Customer Id	uniqueidentifier
	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]
9632	Order Id	Order Id	Normal	GUID	16	Order Id	uniqueidentifier
	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]
9633	Contact Graph Id	Contact Graph Id	Normal	Text	250	Contact Graph Id	nvarchar(500)
9634	Currency Id	Currency Id	Normal	GUID	16	Currency Id	uniqueidentifier
	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]
9635	Payment Terms Id	Payment Terms Id	Normal	GUID	16	Payment Terms Id	uniqueidentifier
	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]
9636	Shipment Method Id	Shipment Method Id	Normal	GUID	16	Shipment Method Id	uniqueidentifier
	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]
9637	Tax Area ID	Tax Area ID	Normal	GUID	16	Tax Area ID	uniqueidentifier
9638	Bill-to Customer Id	Bill-to Customer Id	Normal	GUID	16	Bill-to Customer Id	uniqueidentifier
	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	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Sales Invoice Entity Aggregate table

Dynamics 365 BC Table Reference Tables Company Tables SSales Invoice Entity Aggregate

Leave a Reply Cancel reply