PT00101 - Project Costing Master | Prospr - Dynamics GP Table Reference

PT00101 - Project Costing Master

Query Builder

Select * from PT00101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PROJNAME	Project Name	String	22	View
PROJDESC	Project Description	String	52	View
PROJMGR	Project Manager	String	32	View
PROJTYPE	Project Type	String	32	View
ESTSTARTDATE	Estimated Start Date	Date	4	View
ESTCOMPDATE	Estimated Completion Date	Date	4	View
ACTSTARTDATE	Actual Start Date	Date	4	View
ACTCOMPDATE	Actual Completion Date	Date	4	View
PROJSTATUS	Project Status	Integer	2	View
CLOSEDTOBILL	Closed To Billing	Boolean	2	View
CLOSEDTOCOST	Closed To Costs	Boolean	2	View
CUSTNMBR	Customer Number	String	16	View
PRBTADCD	Primary Billto Address Code	String	16	View
ADRSCODE	Address Code	String	16	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIP	Zip	String	12	View
ESTPREFER	Estimate Preference	Integer	2	View
ESTMATCOST	Estimated Material Cost	Currency	10	View
ESTLABORCOST	Estimated Labor Cost	Currency	10	View
ESTMISCCOST	Estimated Misc Cost	Currency	10	View
ESTMATREV	Estimated Material Revenue	Currency	10	View
ESTLABORREV	Estimated Labor Revenue	Currency	10	View
ESTMISCREV	Estimated Misc Revenue	Currency	10	View
ACTMATCOST	Actual Material Cost	Currency	10	View
ACTLABORCOST	Actual Labor Cost	Currency	10	View
ACTMISCCOST	Actual Misc Cost	Currency	10	View
ACTMATREV	Actual Material Revenue	Currency	10	View
ACTLABORREV	Actual Labor Revenue	Currency	10	View
ACTMISCREV	Actual Misc Revenue	Currency	10	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
CREATDDT	Created Date	Date	4	View
CRUSRID	Created User ID	String	16	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
NOTEINDX	Note Index	Currency	10	View

PT00101 - Project Costing Master

Query Builder

Customer Service

Information

My Account

Contact Us