Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVRMA305
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: Commission History Archive
Physical Name: SVRMA305
Technical Name: RM_Commission_History_ArchiveSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 NCOMAMNT 
Non-Commissioned Amount DLR19_RBS0_STR$ Currency 19 2 RMDTYPAL RM Document Type-All INT2 Integer 2 Document Type records the type of document.
Click to show/hide the Document Types
0 Balance Carried Forward
1 Sales / Invoice
2 Scheduled Payments
3 Debit Memo
4 Finance Charge
5 Service Repairs
6 Warranties
7 Credit Memo
8 Returns
9 Payments3 COMPRCNT Commission Percent INT5_%2 Integer 5 4 DOCNUMBR Document Number STR20_Document_Number String 20 5 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 6 TRXSORCE TRX Source STR13 String 13 7 COMTRSRC Commission TRX Source STR13 String 13 8 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Commission History Archive'].CUSTNMBR AS 'Commission History Archive-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVRMA305 AS ['Commission History Archive']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Commission History Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR9 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['Commission History Archive'].SLPRSNID AS 'Commission History Archive-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
SVRMA305 AS ['Commission History Archive']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['Commission History Archive'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID10 SALSTERR Sales Territory STR15_Sales_Territory String 15 Key to the Sales Territory Master File (RM00303).
Click to show/hide
SELECT
['Commission History Archive'].SALSTERR AS 'Commission History Archive-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
SVRMA305 AS ['Commission History Archive']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['Commission History Archive'].SALSTERR = ['Sales Territory Master File'].SALSTERR11 COMMCODE Commission Code STR15_LBAU String 15 12 PRCTOSAL Percent of Sale INT5_%2 Integer 5 13 SLSAMNT Sales Amount DLR19_RBSO_UTR$ Currency 19 14 COMDLRAM Commission Dollar Amount DLR17_RBSO_STR$ Currency 17 15 POSTED Posted True/False Boolean 0 16 COMMPAID Commission Paid CB_Commission_Paid Boolean 0 17 COMMDEST Commission Destination DDL_Commission_Destination Integer 0 18 ORCOMAMT Originating Commission Dollar Amount DLR17_RBSO_STR$ Currency 17 19 ORSLSAMT Originating Sales Amount DLR19_RBSO_STR$ Currency 19 20 ORNCMAMT Originating Non-Commissioned Amount DLR19_RBS0_STR$ Currency 19 21 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Commission History Archive'].CURRNIDX AS 'Commission History Archive-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
SVRMA305 AS ['Commission History Archive']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Commission History Archive'].CURRNIDX = ['Currency Setup'].CURRNIDX