RM Salesperson Master (RM00301)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM00301

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Salesperson Master
Physical Name: RM00301
Technical Name: RM_Salesperson_MSTR

Group Display Name: Receivables Salesperson Files
Group Technical Name: RM_Salesperson_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
2EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
3VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['RM Salesperson Master'].VENDORID AS 'RM Salesperson Master-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       RM00301 AS ['RM Salesperson Master']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['RM Salesperson Master'].VENDORID = ['PM Vendor Master File'].VENDORID
4SLPRSNFN SearchSalespersons First NameStringSTR15_Name15
5SPRSNSMN SearchSalespersons Middle NameStringSTR15_Name15
6SPRSNSLN SearchSalespersons Last NameStringSTR2020
7ADDRESS1 SearchAddress 1StringSTR6060
8ADDRESS2 SearchAddress 2StringSTR6060
9ADDRESS3 SearchAddress 3StringSTR6060
10CITY SearchCityStringSTR3535
11STATE SearchStateStringSTR30_State29
12ZIP SearchZipStringSTR1010
13COUNTRY SearchCountryStringSTR6060
14PHONE1 SearchPhone 1StringPhone_Number14
15PHONE2 SearchPhone 2StringPhone_Number14
16PHONE3 SearchPhone 3StringPhone_Number314
17FAX SearchFaxStringSTR14_FAX14
18INACTIVE SearchInactiveBooleanCB_Inactive0
19SALSTERR SearchSales TerritoryStringSTR15_Sales_Territory15
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['RM Salesperson Master'].SALSTERR AS 'RM Salesperson Master-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       RM00301 AS ['RM Salesperson Master']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['RM Salesperson Master'].SALSTERR = ['Sales Territory Master File'].SALSTERR
20COMMCODE SearchCommission CodeStringSTR15_LBAU15
21COMPRCNT SearchCommission PercentIntegerINT5_%25
22STDCPRCT SearchStandard Commission PercentIntegerINT0
23COMAPPTO SearchCommission Applied ToIntegerGB0
24COSTTODT SearchCost To DateCurrencyDLR19_RBSO_STR$19
25CSTLSTYR SearchCost Last YearCurrencyDLR19_RBSO_STR$19
26TTLCOMTD SearchTotal Commissions To DateCurrencyDLR19_RBSO_STR$19
27TTLCOMLY SearchTotal Commissions Last YearCurrencyDLR19_RBSO_STR$19
28COMSLTDT SearchCommissioned Sales To DateCurrencyDLR19_RBSO_STR$19
29COMSLLYR SearchCommissioned Sales Last YearCurrencyDLR19_RBSO_STR$19
30NCOMSLTD SearchNon-Commissioned Sales To DateCurrencyDLR19_RBSO_STR$19
31NCOMSLYR SearchNon-Commissioned Sales Last YearCurrencyDLR19_RBSO_STR$19
32KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
33KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
34NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['RM Salesperson Master'].NOTEINDX AS 'RM Salesperson Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       RM00301 AS ['RM Salesperson Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['RM Salesperson Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
35MODIFDT SearchModified DateDateDT8
36CREATDDT SearchCreated DateDateDT8
37COMMDEST SearchCommission DestinationIntegerDDL_Commission_Destination0

Leave a Reply

Your email address will not be published. Required fields are marked *