Invoicing Commissions (IVC10400)

azurecurveProductsMicrosoft Dynamics GP (0)SalesInvoicing Commissions (IVC10400)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Invoicing Commissions
Physical Name: IVC10400
Technical Name: IVC_Commission

Group Display Name: Invoice Distribution
Group Technical Name: Invoice Distribution

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
2INVCNMBR SearchInvoice NumberStringSTR20_IVC_Document_Number17
3SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
4SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

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

Click to show/hide

SELECT
       ['Invoicing Commissions'].SALSTERR AS 'Invoicing Commissions-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       IVC10400 AS ['Invoicing Commissions']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Invoicing Commissions'].SALSTERR = ['Sales Territory Master File'].SALSTERR
6COMPRCNT SearchCommission PercentIntegerINT5_%25
7COMDLRAM SearchCommission Dollar AmountCurrencyDLR17_RBSO_STR$17
8NCOMAMNT SearchNon-Commissioned AmountCurrencyDLR19_RBS0_STR$19
9PRCTOSAL SearchPercent of SaleIntegerINT5_%25
10SLSAMNT SearchSales AmountCurrencyDLR19_RBSO_UTR$19
11COMMCODE SearchCommission CodeStringSTR15_LBAU15
12TRXSORCE SearchTRX SourceStringSTR1313
13COMMFLAG SearchCommission FlagIntegerINT11
14ACTVTYPE SearchActivity TypeIntegerINT0
azurecurveProductsMicrosoft Dynamics GP (0)SalesInvoicing Commissions (IVC10400)

Leave a Reply

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