PA01405 - PA Job Title Rate Table Line
Dynamics GP table PA01405 (PA Job Title Rate Table Line) contains 23 columns including PARate_Table_ID, PARate_Table_Date, PAJob_Title....
SQL Query Builder
23 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PARate_Table_ID | PA Rate Table ID | String | 32 | |
| PARate_Table_Date | PA Rate Table Date | Date | 4 | |
| PAJob_Title | PA Job Title | String | 8 | |
| PAPayCode | PA Pay Code | String | 8 | |
| PAUnit_of_Measure | PA Unit of Measure | String | 10 | |
| PAUNITCOST | PA Unit Cost | Currency | 10 | |
| PAProfitType | PA Profit Type1 = Billing Rate2 = Markup3 = Profit/Unit Fixed4 = Profit/Unit Variable5 = Total Profit6 = % of Baseline7 = % of Actual8 = None9 = Price Level | Integer | 2 | |
| PAProfitAmount | PA Profit Amount | Currency | 10 | |
| PAProfitPercent | PA Profit Percent | Currency | 10 | |
| PAOverhead_Group_ID | PA Overhead Group ID | String | 16 | |
| SUTASTAT | Suta State | String | 4 | |
| WRKRCOMP | Workers Comp | String | 8 | |
| PA_Orig_Profit_AmtTM | PA Originating Profit Amount - TM | 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 | |
| XCHGRATE | Exchange Rate | Currency (Variable) | 10 | |
| EXCHDATE | Exchange Date | Date | 4 | |
| 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 PA01405. Click "Join" to add to your query.