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 |