GP Tables

EDCVAT06 - VAT Daybook Line

Dynamics GP table EDCVAT06 (VAT Daybook Line) contains 8 columns including VATRPTID, CCode, VATCOLCD....

SQL Query Builder

8 Columns

Column Description Type Length
VATRPTID Vat Daybook Report ID String 10
CCode Country Code String 8
VATCOLCD Vat Column Code String 4
SERIES Series1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll - USA7 = Project Integer 2
Module Series values (8)
1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll7 = Project10 = 3rd Party
TAXDTLID Tax Detail ID String 16
TXDTLDSC Tax Detail Description String 32
AMTTYP Amount Type Integer 2
DocType Doc Type Integer 2

Related Tables

Tables that share columns with EDCVAT06. Click "Join" to add to your query.