Job Master File (ICJC0001)

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

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

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	String	STR30	30
2	JOBDESCRIPTION_I	Job Description	String	STR50	50
3	JOBSTATUS_I	Job Status	Integer	DDL_JC_Status	0
4	JOBONHOLD_I	Job On Hold	Boolean	CB Job On Hold	0
5	JOBCANCELLED_I	Job Cancelled	Boolean	CB Job Cancelled	0
6	JOBCATEGORIES_I_1	Job Categories[1]	Integer	DDL	0
7	JOBCATEGORIES_I	Job Categories	DDL	Integer	0
8	JOBCATEGORIES_I_2	Job Categories[2]	Integer	DDL	0
9	JOBCATEGORIES_I_3	Job Categories[3]	Integer	DDL	0
10	CUSTOMERID_I	Customer ID	String	STR30	30
11	CHECKLISTI	Checklist	String	STR30_I	30
12	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
13	ESTIMATEDSTARTDATE_I	Estimated Start Date Mfg	Date	Date	6
14	ESTIMATEDENDDATE_I	Estimated End Date	Date	Date	6
15	CHECKBOXES_I	Checkboxes	CB	Boolean	0
16	ACTUALSTARTDATE_I	ActualStartDate	Date	DATE	6
17	ACTUALENDDATE_I	Actual End Date	Date	Date	6
18	STRINGS_I	Strings	STR30_I	String	30
19	DATES_I	Dates	Date	Date	6
20	CHECKBOXES_I_1	Checkboxes[1]	Boolean	CB	0
21	CHECKBOXES_I_2	Checkboxes[2]	Boolean	CB	0
22	DOLLARS_I	Dollars	DLR14	Currency	14
23	LONGINTARRAY	Long Integer Array	LI_14	Long Integer	14
24	CHECKBOXES_I_3	Checkboxes[3]	Boolean	CB	0
25	CHECKBOXES_I_4	Checkboxes[4]	Boolean	CB	0
26	CHECKBOXES_I_5	Checkboxes[5]	Boolean	CB	0
27	STRINGS_I_1	Strings[1]	String	STR30_I	30
28	STRINGS_I_2	Strings[2]	String	STR30_I	30
29	STRINGS_I_3	Strings[3]	String	STR30_I	30
30	STRINGS_I_4	Strings[4]	String	STR30_I	30
31	STRINGS_I_5	Strings[5]	String	STR30_I	30
32	DATES_I_1	Dates[1]	Date	Date	6
33	DATES_I_2	Dates[2]	Date	Date	6
34	DATES_I_3	Dates[3]	Date	Date	6
35	DATES_I_4	Dates[4]	Date	Date	6
36	DATES_I_5	Dates[5]	Date	Date	6
37	DOLLARS_I_1	Dollars[1]	Currency	DLR14	14
38	DOLLARS_I_2	Dollars[2]	Currency	DLR14	14
39	DOLLARS_I_3	Dollars[3]	Currency	DLR14	14
40	DOLLARS_I_4	Dollars[4]	Currency	DLR14	14
41	DOLLARS_I_5	Dollars[5]	Currency	DLR14	14
42	LONGINTARRAY_1	Long Integer Array[1]	Long Integer	LI_14	14
43	LONGINTARRAY_2	Long Integer Array[2]	Long Integer	LI_14	14
44	LONGINTARRAY_3	Long Integer Array[3]	Long Integer	LI_14	14
45	LONGINTARRAY_4	Long Integer Array[4]	Long Integer	LI_14	14
46	LONGINTARRAY_5	Long Integer Array[5]	Long Integer	LI_14	14
47	ESTIMATEDJOBREVENUE_I	Estimated Job Revenue	Currency	DLR19_RBSO_STR$	19
48	ESTIMATEDJOBEXPENSES_I	Estimated Job Expenses	Currency	DLR19_RBS0_STR$	19
49	ESTIMATEDJOBPROFIT_I	Estimated Job Profit	Currency	DLR19_RBS0_STR$	19
50	ESTIMATEDJOBMARGIN_I	Estimated Job Margin	Currency	DLR5_%2	8
51	PLANNEDJOBREVENUE_I	Planned Job Revenue	Currency	DOLLAR	0
52	PLANNEDJOBEXPENSES_I	Planned Job Expenses	Currency	DOLLAR	0
53	PLANNEDJOBPROFIT_I	Planned Job Profit	Currency	DOLLAR	0
54	PLANNEDJOBMARGIN_I	Planned Job Margin	Currency	Stat_Percent	6
55	ACTUALJOBREVENUE_I	Actual Job Revenue	Currency	DLR19_RBS0_STR$	19
56	ACTUALJOBEXPENSES_I	Actual Job Expenses	Currency	DLR19_RBSO_STR$	19
57	ACTUALJOBPROFIT_I	Actual Job Profit	Currency	DLR19_RBS0_STR$	19
58	ACTUALJOBMARGIN_I	Actual Job Margin	Currency	DLR5_%2	8
59	CHANGEDATE_I	Change Date	Date	DT	8
60	USERID	User ID	String	STR15_User_ID	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
61	MFGNOTEINDEX_I	MFG Note Index	Currency	DLR14	14

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

Click to show/hide

Leave a Reply Cancel reply