RM30501 - Commission History | Prospr - Dynamics GP Table Reference

RM30501 - Commission History

Select * from RM30501

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
NCOMAMNT	Non-Commissioned Amount	Currency	10	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
COMPRCNT	Commission Percent	Integer	2	View
DOCNUMBR	Document Number	String	22	View
SEQNUMBR	Sequence Number	Long Integer	4	View
TRXSORCE	TRX Source	String	14	View
COMTRSRC	Commission TRX Source	String	14	View
CUSTNMBR	Customer Number	String	16	View
SLPRSNID	Salesperson ID	String	16	View
SALSTERR	Sales Territory	String	16	View
COMMCODE	Commission Code	String	16	View
PRCTOSAL	Percent of Sale	Integer	2	View
SLSAMNT	Sales Amount	Currency	10	View
COMDLRAM	Commission Dollar Amount	Currency	10	View
POSTED	Posted	Boolean	2	View
COMMPAID	Commission Paid	Boolean	2	View
COMMDEST	Commission Destination	Integer	2	View
ORCOMAMT	Originating Commission Dollar Amount	Currency	10	View
ORSLSAMT	Originating Sales Amount	Currency	10	View
ORNCMAMT	Originating Non-Commissioned Amount	Currency	10	View
CURRNIDX	Currency Index	Integer	2	View