| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| PADocnumber20 | PA Document No. |
String | 18 | View | |
| PADOCDT | PA Document Date |
Date | 4 | View | |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| CUTOFDAT | Cutoff Date |
Date | 4 | View | |
| PAPROJNUMBER | PA Project Number |
String | 16 | View | |
| PAprojname | PA Project Name |
String | 32 | View | |
| PAAcctgMethod | PA Accounting Method |
Integer | 2 | View | |
| PASTAT | PA Status 1 = Open |
Integer | 2 | View | |
| PACOSTCATID | PA Cost Category ID |
String | 16 | View | |
| PACBRecogRev | PA Recognize Revenue CB |
Boolean | 2 | View | |
| PATU | PA Transaction Usage 1 = Timesheet |
Integer | 2 | View | |
| PAFTotalCost | PA Forecast Total Cost |
Currency | 10 | View | |
| PAFQuantity | PA Forecast Quantity |
Currency | 10 | View | |
| PAFBillings | PA Forecast Billings |
Currency | 10 | View | |
| PAPostCost | PA Actual Cost |
Currency | 10 | View | |
| PAPostedQtySTDN | PA Actual Qty STD |
Currency | 10 | View | |
| PAPercentCompleted | PA Percent Completed |
Currency | 10 | View | |
| PAREB | PA Revenue Earned-Budget |
Currency | 10 | View | |
| PA_Cost_of_Earnings | PA Cost of Earnings |
Currency | 10 | View | |
| PABRecognizedBudgAmount | PA Recognized Budget Amount |
Currency | 10 | View | |
| PABIEEAMOUNT | PA BIEE Amount |
Currency | 10 | View | |
| PAEIEBAMOUNT | PA EIEB Amount |
Currency | 10 | View | |
| PAPostedBillingsN | PA Actual Billings |
Currency | 10 | View | |
| PA_Trade_Discount_Amount | PA Trade Discount Amount |
Currency | 10 | View | |
| PACGBWIPIDX | PA WIP IDX |
Long Integer | 4 | View | |
| PABBillingsIDX | PA Billings IDX |
Long Integer | 4 | View | |
| PABExpenseIDX | PA Expense IDX |
Long Integer | 4 | View | |
| PABLossIDX | PA Loss IDX |
Long Integer | 4 | View | |
| PARev_IDX | PA Revenue IDX |
Long Integer | 4 | View | |
| PABEIEBIDX | PA EIEB IDX |
Long Integer | 4 | View | |
| PABBIEEIDX | PA BIEE IDX |
Long Integer | 4 | View | |
| PACGBRRSublineErrorsB | PA RR Subline Errors-Budget |
Long Integer | 4 | View | |
| NOTEINDX | Note Index |
Currency | 10 | View | |
| PA_ActualCost__LossTest | PA ActualCost - LossTest |
Currency | 10 | View | |
| PA_ProjAmt__LossTest | PA ProjAmt - LossTest |
Currency | 10 | View | |
| PA_ActualRecogRev__LossT | PA ActualRecogRev - LossTest |
Currency | 10 | View | |
| PA_ActualBlgs__XcessTest | PA ActualBlgs - XcessTest |
Currency | 10 | View | |
| PA_Earnings__XcessTest | PA Earnings - XcessTest |
Currency | 10 | View | |
| PAPostRecogRevN | PA Actual Recognized Revenue |
Currency | 10 | View | |
| PALossAmount | PA Loss Amount |
Currency | 10 | View | |
| PAPrevRecognizedRev | PA Prev Recognized Revenue |
Currency | 10 | View | |
| PAPrevBIEEAmount | PA Prev BIEE Amount |
Currency | 10 | View | |
| PAPrevEIEBAmount | PA Prev EIEB Amount |
Currency | 10 | View | |
| PAPrevEarnings | PA Prev Earnings |
Currency | 10 | View | |
| PAPrevLossAmount | PA Prev Loss Amount |
Currency | 10 | View | |
| PAPrevBillings | PA Prev Billings |
Currency | 10 | View | |
| PAPrevCost | PA Prev Cost |
Currency | 10 | View |