| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| PAPROJNUMBER | PA Project Number |
String | 16 | View | |
| PACOSTCATID | PA Cost Category ID |
String | 16 | View | |
| ITEMNMBR | Item Number |
String | 32 | View | |
| PABase_Qty | PA Base Qty |
Currency | 10 | View | |
| PABase_Unit_Cost | PA Base Unit Cost |
Currency | 10 | View | |
| PABaseProfitAmount | PA Base Profit Amount |
Currency | 10 | View | |
| PABaseOvhdCost | PA Base Overhead Cost |
Currency | 10 | View | |
| PABQuantity | PA Baseline Quantity |
Currency | 10 | View | |
| PAForecastBaseQty | PA Forecast Base Qty |
Currency | 10 | View | |
| PAForecastBaseUnitCost | PA Forecast Base Unit Cost |
Currency | 10 | View | |
| PAForecastBaseProfitAmt | PA Forecast Base Profit Amount |
Currency | 10 | View | |
| PABUnitCost | PA Baseline Unit Cost |
Currency | 10 | View | |
| PABTotalCost | PA Baseline Total Cost |
Currency | 10 | View | |
| PABBillings | PA Baseline Billings |
Currency | 10 | View | |
| PABProfitAmt | PA Baseline Profit Amount |
Currency | 10 | View | |
| PABaselineOvhdCost | PA Baseline Overhead Cost |
Currency | 10 | View | |
| PABTaxPaidAmt | PA Baseline Tax Paid Amount |
Currency | 10 | View | |
| PABTaxChargedAmt | PA Baseline Tax Charged Amount |
Currency | 10 | View | |
| PABaselinePTaxOptions | PA Baseline Purchase Tax Options 1 – Taxable |
Integer | 2 | View | |
| PABaselineCTaxSchedID | PA Baseline Cost Tax Schedule ID |
String | 16 | View | |
| PABaselineSTaxOptions | PA Baseline Sales Tax Options 1 – Taxable |
Integer | 2 | View | |
| PABaselineBTaxSchedID | PA Baseline Billing Tax Schedule ID |
String | 16 | View | |
| PAFQuantity | PA Forecast Quantity |
Currency | 10 | View | |
| PAFUnitCost | PA Forecast Unit Cost |
Currency | 10 | View | |
| PAFTotalCost | PA Forecast Total Cost |
Currency | 10 | View | |
| PAFBillings | PA Forecast Billings |
Currency | 10 | View | |
| PAFProfitAmt | PA Forecast Profit Amount |
Currency | 10 | View | |
| PAForecastOvhdCost | PA Forecast Overhead Cost |
Currency | 10 | View | |
| PAFTaxPaidAmt | PA Forecast Tax Paid Amount |
Currency | 10 | View | |
| PAFTaxChargedAmt | PA Forecast Tax Charged Amount |
Currency | 10 | View | |
| PAForecastPTaxOptions | PA Forecast Purchase Tax Options |
Integer | 2 | View | |
| PAForecastCTaxSchedID | PA Forecast Cost Tax Schedule ID |
String | 16 | View | |
| PAForecastSTaxOptions | PA Forecast Sales Tax Options |
Integer | 2 | View | |
| PAForecastBTaxSchedID | PA Forecast Billing Tax Schedule ID |
String | 16 | View | |
| UOFM | U Of M |
String | 10 | View | |
| UOMSCHDL | U Of M Schedule |
String | 12 | View | |
| PRICELVL | Price Level |
String | 16 | View | |
| PAUOfMMult | PA UOfM Multiplier |
Currency | 10 | View | |
| PAbllngtype | PA Billing Type |
Integer | 2 | View | |
| PAbillnoteidx | PA Billing Note Index |
Currency | 10 | View | |
| DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
| DECPLQTY | Decimal Places QTYS |
Integer | 2 | View | |
| PAPostedQty | PA Actual Qty |
Currency | 10 | View | |
| PApstdcosts | PA Actual Costs |
Currency | 10 | View | |
| PAPosted_Accr_RevN | PA Actual Accrued Revenues |
Currency | 10 | View | |
| PAPosted_Return_QTY | PA Actual Return QTY |
Currency | 10 | View | |
| PAPosted_Return_Costs | PA Actual Return Costs |
Currency | 10 | View | |
| PAActualReturnAccrRev | PA Actual Return Accrued Revenue |
Currency | 10 | View | |
| PAunpcosts | PA Unposted Costs |
Currency | 10 | View | |
| PAUnpQty | PA Unposted QTY |
Currency | 10 | View | |
| PAUnpostAccrRevN | PA Unposted Accrued Revenues |
Currency | 10 | View | |
| PAUnposted_Return_QTY | PA Unposted Return QTY |
Currency | 10 | View | |
| PAUnposted_Return_Cost | PA Unposted Return Costs |
Currency | 10 | View | |
| PAUnpostedReturnAccrRev | PA Unposted Return Accrued Revenue |
Currency | 10 | View | |
| PAPOCost | PA PO Cost |
Currency | 10 | View | |
| PAPOQty | PA PO Qty |
Currency | 10 | View | |
| PACommitted_Costs | PA Committed Costs |
Currency | 10 | View | |
| PACommitted_Qty | PA Committed Qty |
Currency | 10 | View | |
| PAPOPostedQty | PA PO Actual Qty |
Currency | 10 | View | |
| PAPOPostedCost | PA PO Actual Cost |
Currency | 10 | View | |
| REQDATE | Required Date |
Date | 4 | View | |
| PALineItemSeq | PA Line Item Sequence |
Long Integer | 4 | View | |
| PAPostedBillingsN | PA Actual Billings |
Currency | 10 | View | |
| PAUnposted_Tax_Amount | PA Unposted Tax Amount |
Currency | 10 | View | |
| PAPosted_Tax_Amount | PA Actual Tax Amount |
Currency | 10 | View | |
| PACHGORDNO | PA Change Order Number |
String | 18 | View |