VAT Reports Configuration

Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT Reports Configuration

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

Table Type: Company

Table Name: VAT Reports Configuration
Database Table Name: CRONUS UK Ltd_$VAT Reports Configuration$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 746

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 VAT Reports Configuration can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$VAT Reports Configuration$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [VAT Report Type]
   ,[VAT Report Version]
   ,[Suggest Lines Codeunit ID]
   ,[Content Codeunit ID]
   ,[Submission Codeunit ID]
   ,[Response Handler Codeunit ID]
   ,[Validate Codeunit ID]
   ,[VAT Statement Template]
   ,[VAT Statement Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$VAT Reports Configuration$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$VAT Reports Configuration$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Reports Configuration]
LEFT JOIN
   [CRONUS UK Ltd_$VAT Statement Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Statement Template]
      ON
         [VAT Reports Configuration].[VAT Statement Template] = [VAT Statement Template].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$VAT Statement Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Statement Name]
      ON
         [VAT Reports Configuration].[VAT Statement Name] = [VAT Statement Name].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Reports Configuration].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Reports Configuration].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in VAT Reports Configuration table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1VAT Report Type SearchTax Report TypeNormalOption4VAT Report Typeint
Available options are:
  • “EC Sales List”
  • “VAT Return”
  • “Intrastat Report”
2VAT Report Version Primary Key SearchTax Report VersionNormalCode10VAT Report Versionnvarchar(20)
3Suggest Lines Codeunit ID Primary Key SearchSuggest Lines Codeunit IDNormalInteger4Suggest Lines Codeunit IDint
4Suggest Lines Codeunit Caption SearchSuggest Lines Codeunit CaptionFlowFieldText250
5Content Codeunit ID SearchContent Codeunit IDNormalInteger4Content Codeunit IDint
6Content Codeunit Caption SearchContent Codeunit CaptionFlowFieldText250
7Submission Codeunit ID SearchSubmission Codeunit IDNormalInteger4Submission Codeunit IDint
8Submission Codeunit Caption SearchSubmission Codeunit CaptionFlowFieldText250
9Response Handler Codeunit ID SearchResponse Handler Codeunit IDNormalInteger4Response Handler Codeunit IDint
10Resp. Handler Codeunit Caption SearchResp. Handler Codeunit CaptionFlowFieldText250
11Validate Codeunit ID SearchValidate Codeunit IDNormalInteger4Validate Codeunit IDint
12Validate Codeunit Caption SearchValidate Codeunit CaptionFlowFieldText250
13VAT Statement Template SearchTax Statement TemplateNormalCode10VAT Statement Templatenvarchar(20)
Key to join to the VAT Statement Template table.

Show/hide example query

SELECT
	       [VAT Reports Configuration].[VAT Statement Template]
	       ,[VAT Statement Template].[Name]
	FROM
	       [CRONUS UK Ltd_$VAT Reports Configuration$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Reports Configuration]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Statement Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Statement Template]
	              ON
	                     [VAT Reports Configuration].[VAT Statement Template] = [VAT Statement Template].[Name]
14VAT Statement Name SearchTax Statement NameNormalCode10VAT Statement Namenvarchar(20)
Key to join to the VAT Statement Name table.

Show/hide example query

SELECT
	       [VAT Reports Configuration].[VAT Statement Name]
	       ,[VAT Statement Name].[Name]
	FROM
	       [CRONUS UK Ltd_$VAT Reports Configuration$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Reports Configuration]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Statement Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Statement Name]
	              ON
	                     [VAT Reports Configuration].[VAT Statement Name] = [VAT Statement Name].[Name]
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
	       [VAT Reports Configuration].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$VAT Reports Configuration$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Reports Configuration]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [VAT Reports Configuration].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT Reports Configuration

Leave a Reply

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