VAT Report Setup

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

Table Type: Company

Table Name: VAT Report Setup
Database Table Name: CRONUS UK Ltd_$VAT Report Setup$38fa97fa-ebd1-4862-af24-77c4cee2c6ca

Table Number: 743

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$VAT Report Setup$38fa97fa-ebd1-4862-af24-77c4cee2c6ca]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary key]
   ,[No_ Series]
   ,[VAT Group Role]
   ,[MTD OAuth Setup Option]
   ,[MTD Gov Test Scenario]
   ,[Modify Submitted Reports]
   ,[Group Member ID]
   ,[MTD Disable FraudPrev_ Headers]
   ,[Group Representative API URL]
   ,[VAT Return No_ Series]
   ,[Authentication Type]
   ,[VAT Return Period No_ Series]
   ,[MTD FP WinClient Due DateTime]
   ,[Report Version]
   ,[User Name Key]
   ,[MTD FP WebClient Due DateTime]
   ,[MTD FP Batch Due DateTime]
   ,[Period Reminder Time]
   ,[Web Service Access Key Key]
   ,[Update Period Job Frequency]
   ,[MTD FP WinClient Json]
   ,[Group Representative Company]
   ,[Manual Receive Period CU ID]
   ,[MTD FP WebClient Json]
   ,[Client ID Key]
   ,[Client Secret Key]
   ,[Auto Receive Period CU ID]
   ,[MTD FP Batch Json]
   ,[Authority URL]
   ,[MTD Enabled]
   ,[Receive Submitted Return CU ID]
   ,[Period Reminder Calculation]
   ,[Resource URL]
   ,[Redirect URL]
   ,[Report VAT Base]
   ,[Group Representative On SaaS]
   ,[VATGroup Role]
   ,[Group Settlement Account]
   ,[ApprovedMembers]
   ,[GroupMember ID]
   ,[VAT Settlement Account]
   ,[GroupRepresentative API URL]
   ,[VAT Due Box No_]
   ,[AuthenticationType]
   ,[Group Settle_ Gen_ Jnl_ Templ_]
   ,[VAT Group BC Version]
   ,[UserName Key]
   ,[WebService Access Key Key]
   ,[GroupRepresentative Company]
   ,[ClientID Key]
   ,[ClientSecret Key]
   ,[AuthorityURL]
   ,[ResourceURL]
   ,[RedirectURL]
   ,[GroupSettlement Account]
   ,[VATSettlement Account]
   ,[VATDue Box No_]
   ,[GroupSettle_ Gen_ Jnl_ Templ_]
   ,[VATGroup BC Version]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Report Setup$38fa97fa-ebd1-4862-af24-77c4cee2c6ca]

Show/hide columns in VAT Report Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary key Primary Key Searchnvarchar(20)
3MTD OAuth Setup Option Searchint
3No_ Series Searchnvarchar(40)
3VAT Group Role Searchint
4Group Member ID Searchuniqueidentifier
4Modify Submitted Reports Searchtinyint
4MTD Gov Test Scenario Searchnvarchar(500)
5Group Representative API URL Searchnvarchar(500)
5MTD Disable FraudPrev_ Headers Searchtinyint
5VAT Return No_ Series Searchnvarchar(40)
6Authentication Type Searchint
6MTD FP WinClient Due DateTime Searchdatetime
6VAT Return Period No_ Series Searchnvarchar(40)
7MTD FP WebClient Due DateTime Searchdatetime
7Report Version Searchnvarchar(20)
7User Name Key Searchuniqueidentifier
8MTD FP Batch Due DateTime Searchdatetime
8Period Reminder Time Searchint
8Web Service Access Key Key Searchuniqueidentifier
9Group Representative Company Searchnvarchar(60)
9MTD FP WinClient Json Searchimage
9Update Period Job Frequency Searchint
10Client ID Key Searchuniqueidentifier
10Manual Receive Period CU ID Searchint
10MTD FP WebClient Json Searchimage
11Auto Receive Period CU ID Searchint
11Client Secret Key Searchuniqueidentifier
11MTD FP Batch Json Searchimage
12Authority URL Searchnvarchar(500)
12MTD Enabled Searchtinyint
12Receive Submitted Return CU ID Searchint
13Period Reminder Calculation Searchvarchar(32)
13Resource URL Searchnvarchar(500)
14Redirect URL Searchnvarchar(500)
14Report VAT Base Searchtinyint
15Group Representative On SaaS Searchtinyint
15VATGroup Role Searchint
16ApprovedMembers Searchint
16Group Settlement Account Searchnvarchar(40)
17GroupMember ID Searchuniqueidentifier
17VAT Settlement Account Searchnvarchar(40)
18GroupRepresentative API URL Searchnvarchar(500)
18VAT Due Box No_ Searchnvarchar(60)
19AuthenticationType Searchint
19Group Settle_ Gen_ Jnl_ Templ_ Searchnvarchar(20)
20UserName Key Searchuniqueidentifier
20VAT Group BC Version Searchint
21WebService Access Key Key Searchuniqueidentifier
22GroupRepresentative Company Searchnvarchar(60)
23ClientID Key Searchuniqueidentifier
24ClientSecret Key Searchuniqueidentifier
25AuthorityURL Searchnvarchar(500)
26ResourceURL Searchnvarchar(500)
27RedirectURL Searchnvarchar(500)
28GroupSettlement Account Searchnvarchar(40)
29VATSettlement Account Searchnvarchar(40)
30VATDue Box No_ Searchnvarchar(60)
31GroupSettle_ Gen_ Jnl_ Templ_ Searchnvarchar(20)
32VATGroup BC Version Searchint
33$systemId Searchuniqueidentifier
34$systemCreatedAt Searchdatetime
35$systemCreatedBy Searchuniqueidentifier
36$systemModifiedAt Searchdatetime
37$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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