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 Group Display Name: Manufacturing Job Costing
Physical Name: ICJC0001
Technical Name: ICJC_Job_MSTR
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/hideSELECT
['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. |