VATGroup Calculation – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables VVATGroup Calculation

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

Table Type: Company

Table Name: VATGroup Calculation
Database Table Name: CRONUS UK Ltd_$VATGroup Calculation$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 4801

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 VATGroup Calculation can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$VATGroup Calculation$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [ID]
   ,[VAT Group Submission No_]
   ,[VAT Group Submission ID]
   ,[VAT Report No_]
   ,[Group Member Name]
   ,[Box No_]
   ,[Amount]
   ,[Submitted On]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$VATGroup Calculation$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$VATGroup Calculation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VATGroup Calculation]
LEFT JOIN
   [User] AS [User]
      ON
         [VATGroup Calculation].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VATGroup Calculation].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in VATGroup Calculation table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	ID	ID	Normal	GUID	16	ID	uniqueidentifier
2	VAT Group Submission No.	VAT Group Submission No.	Normal	Code	20	VAT Group Submission No_	nvarchar(40)
3	VAT Group Submission ID	VAT Group Submission ID	Normal	GUID	16	VAT Group Submission ID	uniqueidentifier
4	VAT Report No.	VAT Report No.	Normal	Code	20	VAT Report No_	nvarchar(40)
	Key to join to the VAT Report Header table. Show/hide example query SELECT [VATGroup Calculation].[VAT Report No_] ,[VAT Report Header].[No_] FROM [CRONUS UK Ltd_$VATGroup Calculation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VATGroup Calculation] LEFT JOIN [CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [VAT Report Header] ON [VATGroup Calculation].[VAT Report No_] = [VAT Report Header].[No_]
5	Group Member Name	Group Member Name	Normal	Text	250	Group Member Name	nvarchar(500)
6	Box No.	Box No.	Normal	Text	30	Box No_	nvarchar(60)
7	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
8	Submitted On	Submitted On	Normal	DateTime	8	Submitted On	datetime
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 [VATGroup Calculation].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$VATGroup Calculation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VATGroup Calculation] LEFT JOIN [User] AS [User] ON [VATGroup Calculation].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [VATGroup Calculation].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$VATGroup Calculation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VATGroup Calculation] LEFT JOIN [User] AS [User] ON [VATGroup Calculation].[$systemModifiedBy] = [User].[User Security ID]