Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA40601
Product: Project Accounting (258)
Series:
Display Name: PA Employee Class Setup
Physical Name: PA40601
Technical Name: PA_Employee_Class_SETP
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | EMPLCLAS  | Employee Class | String | STR15_Employee_Class | 15 | |
| 2 | PAEmployee_Type | PA Employee Type | Integer | PA_GB_Employee_Type | 0 | |
| 3 | PA_Employed_By | PA Employed By | Integer | PA_DDL_Employed_By | 0 | |
| 4 | PAPayCode | PA Pay Code | String | STR6_Payroll_Code | 6 | |
| 5 | PAUnit_of_Measure | PA Unit of Measure | String | U_Of_M | 8 | |
| 6 | PAUNITCOST | PA Unit Cost | Currency | PA_DLR17_RBS0_UTR$ | 17 | |
| 7 | PATMProfitType | PA Profit Type - TM | Integer | PA_DDL_Profit_Type | 0 | |
| 8 | PATMProfitAmount | PA Profit Amount - TM | Currency | DLR17_RBS0_UTR$ | 17 | |
| 9 | PATMProfitPercent | PA Profit Percent - TM | Currency | DLR5_%2 | 8 | |
| 10 | PAProfit_Type__CP | PA Profit Type - CP | Integer | PA_DDL_Profit_Type | 0 | |
| 11 | PAProfitAmountCP | PA Profit Amount - CP | Currency | DLR17_RBS0_UTR$ | 17 | |
| 12 | PAProfitPercentCP | PA Profit Percent - CP | Currency | DLR5_%2 | 8 | |
| 13 | PAFFProfitType | PA Profit Type - FF | Integer | PA_DDL_Profit_Type | 0 | |
| 14 | PAFFProfitAmount | PA Profit Amount - FF | Currency | DLR17_RBS0_UTR$ | 17 | |
| 15 | PAFFProfitPercent | PA Profit Percent - FF | Currency | DLR5_%2 | 8 | |
| 16 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['PA Employee Class Setup'].VENDORID AS 'PA Employee Class Setup-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PA40601 AS ['PA Employee Class Setup']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PA Employee Class Setup'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 17 | PAOverheadRateMethod | PA Overhead Rate Method | Integer | GB | 0 | |
| 18 | PAOvhdAmtPerUnit | PA Overhead Amount Per Unit | Currency | DLR17_RBS0_UTR$ | 17 | |
| 19 | PAOverheaPercentage | PA Overhead Percentage | Currency | DLR5_%2 | 8 | |