Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
CUSTNMBR | Customer Number |
String | 16 | View | |
YEAR1 | Year |
Integer | 2 | View | |
PERIODID | Period ID |
Integer | 2 | View | |
PABQuantity | PA Baseline Quantity |
Currency | 10 | View | |
PABProfit | PA Baseline Profit |
Currency | 10 | View | |
PABBillings | PA Baseline Billings |
Currency | 10 | View | |
PABTaxPaidAmt | PA Baseline Tax Paid Amount |
Currency | 10 | View | |
PABTaxChargedAmt | PA Baseline Tax Charged Amount |
Currency | 10 | View | |
PABaselineOvhdCost | PA Baseline Overhead Cost |
Currency | 10 | View | |
PAFQuantity | PA Forecast Quantity |
Currency | 10 | View | |
PAFProfit | PA Forecast Profit |
Currency | 10 | View | |
PAFBillings | PA Forecast Billings |
Currency | 10 | View | |
PAFTaxPaidAmt | PA Forecast Tax Paid Amount |
Currency | 10 | View | |
PAFTaxChargedAmt | PA Forecast Tax Charged Amount |
Currency | 10 | View | |
PAForecastOvhdCost | PA Forecast Overhead Cost |
Currency | 10 | View | |
PA_Earnings | PA Earnings |
Currency | 10 | View | |
PA_Cost_of_Earnings | PA Cost of Earnings |
Currency | 10 | View | |
PAUnpostedQty | PA Unposted Qty |
Currency | 10 | View | |
PAPostedQty | PA Actual Qty |
Currency | 10 | View | |
PAUnpostedProfitN | PA Unposted Profit |
Currency | 10 | View | |
PAPostedProfitN | PA Actual Profit |
Currency | 10 | View | |
PAUnpostAccrRevN | PA Unposted Accrued Revenues |
Currency | 10 | View | |
PAPosted_Accr_RevN | PA Actual Accrued Revenues |
Currency | 10 | View | |
PAUnpostedTotalCostN | PA Unposted Total Cost |
Currency | 10 | View | |
PAPostedTotalCostN | PA Actual Total Cost |
Currency | 10 | View | |
PAUnposted_Overhead | PA Unposted Overhead |
Currency | 10 | View | |
PAPosted_Overhead | PA Actual Overhead |
Currency | 10 | View | |
PAUnpostBillN | PA Unposted Billings |
Currency | 10 | View | |
PAPostedBillingsN | PA Actual Billings |
Currency | 10 | View | |
PAUnposted_Fee_Amount | PA Unposted Fee Amount |
Currency | 10 | View | |
PAPosted_Fee_Amount | PA Actual Fee Amount |
Currency | 10 | View | |
PAUnpostedRecogRevN | PA Unposted Recognized Revenue |
Currency | 10 | View | |
PAPostRecogRevN | PA Actual Recognized Revenue |
Currency | 10 | View | |
PAUNPEIEBAMOUNT | PA Unposted EIEB Amount |
Currency | 10 | View | |
PAPOSEIEBAMOUNT | PA Actual EIEB Amount |
Currency | 10 | View | |
PAUNPOSTBIEEAMOUNT | PA Unposted BIEE Amount |
Currency | 10 | View | |
PAPOSBIEEAMOUNT | PA Actual BIEE Amount |
Currency | 10 | View | |
PAWrite_UpDown_Amount | PA Write Up/Down Amount |
Currency | 10 | View | |
PAUnposted_Retainer_Fee | PA Unposted Retainer Fee Amount |
Currency | 10 | View | |
PA_Unposted_Billed_Reten | PA Unposted Billed Retention |
Currency | 10 | View | |
PAUNPOSTRETAMT | PA Unposted Retention Amount |
Currency | 10 | View | |
PAUnposted_Service_Fee | PA Unposted Service Fee Amount |
Currency | 10 | View | |
PAUnposted_Project_Fee | PA Unposted Project Fee Amount |
Currency | 10 | View | |
PA_Actual_Billed_Retenti | PA Actual Billed Retention |
Currency | 10 | View | |
PAPosted_Project_Fee | PA Actual Project Fee Amount |
Currency | 10 | View | |
PAPosted_Retainer_Fee | PA Actual Retainer Fee Amount |
Currency | 10 | View | |
PAPOSTRETAMT | PA Actual Retention Amount |
Currency | 10 | View | |
PAPosted_Service_Fee | PA Actual Service Fee Amount |
Currency | 10 | View | |
PA_Receipts_Amount | PA Receipts Amount |
Currency | 10 | View | |
PA_Actual_Receipts_Amoun | PA Actual Receipts Amount |
Currency | 10 | View | |
PAFeeAmount | PA Fee Amount |
Currency | 10 | View | |
WROFAMNT | Write Off Amount |
Currency | 10 | View | |
ActualWriteOffAmount | Actual Write Off Amount |
Currency | 10 | View | |
DISTKNAM | Discount Taken Amount |
Currency | 10 | View | |
ActualDiscTakenAmount | Actual Discount Taken Amount |
Currency | 10 | View | |
PABTotalCost | PA Baseline Total Cost |
Currency | 10 | View | |
PAFTotalCost | PA Forecast Total Cost |
Currency | 10 | View | |
PAUnposted_Sales_Tax_Am | PA Unposted Sales Tax Amount |
Currency | 10 | View | |
PAPosted_Sales_Tax_Amou | PA Actual Sales Tax Amount |
Currency | 10 | View | |
PACostPcntCompleted | PA Cost Percent Completed |
Currency | 10 | View | |
PAQuantityPcntCompleted | PA Quantity Percent Completed |
Currency | 10 | View | |
PACommitted_Costs | PA Committed Costs |
Currency | 10 | View | |
PACommitted_Qty | PA Committed Qty |
Currency | 10 | View | |
PAPOPostedCost | PA PO Actual Cost |
Currency | 10 | View | |
PAPOPostedQty | PA PO Actual Qty |
Currency | 10 | View | |
PAPOCost | PA PO Cost |
Currency | 10 | View | |
PAPOQty | PA PO Qty |
Currency | 10 | View | |
PAUnposted_Tax_Amount | PA Unposted Tax Amount |
Currency | 10 | View | |
PAPosted_Tax_Amount | PA Actual Tax Amount |
Currency | 10 | View | |
PAtaxpaidamt | PA Tax Paid Amount |
Currency | 10 | View | |
PAPostedTaxPaidN | PA Actual Tax Paid |
Currency | 10 | View | |
PAPostedDiscDolAmtN | PA Actual Discount Dollar Amount |
Currency | 10 | View | |
PAUnpostDiscDolAmtN | PA Unposted Discount Dollar Amount |
Currency | 10 | View | |
PABilled_Accrued_Revenu | PA Billed Accrued Revenues |
Currency | 10 | View | |
PABilled_QtyN | PA Billed Qty |
Currency | 10 | View | |
PAApproved_Accrued_Reve | PA Approved Accrued Revenues |
Currency | 10 | View | |
PAApproved_Quantity | PA Approved Quantity |
Currency | 10 | View | |
PApretainage | PA Actual Retainage |
Currency | 10 | View | |
PAunpretainage | PA Unposted Retainage |
Currency | 10 | View | |
PA_Actual_Freight_Amount | PA Actual Freight Amount |
Currency | 10 | View | |
PA_Unposted_Freight_Amou | PA Unposted Freight Amount |
Currency | 10 | View | |
PA_Actual_Misc_Amount | PA Actual Misc Amount |
Currency | 10 | View | |
PA_Unposted_Misc_Amount | PA Unposted Misc Amount |
Currency | 10 | View | |
PA_Write_Off_Tax_Amount | PA Write Off Tax Amount |
Currency | 10 | View | |
PAActualWOTaxAmt | PA Actual Write Off Tax Amount |
Currency | 10 | View | |
PA_Terms_Taken_Tax_Amt | PA Terms Taken Tax Amt |
Currency | 10 | View | |
PAActualTermsTakenTax | PA Actual Terms Taken Tax Amt |
Currency | 10 | View | |
PAPosted_Earnings | PA Actual Earnings |
Currency | 10 | View | |
PAActualCostofEarnings | PA Actual Cost of Earnings |
Currency | 10 | View | |
PAUnpostedLossAmount | PA Unposted Loss Amount |
Currency | 10 | View | |
PAActualLossAmount | PA Actual Loss Amount |
Currency | 10 | View | |
PAFQLaborOnly | PA Forecast Quantity - Labor Only |
Currency | 10 | View | |
PAAQLaborOnly | PA Actual Qty - Labor Only |
Currency | 10 | View |