PA00701 - PA Equipment Master File
Dynamics GP table PA00701 (PA Equipment Master File) contains 18 columns including PAEQUIPTID, PAEQNME, PAEQUIPTCLSID....
SQL Query Builder
18 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PAEQUIPTID | PA Equipment ID | String | 16 | |
| PAEQNME | PA Equipment Name | String | 32 | |
| PAEQUIPTCLSID | PA Equipment Class ID | String | 16 | |
| PAinactive | PA Inactive | Boolean | 2 | |
| 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 | |
| PAUD1 | PA User Defined 1 | String | 22 | |
| PAUD2 | PA User Defined 2 | String | 22 | |
| PANOTEINDEX | PA Note Index | Currency | 10 |
Related Tables
Tables that share columns with PA00701. Click "Join" to add to your query.