JCV1000 - MFGJCList | Prospr - Dynamics GP Table Reference

JCV1000 - MFGJCList

Query Builder

Select * from JCV1000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
JOBNUMBER_I	Job Num	String	32	View
Language_ID	Language ID	Integer	2	View
JOBSTATUS_I	Job Status	Integer	2	View
JOBSTATUSSTR	Job Status String	String	12	View
CUSTOMERID_I	Customer ID	String	32	View
CUSTNAME	Customer Name	String	66	View
ESTIMATEDSTARTDATE_I	Estimated Start Date Mfg	Date	4	View
ESTIMATEDENDDATE_I	Estimated End Date	Date	4	View
ACTUALSTARTDATE_I	ActualStartDate	Date	4	View
ACTUALENDDATE_I	Actual End Date	Date	4	View