PA41701 - PA Project Budget Setup | Prospr - Dynamics GP Table Reference

PA41701 - PA Project Budget Setup

Query Builder

Select * from PA41701

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PAsetupkey	PA Setup Key	Integer	2	View
PAcontractdefined1	PA User Defined Prompt 1 - Contract	String	16	View
PAcontractdefined2	PA User Defined Prompt 2 - Contract	String	16	View
PAcostcatdefined1	PA User Defined Prompt 1 - Cost Cat	String	16	View
PAcostcatdefined2	PA User Defined Prompt 2 - Cost Cat	String	16	View
PAcustomerdefined1	PA User Defined Prompt 1 - Customer	String	16	View
PAcustomerdefined2	PA User Defined Prompt 2 - Customer	String	16	View
PAemployeedefined1	PA User Defined Prompt 1 - Employee	String	16	View
PAemployeedefined2	PA User Defined Prompt 2 - Employee	String	16	View
PAvendordefinedprompt1	PA User Defined Prompt 1 - Vendor	String	16	View
PAvendordefinedprompt2	PA User Defined Prompt 2 - Vendor	String	16	View
PAMISCdefined1	PA User Defined Prompt 1 - Miscellaneous	String	16	View
PAMISCLdefined2	PA User Defined Prompt 2 - Miscellaneous	String	16	View
PAprojectdefined1	PA User Defined Prompt 1 - Project	String	16	View
PAprojectdefined2	PA User Defined Prompt 2 - Project	String	16	View
PAEQUIPTdefined1	PA User Defined Prompt 1 - Equipment	String	16	View
PAEQUIPTdefined2	PA User Defined Prompt 2 - Equipment	String	16	View
PAUserDefinedPrompt1Fee	PA User Defined Prompt 1 - Fee	String	16	View
PAUserDefinedPrompt2Fee	PA User Defined Prompt 2 - Fee	String	16	View
PAcontractstatus_1	PA Contract Status[1]	String	14	View
PAcontractstatus_2	PA Contract Status[2]	String	14	View
PAcontractstatus_3	PA Contract Status[3]	String	14	View
PAcontractstatus_4	PA Contract Status[4]	String	14	View
PAcontractstatus_5	PA Contract Status[5]	String	14	View
PAcontractstatus_6	PA Contract Status[6]	String	14	View
PAcontractstatus_7	PA Contract Status[7]	String	14	View
PAcontractstatus_8	PA Contract Status[8]	String	14	View
PAcontractstatus_9	PA Contract Status[9]	String	14	View
PAcontractstatus_10	PA Contract Status[10]	String	14	View
PACONTSTATCB_1	PA Contract Status CB[1]	Boolean	2	View
PACONTSTATCB_2	PA Contract Status CB[2]	Boolean	2	View
PACONTSTATCB_3	PA Contract Status CB[3]	Boolean	2	View
PACONTSTATCB_4	PA Contract Status CB[4]	Boolean	2	View
PACONTSTATCB_5	PA Contract Status CB[5]	Boolean	2	View
PACONTSTATCB_6	PA Contract Status CB[6]	Boolean	2	View
PACONTSTATCB_7	PA Contract Status CB[7]	Boolean	2	View
PACONTSTATCB_8	PA Contract Status CB[8]	Boolean	2	View
PACONTSTATCB_9	PA Contract Status CB[9]	Boolean	2	View
PACONTSTATCB_10	PA Contract Status CB[10]	Boolean	2	View
PAprojectstatus_1	PA Project Status[1]	String	14	View
PAprojectstatus_2	PA Project Status[2]	String	14	View
PAprojectstatus_3	PA Project Status[3]	String	14	View
PAprojectstatus_4	PA Project Status[4]	String	14	View
PAprojectstatus_5	PA Project Status[5]	String	14	View
PAprojectstatus_6	PA Project Status[6]	String	14	View
PAprojectstatus_7	PA Project Status[7]	String	14	View
PAprojectstatus_8	PA Project Status[8]	String	14	View
PAprojectstatus_9	PA Project Status[9]	String	14	View
PAprojectstatus_10	PA Project Status[10]	String	14	View
PAPORJSTATCB_1	PA Project Status CB[1]	Boolean	2	View
PAPORJSTATCB_2	PA Project Status CB[2]	Boolean	2	View
PAPORJSTATCB_3	PA Project Status CB[3]	Boolean	2	View
PAPORJSTATCB_4	PA Project Status CB[4]	Boolean	2	View
PAPORJSTATCB_5	PA Project Status CB[5]	Boolean	2	View
PAPORJSTATCB_6	PA Project Status CB[6]	Boolean	2	View
PAPORJSTATCB_7	PA Project Status CB[7]	Boolean	2	View
PAPORJSTATCB_8	PA Project Status CB[8]	Boolean	2	View
PAPORJSTATCB_9	PA Project Status CB[9]	Boolean	2	View
PAPORJSTATCB_10	PA Project Status CB[10]	Boolean	2	View
PAUsePayCodes	PA Use PayCodes	Boolean	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	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
TM_Prj_Deferred_Rev_Fee_	TM Prj Deferred Rev Fee SRC	Integer	2	View
TM_Prj_Rev_Fee_SRC	TM Prj Rev Fee SRC	Integer	2	View
TM_AR_Fee_SRC	TM AR Fee SRC	Integer	2	View
TM_BIEE_Fee_SRC	TM BIEE Fee SRC	Integer	2	View
TM_EIEB_Fee_SRC	TM EIEB Fee SRC	Integer	2	View
FF_WIP_Fee_SRC	FF WIP Fee SRC	Integer	2	View
FF_Prj_Billings_Fee_SRC	FF Prj Billings Fee SRC	Integer	2	View
PAFF_AR_Fee_SRC	FF AR Fee SRC	Integer	2	View
FF_Prj_Rev_Fee_SRC	FF Prj Rev Fee SRC	Integer	2	View
FF_Retention_Fee_SRC	FF Retention Fee SRC	Integer	2	View
FF_Prj_Deferred_Rev_Fee_	FF Prj Deferred Rev Fee SRC	Integer	2	View
FF_BIEE_Fee_SRC	FF BIEE Fee SRC	Integer	2	View
FF_EIEB_Fee_SRC	FF EIEB Fee SRC	Integer	2	View
PAINCPRCHTXPRJCST	PA Incl Purch Tax Proj Cost	Boolean	2	View
PATRKCHGORDS	PA Track Change Orders	Boolean	2	View
PATRKCOBDGADDFLY	PA Track CO for Budgets Add on fly	Boolean	2	View
PAallow_1	PA Allow Options[1]	Boolean	2	View
PAallow_2	PA Allow Options[2]	Boolean	2	View
PAallow_3	PA Allow Options[3]	Boolean	2	View
PAallow_4	PA Allow Options[4]	Boolean	2	View
PAallow_5	PA Allow Options[5]	Boolean	2	View
PAallow_6	PA Allow Options[6]	Boolean	2	View
PAallow_7	PA Allow Options[7]	Boolean	2	View
PAallow_8	PA Allow Options[8]	Boolean	2	View
PAallow_9	PA Allow Options[9]	Boolean	2	View
PAallow_10	PA Allow Options[10]	Boolean	2	View
PAallow_11	PA Allow Options[11]	Boolean	2	View
PAallow_12	PA Allow Options[12]	Boolean	2	View
PAallow_13	PA Allow Options[13]	Boolean	2	View
PApasswordoptions_1	PA Password Options[1]	String	12	View
PApasswordoptions_2	PA Password Options[2]	String	12	View
PApasswordoptions_3	PA Password Options[3]	String	12	View
PApasswordoptions_4	PA Password Options[4]	String	12	View
PApasswordoptions_5	PA Password Options[5]	String	12	View
PApasswordoptions_6	PA Password Options[6]	String	12	View
PApasswordoptions_7	PA Password Options[7]	String	12	View
PApasswordoptions_8	PA Password Options[8]	String	12	View
PApasswordoptions_9	PA Password Options[9]	String	12	View
PApasswordoptions_10	PA Password Options[10]	String	12	View
PApasswordoptions_11	PA Password Options[11]	String	12	View
PApasswordoptions_12	PA Password Options[12]	String	12	View
PApasswordoptions_13	PA Password Options[13]	String	12	View
PAdexcriptionoptions_1	PA Description Options[1]	String	52	View
PAdexcriptionoptions_2	PA Description Options[2]	String	52	View
PAdexcriptionoptions_3	PA Description Options[3]	String	52	View
PAdexcriptionoptions_4	PA Description Options[4]	String	52	View
PAdexcriptionoptions_5	PA Description Options[5]	String	52	View
PAdexcriptionoptions_6	PA Description Options[6]	String	52	View
PAdexcriptionoptions_7	PA Description Options[7]	String	52	View
PAdexcriptionoptions_8	PA Description Options[8]	String	52	View
PAdexcriptionoptions_9	PA Description Options[9]	String	52	View
PAdexcriptionoptions_10	PA Description Options[10]	String	52	View
PAdexcriptionoptions_11	PA Description Options[11]	String	52	View
PAdexcriptionoptions_12	PA Description Options[12]	String	52	View
PAdexcriptionoptions_13	PA Description Options[13]	String	52	View

PA41701 - PA Project Budget Setup

Query Builder

Customer Service

Information

My Account

Contact Us