Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PDK_TS_No | PDK TS No. |
String | 32 | View | |
EMPLOYID | Employee ID |
String | 16 | View | |
PADT | PA Date |
Date | 4 | View | |
PAPROJNUMBER | PA Project Number |
String | 16 | View | |
PACOSTCATID | PA Cost Category ID |
String | 16 | View | |
PATB | PA Time Begin |
Time | 4 | View | |
PATE | PA Time End |
Time | 4 | View | |
PDK_Quantity | PDK Quantity |
Currency | 10 | View | |
PABase_Qty | PA Base Qty |
Currency | 10 | View | |
PAUnit_of_Measure | PA Unit of Measure |
String | 10 | View | |
UOMSCHDL | U Of M Schedule |
String | 12 | View | |
PAUNITCOST | PA Unit Cost |
Currency | 10 | View | |
ORUNTCST | Originating Unit Cost |
Currency | 10 | View | |
PABase_Unit_Cost | PA Base Unit Cost |
Currency | 10 | View | |
PAORGBSUNITCST | PA Originating Base Unit Cost |
Currency | 10 | View | |
PAEXTCOST | PA Extended Cost |
Currency | 10 | View | |
OREXTCST | Originating Extended Cost |
Currency | 10 | View | |
PATOTCST | PA Total Cost |
Currency | 10 | View | |
PAORIGTOTCOST | PA Originating Total Cost |
Currency | 10 | View | |
PAOverhead_Amount | PA Overhead Amount |
Currency | 10 | View | |
PAORIGOVHDAMT | PA Originating Overhead Amount |
Currency | 10 | View | |
PABaseOvhdCost | PA Base Overhead Cost |
Currency | 10 | View | |
PAORIGBASEOVRHCST | PA Originating Base Overhead Cost |
Currency | 10 | View | |
PAOverheaPercentage | PA Overhead Percentage |
Currency | 10 | View | |
PATOTALOVERH | PA Total Overhead |
Currency | 10 | View | |
PAORIGTOTOVRHD | PA Originating Total Overhead |
Currency | 10 | View | |
PA_Base_Billing_Rate | PA Base Billing Rate |
Currency | 10 | View | |
PAORIGBSBILLRTE | PA Originating Base Billing Rate |
Currency | 10 | View | |
PABILRATE | PA Billing Rate |
Currency | 10 | View | |
PAORIGBILLRATE | PA Originating Billing Rate |
Currency | 10 | View | |
PAMARKPERCENT | PA Markup Percentage |
Currency | 10 | View | |
PAACREV | PA Accrued Revenues |
Currency | 10 | View | |
PAORIACCRREV | PA Originating Accrued Revenues |
Currency | 10 | View | |
PASTD_Qty | PA STD Qty |
Currency | 10 | View | |
PANC_Qty | PA NC Qty |
Currency | 10 | View | |
PANB_Qty | PA NB Qty |
Currency | 10 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
PAREFNO | PA Reference Document No. |
String | 18 | View | |
PAReference_Line_Seq_N | PA Reference Line Seq No |
Long Integer | 4 | View | |
PAbllngtype | PA Billing Type |
Integer | 2 | View | |
PACONTNUMBER | PA Contract Number |
String | 12 | View | |
PAPayCode | PA Pay Code |
String | 8 | View | |
PASalary_Posting_Type | PA Salary Posting Type |
Integer | 2 | View | |
PAJob_Title | PA Job Title |
String | 8 | View | |
PADepartment | PA Department |
String | 8 | View | |
STATECD | State Code |
String | 4 | View | |
LOCLCODE | Local Code |
String | 8 | View | |
SUTASTAT | Suta State |
String | 4 | View | |
WRKRCOMP | Workers Comp |
String | 8 | View | |
PAProfitAmount | PA Profit Amount |
Currency | 10 | View | |
PAORIGPROFAMT | PA Originating Profit Amount |
Currency | 10 | View | |
PAProfitPercent | PA Profit Percent |
Currency | 10 | View | |
PATotalProfit | PA Total Profit |
Currency | 10 | View | |
PAORIGTOTPROF | PA Originating Total Profit |
Currency | 10 | View | |
PAProfitType | PA Profit Type 1 = Billing Rate |
Integer | 2 | View | |
PAROUNDAMT | PA Round Amount |
Currency | 10 | View | |
PABilling_StatusN | PA Billing Status 1 = Billable |
Integer | 2 | View | |
PDK_Billing_Note_ID | PDK Billing Note ID |
String | 42 | View | |
PACHGORDNO | PA Change Order Number |
String | 18 | View | |
PAMCCURNCYID | PA MC Currency ID |
String | 16 | View | |
PA_MC_Billing_Rate | PA MC Billing Rate |
Currency | 10 | View | |
PA_MC_Base_Billing_Rate | PA MC Base Billing Rate |
Currency | 10 | View | |
PA_MC_Accrued_Revenue | PA MC Accrued Revenue |
Currency | 10 | 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 | |
RATECALC | Rate Calc 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 |