RM30601 - RM Tax History File | Prospr - Dynamics GP Table Reference

RM30601 - RM Tax History File

Select * from RM30601

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BACHNUMB	Batch Number	String	16	View
RMDTYPAL	RM Document Type-All 0 = Reserved for balance carried forward records 1 = Sales / Invoice 2 = Reserved for schedule payments 3 = Debit Memos 4 = Finance Charges 5 = Service Repairs 6= Warranties 7 = Credit Memos 8 = Returns 9 = Payments	Integer	2	View
DOCNUMBR	Document Number	String	22	View
CUSTNMBR	Customer Number	String	16	View
TRXSORCE	TRX Source	String	14	View
TAXDTLID	Tax Detail ID	String	16	View
ACTINDX	Account Index	Long Integer	4	View
TAXAMNT	Tax Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
STAXAMNT	Sales Tax Amount	Currency	10	View
ORSLSTAX	Originating Sales Tax Amount	Currency	10	View
FRTTXAMT	Freight Tax Amount	Currency	10	View
ORFRTTAX	Originating Freight Tax Amount	Currency	10	View
MSCTXAMT	Misc Tax Amount	Currency	10	View
ORMSCTAX	Originating Misc Tax Amount	Currency	10	View
TAXDTSLS	Tax Detail Total Sales	Currency	10	View
ORTOTSLS	Originating Total Sales	Currency	10	View
TDTTXSLS	Tax Detail Total Taxable Sales	Currency	10	View
ORTXSLS	Originating Total Taxable Sales	Currency	10	View
POSTED	Posted	Boolean	2	View
SEQNUMBR	Sequence Number	Long Integer	4	View
CURRNIDX	Currency Index	Integer	2	View