SOP10101 - Sales Commissions Work and History | Prospr

SOP10101 - Sales Commissions Work and History

Select * from SOP10101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
SOPNUMBE	SOP Number	String	22	View
SEQNUMBR	Sequence Number	Long Integer	4	View
SLPRSNID	Salesperson ID	String	16	View
SALSTERR	Sales Territory	String	16	View
COMPRCNT	Commission Percent	Integer	2	View
COMMAMNT	Commission Amount	Currency	10	View
OCOMMAMT	Originating Commission Amount	Currency	10	View
NCOMAMNT	Non-Commissioned Amount	Currency	10	View
ORNCMAMT	Originating Non-Commissioned Amount	Currency	10	View
PRCTOSAL	Percent of Sale	Integer	2	View
ACTSLAMT	Actual Sale Amount	Currency	10	View
ORSLSAMT	Originating Sales Amount	Currency	10	View
CMMSLAMT	Commission Sale Amount	Currency	10	View
ORCOSAMT	Originating Commission Sales Amount	Currency	10	View
CURRNIDX	Currency Index	Integer	2	View
TRXSORCE	TRX Source	String	14	View