PA40601 - PA Employee Class Setup
Dynamics GP table PA40601 (PA Employee Class Setup) contains 19 columns including EMPLCLAS, PAEmployee_Type, PA_Employed_By....
SQL Query Builder
19 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| EMPLCLAS | Employee Class | String | 16 | |
| PAEmployee_Type | PA Employee Type | Integer | 2 | |
| PA_Employed_By | PA Employed By1 = Standard2 = Placement Agency3 = Subcontractor | Integer | 2 | |
| PAPayCode | PA Pay Code | String | 8 | |
| PAUnit_of_Measure | PA Unit of Measure | String | 10 | |
| PAUNITCOST | PA Unit Cost | Currency | 10 | |
| PATMProfitType | PA Profit Type - TM1 - Billing Rate2 - Markup %3 - Profit/Unit-Fixed4 - Profit/Unit-Variable5 - Total Profit6 - % of Baseline7 - % of Actual8 - None9 - Price Level | Integer | 2 | |
| PATMProfitAmount | PA Profit Amount - TM | Currency | 10 | |
| PATMProfitPercent | PA Profit Percent - TM | Currency | 10 | |
| PAProfit_Type__CP | PA Profit Type - CP1 - Billing Rate2 - Markup %3 - Profit/Unit-Fixed4 - Profit/Unit-Variable5 - Total Profit6 - % of Baseline7 - % of Actual8 - None9 - Price Level | Integer | 2 | |
| PAProfitAmountCP | PA Profit Amount - CP | Currency | 10 | |
| PAProfitPercentCP | PA Profit Percent - CP | Currency | 10 | |
| PAFFProfitType | PA Profit Type - FF1 - Billing Rate2 - Markup %3 - Profit/Unit-Fixed4 - Profit/Unit-Variable5 - Total Profit6 - % of Baseline7 - % of Actual8 - None9 - Price Level | Integer | 2 | |
| PAFFProfitAmount | PA Profit Amount - FF | Currency | 10 | |
| PAFFProfitPercent | PA Profit Percent - FF | Currency | 10 | |
| VENDORID | Vendor ID | String | 16 | |
| PAOverheadRateMethod | PA Overhead Rate Method | Integer | 2 | |
| PAOvhdAmtPerUnit | PA Overhead Amount Per Unit | Currency | 10 | |
| PAOverheaPercentage | PA Overhead Percentage | Currency | 10 |
Related Tables
Tables that share columns with PA40601. Click "Join" to add to your query.