Table 12142 "VAT Book Entry" (IT)

IT country layer · Microsoft.Finance.VAT.Ledger · BC29-30 · source at ea08af5e · facts from BC29

An object of the IT localization, 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”; not editable
7	Type	Enum “General Posting Type”	—	enum Enum 57 “General Posting Type”; 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”; 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.

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.