PA01200 - PA_ProjectListView | Prospr - Dynamics GP Table Reference

PA01200 - PA_ProjectListView

Select * from PA01200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
PACONTNUMBER	PA Contract Number	String	12	View
PAprojid	PA Project ID	String	16	View
PAPROJNUMBER	PA Project Number	String	16	View
PAprojname	PA Project Name	String	32	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
PASegmentCB	PA Segment CB	Boolean	2	View
PAprojmngrid	PA Project Manager ID	String	16	View
PAProject_Amount	PA Project Amount	Currency	10	View
CUSTNAME	Customer Name	String	66	View