Other table in Microsoft Dynamics 365 Business Central. 18 fields, 0 records in Cronus demo.
The MTD Return Details table (ID 10532) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 18 fields, with a primary key of Start Date, End Date. 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: Start Date, End Date.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Start Date PK | Date | Normal | |
| 2 | End Date PK | Date | Normal | |
| 3 | Period Key | Code | Normal | |
| 4 | VAT Due Sales | Decimal | Normal | |
| 5 | VAT Due Acquisitions | Decimal | Normal | |
| 6 | Total VAT Due | Decimal | Normal | |
| 7 | VAT Reclaimed Curr Period | Decimal | Normal | |
| 8 | Net VAT Due | Decimal | Normal | |
| 9 | Total Value Sales Excl. VAT | Decimal | Normal | |
| 10 | Total Value Purchases Excl.VAT | Decimal | Normal | |
| 11 | Total Value Goods Suppl. ExVAT | Decimal | Normal | |
| 12 | Total Acquisitions Excl. VAT | Decimal | Normal | |
| 13 | Finalised | Boolean | 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 |