Table 256 "VAT Statement Line"

Base Application · Microsoft.Finance.VAT.Reporting · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 317 “VAT Statement” (5 Learn pages), Page 475 “VAT Statement Preview Line” (1).

Properties

Property	Value
Caption	VAT Statement Line
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	Statement Template Name	Code[10]	—	TableRelation Table 255 “VAT Statement Template” (VAT Statement Template)
2	Statement Name	Code[10]	—	TableRelation Table 257 “VAT Statement Name” (“VAT Statement Name”.Name where(“Statement Template Name” = field(“Statement Template Name”)))
3	Line No.	Integer	—
4	Row No. Δ BC29	Code[10]	Specifies a number that identifies the line.
5	Description Δ BC29	Text[100]	Specifies a description of the VAT statement line.
6	Type Δ BC29	Enum “VAT Statement Line Type”	Specifies what the VAT statement line will include.	enum Enum 256 “VAT Statement Line Type”
7	Account Totaling Δ BC29	Text[30]	Specifies an account interval or a series of account numbers.	TableRelation Table 15 “G/L Account” (G/L Account)
8	Gen. Posting Type Δ BC29	Enum “General Posting Type”	Specifies the type of transaction.	enum Enum 57 “General Posting Type”
9	VAT Bus. Posting Group Δ BC29	Code[20]	Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
10	VAT Prod. Posting Group Δ BC29	Code[20]	Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
11	Row Totaling Δ BC29	Text[50]	Specifies a row-number interval or a series of row numbers.
12	Amount Type Δ BC29	Enum “VAT Statement Line Amount Type”	Specifies if the VAT statement line shows the VAT amounts, or the base amounts on which the VAT is calculated.	enum Enum 258 “VAT Statement Line Amount Type”
13	Calculate with Δ BC29	Option	Specifies whether amounts on the VAT statement will be calculated with their original sign or with the sign reversed.	OptionCaption: Sign,Opposite Sign
14	Print Δ BC29	Boolean	Specifies whether the VAT statement line will be printed on the report that contains the finished VAT statement.
15	Print with Δ BC29	Option	Specifies whether amounts on the VAT statement will be printed with their original sign or with the sign reversed.	OptionCaption: Sign,Opposite Sign
16	Date Filter	Date	—	FlowFilter; not editable
17	New Page Δ BC29	Boolean	Specifies whether a new page should begin immediately after this line when the VAT statement is printed. To start a new page after this line, place a check mark in the field.
18	Tax Jurisdiction Code Δ BC29	Code[10]	Specifies a tax jurisdiction code for the statement.	TableRelation Table 320 “Tax Jurisdiction” (Tax Jurisdiction)
19	Use Tax Δ BC29	Boolean	Specifies whether to use only entries from the VAT Entry table that are marked as Use Tax to be totaled on this line.
20	Box No. Δ BC29	Text[30]	Specifies the number on the box that the VAT statement applies to.

Keys

Key1: Statement Template Name, Statement Name, Line No. (clustered)

Relations

Account Totaling: TableRelation Table 15 “G/L Account”
Statement Template Name: TableRelation Table 255 “VAT Statement Template”
Statement Name: TableRelation Table 257 “VAT Statement Name”
Tax Jurisdiction Code: TableRelation Table 320 “Tax Jurisdiction”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”

Pages and codeunits on this table

Page 317 “VAT Statement” (source table)
Page 475 “VAT Statement Preview Line” (source table)

Extended by

Table extension 4881 “EU3 VAT Statement Line”

Countries that replace it

AU, BE, CH, ES, IT, NL, NO, SE

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 Statement Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.