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 |