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 Group Display Name: PA Billing Transactions History
Physical Name: PA33204
Technical Name: PA_Billing_Commissions_HIST
Group Technical Name: PA Billing Transactions History
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PABILLTRXT  | PA Biller Trx Type | Integer | PA_DDL_Biller_Trx_Type | 0 | |
| 2 | PADocnumber20 | PA Document No. | String | STR17_LBAU | 17 | |
| 3 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 | |
| 4 | PACONTNUMBER | PA Contract Number | String | STR10_LBAU | 10 | |
| 5 | SLPRSNID | Salesperson ID | String | STR15_Salesperson_ID | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['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 | ||||||
| 6 | SALSTERR | Sales Territory | String | STR15_Sales_Territory | 15 | |
Key to the Sales Territory Master File (RM00303).
Click to show/hideSELECT
['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 | ||||||
| 7 | COMPRCNT | Commission Percent | Integer | INT5_%2 | 5 | |
| 8 | COMDLRAM | Commission Dollar Amount | Currency | DLR17_RBSO_STR$ | 17 | |
| 9 | CMMSLAMT | Commission Sale Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 10 | PAPERBILL | PA Percent of Bill | Integer | INT5_%2 | 5 | |
| 11 | COMAPPTO | Commission Applied To | Integer | GB | 0 | |
| 12 | PABillingAmount | PA Billing Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 13 | COMMFLAG | Commission Flag | Integer | INT1 | 1 | |
| 14 | ACTVTYPE | Activity Type | Integer | INT | 0 | |
| 15 | NCOMAMNT | Non-Commissioned Amount | Currency | DLR19_RBS0_STR$ | 19 | |
| 16 | POSTED | Posted | Boolean | True/False | 0 | |
| 17 | ORCOMAMT | Originating Commission Dollar Amount | Currency | DLR17_RBSO_STR$ | 17 | |
| 18 | ORCOSAMT | Originating Commission Sales Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 19 | PAOrigBillAmount | PA Originating Billing Amount | Currency | DLR17_RBSO_STR$ | 17 | |
| 20 | ORNCMAMT | Originating Non-Commissioned Amount | Currency | DLR19_RBS0_STR$ | 19 | |