---
id: object/table/12142-it
type: object
title: Table 12142 "VAT Book Entry" (IT)
summary: Table 12142 "VAT Book Entry" (IT) in the IT country layer (Microsoft.Finance.VAT.Ledger). 33 fields. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - table
  - it layer
versions:
  introduced: "29"
  last_changed: null
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 62cf654054f527fc29de5fcb6905c4f0a4deae80d0879380ddbeee620f61df15
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/IT/BaseApp/Local/Finance/VAT/Ledger/VATBookEntry.Table.al
    title: src/Layers/IT/BaseApp/Local/Finance/VAT/Ledger/VATBookEntry.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations:
    - localization/it
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 12142
name: VAT Book Entry
namespace: Microsoft.Finance.VAT.Ledger
app: Base Application
extends: null
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
country: IT
counts:
  fields: 33
  procedures: 1
  events: 0
  subscribers: 0
relations:
  out: 0
  referenced_by: 0
  pages: 0
  extended_by: 0
  event_subscribers: 0
---

# Table 12142 "VAT Book Entry" (IT)

> Table 12142 "VAT Book Entry" (IT) in the IT country layer (Microsoft.Finance.VAT.Ledger). 33 fields. Introduced in BC29, still in BC30.

IT country layer · Microsoft.Finance.VAT.Ledger · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/IT/BaseApp/Local/Finance/VAT/Ledger/VATBookEntry.Table.al) · facts from BC29

An object of the [IT localization](../../localizations/it.md), not part of W1.

## Properties

| Property | Value |
|---|---|
| Caption | VAT Book Entry |
| DataClassification | CustomerContent |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Entry No. | Integer | — | not editable |
| 4 | Posting Date | Date | — | not editable |
| 5 | Document No. | Code[20] | — | not editable |
| 6 | Document Type | enum "Gen. Journal Document Type" | — | FlowField: lookup("VAT Entry"."Document Type" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VAT Identi...; enum [Enum 6 "Gen. Journal Document Type"](../enum/6.md); not editable |
| 7 | Type | Enum "General Posting Type" | — | enum [Enum 57 "General Posting Type"](../enum/57.md); not editable |
| 8 | Base | Decimal | — | FlowField: sum("VAT Entry".Base where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VAT Identifier" = field(...; not editable |
| 9 | Amount | Decimal | — | FlowField: sum("VAT Entry".Amount where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VAT Identifier" = fiel...; not editable |
| 10 | VAT Calculation Type | Enum "Tax Calculation Type" | — | FlowField: lookup("VAT Entry"."VAT Calculation Type" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VAT...; enum [Enum 254 "Tax Calculation Type"](../enum/254.md); not editable |
| 12 | Sell-to/Buy-from No. | Code[20] | — | TableRelation if (Type = const(Purchase)) Vendor else if (Type = const(Sale)) Customer; FlowField: lookup("VAT Entry"."Bill-to/Pay-to No." where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VAT I...; not editable |
| 21 | Transaction No. | Integer | — | not editable |
| 26 | External Document No. | Code[35] | — | FlowField: lookup("VAT Entry"."External Document No." where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VA...; not editable |
| 28 | No. Series | Code[20] | — | TableRelation No. Series; FlowField: lookup("VAT Entry"."No. Series" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VAT Identifie...; not editable |
| 39 | VAT Bus. Posting Group | Code[20] | — | TableRelation VAT Business Posting Group; not editable |
| 40 | VAT Prod. Posting Group | Code[20] | — | TableRelation VAT Product Posting Group; not editable |
| 50 | VAT Identifier | Code[20] | — | TableRelation VAT Identifier; not editable |
| 51 | Deductible % | Decimal | — | not editable |
| 52 | Nondeductible Amount | Decimal | — | FlowField: sum("VAT Entry"."Nondeductible Amount" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VAT Id...; not editable |
| 53 | Document Date | Date | — | FlowField: lookup("VAT Entry"."Document Date" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VAT Identi...; not editable |
| 54 | Operation Occurred Date | Date | — | not editable |
| 56 | VAT % | Decimal | — | not editable |
| 57 | VAT Difference | Decimal | — | FlowField: sum("VAT Entry"."VAT Difference" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "Deductible %" = field("Deductible %"), "VAT Identifier" = field("VAT Identifie...; not editable |
| 59 | Nondeductible Base | Decimal | — | FlowField: sum("VAT Entry"."Nondeductible Base" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VAT Iden...; not editable |
| 61 | Unrealized Base | Decimal | — | FlowField: sum("VAT Entry"."Unrealized Base" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VAT Identif...; not editable |
| 62 | Unrealized Amount | Decimal | — | FlowField: sum("VAT Entry"."Unrealized Amount" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VAT Ident...; not editable |
| 63 | Printing Date | Date | — | not editable |
| 64 | Official Date | Date | — | not editable |
| 65 | Reverse VAT Entry | Boolean | — | not editable |
| 66 | Unrealized VAT | Boolean | — | not editable |
| 67 | Unrealized VAT Entry No. | Integer | — | TableRelation VAT Entry; not editable |
| 68 | Additional-Currency Amount | Decimal | — | FlowField: sum("VAT Entry"."Additional-Currency Amount" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "...; not editable |
| 69 | Additional-Currency Base | Decimal | — | FlowField: sum("VAT Entry"."Additional-Currency Base" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %"), "VA...; not editable |
| 72 | Add. Curr. Nondeductible Amt. | Decimal | — | FlowField: sum("VAT Entry"."Add. Curr. Nondeductible Amt." where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %")...; not editable |
| 73 | Add. Curr. Nondeductible Base | Decimal | — | FlowField: sum("VAT Entry"."Add. Curr. Nondeductible Base" where("Document No." = field("Document No."), Type = field(Type), "VAT Bus. Posting Group" = field("VAT Bus. Posting Group"), "VAT Prod. Posting Group" = field("VAT Prod. Posting Group"), "VAT %" = field("VAT %"), "Deductible %" = field("Deductible %")...; not editable |

## Keys

- Key1: Entry No. (clustered)
- Key2: Document No., Type, VAT Bus. Posting Group, VAT Prod. Posting Group, VAT %, Deductible %, VAT Identifier, Transaction No., Unrealized VAT Entry No.
- Key3: Document No., Posting Date

## Procedures

1 local procedures, no public ones.

## Across versions

- Present in: BC29-30
- Changed (declaration) in: none

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "VAT Book Entry")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.

A IT country object, not part of W1: the default corpus does not have it; `bcatlas_list_countries` shows which countries the atlas has.