VAT Report Line #741

Other table in Microsoft Dynamics 365 Business Central. 29 fields, 0 records in Cronus demo.

29
Fields
0
Records
2
Primary key
0
FlowFields
10
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: VAT Report No., Line No..

All fields (29)

VAT Report Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 VAT Report No. PK Code Normal → VAT Report Header #740
2 Line No. PK Integer Normal
3 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
4 Posting Date Date Normal
5 Document No. Code Normal
6 Document Type Option Normal
7 Type Option Normal
8 Base Decimal Normal
9 Amount Decimal Normal
10 VAT Calculation Type Option Normal
12 Bill-to/Pay-to No. Code Normal
13 EU 3-Party Trade Boolean Normal
15 Source Code Code Normal → Source Code #230
16 Reason Code Code Normal → Reason Code #231
19 Country/Region Code Code Normal → Country/Region #9
20 Internal Ref. No. Text Normal
22 Unrealized Amount Decimal Normal
23 Unrealized Base Decimal Normal
26 External Document No. Code Normal
39 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
40 VAT Prod. Posting Group Code Normal → VAT Product Posting Group #324
55 VAT Registration No. Text Normal
56 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
100 Record Identifier Code Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (9)

Tables referenced by fields on the VAT Report Line table through TableRelation properties.

VAT Report Header
#740 · Other · via VAT Report No.
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Source Code
#230 · Other · via Source Code
Reason Code
#231 · Other · via Reason Code
Country/Region
#9 · General Ledger · via Country/Region Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group