VAT 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
   [timestamp]
   ,[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]
   ,[Content Max Lines]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Reports Configuration$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in VAT Reports Configuration table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2VAT Report Type Primary Key Searchint
3VAT Report Version Primary Key Searchnvarchar(20)
4Suggest Lines Codeunit ID Searchint
5Content Codeunit ID Searchint
6Submission Codeunit ID Searchint
7Response Handler Codeunit ID Searchint
8Validate Codeunit ID Searchint
9VAT Statement Template Searchnvarchar(20)
10VAT Statement Name Searchnvarchar(20)
11Content Max Lines Searchint
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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