Table 741 "VAT Report Line"

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

Learn documents this table through its pages: Page 741 “VAT Report Subform” (1 Learn page).

Properties

Property	Value
Caption	VAT Report 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	VAT Report No.	Code[20]	—	TableRelation Table 740 “VAT Report Header” (“VAT Report Header”.“No.”); not editable
2	Line No.	Integer	—	not editable; AutoIncrement
3	Gen. Prod. Posting Group Δ BC29	Code[20]	Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup.	TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group); not editable
4	Posting Date Δ BC29	Date	Specifies the posting date of the document that resulted in the VAT entry.	not editable
5	Document No. Δ BC29	Code[20]	Specifies the document number that resulted in the VAT entry.	not editable
6	Document Type Δ BC29	Enum “Gen. Journal Document Type”	Specifies the type of the document that resulted in the VAT entry.	enum Enum 6 “Gen. Journal Document Type”; not editable
7	Type Δ BC29	Enum “General Posting Type”	Specifies the type of the VAT entry.	enum Enum 57 “General Posting Type”; not editable
8	Base Δ BC28 Δ BC29	Decimal	Specifies the amount that the VAT amount in the Amount is calculated from.	not editable
9	Amount Δ BC28 Δ BC29	Decimal	Specifies the VAT amount for the report line. This is calculated based on the value of the Base field.	not editable
10	VAT Calculation Type Δ BC29	Enum “Tax Calculation Type”	Specifies how VAT will be calculated for purchases or sales of items with this particular combination of VAT business posting group and VAT product posting group.	enum Enum 254 “Tax Calculation Type”; not editable
12	Bill-to/Pay-to No. Δ BC29	Code[20]	Specifies the number of the bill-to customer or pay-to vendor that the entry is linked to.	TableRelation Table 18 “Customer”, Table 23 “Vendor” (if (Type = const(Purchase)) Vendor else if (Type = const(Sale)) Customer); not editable
13	EU 3-Party Trade Δ BC29	Boolean	Specifies if the transaction is related to trade with a third party within the EU.	not editable
15	Source Code Δ BC29	Code[10]	Specifies the source code that specifies where the entry was created.	TableRelation Table 230 “Source Code” (Source Code); not editable
16	Reason Code Δ BC29	Code[10]	Specifies the reason code, a supplementary source code that enables you to trace the entry.	TableRelation Table 231 “Reason Code” (Reason Code); not editable
19	Country/Region Code Δ BC29	Code[10]	Specifies the country/region of the address.	TableRelation Table 9 “Country/Region” (Country/Region); not editable
20	Internal Ref. No. Δ BC29	Text[30]	Specifies the internal reference number of the VAT entry.	not editable
22	Unrealized Amount Δ BC28 Δ BC29	Decimal	Specifies the unrealized VAT amount for this line if you use unrealized VAT.	not editable
23	Unrealized Base Δ BC28 Δ BC29	Decimal	Specifies the unrealized base amount if you use unrealized VAT.	not editable
26	External Document No. Δ BC29	Code[35]	Specifies a document number that refers to the customer’s or vendor’s numbering system.	not editable
39	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); not editable
40	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); not editable
55	VAT Registration No. Δ BC29	Text[20]	Specifies the VAT registration number of the customer or vendor that the VAT entry is linked to.	not editable
56	Gen. Bus. Posting Group	Code[20]	—	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group); not editable
100	Record Identifier	Code[30]	—	not editable

Keys

Key1: VAT Report No., Line No. (clustered)

Triggers

OnModify

Relations

Bill-to/Pay-to No.: TableRelation Table 18 “Customer” (conditional)
Bill-to/Pay-to No.: TableRelation Table 23 “Vendor” (conditional)
Source Code: TableRelation Table 230 “Source Code”
Reason Code: TableRelation Table 231 “Reason Code”
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
VAT Report No.: TableRelation Table 740 “VAT Report Header”
Country/Region Code: TableRelation Table 9 “Country/Region”

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 744 “VAT Report Line Relation”: VAT Report Line No.

Pages and codeunits on this table

Page 741 “VAT Report Subform” (source table)

Countries that replace it

DE, IT

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