VAT00400 - Vat Daybook Reports Electronic Submission | Prospr - Dynamics GP Table Reference

VAT00400 - Vat Daybook Reports Electronic Submission

Query Builder

Select * from VAT00400

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
VATRPTID	Vat Daybook Report ID	String	10	View
CCode	Country Code	String	8	View
Submission_Number	Submission_Number	String	18	View
Total_Sales_Tax	Total Sales Tax	Currency	10	View
EU_Purchases_Tax	EU Purchases Tax	Currency	10	View
Total_Tax	Total Tax	Currency	10	View
Total_Purchases_Tax	Total Purchases Tax	Currency	10	View
Total_Tax_Due	Total Tax Due	Currency	10	View
Total_Sales	Total Sales	Currency	10	View
TOTPURCH	Total Purchases	Currency	10	View
Total_EU_Sales	Total EU Sales	Currency	10	View
Total_EU_Purchases	Total EU Purchases	Currency	10	View
YEAR1	Year	Integer	2	View
VAT_Period	VatReturnPeriod	Integer	2	View
VATReturn_FileName	VATReturn_FileName	String	256	View
STRTNGDT	Starting Date	Date	4	View
ENDINGDT	Ending Date	Date	4	View