ICJC0001 - Job Master File | Prospr - Dynamics GP Table Reference

ICJC0001 - Job Master File

Query Builder

Select * from ICJC0001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
JOBNUMBER_I	Job Num	String	32	View
JOBDESCRIPTION_I	Job Description	String	52	View
JOBSTATUS_I	Job Status	Integer	2	View
JOBONHOLD_I	Job On Hold	Boolean	2	View
JOBCANCELLED_I	Job Cancelled	Boolean	2	View
JOBCATEGORIES_I_1	Job Categories[1]	Integer	2	View
JOBCATEGORIES_I_2	Job Categories[2]	Integer	2	View
JOBCATEGORIES_I_3	Job Categories[3]	Integer	2	View
CUSTOMERID_I	Customer ID	String	32	View
CHECKLISTI	Checklist	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
CHECKBOXES_I_1	Checkboxes[1]	Boolean	2	View
CHECKBOXES_I_2	Checkboxes[2]	Boolean	2	View
CHECKBOXES_I_3	Checkboxes[3]	Boolean	2	View
CHECKBOXES_I_4	Checkboxes[4]	Boolean	2	View
CHECKBOXES_I_5	Checkboxes[5]	Boolean	2	View
STRINGS_I_1	Strings[1]	String	32	View
STRINGS_I_2	Strings[2]	String	32	View
STRINGS_I_3	Strings[3]	String	32	View
STRINGS_I_4	Strings[4]	String	32	View
STRINGS_I_5	Strings[5]	String	32	View
DATES_I_1	Dates[1]	Date	4	View
DATES_I_2	Dates[2]	Date	4	View
DATES_I_3	Dates[3]	Date	4	View
DATES_I_4	Dates[4]	Date	4	View
DATES_I_5	Dates[5]	Date	4	View
DOLLARS_I_1	Dollars[1]	Currency	10	View
DOLLARS_I_2	Dollars[2]	Currency	10	View
DOLLARS_I_3	Dollars[3]	Currency	10	View
DOLLARS_I_4	Dollars[4]	Currency	10	View
DOLLARS_I_5	Dollars[5]	Currency	10	View
LONGINTARRAY_1	Long Integer Array[1]	Long Integer	4	View
LONGINTARRAY_2	Long Integer Array[2]	Long Integer	4	View
LONGINTARRAY_3	Long Integer Array[3]	Long Integer	4	View
LONGINTARRAY_4	Long Integer Array[4]	Long Integer	4	View
LONGINTARRAY_5	Long Integer Array[5]	Long Integer	4	View
ESTIMATEDJOBREVENUE_I	Estimated Job Revenue	Currency	10	View
ESTIMATEDJOBEXPENSES_I	Estimated Job Expenses	Currency	10	View
ESTIMATEDJOBPROFIT_I	Estimated Job Profit	Currency	10	View
ESTIMATEDJOBMARGIN_I	Estimated Job Margin	Currency	10	View
PLANNEDJOBREVENUE_I	Planned Job Revenue	Currency	10	View
PLANNEDJOBEXPENSES_I	Planned Job Expenses	Currency	10	View
PLANNEDJOBPROFIT_I	Planned Job Profit	Currency	10	View
PLANNEDJOBMARGIN_I	Planned Job Margin	Currency	10	View
ACTUALJOBREVENUE_I	Actual Job Revenue	Currency	10	View
ACTUALJOBEXPENSES_I	Actual Job Expenses	Currency	10	View
ACTUALJOBPROFIT_I	Actual Job Profit	Currency	10	View
ACTUALJOBMARGIN_I	Actual Job Margin	Currency	10	View
CHANGEDATE_I	Change Date	Date	4	View
USERID	User ID	String	16	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	View

ICJC0001 - Job Master File

Query Builder

Customer Service

Information

My Account

Contact Us