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 | Length | |
---|---|---|---|---|---|---|
1 | PABILLTRXT ![]() | PA Biller Trx Type | PA_DDL_Biller_Trx_Type | Integer | 0 | |
2 | PADocnumber20 ![]() | PA Document No. | STR17_LBAU | String | 17 | |
3 | SEQNUMBR ![]() | Sequence Number | LI_Sequence_Number | Long Integer | 10 | |
4 | PACONTNUMBER ![]() | PA Contract Number | STR10_LBAU | String | 10 | |
5 | SLPRSNID ![]() | Salesperson ID | STR15_Salesperson_ID | String | 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 | 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 | 5 | |
8 | COMDLRAM ![]() | Commission Dollar Amount | DLR17_RBSO_STR$ | Currency | 17 | |
9 | CMMSLAMT ![]() | Commission Sale Amount | DLR17_RBS0_STR$ | Currency | 17 | |
10 | PAPERBILL ![]() | PA Percent of Bill | INT5_%2 | Integer | 5 | |
11 | COMAPPTO ![]() | Commission Applied To | GB | Integer | 0 | |
12 | PABillingAmount ![]() | PA Billing Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
13 | COMMFLAG ![]() | Commission Flag | INT1 | Integer | 1 | |
14 | ACTVTYPE ![]() | Activity Type | INT | Integer | 0 | |
15 | NCOMAMNT ![]() | Non-Commissioned Amount | DLR19_RBS0_STR$ | Currency | 19 | |
16 | POSTED ![]() | Posted | True/False | Boolean | 0 | |
17 | ORCOMAMT ![]() | Originating Commission Dollar Amount | DLR17_RBSO_STR$ | Currency | 17 | |
18 | ORCOSAMT ![]() | Originating Commission Sales Amount | DLR17_RBS0_STR$ | Currency | 17 | |
19 | PAOrigBillAmount ![]() | PA Originating Billing Amount | DLR17_RBSO_STR$ | Currency | 17 | |
20 | ORNCMAMT ![]() | Originating Non-Commissioned Amount | DLR19_RBS0_STR$ | Currency | 19 | |
21 | DEX_ROW_ID ![]() | int | int | 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. |