PA41701A - PA Project Source Setup | Prospr - Dynamics GP Table Reference

PA41701A - PA Project Source Setup

Query Builder

Select * from PA41701A

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PAcosttrxid	PA Cost Transaction ID	String	18	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

PA41701A - PA Project Source Setup

Query Builder

Customer Service

Information

My Account

Contact Us