VAT Report Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT 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$437dbf0e-84ff-417a-965d-ed2bb9650972

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$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Primary key]
   ,[No_ Series]
   ,[Modify Submitted Reports]
   ,[VAT Return No_ Series]
   ,[VAT Return Period No_ Series]
   ,[Report Version]
   ,[Period Reminder Time]
   ,[Update Period Job Frequency]
   ,[Manual Receive Period CU ID]
   ,[Auto Receive Period CU ID]
   ,[Receive Submitted Return CU ID]
   ,[Period Reminder Calculation]
   ,[Report VAT Base]
   ,[Report VAT Note]
   ,[VATGroup Role]
   ,[ApprovedMembers]
   ,[GroupMember ID]
   ,[GroupRepresentative API URL]
   ,[AuthenticationType]
   ,[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$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 Report Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Report Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Report Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in VAT Report Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary key SearchPrimary keyNormalCode10Primary keynvarchar(20)
2No. Series Primary Key SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [VAT Report Setup].[No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$VAT Report Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [VAT Report Setup].[No_ Series] = [No. Series].[Code]
3Modify Submitted Reports SearchAllow ModificationNormalBoolean4Modify Submitted Reportstinyint
4VAT Return No. Series SearchTax Return No. SeriesNormalCode20VAT Return No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [VAT Report Setup].[VAT Return No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$VAT Report Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [VAT Report Setup].[VAT Return No_ Series] = [No. Series].[Code]
20VAT Return Period No. Series SearchTax Return Period No. SeriesNormalCode20VAT Return Period No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [VAT Report Setup].[VAT Return Period No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$VAT Report Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [VAT Report Setup].[VAT Return Period No_ Series] = [No. Series].[Code]
21Report Version SearchReport VersionNormalCode10Report Versionnvarchar(20)
22Period Reminder Time SearchPeriod Reminder TimeNormalInteger4Period Reminder Timeint
23Update Period Job Frequency SearchUpdate Period Job FrequencyNormalOption4Update Period Job Frequencyint
Available options are:
  • “Never”
  • “Daily”
  • “Weekly”
24Manual Receive Period CU ID SearchManual Receive Period CU IDNormalInteger4Manual Receive Period CU IDint
25Manual Receive Period CU Cap SearchManual Receive Period CU CapFlowFieldText250
26Auto Receive Period CU ID SearchAuto Receive Period CU IDNormalInteger4Auto Receive Period CU IDint
27Auto Receive Period CU Cap SearchAuto Receive Period CU CapFlowFieldText250
28Receive Submitted Return CU ID SearchReceive Submitted Return CU IDNormalInteger4Receive Submitted Return CU IDint
29Receive Submitted Return CUCap SearchReceive Submitted Return CUCapFlowFieldText250
30Period Reminder Calculation SearchPeriod Reminder CalculationNormalDateFormula32Period Reminder Calculationvarchar(32)
31Report VAT Base SearchReport Tax BaseNormalBoolean4Report VAT Basetinyint
32Report VAT Note SearchReport Tax NoteNormalBoolean4Report VAT Notetinyint
4800VATGroup Role SearchVATGroup RoleNormalOption4VATGroup Roleint
Available options are:
  • “”
  • “Representative”
  • “Member”
4801ApprovedMembers SearchApprovedMembersNormalInteger4ApprovedMembersint
4802GroupMember ID SearchGroupMember IDNormalGUID16GroupMember IDuniqueidentifier
4803GroupRepresentative API URL SearchGroupRepresentative API URLNormalText250GroupRepresentative API URLnvarchar(500)
4804AuthenticationType SearchAuthenticationTypeNormalOption4AuthenticationTypeint
Available options are:
  • “WebServiceAccessKey”
  • “OAuth2”
  • “WindowsAuthentication”
4805UserName Key SearchUserName KeyNormalGUID16UserName Keyuniqueidentifier
4806WebService Access Key Key SearchWebService Access Key KeyNormalGUID16WebService Access Key Keyuniqueidentifier
4807GroupRepresentative Company SearchGroupRepresentative CompanyNormalText30GroupRepresentative Companynvarchar(60)
4808ClientID Key SearchClientID KeyNormalGUID16ClientID Keyuniqueidentifier
4809ClientSecret Key SearchClientSecret KeyNormalGUID16ClientSecret Keyuniqueidentifier
4810AuthorityURL SearchAuthorityURLNormalText250AuthorityURLnvarchar(500)
4811ResourceURL SearchResourceURLNormalText250ResourceURLnvarchar(500)
4812RedirectURL SearchRedirectURLNormalText250RedirectURLnvarchar(500)
4814GroupSettlement Account SearchGroupSettlement AccountNormalCode20GroupSettlement Accountnvarchar(40)
4815VATSettlement Account SearchVATSettlement AccountNormalCode20VATSettlement Accountnvarchar(40)
4816VATDue Box No. SearchVATDue Box No.NormalText30VATDue Box No_nvarchar(60)
4817GroupSettle. Gen. Jnl. Templ. SearchGroupSettle. Gen. Jnl. Templ.NormalCode10GroupSettle_ Gen_ Jnl_ Templ_nvarchar(20)
4818VATGroup BC Version SearchVATGroup BC VersionNormalOption4VATGroup BC Versionint
Available options are:
  • “BC”
  • “NAV2018”
  • “NAV2017”
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 Setup].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$VAT Report Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Setup]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [VAT Report Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT Report Setup

Leave a Reply

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