VAT Entry

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

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

   [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_]
   ,[VAT Reporting Date]
   ,[Non-Deductible VAT _]
   ,[Non-Deductible VAT Base]
   ,[Non-Deductible VAT Amount]
   ,[Non-Deductible VAT Base ACY]
   ,[Non-Deductible VAT Amount ACY]
   ,[Non-Deductible VAT Diff_]
   ,[Non-Deductible VAT Diff_ ACY]
   ,[$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_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [VAT Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [VAT Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [VAT Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [VAT Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [VAT Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [VAT Entry].[Reason Code] = [Reason Code].[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]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
      ON
         [VAT Entry].[Tax Jurisdiction Code] = [Tax Jurisdiction].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [VAT Entry].[Tax Group Used] = [Tax Group].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [VAT Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in VAT Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [VAT Entry].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [VAT Entry].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
3Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [VAT Entry].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [VAT Entry].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
6Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
7Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
8Base SearchBaseNormalDecimal12Basedecimal(38,38)
9Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
10VAT Calculation Type SearchVAT Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
12Bill-to/Pay-to No. SearchBill-to/Pay-to No.NormalCode20Bill-to_Pay-to No_nvarchar(40)
13EU 3-Party Trade SearchEU 3-Party TradeNormalBoolean4EU 3-Party Tradetinyint
14User ID SearchUser IDNormalCode50User IDnvarchar(100)
15Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [VAT Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [VAT Entry].[Source Code] = [Source Code].[Code]
16Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [VAT Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [VAT Entry].[Reason Code] = [Reason Code].[Code]
17Closed by Entry No. SearchClosed by Entry No.NormalInteger4Closed by Entry No_int
18Closed SearchClosedNormalBoolean4Closedtinyint
19Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(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. SearchInternal Ref. No.NormalText30Internal Ref_ No_nvarchar(60)
21Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
22Unrealized Amount SearchUnrealized AmountNormalDecimal12Unrealized Amountdecimal(38,38)
23Unrealized Base SearchUnrealized BaseNormalDecimal12Unrealized Basedecimal(38,38)
24Remaining Unrealized Amount SearchRemaining Unrealized AmountNormalDecimal12Remaining Unrealized Amountdecimal(38,38)
25Remaining Unrealized Base SearchRemaining Unrealized BaseNormalDecimal12Remaining Unrealized Basedecimal(38,38)
26External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
28No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [VAT Entry].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [VAT Entry].[No_ Series] = [No. Series].[Code]
29Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(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]
30Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
31Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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]
32Use Tax SearchUse TaxNormalBoolean4Use Taxtinyint
33Tax Jurisdiction Code SearchTax Jurisdiction CodeNormalCode10Tax Jurisdiction Codenvarchar(20)
Key to join to the Tax Jurisdiction table.

Show/hide example query

SELECT
       [VAT Entry].[Tax Jurisdiction Code]
       ,[Tax Jurisdiction].[Code]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
              ON
                     [VAT Entry].[Tax Jurisdiction Code] = [Tax Jurisdiction].[Code]
34Tax Group Used SearchTax Group UsedNormalCode20Tax Group Usednvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [VAT Entry].[Tax Group Used]
       ,[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 Used] = [Tax Group].[Code]
35Tax Type SearchTax TypeNormalOption4Tax Typeint
Available options are:
  • “Sales and Use Tax”
  • “Excise Tax”
  • “Sales Tax Only”
  • “Use Tax Only”
36Tax on Tax SearchTax on TaxNormalBoolean4Tax on Taxtinyint
37Sales Tax Connection No. SearchSales Tax Connection No.NormalInteger4Sales Tax Connection No_int
38Unrealized VAT Entry No. SearchUnrealized Tax Entry No.NormalInteger4Unrealized VAT Entry No_int
39VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [VAT Entry].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [VAT Entry].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
40VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [VAT Entry].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [VAT Entry].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
43Additional-Currency Amount SearchAdditional-Currency AmountNormalDecimal12Additional-Currency Amountdecimal(38,38)
44Additional-Currency Base SearchAdditional-Currency BaseNormalDecimal12Additional-Currency Basedecimal(38,38)
45Add.-Currency Unrealized Amt. SearchAdd.-Currency Unrealized Amt.NormalDecimal12Add_-Currency Unrealized Amt_decimal(38,38)
46Add.-Currency Unrealized Base SearchAdd.-Currency Unrealized BaseNormalDecimal12Add_-Currency Unrealized Basedecimal(38,38)
48VAT Base Discount % SearchVAT Base Discount %NormalDecimal12VAT Base Discount _decimal(38,38)
49Add.-Curr. Rem. Unreal. Amount SearchAdd.-Curr. Rem. Unreal. AmountNormalDecimal12Add_-Curr_ Rem_ Unreal_ Amountdecimal(38,38)
50Add.-Curr. Rem. Unreal. Base SearchAdd.-Curr. Rem. Unreal. BaseNormalDecimal12Add_-Curr_ Rem_ Unreal_ Basedecimal(38,38)
51VAT Difference SearchTax DifferenceNormalDecimal12VAT Differencedecimal(38,38)
52Add.-Curr. VAT Difference SearchAdd.-Curr. Tax DifferenceNormalDecimal12Add_-Curr_ VAT Differencedecimal(38,38)
53Ship-to/Order Address Code SearchShip-to/Order Address CodeNormalCode10Ship-to_Order Address Codenvarchar(20)
54Document Date SearchDocument DateNormalDate4Document Datedatetime
55VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
56Reversed SearchReversedNormalBoolean4Reversedtinyint
57Reversed by Entry No. SearchReversed by Entry No.NormalInteger4Reversed by Entry No_int
58Reversed Entry No. SearchReversed Entry No.NormalInteger4Reversed Entry No_int
59EU Service SearchEU ServiceNormalBoolean4EU Servicetinyint
60Base Before Pmt. Disc. SearchBase Before Pmt. Disc.NormalDecimal12Base Before Pmt_ Disc_decimal(38,38)
78Journal Templ. Name SearchJournal Template NameNormalCode10Journal Templ_ Namenvarchar(20)
79Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
81Realized Amount SearchRealized AmountNormalDecimal12Realized Amountdecimal(38,38)
82Realized Base SearchRealized BaseNormalDecimal12Realized Basedecimal(38,38)
83Add.-Curr. Realized Amount SearchAdd.-Curr. Realized AmountNormalDecimal12Add_-Curr_ Realized Amountdecimal(38,38)
84Add.-Curr. Realized Base SearchAdd.-Curr. Realized BaseNormalDecimal12Add_-Curr_ Realized Basedecimal(38,38)
85G/L Acc. No. SearchG/L Account No.NormalCode20G_L Acc_ No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [VAT Entry].[G_L Acc_ No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [VAT Entry].[G_L Acc_ No_] = [G/L Account].[No_]
86VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
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)
6203Non-Deductible VAT Base ACY SearchNon-Deductible Tax Base ACYNormalDecimal12Non-Deductible VAT Base ACYdecimal(38,38)
6204Non-Deductible VAT Amount ACY SearchNon-Deductible Tax Amount ACYNormalDecimal12Non-Deductible VAT Amount ACYdecimal(38,38)
6205Non-Deductible VAT Diff. SearchNon-Deductible Tax DifferenceNormalDecimal12Non-Deductible VAT Diff_decimal(38,38)
6206Non-Deductible VAT Diff. ACY SearchNon-Deductible Tax Difference ACYNormalDecimal12Non-Deductible VAT Diff_ ACYdecimal(38,38)
10015Tax Exemption No. SearchTax Exemption No.NormalText30
10018STE Transaction ID SearchSTE Transaction IDNormalText20
10019GST/HST SearchGST/HSTNormalOption4
27030DIOT Type of Operation SearchDIOT Type of OperationNormalOption4
27040DIOT-Type of Operation SearchDIOT Type of OperationNormalOption4
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 Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [VAT Entry].[$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 Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [VAT Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from VAT Entry table

Sales HeaderSales Header ArchiveTax AreaTax Group
Dynamics 365 BC Table ReferenceTablesCompany TablesVVAT Entry

Leave a Reply

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