VAT Group Submission Line

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

Table Type: Company

Table Name: VAT Group Submission Line
Database Table Name: CRONUS UK Ltd_$VAT Group Submission Line$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 Submission Line can be queried.

Show/hide an example select of all columns

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

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_$VAT Group Submission Line$c50a4bf0-db51-4ad2-88d5-fe2287da0eb8]

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