| 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 |