| Column | Description | Data Type | Length | Tables This Field Is In | In Query () | 
| PACONTNUMBER | PA Contract Number  | 
									String | 12 | View | |
| PACHGORDNO | PA Change Order Number  | 
									String | 18 | View | |
| PACOTRKCHGBY | PA CO Track Changes By  | 
									Integer | 2 | View | |
| LNITMSEQ | Line Item Sequence  | 
									Long Integer | 4 | View | |
| PAPROJNUMBER | PA Project Number  | 
									String | 16 | View | |
| PATU | PA Transaction Usage 1 = Timesheet  | 
									Integer | 2 | View | |
| PACOSTCATID | PA Cost Category ID  | 
									String | 16 | View | |
| PALineItemSeq | PA Line Item Sequence  | 
									Long Integer | 4 | View | |
| PAUnit_of_Measure | PA Unit of Measure  | 
									String | 10 | View | |
| UOMSCHDL | U Of M Schedule  | 
									String | 12 | View | |
| PAPREVBEGINDT | PA Prev Begin Date  | 
									Date | 4 | View | |
| PAbegindate | PA Begin Date  | 
									Date | 4 | View | |
| PAPREVENDDT | PA Prev End Date  | 
									Date | 4 | View | |
| PAEnDate | PA End Date  | 
									Date | 4 | View | |
| PAPREVPYCDESLY | PA Prev Pay Code Salary  | 
									String | 8 | View | |
| PAPay_Code_Salary | PA Pay Code Salary  | 
									String | 8 | View | |
| PAPREVPYCODEHOURLY | PA Prev Pay Code Hourly  | 
									String | 8 | View | |
| PAPay_Code_Hourly | PA Pay Code Hourly  | 
									String | 8 | View | |
| PAProfitType | PA Profit Type 1 = Billing Rate  | 
									Integer | 2 | View | |
| PAbllngtype | PA Billing Type  | 
									Integer | 2 | View | |
| PAPREVPURCHTXOPT | PA Prev Purchase Tax Options  | 
									Integer | 2 | View | |
| PAPurchase_Tax_Options | PA Purchase Tax Options  | 
									Integer | 2 | View | |
| PAPREVCOSTXSCHED | PA Prev Cost Tax Schedule ID  | 
									String | 16 | View | |
| PAPURCHTAXSCHED | PA Purchase Tax Schedule ID  | 
									String | 16 | View | |
| DECPLQTY | Decimal Places QTYS  | 
									Integer | 2 | View | |
| DECPLCUR | Decimal Places Currency  | 
									Integer | 2 | View | |
| PAPREVSALESTXOPT | PA Prev Sales Tax Options  | 
									Integer | 2 | View | |
| PASales_Tax_Options | PA Sales Tax Options  | 
									Integer | 2 | View | |
| PAPREVBILLTXSCHED | PA Prev Billing Tax Schedule ID  | 
									String | 16 | View | |
| PAbilltaxscheduleid | PA Billing Tax Schedule ID  | 
									String | 16 | View | |
| PAVarianceQty | PA Variance Qty  | 
									Currency | 10 | View | |
| PAQtyQ | PA Quantity  | 
									Currency | 10 | View | |
| PAPREVQTY | PA Prev Quantity  | 
									Currency | 10 | View | |
| PAVarianceCosts | PA Variance Costs  | 
									Currency | 10 | View | |
| PAUNITCOST | PA Unit Cost  | 
									Currency | 10 | View | |
| PAPREVUNITCOST | PA Prev Unit Cost  | 
									Currency | 10 | View | |
| PAVARTOTCOST | PA Variance Total Cost  | 
									Currency | 10 | View | |
| PAVAROVERHDAMT | PA Variance Total Overhead Amount  | 
									Currency | 10 | View | |
| PATOTALOVERH | PA Total Overhead  | 
									Currency | 10 | View | |
| PAVAROVERHDPRCNT | PA Variance Overhead Percent  | 
									Currency | 10 | View | |
| PAOverheaPercentage | PA Overhead Percentage  | 
									Currency | 10 | View | |
| PAPREVOVRHDPRCNT | PA Prev Overhead Percentage  | 
									Currency | 10 | View | |
| PAPREVTOTOVEHD | PA Prev Total Overhead  | 
									Currency | 10 | View | |
| PAVAROVRHDUNIT | PA Variance Overhead Per Unit  | 
									Currency | 10 | View | |
| PAOvhdAmtPerUnit | PA Overhead Amount Per Unit  | 
									Currency | 10 | View | |
| PAPREVOVEHDUNIT | PA Prev Overhead Amount Per Unit  | 
									Currency | 10 | View | |
| PATOTCST | PA Total Cost  | 
									Currency | 10 | View | |
| PAPREVTOTCOST | PA Prev Total Cost  | 
									Currency | 10 | View | |
| PAVARMUPRCNT | PA Variance Markup Percentage  | 
									Currency | 10 | View | |
| PAProfitPercent | PA Profit Percent  | 
									Currency | 10 | View | |
| PAPREVPROFPRCNT | PA Prev Profit Percent  | 
									Currency | 10 | View | |
| PAVARPROFAMT | PA Variance Profit Amount  | 
									Currency | 10 | View | |
| PAProfitAmount | PA Profit Amount  | 
									Currency | 10 | View | |
| PAPRVPROFITAMT | PA Prev Profit Amount  | 
									Currency | 10 | View | |
| PAVARTOTLPROF | PA Variance Total Profit  | 
									Currency | 10 | View | |
| PATotalProfit | PA Total Profit  | 
									Currency | 10 | View | |
| PAPREVTOTPROF | PA Prev Total Profit  | 
									Currency | 10 | View | |
| PAVARTOTBILLINGS | PA Variance Total Billings  | 
									Currency | 10 | View | |
| PAtotbillings | PA Total Billings  | 
									Currency | 10 | View | |
| PAPREVTOTBILL | PA Prev Total Billings  | 
									Currency | 10 | View | |
| PAORIGBUDGTAMT | PA Original Budget Amount  | 
									Currency | 10 | View | |
| PAROGPROJAMT | PA Original Project Amount  | 
									Currency | 10 | View | |
| PAProject_Amount | PA Project Amount  | 
									Currency | 10 | View | |
| PAPREVPROJAMT | PA Prev Project Amount  | 
									Currency | 10 | View | |
| PAVARPROJAMT | PA Variance Project Amount  | 
									Currency | 10 | View | |
| PAPREVBASEQTY | PA Prev Base Qty  | 
									Currency | 10 | View | |
| PABase_Qty | PA Base Qty  | 
									Currency | 10 | View | |
| PAPREVBSEUNTCST | PA Prev Base Unit Cost  | 
									Currency | 10 | View | |
| PABase_Unit_Cost | PA Base Unit Cost  | 
									Currency | 10 | View | |
| PAPREVBSOVERHDCST | PA Prev Base Overhead Cost  | 
									Currency | 10 | View | |
| PABaseOvhdCost | PA Base Overhead Cost  | 
									Currency | 10 | View | |
| PAPREVBSPROFAMT | PA Prev Base Profit Amount  | 
									Currency | 10 | View | |
| PABaseProfitAmount | PA Base Profit Amount  | 
									Currency | 10 | View | |
| PAPROPQUOTEAMT | PA Propose Quote Amount  | 
									Currency | 10 | View | |
| PAFINQUOTEAMT | PA Final Quote Amount  | 
									Currency | 10 | View | |
| PAQUOTEPREPBY | PA Quote Prepared By  | 
									String | 22 | View | |
| PAQUOTEAPPRVBY | PA Quote Approved By  | 
									String | 22 | View | |
| PAREVBUDGTAMT | PA Revise Budget Amount  | 
									Currency | 10 | View | |
| PAREVPROJAMT | PA Revise Project Amount  | 
									Currency | 10 | View | |
| PAsequencenumber | PA Sequence Number 1  | 
									Integer | 2 | View | |
| APPRVLDT | Approval Date  | 
									Date | 4 | View | |
| PAClose_CB | PA Close CB  | 
									Boolean | 2 | 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 |