Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PAertrxtype | PA Empl Expense TRX Type |
Integer | 2 | View | |
PAerdocnumber | PA Empl Expense Document No. |
String | 18 | View | |
PAREFNO | PA Reference Document No. |
String | 18 | View | |
EMPLOYID | Employee ID |
String | 16 | View | |
PADT | PA Date |
Date | 4 | View | |
PACONTNUMBER | PA Contract Number |
String | 12 | View | |
PAPROJNUMBER | PA Project Number |
String | 16 | View | |
PACOSTCATID | PA Cost Category ID |
String | 16 | View | |
PAitemnumber | PA Item Number |
String | 32 | View | |
PAbillnoteidx | PA Billing Note Index |
Currency | 10 | View | |
PAQtyQ | PA 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 | |
PAtotcosts | PA Total Costs |
Currency | 10 | View | |
PAORIGTOTCOSTS | PA Originating Total Costs |
Currency | 10 | View | |
PABILRATE | PA Billing Rate |
Currency | 10 | View | |
PAORIGBILLRATE | PA Originating Billing Rate |
Currency | 10 | View | |
PA_Base_Billing_Rate | PA Base Billing Rate |
Currency | 10 | View | |
PAORIGBSBILLRTE | PA Originating Base Billing Rate |
Currency | 10 | View | |
PAMARKPERCENT | PA Markup Percentage |
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 | |
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 | |
PAProfitType | PA Profit Type 1 = Billing Rate |
Integer | 2 | 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 | |
PAPurchase_Tax_Options | PA Purchase Tax Options |
Integer | 2 | View | |
ITMTSHID | Item Tax Schedule ID |
String | 16 | View | |
TAXAMNT | Tax Amount |
Currency | 10 | View | |
ORTAXAMT | Originating Tax Amount |
Currency | 10 | View | |
BCKTXAMT | Backout Tax Amount |
Currency | 10 | View | |
OBTAXAMT | Originating Backout Tax Amount |
Currency | 10 | View | |
PAPaymentMethod | PA Payment Method |
Integer | 2 | View | |
PAExpenseType | PA Expense Type |
Integer | 2 | View | |
PAReimbursableAmount | PA Reimbursable Amount |
Currency | 10 | View | |
PAOrigReimbursableAmt | PA Originating Reimbursable Amount |
Currency | 10 | View | |
PACGBWIPIDX | PA WIP IDX |
Long Integer | 4 | View | |
PAUnbilled_AR_Idx | PA Unbilled AR IDX |
Long Integer | 4 | View | |
PACogs_Idx | PA COGS IDX |
Long Integer | 4 | View | |
PAContra_Account_IDX | PA Contra Account IDX |
Long Integer | 4 | View | |
PAOverhead_IDX | PA Overhead IDX |
Long Integer | 4 | View | |
PAUnbilled_Proj_Rev_Idx | PA Unbilled Proj Rev IDX |
Long Integer | 4 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
PAReference_Line_Seq_N | PA Reference Line Seq No |
Long Integer | 4 | View | |
PAbllngtype | PA Billing Type |
Integer | 2 | View | |
PABilling_StatusN | PA Billing Status 1 = Billable |
Integer | 2 | View | |
PAexptdate | PA Export Date |
Date | 4 | View | |
PABilled_Misc | PA Billed Misc |
Currency | 10 | View | |
PABilled_QtyN | PA Billed Qty |
Currency | 10 | View | |
PABilledTax | PA Billed Tax |
Currency | 10 | View | |
PABilled_Discount | PA Billed Discount |
Currency | 10 | View | |
PAApproved_Quantity | PA Approved Quantity |
Currency | 10 | View | |
PAAPPROVBILLRATE | PA Approved Billing Rate |
Currency | 10 | View | |
PAAPPROVMKUPPCT | PA Approved Markup Percentage |
Currency | 10 | View | |
PAApproved_Billing_Amou | PA Approved Billing Amount |
Currency | 10 | View | |
PARemaining_Quantity | PA Remaining Quantity |
Currency | 10 | View | |
PARemaining_Total_Cost | PA Remaining Total Cost |
Currency | 10 | View | |
PARemaining_Accrued_Rev | PA Remaining Accrued Revenues |
Currency | 10 | View | |
PA_Billed_Profit_Amount_ | PA Billed Profit Amount Average |
Currency | 10 | View | |
PABilledProfitPercentage | PA Billed Profit Percentage Average |
Currency | 10 | View | |
PABilled_Amount | PA Billed Amount |
Currency | 10 | View | |
PAWrite_UpDown_Amount | PA Write Up/Down Amount |
Currency | 10 | View | |
PAWrite_UpDown_Percenta | PA Write Up/Down Percentage |
Long Integer | 4 | View | |
PAApprover_ID | PA Approver ID |
String | 16 | View | |
PAApprover_Type | PA Approver Type |
Integer | 2 | View | |
PAPartial_Bill | PA Partial Bill |
Boolean | 2 | View | |
PAROUNDAMT | PA Round Amount |
Currency | 10 | View | |
RNDDIFF | Rounding Difference |
Long Integer | 4 | View | |
PACHGORDNO | PA Change Order Number |
String | 18 | View | |
PACBADDFRMFLY | PA CB From Add On The Fly |
Boolean | 2 | View | |
PA_Billed_Status | PA Billed Status |
Boolean | 2 | 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 | |
Correcting_Trx_Type | Correcting Trx Type |
Integer | 2 | View | |
PAORIGINLDOCNUM | PA Original Document Number |
String | 18 | View | |
PAORIGLINEIMSEQ | PA Original Line Item Sequence |
Long Integer | 4 | View |