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 |