PA Billing Commissions HIST (PA33204)

azurecurveProductsProject Accounting (258)ProjectPA Billing Commissions HIST (PA33204)

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

Product: Project Accounting (258)
Series:

Display Name: PA Billing Commissions HIST
Physical Name: PA33204
Technical Name: PA_Billing_Commissions_HIST

Group Display Name: PA Billing Transactions History
Group Technical Name: PA Billing Transactions History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PABILLTRXT SearchPA Biller Trx TypeIntegerPA_DDL_Biller_Trx_Type0
2PADocnumber20 SearchPA Document No.StringSTR17_LBAU17
3SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
4PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
5SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

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

Click to show/hide

SELECT
       ['PA Billing Commissions HIST'].SALSTERR AS 'PA Billing Commissions HIST-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       PA33204 AS ['PA Billing Commissions HIST']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['PA Billing Commissions HIST'].SALSTERR = ['Sales Territory Master File'].SALSTERR
7COMPRCNT SearchCommission PercentIntegerINT5_%25
8COMDLRAM SearchCommission Dollar AmountCurrencyDLR17_RBSO_STR$17
9CMMSLAMT SearchCommission Sale AmountCurrencyDLR17_RBS0_STR$17
10PAPERBILL SearchPA Percent of BillIntegerINT5_%25
11COMAPPTO SearchCommission Applied ToIntegerGB0
12PABillingAmount SearchPA Billing AmountCurrencyDLR17_RBS0_UTR$17
13COMMFLAG SearchCommission FlagIntegerINT11
14ACTVTYPE SearchActivity TypeIntegerINT0
15NCOMAMNT SearchNon-Commissioned AmountCurrencyDLR19_RBS0_STR$19
16POSTED SearchPostedBooleanTrue/False0
17ORCOMAMT SearchOriginating Commission Dollar AmountCurrencyDLR17_RBSO_STR$17
18ORCOSAMT SearchOriginating Commission Sales AmountCurrencyDLR17_RBS0_STR$17
19PAOrigBillAmount SearchPA Originating Billing AmountCurrencyDLR17_RBSO_STR$17
20ORNCMAMT SearchOriginating Non-Commissioned AmountCurrencyDLR19_RBS0_STR$19
azurecurveProductsProject Accounting (258)ProjectPA Billing Commissions HIST (PA33204)

Leave a Reply

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