Job Master File (ICJC0001)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ICJC0001

Product: Manufacturing (346)
Series: 3rd Party

Display Name: Job Master File
Physical Name: ICJC0001
Technical Name: ICJC_Job_MSTR

Group Display Name: Manufacturing Job Costing
Group Technical Name: Manufacturing Job Costing

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	JOBNUMBER_I	Job Num	STR30	String	30
2	JOBDESCRIPTION_I	Job Description	STR50	String	50
3	JOBSTATUS_I	Job Status	DDL_JC_Status	Integer	0
4	JOBONHOLD_I	Job On Hold	CB Job On Hold	Boolean	0
5	JOBCANCELLED_I	Job Cancelled	CB Job Cancelled	Boolean	0
6	JOBCATEGORIES_I_1	Job Categories[1]	DDL	Integer	0
7	JOBCATEGORIES_I	Job Categories	DDL	Integer	0
8	JOBCATEGORIES_I_2	Job Categories[2]	DDL	Integer	0
9	CUSTOMERID_I	Customer ID	STR30	String	30
10	JOBCATEGORIES_I_3	Job Categories[3]	DDL	Integer	0
11	CHECKLISTI	Checklist	STR30_I	String	30
12	CUSTNAME	Customer Name	STR64_Customer_Name	String	64
13	ESTIMATEDSTARTDATE_I	Estimated Start Date Mfg	Date	Date	6
14	ESTIMATEDENDDATE_I	Estimated End Date	Date	Date	6
15	ACTUALSTARTDATE_I	ActualStartDate	DATE	Date	6
16	ACTUALENDDATE_I	Actual End Date	Date	Date	6
17	CHECKBOXES_I	Checkboxes	CB	Boolean	0
18	STRINGS_I	Strings	STR30_I	String	30
19	DATES_I	Dates	Date	Date	6
20	CHECKBOXES_I_1	Checkboxes[1]	CB	Boolean	0
21	CHECKBOXES_I_2	Checkboxes[2]	CB	Boolean	0
22	DOLLARS_I	Dollars	DLR14	Currency	14
23	CHECKBOXES_I_3	Checkboxes[3]	CB	Boolean	0
24	LONGINTARRAY	Long Integer Array	LI_14	Long Integer	14
25	ESTIMATEDJOBREVENUE_I	Estimated Job Revenue	DLR19_RBSO_STR$	Currency	19
26	CHECKBOXES_I_4	Checkboxes[4]	CB	Boolean	0
27	ESTIMATEDJOBEXPENSES_I	Estimated Job Expenses	DLR19_RBS0_STR$	Currency	19
28	CHECKBOXES_I_5	Checkboxes[5]	CB	Boolean	0
29	ESTIMATEDJOBPROFIT_I	Estimated Job Profit	DLR19_RBS0_STR$	Currency	19
30	STRINGS_I_1	Strings[1]	STR30_I	String	30
31	ESTIMATEDJOBMARGIN_I	Estimated Job Margin	DLR5_%2	Currency	8
32	STRINGS_I_2	Strings[2]	STR30_I	String	30
33	PLANNEDJOBREVENUE_I	Planned Job Revenue	DOLLAR	Currency	0
34	STRINGS_I_3	Strings[3]	STR30_I	String	30
35	STRINGS_I_4	Strings[4]	STR30_I	String	30
36	PLANNEDJOBEXPENSES_I	Planned Job Expenses	DOLLAR	Currency	0
37	STRINGS_I_5	Strings[5]	STR30_I	String	30
38	PLANNEDJOBPROFIT_I	Planned Job Profit	DOLLAR	Currency	0
39	PLANNEDJOBMARGIN_I	Planned Job Margin	Stat_Percent	Currency	6
40	DATES_I_1	Dates[1]	Date	Date	6
41	DATES_I_2	Dates[2]	Date	Date	6
42	ACTUALJOBREVENUE_I	Actual Job Revenue	DLR19_RBS0_STR$	Currency	19
43	DATES_I_3	Dates[3]	Date	Date	6
44	ACTUALJOBEXPENSES_I	Actual Job Expenses	DLR19_RBSO_STR$	Currency	19
45	ACTUALJOBPROFIT_I	Actual Job Profit	DLR19_RBS0_STR$	Currency	19
46	DATES_I_4	Dates[4]	Date	Date	6
47	DATES_I_5	Dates[5]	Date	Date	6
48	ACTUALJOBMARGIN_I	Actual Job Margin	DLR5_%2	Currency	8
49	DOLLARS_I_1	Dollars[1]	DLR14	Currency	14
50	CHANGEDATE_I	Change Date	DT	Date	8
51	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Job Master File'].USERID AS 'Job Master File-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ICJC0001 AS ['Job Master File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Job Master File'].USERID = ['Users Master'].USERID
52	DOLLARS_I_2	Dollars[2]	DLR14	Currency	14
53	MFGNOTEINDEX_I	MFG Note Index	DLR14	Currency	14
54	DOLLARS_I_3	Dollars[3]	DLR14	Currency	14
55	DOLLARS_I_4	Dollars[4]	DLR14	Currency	14
56	DOLLARS_I_5	Dollars[5]	DLR14	Currency	14
57	LONGINTARRAY_1	Long Integer Array[1]	LI_14	Long Integer	14
58	LONGINTARRAY_2	Long Integer Array[2]	LI_14	Long Integer	14
59	LONGINTARRAY_3	Long Integer Array[3]	LI_14	Long Integer	14
60	LONGINTARRAY_4	Long Integer Array[4]	LI_14	Long Integer	14
61	LONGINTARRAY_5	Long Integer Array[5]	LI_14	Long Integer	14
62	DEX_ROW_ID		int	int	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurve Products Manufacturing (346)3rd PartyJob Master File (ICJC0001)

Click to show/hide

Leave a Reply Cancel reply