TX20500 - Tax Rebate | Prospr - Dynamics GP Table Reference

TX20500 - Tax Rebate

Select * from TX20500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DOCNUMBR	Document Number	String	22	View
DOCTYPE	Document Type	Integer	2	View
APFRDCNM	Apply From Document Number	String	22	View
APFRDCTY	Apply From 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
TaxRebateType	TaxRebateType	Integer	2	View
SEQNUMBR	Sequence Number	Long Integer	4	View
TAXDTLID	Tax Detail ID	String	16	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
ACTINDX	Account Index	Long Integer	4	View
ECTRX	EC Transaction	Boolean	2	View
TRXSORCE	TRX Source	String	14	View
POSTED	Posted	Boolean	2	View
CustomerVendor_ID	Customer/Vendor ID	String	16	View
DOCDATE	Document Date	Date	4	View
Tax_Date	Tax Date	Date	4	View
PSTGDATE	Posting Date	Date	4	View
CURRNIDX	Currency Index	Integer	2	View