Sales Commissions Work and History (SOP10101)

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Commissions Work and History (SOP10101)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales Commissions Work and History
Physical Name: SOP10101
Technical Name: SOP_Commission_WORK_HIST

Group Display Name: Sales Distribution
Group Technical Name: Sales Distribution

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SOPTYPE SearchSOP TypeIntegerDDL_SOP_Type0
2SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17
3SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
4SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['Sales Commissions Work and History'].SLPRSNID AS 'Sales Commissions Work and History-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SOP10101 AS ['Sales Commissions Work and History']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Sales Commissions Work and History'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
5SALSTERR SearchSales TerritoryStringSTR15_Sales_Territory15
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['Sales Commissions Work and History'].SALSTERR AS 'Sales Commissions Work and History-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       SOP10101 AS ['Sales Commissions Work and History']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Sales Commissions Work and History'].SALSTERR = ['Sales Territory Master File'].SALSTERR
6COMPRCNT SearchCommission PercentIntegerINT5_%25
7COMMAMNT SearchCommission AmountCurrencyDLR17_RBS0_STR$17
8OCOMMAMT SearchOriginating Commission AmountCurrencyDLR17_RBSO_STR$17
9NCOMAMNT SearchNon-Commissioned AmountCurrencyDLR19_RBS0_STR$19
10ORNCMAMT SearchOriginating Non-Commissioned AmountCurrencyDLR19_RBS0_STR$19
11PRCTOSAL SearchPercent of SaleIntegerINT5_%25
12ACTSLAMT SearchActual Sale AmountCurrencyDLR19_RBS0_STR$19
13ORSLSAMT SearchOriginating Sales AmountCurrencyDLR19_RBSO_STR$19
14CMMSLAMT SearchCommission Sale AmountCurrencyDLR17_RBS0_STR$17
15ORCOSAMT SearchOriginating Commission Sales AmountCurrencyDLR17_RBS0_STR$17
16CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Sales Commissions Work and History'].CURRNIDX AS 'Sales Commissions Work and History-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SOP10101 AS ['Sales Commissions Work and History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Sales Commissions Work and History'].CURRNIDX = ['Currency Setup'].CURRNIDX
17TRXSORCE SearchTRX SourceStringSTR1313
azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Commissions Work and History (SOP10101)

Leave a Reply

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