PA40201 - PA Budget Template File | Prospr - Dynamics GP Table Reference

PA40201 - PA Budget Template File

Query Builder

Select * from PA40201

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
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
PACOSTCATID	PA Cost Category ID	String	16	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
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
PAForecastBaseQty	PA Forecast Base Qty	Currency	10	View
PAForecastBaseUnitCost	PA Forecast Base Unit Cost	Currency	10	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
PAFProfitAmt	PA Forecast Profit Amount	Currency	10	View
PAFProfitPcnt	PA Forecast Profit Percent	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
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
PAcostaxscheduleid	PA Cost Tax Schedule ID	String	16	View
PAPurchase_Tax_Options	PA Purchase Tax Options	Integer	2	View
PAbilltaxscheduleid	PA Billing Tax Schedule ID	String	16	View
PASales_Tax_Options	PA Sales Tax Options	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
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

PA40201 - PA Budget Template File

Query Builder

Customer Service

Information

My Account

Contact Us