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 |