VATGroup Submission Header

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

Table Type: Company

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

Table Number: 4802

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[No_]
   ,[VAT Group Return No_]
   ,[Group Member ID]
   ,[Group Member Name]
   ,[Start Date]
   ,[End Date]
   ,[Submitted On]
   ,[Company]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VATGroup Submission Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in VATGroup Submission Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3No_ Searchnvarchar(40)
4VAT Group Return No_ Searchnvarchar(40)
5Group Member ID Searchuniqueidentifier
6Group Member Name Searchnvarchar(500)
7Start Date Searchdatetime
8End Date Searchdatetime
9Submitted On Searchdatetime
10Company Searchnvarchar(60)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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