VAT 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 IDColumn NameData Type
1timestamp Searchtimestamp
2VAT Identifier Primary Key Searchnvarchar(40)
3VAT Calculation Type Primary Key Searchint
4Tax Group Code Primary Key Searchnvarchar(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]
5Use Tax Primary Key Searchtinyint
6Positive Primary Key Searchtinyint
7VAT _ Searchdecimal(38,38)
8VAT Base Searchdecimal(38,38)
9VAT Amount Searchdecimal(38,38)
10Amount Including VAT Searchdecimal(38,38)
11Line Amount Searchdecimal(38,38)
12Inv_ Disc_ Base Amount Searchdecimal(38,38)
13Invoice Discount Amount Searchdecimal(38,38)
14Quantity Searchdecimal(38,38)
15Modified Searchtinyint
16Calculated VAT Amount Searchdecimal(38,38)
17VAT Difference Searchdecimal(38,38)
18Includes Prepayment Searchtinyint
19VAT Clause Code Searchnvarchar(40)
20Tax Category Searchnvarchar(20)
21Pmt_ Discount Amount Searchdecimal(38,38)
22Reverse Charge Searchdecimal(38,38)
23$systemId Searchuniqueidentifier
24$systemCreatedAt Searchdatetime
25$systemCreatedBy Searchuniqueidentifier
26$systemModifiedAt Searchdatetime
27$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from VAT Amount Line table

Leave a Reply

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