TX00304 - Tax Return Detail | Prospr - Dynamics GP Table Reference

TX00304 - Tax Return Detail

Select * from TX00304

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
Tax_Return_ID	Tax Return ID	String	22	View
DOCNUMBR	Document Number	String	22	View
DOCTYPE	Document Type	Integer	2	View
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
TAXDTLID	Tax Detail ID	String	16	View
Tax_Date	Tax Date	Date	4	View
PSTGDATE	Posting Date	Date	4	View
TAXAMNT	Tax Amount	Currency	10	View
Taxable_Amount	Taxable Amount	Currency	10	View
DOCAMNT	Document Amount	Currency	10	View
EU_Purchases_Tax	EU Purchases Tax	Currency	10	View
ECTRX	EC Transaction	Boolean	2	View
VOIDSTTS	Void Status 0 = Document has not been voided. 1 = Document has been voided. 2 = Document has been marked NSF and voided.	Integer	2	View
CustomerVendor_ID	Customer/Vendor ID	String	16	View
DOCDESCR	Document Description	String	32	View