VAT Statement Line

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

Table Type: Company

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

Table Number: 256

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Statement Template Name]
   ,[Statement Name]
   ,[Line No_]
   ,[Row No_]
   ,[Description]
   ,[Type]
   ,[Account Totaling]
   ,[Gen_ Posting Type]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Row Totaling]
   ,[Amount Type]
   ,[Calculate with]
   ,[Print]
   ,[Print with]
   ,[New Page]
   ,[Tax Jurisdiction Code]
   ,[Use Tax]
   ,[Box No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Statement Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in VAT Statement Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Statement Template Name Primary Key Searchnvarchar(20)
3Statement Name Primary Key Searchnvarchar(20)
4Line No_ Primary Key Searchint
5Row No_ Searchnvarchar(20)
6Description Searchnvarchar(200)
7Type Searchint
8Account Totaling Searchnvarchar(60)
9Gen_ Posting Type Searchint
10VAT Bus_ Posting Group Searchnvarchar(40)
11VAT Prod_ Posting Group Searchnvarchar(40)
12Row Totaling Searchnvarchar(100)
13Amount Type Searchint
14Calculate with Searchint
15Print Searchtinyint
16Print with Searchint
17New Page Searchtinyint
18Tax Jurisdiction Code Searchnvarchar(20)
19Use Tax Searchtinyint
20Box No_ Searchnvarchar(60)
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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