VAT Amount Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables VVAT Amount Line

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

Table Type: Company

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

Table Number: 290

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[VAT Identifier]
   ,[VAT Calculation Type]
   ,[Tax Group Code]
   ,[Use Tax]
   ,[Positive]
   ,[VAT _]
   ,[VAT Base]
   ,[VAT Amount]
   ,[Amount Including VAT]
   ,[Line Amount]
   ,[Inv_ Disc_ Base Amount]
   ,[Invoice Discount Amount]
   ,[Quantity]
   ,[Modified]
   ,[Calculated VAT Amount]
   ,[VAT Difference]
   ,[Includes Prepayment]
   ,[VAT Clause Code]
   ,[Tax Category]
   ,[Pmt_ Discount Amount]
   ,[Reverse Charge]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$VAT Amount Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Amount Line]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [VAT Amount Line].[Tax Group Code] = [Tax Group].[Code]

Show/hide columns in VAT Amount Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	VAT Identifier	nvarchar(40)
3	VAT Calculation Type	int
4	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [VAT Amount Line].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$VAT Amount Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Amount Line] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [VAT Amount Line].[Tax Group Code] = [Tax Group].[Code]
5	Use Tax	tinyint
6	Positive	tinyint
7	VAT _	decimal(38,38)
8	VAT Base	decimal(38,38)
9	VAT Amount	decimal(38,38)
10	Amount Including VAT	decimal(38,38)
11	Line Amount	decimal(38,38)
12	Inv_ Disc_ Base Amount	decimal(38,38)
13	Invoice Discount Amount	decimal(38,38)
14	Quantity	decimal(38,38)
15	Modified	tinyint
16	Calculated VAT Amount	decimal(38,38)
17	VAT Difference	decimal(38,38)
18	Includes Prepayment	tinyint
19	VAT Clause Code	nvarchar(40)
20	Tax Category	nvarchar(20)
21	Pmt_ Discount Amount	decimal(38,38)
22	Reverse Charge	decimal(38,38)
23	$systemId	uniqueidentifier
24	$systemCreatedAt	datetime
25	$systemCreatedBy	uniqueidentifier
26	$systemModifiedAt	datetime
27	$systemModifiedBy	uniqueidentifier