VAT00100 - UK Electronic VAT Response Master
Dynamics GP table VAT00100 (UK Electronic VAT Response Master) contains 15 columns including Submission_Number, ElectronicVATStatus, ElecVAT_FromDate....
SQL Query Builder
15 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| Submission_Number | Submission_Number | String | 18 | |
| ElectronicVATStatus | ElectronicVATStatus | Integer | 2 | |
| ElecVAT_FromDate | ElecVAT_FromDate | Date | 4 | |
| ElecVAT_ToDate | ElecVAT_ToDate | Date | 4 | |
| ElecVAT_SubmitDate | ElecVAT_SubmitDate | Date | 4 | |
| Submit_Time | ElecVAT_SubmitTime | Time | 4 | |
| ElecVAT_AcceptDate | ElecVAT_AcceptDate | Date | 4 | |
| Accepted_Time | ElecVAT_AcceptedTime | Time | 4 | |
| Correlative_ID | Correlative_ID | String | 256 | |
| ElecVAT_ErrorDate | ElecVAT_ErrorDate | Date | 4 | |
| Error_Time | ElecVAT_ErrorTime | Time | 4 | |
| Average_Polling_Time | AvgPollingTime | Integer | 2 | |
| YEAR1 | Year | Integer | 2 | |
| VAT_Period | VatReturnPeriod | Integer | 2 | |
| HMRC_Response | HMRC_Response | Text | 2 |