VAT Statement Report Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables VVAT Statement Report Line

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

Table Type: Company

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

Table Number: 742

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$VAT Statement Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns by name

SELECT

   [VAT Report No_]
   ,[VAT Report Config_ Code]
   ,[Line No_]
   ,[Row No_]
   ,[Description]
   ,[Box No_]
   ,[Base]
   ,[Amount]
   ,[Note]
   ,[RepresentativeAmount]
   ,[GroupAmount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$VAT Statement Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$VAT Statement Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Statement Report Line]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Statement Report Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Statement Report Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in VAT Statement Report Line table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	VAT Report No.	Tax Report No.	Normal	Code	20	VAT Report No_	nvarchar(40)
	Key to join to the VAT Report Header table. Show/hide example query SELECT [VAT Statement Report Line].[VAT Report No_] ,[VAT Report Header].[No_] FROM [CRONUS UK Ltd_$VAT Statement Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [VAT Statement Report Line] LEFT JOIN [CRONUS UK Ltd_$VAT Report Header$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [VAT Report Header] ON [VAT Statement Report Line].[VAT Report No_] = [VAT Report Header].[No_]
2	VAT Report Config. Code	Tax Report Config. Code	Normal	Option	4	VAT Report Config_ Code	int
	Key to join to the VAT Reports Configuration table. Show/hide example query SELECT [VAT Statement Report Line].[VAT Report Config_ Code] ,[VAT Reports Configuration].[VAT Report Type] FROM [CRONUS UK Ltd_$VAT Statement Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [VAT Statement Report Line] LEFT JOIN [CRONUS UK Ltd_$VAT Reports Configuration$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Reports Configuration] ON [VAT Statement Report Line].[VAT Report Config_ Code] = [VAT Reports Configuration].[VAT Report Type] Available options are: “EC Sales List” “VAT Return” “Intrastat Report”
3	Line No.	Line No.	Normal	Integer	4	Line No_	int
4	Row No.	Row No.	Normal	Code	10	Row No_	nvarchar(20)
5	Description	Description	Normal	Text	100	Description	nvarchar(200)
6	Box No.	Box No.	Normal	Text	30	Box No_	nvarchar(60)
7	Base	Base	Normal	Decimal	12	Base	decimal(38,38)
8	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
9	Note	Note	Normal	Text	250	Note	nvarchar(500)
4800	RepresentativeAmount	RepresentativeAmount	Normal	Decimal	12	RepresentativeAmount	decimal(38,38)
4801	GroupAmount	GroupAmount	Normal	Decimal	12	GroupAmount	decimal(38,38)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [VAT Statement Report Line].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$VAT Statement Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [VAT Statement Report Line] LEFT JOIN [User] AS [User] ON [VAT Statement Report Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier