---
title: "Table 254 VAT Entry"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/254-vat-entry/
type: table
id: 254
name: "VAT Entry"
app: "Base Application"
namespace: Microsoft.Finance.VAT.Ledger
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/254-vat-entry/source/29/"
checked: 2026-09-20
subject: "Microsoft Dynamics 365 Business Central"
license: "Content © 2026 Jonas Paprotka. Quote freely with attribution and a link."
---

# Table 254 VAT Entry

Jonas Paprotka, https://jonas-paprotka.de/ref/table/254-vat-entry/

| | |
| --- | --- |
| App | Base Application |
| Namespace | Microsoft.Finance.VAT.Ledger |
| Versions | 17-28 |
| Source file | Finance/VAT/Ledger/VATEntry.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | Entry No. | Integer | 17-28 | - | - |
| 2 | Gen. Bus. Posting Group | Code[20] | 17-28 | - | - |
| 3 | Gen. Prod. Posting Group | Code[20] | 17-28 | - | - |
| 4 | Posting Date | Date | 17-28 | - | - |
| 5 | Document No. | Code[20] | 17-28 | - | - |
| 6 | Document Type | Enum Gen. Journal Document Type | 17-28 | - | - |
| 7 | Type | Enum General Posting Type | 17-28 | - | - |
| 8 | Base | Decimal | 17-28 | - | - |
| 9 | Amount | Decimal | 17-28 | - | - |
| 10 | VAT Calculation Type | Enum Tax Calculation Type | 17-28 | - | - |
| 12 | Bill-to/Pay-to No. | Code[20] | 17-28 | - | - |
| 13 | EU 3-Party Trade | Boolean | 17-28 | - | - |
| 14 | User ID | Code[50] | 17-28 | - | - |
| 15 | Source Code | Code[10] | 17-28 | - | - |
| 16 | Reason Code | Code[10] | 17-28 | - | - |
| 17 | Closed by Entry No. | Integer | 17-28 | - | - |
| 18 | Closed | Boolean | 17-28 | - | - |
| 19 | Country/Region Code | Code[10] | 17-28 | - | - |
| 20 | Internal Ref. No. | Text[30] | 17-28 | - | - |
| 21 | Transaction No. | Integer | 17-28 | - | - |
| 22 | Unrealized Amount | Decimal | 17-28 | - | - |
| 23 | Unrealized Base | Decimal | 17-28 | - | - |
| 24 | Remaining Unrealized Amount | Decimal | 17-28 | - | - |
| 25 | Remaining Unrealized Base | Decimal | 17-28 | - | - |
| 26 | External Document No. | Code[35] | 17-28 | - | - |
| 28 | No. Series | Code[20] | 17-28 | - | - |
| 29 | Tax Area Code | Code[20] | 17-28 | - | - |
| 30 | Tax Liable | Boolean | 17-28 | - | - |
| 31 | Tax Group Code | Code[20] | 17-28 | - | - |
| 32 | Use Tax | Boolean | 17-28 | - | - |
| 33 | Tax Jurisdiction Code | Code[10] | 17-28 | - | - |
| 34 | Tax Group Used | Code[20] | 17-28 | - | - |
| 35 | Tax Type | Option | 17-28 | - | - |
| 36 | Tax on Tax | Boolean | 17-28 | - | - |
| 37 | Sales Tax Connection No. | Integer | 17-28 | - | - |
| 38 | Unrealized VAT Entry No. | Integer | 17-28 | - | - |
| 39 | VAT Bus. Posting Group | Code[20] | 17-28 | - | - |
| 40 | VAT Prod. Posting Group | Code[20] | 17-28 | - | - |
| 43 | Additional-Currency Amount | Decimal | 17-28 | - | - |
| 44 | Additional-Currency Base | Decimal | 17-28 | - | - |
| 45 | Add.-Currency Unrealized Amt. | Decimal | 17-28 | - | - |
| 46 | Add.-Currency Unrealized Base | Decimal | 17-28 | - | - |
| 48 | VAT Base Discount % | Decimal | 17-28 | - | - |
| 49 | Add.-Curr. Rem. Unreal. Amount | Decimal | 17-28 | - | - |
| 50 | Add.-Curr. Rem. Unreal. Base | Decimal | 17-28 | - | - |
| 51 | VAT Difference | Decimal | 17-28 | - | - |
| 52 | Add.-Curr. VAT Difference | Decimal | 17-28 | - | - |
| 53 | Ship-to/Order Address Code | Code[10] | 17-28 | - | - |
| 54 | Document Date | Date | 17-28 | - | - |
| 55 | VAT Registration No. | Text[20] | 17-28 | - | - |
| 56 | Reversed | Boolean | 17-28 | - | - |
| 57 | Reversed by Entry No. | Integer | 17-28 | - | - |
| 58 | Reversed Entry No. | Integer | 17-28 | - | - |
| 59 | EU Service | Boolean | 17-28 | - | - |
| 60 | Base Before Pmt. Disc. | Decimal | 17-28 | - | - |
| 70 | Source Currency VAT Amount | Decimal | 24-28 | - | - |
| 71 | Source Currency VAT Base | Decimal | 24-28 | - | - |
| 74 | Source Currency Code | Code[10] | 24-28 | - | - |
| 75 | Source Currency Factor | Decimal | 24-28 | - | - |
| 78 | Journal Templ. Name | Code[10] | 20-28 | - | - |
| 79 | Journal Batch Name | Code[10] | 20-28 | - | - |
| 81 | Realized Amount | Decimal | 17-28 | - | - |
| 82 | Realized Base | Decimal | 17-28 | - | - |
| 83 | Add.-Curr. Realized Amount | Decimal | 17-28 | - | - |
| 84 | Add.-Curr. Realized Base | Decimal | 17-28 | - | - |
| 85 | G/L Acc. No. | Code[20] | 19-28 | - | - |
| 86 | VAT Reporting Date | Date | 21-28 | - | - |
| 6200 | Non-Deductible VAT % | Decimal | 22-28 | - | - |
| 6201 | Non-Deductible VAT Base | Decimal | 22-28 | - | - |
| 6202 | Non-Deductible VAT Amount | Decimal | 22-28 | - | - |
| 6203 | Non-Deductible VAT Base ACY | Decimal | 22-28 | - | - |
| 6204 | Non-Deductible VAT Amount ACY | Decimal | 22-28 | - | - |
| 6205 | Non-Deductible VAT Diff. | Decimal | 22-28 | - | - |
| 6206 | Non-Deductible VAT Diff. ACY | Decimal | 22-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | Entry No. | 17-28 |
| Key2 | Type, Closed, VAT Bus. Posting Group, VAT Prod. Posting Group, Posting Date, G/L Acc. No., VAT Reporting Date | 17-28 |
| Key3 | Type, Closed, Tax Jurisdiction Code, Use Tax, Posting Date | 17-28 |
| Key4 | Type, Country/Region Code, VAT Registration No., VAT Bus. Posting Group, VAT Prod. Posting Group, Posting Date | 17-28 |
| Key5 | Document No., Posting Date | 17-28 |
| Key6 | Transaction No. | 17-28 |
| Key7 | Tax Jurisdiction Code, Tax Group Used, Tax Type, Use Tax, Posting Date | 17-28 |
| Key8 | Type, Bill-to/Pay-to No., Transaction No. | 17-28 |
| Key9 | Type, Closed, VAT Bus. Posting Group, VAT Prod. Posting Group, Tax Jurisdiction Code, Use Tax, Posting Date, G/L Acc. No. | 17-28 |
| Key10 | Posting Date, Type, Closed, VAT Bus. Posting Group, VAT Prod. Posting Group, Reversed, G/L Acc. No., VAT Reporting Date | 17-28 |
| Key11 | Document Date | 17-28 |
| Key12 | G/L Acc. No. | 19-28 |
| Key13 | Type, Closed, VAT Bus. Posting Group, VAT Prod. Posting Group, Reversed, Posting Date, G/L Acc. No., VAT Reporting Date | 24-28 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| GetLastEntryNo | () | Integer | public | 17-28 | - | - |
| GetUnrealizedVATPart | (Decimal, Decimal, Decimal, Decimal, Decimal) | Decimal | public | 17-28 | - | - |
| CopyFromGenJnlLine | (Record Gen. Journal Line) | - | public | 17-28 | - | - |
| CopyAmountsFromVATEntry | (Record VAT Entry, Boolean) | - | public | 17-28 | - | - |
| SetUnrealAmountsToZero | () | - | public | 17-28 | - | - |
| SetGLAccountNo | (Boolean) | - | public | 19-28 | - | - |
| SetGLAccountNoWithResponse | (Boolean, Boolean, var Boolean) | - | public | 19-28 | - | - |
| CheckGLAccountNoFilled | () | - | public | 19-28 | - | - |
| CopyPostingDataFromGenJnlLine | (Record Gen. Journal Line) | - | public | 20-28 | - | - |
| SetVATDateFromGenJnlLine | (var Record Gen. Journal Line) | - | internal | 21 | - | - |
| SetVATDateFromGenJnlLine | (Record Gen. Journal Line) | - | internal | 22-28 | - | - |
| GetUnrealizedVATType | () | Integer | public | 24-28 | - | - |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnAfterCopyFromGenJnlLine | (var Record VAT Entry, Record Gen. Journal Line) | 17-28 | - | - |
| Integration event | OnAfterCopyAmountsFromVATEntry | (var Record VAT Entry, Boolean) | 17-26 | Pending 24.0 | Use the OnAfterOnCopyAmountsFromVATEntry method instead |
| Integration event | OnBeforeSetGLAccountNo | (var Record VAT Entry, var Boolean, var Boolean) | 19 | - | - |
| Integration event | OnAfterSetGLAccountNo | (var Record VAT Entry, var Boolean) | 19 | - | - |
| Integration event | OnBeforeSetGLAccountNo | (var Record VAT Entry, var Boolean, var Boolean, Boolean, Boolean) | 20-28 | - | - |
| Integration event | OnAfterSetGLAccountNo | (var Record VAT Entry, var Boolean, Boolean) | 20-28 | - | - |
| Integration event | OnAfterOnCopyAmountsFromVATEntry | (var Record VAT Entry, Boolean, var Record VAT Entry) | 23-28 | - | - |

## Source

Symbols: Microsoft.BaseApplication.symbols.437dbf0e-84ff-417a-965d-ed2bb9650972, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-09-20.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at a66254c3b8b5bb1cea290dc8f9d097aec4381153.

Jonas Paprotka, 2026-09-20.
