VAT 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

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]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[VAT Report Config_ Code]
   ,[No_]
   ,[VAT Report Type]
   ,[VAT Group Return]
   ,[Start Date]
   ,[VAT Group Status]
   ,[VAT Group Settlement Posted]
   ,[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_]
   ,[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]

Show/hide columns in VAT Report Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2VAT Report Config_ Code Primary Key Searchint
3No_ Primary Key Searchnvarchar(40)
4VAT Group Return Searchtinyint
4VAT Report Type Searchint
5Start Date Searchdatetime
5VAT Group Status Searchnvarchar(40)
6End Date Searchdatetime
6VAT Group Settlement Posted Searchtinyint
7Status Searchint
8No_ Series Searchnvarchar(40)
9Original Report No_ Searchnvarchar(40)
10Period Type Searchint
11Period No_ Searchint
12Period Year Searchint
13Message Id Searchnvarchar(500)
14Statement Template Name Searchnvarchar(20)
15Statement Name Searchnvarchar(20)
16VAT Report Version Searchnvarchar(20)
17Submitted By Searchuniqueidentifier
18Submitted Date Searchdatetime
19Return Period No_ Searchnvarchar(40)
20Additional Information Searchnvarchar(100)
21Created Date-Time Searchdatetime
22Amounts in Add_ Rep_ Currency Searchtinyint
23VATGroup Return Searchtinyint
24VATGroup Status Searchnvarchar(40)
25VATGroup Settlement Posted Searchtinyint
26$systemId Searchuniqueidentifier
27$systemCreatedAt Searchdatetime
28$systemCreatedBy Searchuniqueidentifier
29$systemModifiedAt Searchdatetime
30$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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