VAT Report Header

Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT Report Header

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

Table Type: Company

Table Name: VAT Report Header
Database Table Name: CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972$ext

Table Number: 740

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 Report Header can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[VAT Report Config_ Code]
   ,[VAT Report Type]
   ,[Start Date]
   ,[End Date]
   ,[Status]
   ,[No_ Series]
   ,[Original Report No_]
   ,[Period Type]
   ,[Period No_]
   ,[Period Year]
   ,[Message Id]
   ,[Statement Template Name]
   ,[Statement Name]
   ,[VAT Report Version]
   ,[Submitted By]
   ,[Submitted Date]
   ,[Return Period No_]
   ,[Date Type]
   ,[Additional Information]
   ,[Created Date-Time]
   ,[Amounts in Add_ Rep_ Currency]
   ,[VATGroup Return]
   ,[VATGroup Status]
   ,[VATGroup Settlement Posted]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Header]
LEFT JOIN
   [CRONUS UK Ltd_$Email Message$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Message]
      ON
         [VAT Report Header].[Message Id] = [Email Message].[Id]
LEFT JOIN
   [CRONUS UK Ltd_$VAT Statement Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Statement Template]
      ON
         [VAT Report Header].[Statement Template Name] = [VAT Statement Template].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Report Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Report Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in VAT Report Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalCode20No_nvarchar(40)
2VAT Report Config. Code Primary Key SearchTax Report Config. CodeNormalOption4VAT Report Config_ Codeint
Key to join to the VAT Reports Configuration table.

Show/hide example query

SELECT
	       [VAT Report Header].[VAT Report Config_ Code]
	       ,[VAT Reports Configuration].[VAT Report Type]
	FROM
	       [CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [VAT Report Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Reports Configuration$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Reports Configuration]
	              ON
	                     [VAT Report Header].[VAT Report Config_ Code] = [VAT Reports Configuration].[VAT Report Type]
Available options are:
  • “EC Sales List”
  • “VAT Return”
  • “Intrastat Report”
3VAT Report Type Primary Key SearchTax Report TypeNormalOption4VAT Report Typeint
Available options are:
  • “Standard”
  • “Corrective”
  • “Supplementary”
4Start Date SearchStart DateNormalDate4Start Datedatetime
5End Date SearchEnd DateNormalDate4End Datedatetime
6Status SearchStatusNormalOption4Statusint
Available options are:
  • “Open”
  • “Released”
  • “Submitted”
  • “Accepted”
  • “Closed”
  • “Rejected”
  • “Canceled”
8No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [VAT Report Header].[No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [VAT Report Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [VAT Report Header].[No_ Series] = [No. Series].[Code]
9Original Report No. SearchOriginal Report No.NormalCode20Original Report No_nvarchar(40)
10Period Type SearchPeriod TypeNormalOption4Period Typeint
Available options are:
  • ” Month”
  • “Quarter”
  • “Year”
  • “Bi-Monthly”
  • “Half-Year”
  • “Half-Month”
  • “Weekly”
11Period No. SearchPeriod No.NormalInteger4Period No_int
12Period Year SearchPeriod YearNormalInteger4Period Yearint
13Message Id SearchMessage IdNormalText250Message Idnvarchar(500)
Key to join to the Email Message table.

Show/hide example query

SELECT
	       [VAT Report Header].[Message Id]
	       ,[Email Message].[Id]
	FROM
	       [CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [VAT Report Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Email Message$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Email Message]
	              ON
	                     [VAT Report Header].[Message Id] = [Email Message].[Id]
14Statement Template Name SearchStatement Template NameNormalCode10Statement Template Namenvarchar(20)
Key to join to the VAT Statement Template table.

Show/hide example query

SELECT
	       [VAT Report Header].[Statement Template Name]
	       ,[VAT Statement Template].[Name]
	FROM
	       [CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [VAT Report Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Statement Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Statement Template]
	              ON
	                     [VAT Report Header].[Statement Template Name] = [VAT Statement Template].[Name]
15Statement Name SearchStatement NameNormalCode10Statement Namenvarchar(20)
16VAT Report Version SearchTax Report VersionNormalCode10VAT Report Versionnvarchar(20)
17Submitted By SearchSubmitted ByNormalGUID16Submitted Byuniqueidentifier
18Submitted Date SearchSubmitted DateNormalDate4Submitted Datedatetime
19Return Period No. SearchReturn Period No.NormalCode20Return Period No_nvarchar(40)
20Date Type SearchDate TypeNormalOption4Date Typeint
Available options are:
  • “Posting Date”
  • “Document Date”
  • “VAT Reporting Date”
30Additional Information SearchAdditional InformationNormalCode50Additional Informationnvarchar(100)
31Created Date-Time SearchCreated Date-TimeNormalDateTime8Created Date-Timedatetime
100Amounts in Add. Rep. Currency SearchAmounts in Add. Rep. CurrencyNormalBoolean4Amounts in Add_ Rep_ Currencytinyint
4800VATGroup Return SearchVATGroup ReturnNormalBoolean4VATGroup Returntinyint
4801VATGroup Status SearchVATGroup StatusNormalText20VATGroup Statusnvarchar(40)
4802VATGroup Settlement Posted SearchVATGroup Settlement PostedNormalBoolean4VATGroup Settlement Postedtinyint
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 Report Header].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [VAT Report Header]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [VAT Report Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT Report Header

Leave a Reply

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