PA41601 - PA Project Template File | Prospr - Dynamics GP Table Reference

PA41601 - PA Project Template File

Query Builder

Select * from PA41601

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
PAPTN	PA Project Template Name	String	32	View
PAPROJNUMSEG	PA Project Number Segment	String	6	View
PAprjclsid	PA Project Class ID	String	16	View
PAProjectType	PA Project Type	Integer	2	View
PAAcctgMethod	PA Accounting Method	Integer	2	View
PASTAT	PA Status 1 = Open 2 = On Hold 3 = Closed 4 = Estimate 5 = Completed	Integer	2	View
PADepartment	PA Department	String	8	View
PABBeginDate	PA Baseline Begin Date	Date	4	View
PABEndDate	PA Baseline End Date	Date	4	View
PABQuantity	PA Baseline Quantity	Currency	10	View
PABTotalCost	PA Baseline Total Cost	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
PAFBeginDate	PA Forecast Begin Date	Date	4	View
PAFEndDate	PA Forecast End Date	Date	4	View
PAFQuantity	PA Forecast Quantity	Currency	10	View
PAFTotalCost	PA Forecast Total Cost	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
PAEstimatorID	PA Estimator ID	String	16	View
PAprojmngrid	PA Project Manager ID	String	16	View
PABusMgrID	PA Business Manager ID	String	16	View
LOCATNID	Location ID	String	16	View
COMPRCNT	Commission Percent	Integer	2	View
COMAPPTO	Commission Applied To	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
PAbllngtype	PA Billing Type	Integer	2	View
PAProject_Amount	PA Project Amount	Currency	10	View
PAProject_Fee_Amount	PA Project Fee Amount	Currency	10	View
PAService_Fee_Amount	PA Service Fee Amount	Currency	10	View
PARetainer_Fee_Amount	PA Retainer Fee Amount	Currency	10	View
PARetentionFeeAmount	PA Retention Fee Amount	Currency	10	View
ACCTAMNT	Account Amount	Currency	10	View
PABILLFORMAT	PA Bill Format	String	16	View
PADiscMetToUse	PA Discount Method To Use	Integer	2	View
DISCAMNT	Discount Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
PA_Retention_Percent	PA Retention Percent	Currency	10	View
PAtotcbts	PA Label Checkbox - TS	Boolean	2	View
PAtotcbEL	PA Label Checkbox - EL	Boolean	2	View
PAtotcbML	PA Label Checkbox - ML	Boolean	2	View
PAtotcbvi	PA Label Checkbox - VI	Boolean	2	View
PAtotcber	PA Label Checkbox - EE	Boolean	2	View
PAtotcbinv	PA Label Checkbox - INV	Boolean	2	View
PAtotcbfee	PA Label Checkbox - FEE	Boolean	2	View
PAUD1Proj	PA User Defined 1 - Project	String	52	View
PAUD2_Proj	PA User Defined 2 - Project	String	52	View
PASegmentCB	PA Segment CB	Boolean	2	View
PAbillnoteidx	PA Billing Note Index	Currency	10	View
PAbillnoteidxts	PA Billing Note Index - TS	Currency	10	View
PAELbillniteidx	PA Billing Note Index - EL	Currency	10	View
PAbillnoteidxML	PA Billing Note Index - ML	Currency	10	View
PAbillnoteidxvi	PA Billing Note Index - VI	Currency	10	View
PAbillnoteidxee	PA Billing Note Index - EE	Currency	10	View
PAbillnoteidxinv	PA Billing Note Index - INV	Currency	10	View
PAbillnoteidxfee	PA Billing Note Index - FEE	Currency	10	View
NOTEINDX	Note Index	Currency	10	View
WRKRCOMP	Workers Comp	String	8	View
SUTASTAT	Suta State	String	4	View

PA41601 - PA Project Template File

Query Builder

Customer Service

Information

My Account

Contact Us