Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PARate_Table_ID | PA Rate Table ID |
String | 32 | View | |
PARate_Table_Date | PA Rate Table Date |
Date | 4 | View | |
PAJob_Title | PA Job Title |
String | 8 | View | |
PAPayCode | PA Pay Code |
String | 8 | View | |
PAUnit_of_Measure | PA Unit of Measure |
String | 10 | View | |
PAUNITCOST | PA Unit Cost |
Currency | 10 | View | |
PAProfitType | PA Profit Type 1 = Billing Rate |
Integer | 2 | View | |
PAProfitAmount | PA Profit Amount |
Currency | 10 | View | |
PAProfitPercent | PA Profit Percent |
Currency | 10 | View | |
PAOverhead_Group_ID | PA Overhead Group ID |
String | 16 | View | |
SUTASTAT | Suta State |
String | 4 | View | |
WRKRCOMP | Workers Comp |
String | 8 | View | |
PA_Orig_Profit_AmtTM | PA Originating Profit Amount - TM |
Currency | 10 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
CURRNIDX | Currency Index |
Integer | 2 | View | |
RATETPID | Rate Type ID |
String | 16 | View | |
EXGTBLID | Exchange Table ID |
String | 16 | View | |
XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
EXCHDATE | Exchange Date |
Date | 4 | View | |
TIME1 | Time |
Time | 4 | View | |
RTCLCMTD | Rate Calculation Method |
Integer | 2 | View | |
DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. |
Integer | 2 | View |