VAT Entry

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Gen_ Bus_ Posting Group]
   ,[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]
   ,[User ID]
   ,[Source Code]
   ,[Reason Code]
   ,[Closed by Entry No_]
   ,[Closed]
   ,[Country_Region Code]
   ,[Internal Ref_ No_]
   ,[Transaction No_]
   ,[Unrealized Amount]
   ,[Unrealized Base]
   ,[Remaining Unrealized Amount]
   ,[Remaining Unrealized Base]
   ,[External Document No_]
   ,[No_ Series]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[Use Tax]
   ,[Tax Jurisdiction Code]
   ,[Tax Group Used]
   ,[Tax Type]
   ,[Tax on Tax]
   ,[Sales Tax Connection No_]
   ,[Unrealized VAT Entry No_]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Additional-Currency Amount]
   ,[Additional-Currency Base]
   ,[Add_-Currency Unrealized Amt_]
   ,[Add_-Currency Unrealized Base]
   ,[VAT Base Discount _]
   ,[Add_-Curr_ Rem_ Unreal_ Amount]
   ,[Add_-Curr_ Rem_ Unreal_ Base]
   ,[VAT Difference]
   ,[Add_-Curr_ VAT Difference]
   ,[Ship-to_Order Address Code]
   ,[Document Date]
   ,[VAT Registration No_]
   ,[Reversed]
   ,[Reversed by Entry No_]
   ,[Reversed Entry No_]
   ,[EU Service]
   ,[Base Before Pmt_ Disc_]
   ,[Journal Templ_ Name]
   ,[Journal Batch Name]
   ,[Realized Amount]
   ,[Realized Base]
   ,[Add_-Curr_ Realized Amount]
   ,[Add_-Curr_ Realized Base]
   ,[G_L Acc_ No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Entry$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 Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [VAT Entry].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [VAT Entry].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [VAT Entry].[Tax Group Code] = [Tax Group].[Code]

Show/hide columns in VAT Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Gen_ Bus_ Posting Group Searchnvarchar(40)
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
14User ID Searchnvarchar(100)
15Source Code Searchnvarchar(20)
16Reason Code Searchnvarchar(20)
17Closed by Entry No_ Searchint
18Closed Searchtinyint
19Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [VAT Entry].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [VAT Entry].[Country_Region Code] = [Country_Region].[Code]
20Internal Ref_ No_ Searchnvarchar(60)
21Transaction No_ Searchint
22Unrealized Amount Searchdecimal(38,38)
23Unrealized Base Searchdecimal(38,38)
24Remaining Unrealized Amount Searchdecimal(38,38)
25Remaining Unrealized Base Searchdecimal(38,38)
26External Document No_ Searchnvarchar(70)
27No_ Series Searchnvarchar(40)
28Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [VAT Entry].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [VAT Entry].[Tax Area Code] = [Tax Area].[Code]
29Tax Liable Searchtinyint
30Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [VAT Entry].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [VAT Entry].[Tax Group Code] = [Tax Group].[Code]
31Use Tax Searchtinyint
32Tax Jurisdiction Code Searchnvarchar(20)
33Tax Group Used Searchnvarchar(40)
34Tax Type Searchint
35Tax on Tax Searchtinyint
36Sales Tax Connection No_ Searchint
37Unrealized VAT Entry No_ Searchint
38VAT Bus_ Posting Group Searchnvarchar(40)
39VAT Prod_ Posting Group Searchnvarchar(40)
40Additional-Currency Amount Searchdecimal(38,38)
41Additional-Currency Base Searchdecimal(38,38)
42Add_-Currency Unrealized Amt_ Searchdecimal(38,38)
43Add_-Currency Unrealized Base Searchdecimal(38,38)
44VAT Base Discount _ Searchdecimal(38,38)
45Add_-Curr_ Rem_ Unreal_ Amount Searchdecimal(38,38)
46Add_-Curr_ Rem_ Unreal_ Base Searchdecimal(38,38)
47VAT Difference Searchdecimal(38,38)
48Add_-Curr_ VAT Difference Searchdecimal(38,38)
49Ship-to_Order Address Code Searchnvarchar(20)
50Document Date Searchdatetime
51VAT Registration No_ Searchnvarchar(40)
52Reversed Searchtinyint
53Reversed by Entry No_ Searchint
54Reversed Entry No_ Searchint
55EU Service Searchtinyint
56Base Before Pmt_ Disc_ Searchdecimal(38,38)
57Journal Templ_ Name Searchnvarchar(20)
58Journal Batch Name Searchnvarchar(20)
59Realized Amount Searchdecimal(38,38)
60Realized Base Searchdecimal(38,38)
61Add_-Curr_ Realized Amount Searchdecimal(38,38)
62Add_-Curr_ Realized Base Searchdecimal(38,38)
63G_L Acc_ No_ Searchnvarchar(40)
64$systemId Searchuniqueidentifier
65$systemCreatedAt Searchdatetime
66$systemCreatedBy Searchuniqueidentifier
67$systemModifiedAt Searchdatetime
68$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from VAT Entry table

Leave a Reply

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