PA01301 - PA Budget Master File | Prospr - Dynamics GP Table Reference

PA01301 - PA Budget Master File

Query Builder

Select * from PA01301

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
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
PAIV_Item_Checkbox	PA IV Item Checkbox	Boolean	2	View
PASTAT	PA Status 1 = Open 2 = On Hold 3 = Closed 4 = Estimate 5 = Completed	Integer	2	View
PAProfitType	PA Profit Type 1 = Billing Rate 2 = Markup 3 = Profit/Unit Fixed 4 = Profit/Unit Variable 5 = Total Profit 6 = % of Baseline 7 = % of Actual 8 = None 9 = Price Level	Integer	2	View
PAbllngtype	PA Billing Type	Integer	2	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
PAForecastBaseOvrhdAmt	PA Forecast Base Overhead Amount	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
PABBeginDate	PA Baseline Begin Date	Date	4	View
PABEndDate	PA Baseline End Date	Date	4	View
PABQuantity	PA Baseline Quantity	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
PABProfit	PA Baseline Profit	Currency	10	View
PABProfitAmt	PA Baseline Profit Amount	Currency	10	View
PABProfitPcnt	PA Baseline Profit Percent	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
PABaselinePTaxOptions	PA Baseline Purchase Tax Options 1 – Taxable 2 – Nontaxable 3 – Based on vendor	Integer	2	View
PABaselineCTaxSchedID	PA Baseline Cost Tax Schedule ID	String	16	View
PABaselineSTaxOptions	PA Baseline Sales Tax Options 1 – Taxable 2 – Nontaxable 3 – Based on vendor	Integer	2	View
PABaselineBTaxSchedID	PA Baseline Billing Tax Schedule ID	String	16	View
PAACTUALBEGDATE	PA Actual Begin Date	Date	4	View
PA_Actual_End_Date	PA Actual End Date	Date	4	View
PAFBeginDate	PA Forecast Begin Date	Date	4	View
PAFEndDate	PA Forecast End Date	Date	4	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
PAFProfit	PA Forecast Profit	Currency	10	View
PAFTaxPaidAmt	PA Forecast Tax Paid Amount	Currency	10	View
PAFTaxChargedAmt	PA Forecast Tax Charged Amount	Currency	10	View
PAFProfitAmt	PA Forecast Profit Amount	Currency	10	View
PAFProfitPcnt	PA Forecast Profit Percent	Currency	10	View
PAForecastOvhdCost	PA Forecast Overhead Cost	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
PAUnit_of_Measure	PA Unit of Measure	String	10	View
UOMSCHDL	U Of M Schedule	String	12	View
PAUOfMMult	PA UOfM Multiplier	Currency	10	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
PAPay_Code_Hourly	PA Pay Code Hourly	String	8	View
PAPay_Code_Salary	PA Pay Code Salary	String	8	View
DECPLCUR	Decimal Places Currency	Integer	2	View
PALabor_Rate_Table_ID	PA Labor Rate Table ID	String	32	View
PALabor_RateTable_Type	PA Labor Rate Table Type	Integer	2	View
PALabor_Rate_Table_Acc	PA Labor Rate Table Accept	Boolean	2	View
PAEquip_Rate_Table_ID	PA Equip Rate Table ID	String	32	View
PAEquip_Rate_Table_Acc	PA Equip Rate Table Accept	Boolean	2	View
TM_WIP_SRC	TM WIP SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category 6 –Trx Owner 7 – Specific	Integer	2	View
TM_COGS_SRC	TM COGS SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category 6 –Trx Owner 7 – Specific	Integer	2	View
TM_Cost_Contra_SRC	TM Cost Contra SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category 6 –Trx Owner 7 – Specific	Integer	2	View
TM_Unbilled_AR_SRC	TM Unbilled AR SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category 6 –Trx Owner 7 – Specific	Integer	2	View
TM_Unbilled_Rev_SRC	TM Unbilled Rev SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category 6 –Trx Owner 7 – Specific	Integer	2	View
TM_AR_SRC	TM AR SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category 6 –Trx Owner 7 – Specific	Integer	2	View
TM_Prj_Rev_SRC	TM Prj Rev SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category 6 –Trx Owner 7 – Specific	Integer	2	View
TM_OVHD_SRC	TM OVHD SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category 6 –Trx Owner 7 – Specific	Integer	2	View
FF_WIP_SRC	FF WIP SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category	Integer	2	View
FF_Cost_Contra_SRC	FF Cost Contra SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category	Integer	2	View
FF_AR_SRC	FF AR SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category	Integer	2	View
FF_Prj_Billings_SRC	FF Prj Billings SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category	Integer	2	View
FF_Prj_Expense_SRC	FF Prj Expense SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category	Integer	2	View
FF_Prj_Revenue_SRC	FF Prj Revenue SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category	Integer	2	View
FF_Prj_Loss_SRC	FF Prj Loss SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category	Integer	2	View
FF_BIEE_SRC	FF BIEE SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category	Integer	2	View
FF_EIEB_SRC	FF EIEB SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category	Integer	2	View
FF_OVHD_SRC	FF OVHD SRC 1 – None 2 – Customer 3 – Contract 4 – Project 5 – Cost Category	Integer	2	View
PAProject_Amount	PA Project Amount	Currency	10	View
PAOverheadRateMethod	PA Overhead Rate Method	Integer	2	View
PABaselineOvhdAmtPerUnit	PA Baseline Overhead Amount Per Unit	Currency	10	View
PABaselineOvrhdPct	PA Baseline Overhead Percentage	Currency	10	View
PAForecastOvrhdAmtPerUnt	PA Forecast Overhead Amount Per Unit	Currency	10	View
PAForecastOvrhdPct	PA Forecast Overhead Percentage	Currency	10	View
PAUBeginDate	PA Unposted Begin Date	Date	4	View
PAUEndDate	PA Unposted End Date	Date	4	View
PAUnpostedQty	PA Unposted Qty	Currency	10	View
PAUnpostedTotalCostN	PA Unposted Total Cost	Currency	10	View
PAUnposted_Overhead	PA Unposted Overhead	Currency	10	View
PAUnpostedProfitN	PA Unposted Profit	Currency	10	View
PAUnposted_Tax_Amount	PA Unposted Tax Amount	Currency	10	View
PAUnpostAccrRevN	PA Unposted Accrued Revenues	Currency	10	View
PAUnpostedCommitedQty	PA Unposted Commited Qty	Currency	10	View
PAUnpostedCommitedCost	PA Unposted Commited Cost	Currency	10	View
PAUnpostedCommitedTaxAmt	PA Unposted Commited Tax Amount	Currency	10	View
PAUNPOSTBIEEAMOUNT	PA Unposted BIEE Amount	Currency	10	View
PAUNPEIEBAMOUNT	PA Unposted EIEB Amount	Currency	10	View
PAunpostbillamt	PA Unposted Billed Amount	Currency	10	View
PAPostedQty	PA Actual Qty	Currency	10	View
PAPostedTotalCostN	PA Actual Total Cost	Currency	10	View
PAPosted_Overhead	PA Actual Overhead	Currency	10	View
PAPostedProfitN	PA Actual Profit	Currency	10	View
PAPosted_Tax_Amount	PA Actual Tax Amount	Currency	10	View
PAPosted_Accr_RevN	PA Actual Accrued Revenues	Currency	10	View
PAPostedCommitedQty	PA Actual Commited Qty	Currency	10	View
PAPostedCommitedCost	PA Actual Commited Cost	Currency	10	View
PAPostedCommitedTaxAmt	PA Actual Commited Tax Amount	Currency	10	View
PAPostRecogRevN	PA Actual Recognized Revenue	Currency	10	View
PAPOSBIEEAMOUNT	PA Actual BIEE Amount	Currency	10	View
PAPOSEIEBAMOUNT	PA Actual EIEB Amount	Currency	10	View
PApostbillamt	PA Actual Billed Amount	Currency	10	View
PAWrite_UpDown_Amount	PA Write Up/Down Amount	Currency	10	View
PABilled_QtyN	PA Billed Qty	Currency	10	View
PABilled_Cost	PA Billed Cost	Currency	10	View
PABilled_Accrued_Revenu	PA Billed Accrued Revenues	Currency	10	View
PACostPcntCompleted	PA Cost Percent Completed	Currency	10	View
PAQuantityPcntCompleted	PA Quantity Percent Completed	Currency	10	View
PA_Receipts_Amount	PA Receipts Amount	Currency	10	View
PA_Actual_Receipts_Amoun	PA Actual Receipts Amount	Currency	10	View
PA_Earnings	PA Earnings	Currency	10	View
PA_Cost_of_Earnings	PA Cost of Earnings	Currency	10	View
PAUnpostBillN	PA Unposted Billings	Currency	10	View
PAUnpostDiscDolAmtN	PA Unposted Discount Dollar Amount	Currency	10	View
PAUnposted_Sales_Tax_Am	PA Unposted Sales Tax Amount	Currency	10	View
PAPostedBillingsN	PA Actual Billings	Currency	10	View
PAPostedDiscDolAmtN	PA Actual Discount Dollar Amount	Currency	10	View
PAPosted_Sales_Tax_Amou	PA Actual Sales Tax Amount	Currency	10	View
PABCWPAMT	PA BCWP Amount	Currency	10	View
PABCWSAMT	PA BCWS Amount	Currency	10	View
PAACWPAMT	PA ACWP Amount	Currency	10	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
PALineItemSeq	PA Line Item Sequence	Long Integer	4	View
PAbillnoteidx	PA Billing Note Index	Currency	10	View
PAUnpostedRecogRevN	PA Unposted Recognized Revenue	Currency	10	View
PAApproved_Accrued_Reve	PA Approved Accrued Revenues	Currency	10	View
PAApproved_Cost	PA Approved Cost	Currency	10	View
PAApproved_Quantity	PA Approved Quantity	Currency	10	View
PACommitted_Costs	PA Committed Costs	Currency	10	View
PACommitted_Qty	PA Committed Qty	Currency	10	View
PAPOQty	PA PO Qty	Currency	10	View
PAPOCost	PA PO Cost	Currency	10	View
PAPOPostedQty	PA PO Actual Qty	Currency	10	View
PAPOPostedCost	PA PO Actual Cost	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
PAsfid	PA Source File ID	Integer	2	View
PAPreviouslyOpen	PA Previously Open	Boolean	2	View
PAtaxpaidamt	PA Tax Paid Amount	Currency	10	View
PAPostedTaxPaidN	PA Actual Tax Paid	Currency	10	View
PAPOSTRETAMT	PA Actual Retention Amount	Currency	10	View
PAUNPOSTRETAMT	PA Unposted Retention 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
PACHGORDNO	PA Change Order Number	String	18	View
PAUNAPPRVPROJAMT	PA Unapproved Project Amount	Currency	10	View
PAUNAPFRTOTBILL	PA Unapproved Forecast Total Billings	Currency	10	View
PAUNAPPFRTOTCST	PA Unapproved Forecast Total Cost	Currency	10	View
PAUNFRCTOTPROF	PA Unapproved Forecast Total Profit	Currency	10	View
PAUNPFRTOTQTY	PA Unapproved Forecast Total Qty	Currency	10	View
PAUNABSTOTBILL	PA Unapproved Baseline Total Billings	Currency	10	View
PAUNPBSTOTCST	PA Unapproved Baseline Total Cost	Currency	10	View
PAUNPBSLTOTPROF	PA Unapproved Baseline Total Profit	Currency	10	View
PAUNPBSTOTQTY	PA Unapproved Baseline Total Qty	Currency	10	View
PATOTCHGORDAMT	PA Total Change Order Amount	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
PAMCCURNCYID	PA MC Currency ID	String	16	View
PAMCBProfitAmt	PA MC Baseline Profit Amt	Currency	10	View
PAMCBBillings	PA MC Baseline Billings	Currency	10	View
PAMCFProfitAmt	PA MC Forecast Profit Amt	Currency	10	View
PAMCFBillings	PA MC Forecast Billings	Currency	10	View
PAMCBaseProfitAmount	PA MC Base Profit Amount	Currency	10	View
PAMCForecastBProfitAmt	PA MC Forecast Base Profit Amount	Currency	10	View
PAMCProjectAmount	PA MC Project Amount	Currency	10	View
PAMCActualBillings	PA MC Actual Billings	Currency	10	View
PAMCActualDiscountAmt	PA MC Actual Discount Amt	Currency	10	View
PAMCActualSalesTaxAmt	PA MC Actual Sales Tax Amt	Currency	10	View
PAMCUnpostBillN	PA MC Unposted Billings	Currency	10	View
PAMCUnpostedDiscount	PA MC Unposted Discount Amt	Currency	10	View
PAMCUnpostedSalesTax	PA MC Unposted Sales Tax Amt	Currency	10	View
PABILLMIN	paBillMinimum	Currency	10	View
PAMCBILLMIN	paMCBillMinimum	Currency	10	View

PA01301 - PA Budget Master File

Query Builder

Customer Service

Information

My Account

Contact Us