VAT Group Calculation

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

Table Type: Company

Table Name: VAT Group Calculation
Database Table Name: CRONUS UK Ltd_$VAT Group Calculation$c50a4bf0-db51-4ad2-88d5-fe2287da0eb8

Table Number: 0

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$VAT Group Calculation$c50a4bf0-db51-4ad2-88d5-fe2287da0eb8]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[VAT Group Submission No_]
   ,[VAT Group Submission ID]
   ,[VAT Report No_]
   ,[Group Member Name]
   ,[Box No_]
   ,[Amount]
   ,[Submitted On]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Group Calculation$c50a4bf0-db51-4ad2-88d5-fe2287da0eb8]

Show/hide columns in VAT Group Calculation table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3VAT Group Submission No_ Searchnvarchar(40)
4VAT Group Submission ID Searchuniqueidentifier
5VAT Report No_ Searchnvarchar(40)
6Group Member Name Searchnvarchar(500)
7Box No_ Searchnvarchar(60)
8Amount Searchdecimal(38,38)
9Submitted On Searchdatetime
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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