| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| PA_Proj_Closing_Sequence | PA Proj Closing Sequence No. |
Long Integer | 4 | View | |
| PALineItemSeq | PA Line Item Sequence |
Long Integer | 4 | View | |
| JRNENTRY | Journal Entry |
Long Integer | 4 | View | |
| PACONTNUMBER | PA Contract Number |
String | 12 | View | |
| PAPROJNUMBER | PA Project Number |
String | 16 | View | |
| PACOSTCATID | PA Cost Category ID |
String | 16 | View | |
| PATU | PA Transaction Usage 1 = Timesheet |
Integer | 2 | View | |
| PAProfitType | PA Profit Type 1 = Billing Rate |
Integer | 2 | View | |
| PACGBWIPIDX | PA WIP IDX |
Long Integer | 4 | View | |
| PABBillingsIDX | PA Billings IDX |
Long Integer | 4 | View | |
| PABBIEEIDX | PA BIEE IDX |
Long Integer | 4 | View | |
| PABEIEBIDX | PA EIEB IDX |
Long Integer | 4 | View | |
| PABLossIDX | PA Loss IDX |
Long Integer | 4 | View | |
| PAFBillings | PA Forecast Billings |
Currency | 10 | View | |
| PAFTotalCost | PA Forecast Total Cost |
Currency | 10 | View | |
| PAFQuantity | PA Forecast Quantity |
Currency | 10 | View | |
| PAPostedQty | PA Actual Qty |
Currency | 10 | View | |
| PAPostedTotalCostN | PA Actual Total Cost |
Currency | 10 | View | |
| PAPostedBillingsN | PA Actual Billings |
Currency | 10 | View | |
| PAPostRecogRevN | PA Actual Recognized Revenue |
Currency | 10 | View | |
| PAPOSBIEEAMOUNT | PA Actual BIEE Amount |
Currency | 10 | View | |
| PAPOSEIEBAMOUNT | PA Actual EIEB Amount |
Currency | 10 | View | |
| PAActualLossAmount | PA Actual Loss Amount |
Currency | 10 | View | |
| PAPrevCost | PA Prev Cost |
Currency | 10 | View | |
| PAPrevBIEEAmount | PA Prev BIEE Amount |
Currency | 10 | View | |
| PAPrevEIEBAmount | PA Prev EIEB Amount |
Currency | 10 | View | |
| PAPrevBillings | PA Prev Billings |
Currency | 10 | View | |
| PAPrevLossAmount | PA Prev Loss Amount |
Currency | 10 | View | |
| PAPrevRecognizedRev | PA Prev Recognized Revenue |
Currency | 10 | View | |
| PAPrevEarnings | PA Prev Earnings |
Currency | 10 | View | |
| PAPosted_Earnings | PA Actual Earnings |
Currency | 10 | View |