Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA41101
Product: Project Accounting (258)
Series:
Display Name: PA Contract Class Setup File Group Display Name: PA Budgeting Class
Physical Name: PA41101
Technical Name: PA_Contract_Class_SETP
Group Technical Name: PA Budgeting Class
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PAcontclassid | PA Contract Class ID | String | STR15_Contract_Class_ID | 15 | |
2 | PAcontclassname | PA Contract Class Name | String | STR30_PTBS Description 1 | 30 | |
3 | PADC | PA Default Class | Boolean | CB_Default | 0 | |
4 | PACOMMSELRB | PA Commission Select RG | Integer | GB | 0 | |
5 | COMPRCNT | Commission Percent | Integer | INT5_%2 | 5 | |
6 | COMAPPTO | Commission Applied To | Integer | GB | 0 | |
7 | PAbillnoteidx | PA Billing Note Index | Currency | DLR14 | 14 | |
8 | PAbillnoteidxts | PA Billing Note Index - TS | Currency | DLR14 | 14 | |
9 | PAELbillniteidx | PA Billing Note Index - EL | Currency | DLR14 | 14 | |
10 | PAbillnoteidxML | PA Billing Note Index - ML | Currency | DLR14 | 14 | |
11 | PAbillnoteidxvi | PA Billing Note Index - VI | Currency | DLR14 | 14 | |
12 | PAbillnoteidxee | PA Billing Note Index - EE | Currency | DLR14 | 14 | |
13 | PAbillnoteidxinv | PA Billing Note Index - INV | Currency | DLR14 | 14 | |
14 | PAbillnoteidxfee | PA Billing Note Index - FEE | Currency | DLR14 | 14 | |
15 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['PA Contract Class Setup File'].NOTEINDX AS 'PA Contract Class Setup File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PA41101 AS ['PA Contract Class Setup File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PA Contract Class Setup File'].NOTEINDX = ['Record Notes Master'].NOTEINDX |