VAT Report Line

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

Table Type: Company

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

Table Number: 741

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[VAT Report No_]
   ,[Line No_]
   ,[Gen_ Prod_ Posting Group]
   ,[Posting Date]
   ,[Document No_]
   ,[Document Type]
   ,[Type]
   ,[Base]
   ,[Amount]
   ,[VAT Calculation Type]
   ,[Bill-to_Pay-to No_]
   ,[EU 3-Party Trade]
   ,[Source Code]
   ,[Reason Code]
   ,[Country_Region Code]
   ,[Internal Ref_ No_]
   ,[Unrealized Amount]
   ,[Unrealized Base]
   ,[External Document No_]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[VAT Registration No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Record Identifier]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Report 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 Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Line]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [VAT Report Line].[Country_Region Code] = [Country_Region].[Code]

Show/hide columns in VAT Report Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2VAT Report No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Gen_ Prod_ Posting Group Searchnvarchar(40)
5Posting Date Searchdatetime
6Document No_ Searchnvarchar(40)
7Document Type Searchint
8Type Searchint
9Base Searchdecimal(38,38)
10Amount Searchdecimal(38,38)
11VAT Calculation Type Searchint
12Bill-to_Pay-to No_ Searchnvarchar(40)
13EU 3-Party Trade Searchtinyint
14Source Code Searchnvarchar(20)
15Reason Code Searchnvarchar(20)
16Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [VAT Report Line].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$VAT Report Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Report Line]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [VAT Report Line].[Country_Region Code] = [Country_Region].[Code]
17Internal Ref_ No_ Searchnvarchar(60)
18Unrealized Amount Searchdecimal(38,38)
19Unrealized Base Searchdecimal(38,38)
20External Document No_ Searchnvarchar(70)
21VAT Bus_ Posting Group Searchnvarchar(40)
22VAT Prod_ Posting Group Searchnvarchar(40)
23VAT Registration No_ Searchnvarchar(40)
24Gen_ Bus_ Posting Group Searchnvarchar(40)
25Record Identifier Searchnvarchar(60)
26$systemId Searchuniqueidentifier
27$systemCreatedAt Searchdatetime
28$systemCreatedBy Searchuniqueidentifier
29$systemModifiedAt Searchdatetime
30$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from VAT Report Line table

Leave a Reply

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