PA01001 - PA Cost Category Master File
Dynamics GP table PA01001 (PA Cost Category Master File) contains 44 columns including PACOSTCATID, PACOSTCATNME, PACOSTCATCLASID....
SQL Query Builder
44 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PACOSTCATID | PA Cost Category ID | String | 16 | |
| PACOSTCATNME | PA Cost Category Name | String | 32 | |
| PACOSTCATCLASID | PA Cost Category Class ID | String | 16 | |
| PAinactive | PA Inactive | Boolean | 2 | |
| PATU | PA Transaction Usage1 = Timesheet2 = Equipment Log3 = Miscellaneous Log4 = Purchases/Material5 = Employee Expense | Integer | 2 | |
| PAIV_Item_Checkbox | PA IV Item Checkbox | Boolean | 2 | |
| PAUnit_of_Measure | PA Unit of Measure | String | 10 | |
| UOMSCHDL | U Of M Schedule | String | 12 | |
| DECPLQTY | Decimal Places QTYS | Integer | 2 | |
| PAUNITCOST | PA Unit Cost | Currency | 10 | |
| PAPay_Code_Hourly | PA Pay Code Hourly | String | 8 | |
| PAPay_Code_Salary | PA Pay Code Salary | String | 8 | |
| 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 | |
| PA_Orig_Profit_AmtTM | PA Originating 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 | |
| DECPLCUR | Decimal Places Currency | Integer | 2 | |
| PAcostaxscheduleid | PA Cost Tax Schedule ID | String | 16 | |
| PAPurchase_Tax_Options | PA Purchase Tax Options | Integer | 2 | |
| PAbilltaxscheduleid | PA Billing Tax Schedule ID | String | 16 | |
| PASales_Tax_Options | PA Sales Tax Options | Integer | 2 | |
| PAUD1 | PA User Defined 1 | String | 22 | |
| PAUD2 | PA User Defined 2 | String | 22 | |
| PAbillnoteidx | PA Billing Note Index | Currency | 10 | |
| PAOverheadRateMethod | PA Overhead Rate Method | Integer | 2 | |
| PAOvhdAmtPerUnit | PA Overhead Amount Per Unit | Currency | 10 | |
| PAOverheaPercentage | PA Overhead Percentage | Currency | 10 | |
| PANOTEINDEX | PA Note Index | Currency | 10 | |
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | |
| CURRNIDX | Currency Index | Integer | 2 | |
| RATETPID | Rate Type ID | String | 16 | |
| EXGTBLID | Exchange Table ID | String | 16 | |
| EXCHDATE | Exchange Date | Date | 4 | |
| XCHGRATE | Exchange Rate | Currency (Variable) | 10 | |
| TIME1 | Time | Time | 4 | |
| RTCLCMTD | Rate Calculation Method | Integer | 2 | |
| DENXRATE | Denomination Exchange Rate | Currency (Variable) | 10 | |
| MCTRXSTT | MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = Originating is not a denomination; Functional is the Euro currency.3 = Originating is not a denomination; Functional is a denomination.4 = Originating is a denomination; Functional is not a denomination.5 = Originating is a denomination; Functional is a denomination.6 = Originating is a denomination; Functional is the Euro currency.7 = Originating is the Euro currency; Functional is a denomination.8 = Originating is the Euro currency; Functional is not a denomination. | Integer | 2 |
Related Tables
Tables that share columns with PA01001. Click "Join" to add to your query.