VAT Amount Line

Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT 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

   [VAT _]
   ,[VAT Base]
   ,[VAT Amount]
   ,[Amount Including VAT]
   ,[VAT Identifier]
   ,[Line Amount]
   ,[Inv_ Disc_ Base Amount]
   ,[Invoice Discount Amount]
   ,[VAT Calculation Type]
   ,[Tax Group Code]
   ,[Quantity]
   ,[Modified]
   ,[Use Tax]
   ,[Calculated VAT Amount]
   ,[VAT Difference]
   ,[Positive]
   ,[Includes Prepayment]
   ,[VAT Clause Code]
   ,[Tax Category]
   ,[Pmt_ Discount Amount]
   ,[Non-Deductible VAT _]
   ,[Non-Deductible VAT Base]
   ,[Non-Deductible VAT Amount]
   ,[Calc_ Non-Ded_ VAT Amount]
   ,[Deductible VAT Base]
   ,[Deductible VAT Amount]
   ,[Non-Deductible VAT Diff_]
   ,[$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]
LEFT JOIN
   [CRONUS UK Ltd_$VAT Clause$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Clause]
      ON
         [VAT Amount Line].[VAT Clause Code] = [VAT Clause].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [VAT Amount Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Amount Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Amount Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in VAT Amount Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1VAT % SearchTax %NormalDecimal12VAT _decimal(38,38)
2VAT Base SearchTax BaseNormalDecimal12VAT Basedecimal(38,38)
3VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
4Amount Including VAT SearchAmount Including TaxNormalDecimal12Amount Including VATdecimal(38,38)
5VAT Identifier Primary Key SearchTax IdentifierNormalCode20VAT Identifiernvarchar(40)
6Line Amount SearchLine AmountNormalDecimal12Line Amountdecimal(38,38)
7Inv. Disc. Base Amount SearchInv. Disc. Base AmountNormalDecimal12Inv_ Disc_ Base Amountdecimal(38,38)
8Invoice Discount Amount SearchInvoice Discount AmountNormalDecimal12Invoice Discount Amountdecimal(38,38)
9VAT Calculation Type Primary Key SearchVAT Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
10Tax Group Code Primary Key SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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]
11Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
12Modified SearchModifiedNormalBoolean4Modifiedtinyint
13Use Tax Primary Key SearchUse TaxNormalBoolean4Use Taxtinyint
14Calculated VAT Amount SearchCalculated Tax AmountNormalDecimal12Calculated VAT Amountdecimal(38,38)
15VAT Difference SearchTax DifferenceNormalDecimal12VAT Differencedecimal(38,38)
16Positive Primary Key SearchPositiveNormalBoolean4Positivetinyint
17Includes Prepayment SearchIncludes PrepaymentNormalBoolean4Includes Prepaymenttinyint
18VAT Clause Code SearchTax Clause CodeNormalCode20VAT Clause Codenvarchar(40)
Key to join to the VAT Clause table.

Show/hide example query

SELECT
       [VAT Amount Line].[VAT Clause Code]
       ,[VAT Clause].[Code]
FROM
       [CRONUS UK Ltd_$VAT Amount Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Amount Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Clause$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Clause]
              ON
                     [VAT Amount Line].[VAT Clause Code] = [VAT Clause].[Code]
19Tax Category SearchTax CategoryNormalCode10Tax Categorynvarchar(20)
20Pmt. Discount Amount SearchPmt. Discount AmountNormalDecimal12Pmt_ Discount Amountdecimal(38,38)
6200Non-Deductible VAT % SearchNon-Deductible Tax %NormalDecimal12Non-Deductible VAT _decimal(38,38)
6201Non-Deductible VAT Base SearchNon-Deductible Tax BaseNormalDecimal12Non-Deductible VAT Basedecimal(38,38)
6202Non-Deductible VAT Amount SearchNon-Deductible Tax AmountNormalDecimal12Non-Deductible VAT Amountdecimal(38,38)
6203Calc. Non-Ded. VAT Amount SearchCalculated Non-Deductible Tax AmountNormalDecimal12Calc_ Non-Ded_ VAT Amountdecimal(38,38)
6204Deductible VAT Base SearchDeductible Tax BaseNormalDecimal12Deductible VAT Basedecimal(38,38)
6205Deductible VAT Amount SearchDeductible Tax AmountNormalDecimal12Deductible VAT Amountdecimal(38,38)
6206Non-Deductible VAT Diff. SearchNon-Deductible Tax DifferenceNormalDecimal12Non-Deductible VAT Diff_decimal(38,38)
10001Tax Area Code Primary Key SearchTax Area CodeNormalCode20
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [VAT Amount Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$VAT Amount Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Amount Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [VAT Amount Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [VAT Amount Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$VAT Amount Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Amount Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [VAT Amount Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from VAT Amount Line table

Tax AreaTax Group
Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT Amount Line

Leave a Reply

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