TX30000 - Tax History | Prospr - Dynamics GP Table Reference

TX30000 - Tax History

Query Builder

Select * from TX30000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
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
RCTRXSEQ	Recurring TRX Sequence	Currency	10	View
SEQNUMBR	Sequence Number	Long Integer	4	View
TAXDTLID	Tax Detail ID	String	16	View
TXDTLPCT	Tax Detail Percent	Currency	10	View
TXDTLAMT	Tax Detail Amount	Currency	10	View
ACTINDX	Account Index	Long Integer	4	View
DOCDATE	Document Date	Date	4	View
Tax_Date	Tax Date	Date	4	View
PSTGDATE	Posting Date	Date	4	View
TAXAMNT	Tax Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
Taxable_Amount	Taxable Amount	Currency	10	View
Originating_Taxable_Amt	Originating Taxable Amount	Currency	10	View
DOCAMNT	Document Amount	Currency	10	View
ORDOCAMT	Originating Document Amount	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
CURRNIDX	Currency Index	Integer	2	View
Included_On_Return	Included On Return	Boolean	2	View
Tax_Return_ID	Tax Return ID	String	22	View
TXORGN	Tax Origin	Integer	2	View
TXDTLTYP	Tax Detail Type	Integer	2	View
TRXSTATS	Trx Status	String	2	View
RETNUM	Return Number	String	18	View
YEAR1	Year	Integer	2	View
INVATRET	Included On VAT Return	Boolean	2	View
VATCOLCD	Vat Column Code	String	4	View
VATRPTID	Vat Daybook Report ID	String	10	View
Revision_Number	Revision Number	Integer	2	View
PERIODID	Period ID	Integer	2	View
ISGLTRX	IsGLTax	Boolean	2	View

TX30000 - Tax History

Query Builder

Customer Service

Information

My Account

Contact Us