Other table in Microsoft Dynamics 365 Business Central. 29 fields, 0 records in Cronus demo.
The VAT Report Line table (ID 741) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 29 fields, with a primary key of VAT Report No., Line No.. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: VAT Report No., Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the VAT Report Line table through TableRelation properties.