VATGroup Submission Line

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

Table Type: Company

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

Table Number: 4803

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[VAT Group Submission ID]
   ,[Line No_]
   ,[VAT Group Submission No_]
   ,[ID]
   ,[Row No_]
   ,[Description]
   ,[Box No_]
   ,[Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VATGroup Submission Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in VATGroup Submission Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2VAT Group Submission ID Primary Key Searchuniqueidentifier
3Line No_ Primary Key Searchint
4VAT Group Submission No_ Searchnvarchar(40)
5ID Searchuniqueidentifier
6Row No_ Searchnvarchar(20)
7Description Searchnvarchar(200)
8Box No_ Searchnvarchar(60)
9Amount Searchdecimal(38,38)
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 *