VATGroup Calculation

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

Table Type: Company

Table Name: VATGroup Calculation
Database Table Name: CRONUS UK Ltd_$VATGroup Calculation$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 4801

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$VATGroup Calculation$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

Show/hide columns in VATGroup 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 *