Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA11000
Product: Project Accounting (258)
Series: Project
Display Name: PA Billing Commissions LINK Group Display Name: PA Billing Transactions
Physical Name: PA11000
Technical Name: PA_Billing_Commissions_LINK
Group Technical Name: PA Billing Transactions
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
|---|---|---|---|---|---|---|
| 1 | PABILLTRXT  | PA Biller Trx Type | PA_DDL_Biller_Trx_Type | Integer | 2 | 0 |
| 2 | PADocnumber20 | PA Document No. | STR17_LBAU | String | 18 | 17 |
| 3 | SEQNUMBR | Sequence Number | LI_Sequence_Number | Long Integer | 4 | 10 |
| 4 | PACONTNUMBER | PA Contract Number | STR10_LBAU | String | 12 | 10 |
| 5 | SLPRSNID | Salesperson ID | STR15_Salesperson_ID | String | 16 | 15 |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['PA Billing Commissions LINK'].SLPRSNID AS 'PA Billing Commissions LINK-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
PA11000 AS ['PA Billing Commissions LINK']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['PA Billing Commissions LINK'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
| 6 | SALSTERR | Sales Territory | STR15_Sales_Territory | String | 16 | 15 |
Key to the Sales Territory Master File (RM00303).
Click to show/hideSELECT
['PA Billing Commissions LINK'].SALSTERR AS 'PA Billing Commissions LINK-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
PA11000 AS ['PA Billing Commissions LINK']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['PA Billing Commissions LINK'].SALSTERR = ['Sales Territory Master File'].SALSTERR | ||||||
| 7 | COMPRCNT | Commission Percent | INT5_%2 | Integer | 2 | 5 |
| 8 | COMDLRAM | Commission Dollar Amount | DLR17_RBSO_STR$ | Currency | 10 | 17 |
| 9 | CMMSLAMT | Commission Sale Amount | DLR17_RBS0_STR$ | Currency | 10 | 17 |
| 10 | PAPERBILL | PA Percent of Bill | INT5_%2 | Integer | 2 | 5 |
| 11 | COMAPPTO | Commission Applied To | GB | Integer | 2 | 0 |
| 12 | PABillingAmount | PA Billing Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
| 13 | COMMFLAG | Commission Flag | INT1 | Integer | 2 | 1 |
| 14 | ACTVTYPE | Activity Type | INT | Integer | 2 | 0 |
| 15 | NCOMAMNT | Non-Commissioned Amount | DLR19_RBS0_STR$ | Currency | 10 | 19 |
| 16 | POSTED | Posted | True/False | Boolean | 2 | 0 |
| 17 | ORCOMAMT | Originating Commission Dollar Amount | DLR17_RBSO_STR$ | Currency | 10 | 17 |
| 18 | ORCOSAMT | Originating Commission Sales Amount | DLR17_RBS0_STR$ | Currency | 10 | 17 |
| 19 | PAOrigBillAmount | PA Originating Billing Amount | DLR17_RBSO_STR$ | Currency | 10 | 17 |
| 20 | ORNCMAMT | Originating Non-Commissioned Amount | DLR19_RBS0_STR$ | Currency | 10 | 19 |
| 21 | DEX_ROW_ID | int | int | 10 | 10 | |
DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column. | ||||||