VAT00400 - Vat Daybook Reports Electronic Submission
Dynamics GP table VAT00400 (Vat Daybook Reports Electronic Submission) contains 17 columns including VATRPTID, CCode, Submission_Number....
SQL Query Builder
17 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| VATRPTID | Vat Daybook Report ID | String | 10 | |
| CCode | Country Code | String | 8 | |
| Submission_Number | Submission_Number | String | 18 | |
| Total_Sales_Tax | Total Sales Tax | Currency | 10 | |
| EU_Purchases_Tax | EU Purchases Tax | Currency | 10 | |
| Total_Tax | Total Tax | Currency | 10 | |
| Total_Purchases_Tax | Total Purchases Tax | Currency | 10 | |
| Total_Tax_Due | Total Tax Due | Currency | 10 | |
| Total_Sales | Total Sales | Currency | 10 | |
| TOTPURCH | Total Purchases | Currency | 10 | |
| Total_EU_Sales | Total EU Sales | Currency | 10 | |
| Total_EU_Purchases | Total EU Purchases | Currency | 10 | |
| YEAR1 | Year | Integer | 2 | |
| VAT_Period | VatReturnPeriod | Integer | 2 | |
| VATReturn_FileName | VATReturn_FileName | String | 256 | |
| STRTNGDT | Starting Date | Date | 4 | |
| ENDINGDT | Ending Date | Date | 4 |
Related Tables
Tables that share columns with VAT00400. Click "Join" to add to your query.
TOTPURCH
VAT_Period