| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| PACTID | PA Contract Template ID |
String | 16 | View | |
| PAPTID | PA Project Template ID |
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 | |
| PABUnitCost | PA Baseline Unit Cost |
Currency | 10 | View | |
| PABTotalCost | PA Baseline Total Cost |
Currency | 10 | View | |
| PABProfitAmt | PA Baseline Profit Amount |
Currency | 10 | View | |
| PABBillings | PA Baseline Billings |
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 | |
| 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 | |
| UOFM | U Of M |
String | 10 | View | |
| UOMSCHDL | U Of M Schedule |
String | 12 | View | |
| PAUOfMMult | PA UOfM Multiplier |
Currency | 10 | View | |
| PRICELVL | Price Level |
String | 16 | View | |
| PAbllngtype | PA Billing Type |
Integer | 2 | View | |
| PAbillnoteidx | PA Billing Note Index |
Currency | 10 | View | |
| PAPurchase_Tax_Options | PA Purchase Tax Options |
Integer | 2 | View | |
| PAcostaxscheduleid | PA Cost Tax Schedule ID |
String | 16 | View | |
| PASales_Tax_Options | PA Sales Tax Options |
Integer | 2 | View | |
| PAbilltaxscheduleid | PA Billing Tax Schedule ID |
String | 16 | View | |
| DECPLQTY | Decimal Places QTYS |
Integer | 2 | View | |
| DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
| PALineItemSeq | PA Line Item Sequence |
Long Integer | 4 | View | |
| REQDATE | Required Date |
Date | 4 | View |