Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PACONTNUMBER | PA Contract Number |
String | 12 | View | |
PAchangeorderdocounter | PA Change Order Doc Counter |
String | 18 | View | |
PATRKCHGORDS | PA Track Change Orders |
Boolean | 2 | View | |
PATRKCOBDGADDFLY | PA Track CO for Budgets Add on fly |
Boolean | 2 | View | |
PACOTRKBASELINE | PA CO Create Baseline |
Boolean | 2 | View | |
PATOTCHGORDAMT | PA Total Change Order Amount |
Currency | 10 | View | |
PANOPENDCO | PA Number of Pending CO |
Integer | 2 | View | |
PANUMCO | PA Number of Change Order |
Integer | 2 | View | |
PACOBASEPROJAMT | PA CO Baseline Project Amount |
Currency | 10 | View | |
PACOBSLNFEEPROJAMT | PA CO Baseline Fee Project Amount |
Currency | 10 | View | |
PAUNPRRTOTPROJAMT | PA Unapproved Total Project Amount |
Currency | 10 | View | |
PAUNABSTOTBILL | PA Unapproved Baseline Total Billings |
Currency | 10 | View | |
PAUNPBSTOTCST | PA Unapproved Baseline Total Cost |
Currency | 10 | View | |
PAUNPBSLTOTPROF | PA Unapproved Baseline Total Profit |
Currency | 10 | View | |
PAUNPBSTOTQTY | PA Unapproved Baseline Total Qty |
Currency | 10 | View | |
PAUNAPFRTOTBILL | PA Unapproved Forecast Total Billings |
Currency | 10 | View | |
PAUNAPPFRTOTCST | PA Unapproved Forecast Total Cost |
Currency | 10 | View | |
PAUNFRCTOTPROF | PA Unapproved Forecast Total Profit |
Currency | 10 | View | |
PAUNPFRTOTQTY | PA Unapproved Forecast Total Qty |
Currency | 10 | View | |
PAPostedQty | PA Actual Qty |
Currency | 10 | View | |
PAPostedTotalCostN | PA Actual Total Cost |
Currency | 10 | View | |
PAPosted_Overhead | PA Actual Overhead |
Currency | 10 | View | |
PAPostedProfitN | PA Actual Profit |
Currency | 10 | View | |
PAPosted_Tax_Amount | PA Actual Tax Amount |
Currency | 10 | View | |
PAPosted_Accr_RevN | PA Actual Accrued Revenues |
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 | |
PApostbillamt | PA Actual Billed Amount |
Currency | 10 | View | |
PA_Actual_Receipts_Amoun | PA Actual Receipts Amount |
Currency | 10 | View | |
PAPostedBillingsN | PA Actual Billings |
Currency | 10 | View | |
PAPostedDiscDolAmtN | PA Actual Discount Dollar Amount |
Currency | 10 | View | |
PAPosted_Sales_Tax_Amou | PA Actual Sales Tax Amount |
Currency | 10 | View | |
ActualWriteOffAmount | Actual Write Off Amount |
Currency | 10 | View | |
ActualDiscTakenAmount | Actual Discount Taken Amount |
Currency | 10 | View | |
PAPostedTaxPaidN | PA Actual Tax Paid |
Currency | 10 | View | |
PAPOSTRETAMT | PA Actual Retention Amount |
Currency | 10 | View | |
PAActualWOTaxAmt | PA Actual Write Off Tax Amount |
Currency | 10 | View | |
PAActualTermsTakenTax | PA Actual Terms Taken Tax Amt |
Currency | 10 | View | |
PAPosted_Project_Fee | PA Actual Project Fee Amount |
Currency | 10 | View | |
PAPosted_Retainer_Fee | PA Actual Retainer Fee Amount |
Currency | 10 | View | |
PAPosted_Service_Fee | PA Actual Service Fee Amount |
Currency | 10 | View | |
PAGBTRKCHG | PA GB Track Changes |
Integer | 2 | View |