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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1JOBNUMBER_I SearchJob NumSTR30String3230
2JOBDESCRIPTION_I SearchJob DescriptionSTR50String5250
3JOBSTATUS_I SearchJob StatusDDL_JC_StatusInteger20
4JOBONHOLD_I SearchJob On HoldCB Job On HoldBoolean20
5JOBCANCELLED_I SearchJob CancelledCB Job CancelledBoolean20
6JOBCATEGORIES_I_1 SearchJob Categories[1]DDLInteger20
7JOBCATEGORIES_I SearchJob CategoriesDDLInteger20
8JOBCATEGORIES_I_2 SearchJob Categories[2]DDLInteger20
9CUSTOMERID_I SearchCustomer IDSTR30String3230
10JOBCATEGORIES_I_3 SearchJob Categories[3]DDLInteger20
11CHECKLISTI SearchChecklistSTR30_IString3230
12CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
13ESTIMATEDSTARTDATE_I SearchEstimated Start Date MfgDateDate46
14ESTIMATEDENDDATE_I SearchEstimated End DateDateDate46
15ACTUALSTARTDATE_I SearchActualStartDateDATEDate46
16ACTUALENDDATE_I SearchActual End DateDateDate46
17CHECKBOXES_I SearchCheckboxesCBBoolean20
18STRINGS_I SearchStringsSTR30_IString3230
19DATES_I SearchDatesDateDate46
20CHECKBOXES_I_1 SearchCheckboxes[1]CBBoolean20
21CHECKBOXES_I_2 SearchCheckboxes[2]CBBoolean20
22DOLLARS_I SearchDollarsDLR14Currency1014
23CHECKBOXES_I_3 SearchCheckboxes[3]CBBoolean20
24LONGINTARRAY SearchLong Integer ArrayLI_14Long Integer414
25ESTIMATEDJOBREVENUE_I SearchEstimated Job RevenueDLR19_RBSO_STR$Currency1019
26CHECKBOXES_I_4 SearchCheckboxes[4]CBBoolean20
27ESTIMATEDJOBEXPENSES_I SearchEstimated Job ExpensesDLR19_RBS0_STR$Currency1019
28CHECKBOXES_I_5 SearchCheckboxes[5]CBBoolean20
29ESTIMATEDJOBPROFIT_I SearchEstimated Job ProfitDLR19_RBS0_STR$Currency1019
30STRINGS_I_1 SearchStrings[1]STR30_IString3230
31ESTIMATEDJOBMARGIN_I SearchEstimated Job MarginDLR5_%2Currency108
32STRINGS_I_2 SearchStrings[2]STR30_IString3230
33PLANNEDJOBREVENUE_I SearchPlanned Job RevenueDOLLARCurrency100
34STRINGS_I_3 SearchStrings[3]STR30_IString3230
35STRINGS_I_4 SearchStrings[4]STR30_IString3230
36PLANNEDJOBEXPENSES_I SearchPlanned Job ExpensesDOLLARCurrency100
37STRINGS_I_5 SearchStrings[5]STR30_IString3230
38PLANNEDJOBPROFIT_I SearchPlanned Job ProfitDOLLARCurrency100
39PLANNEDJOBMARGIN_I SearchPlanned Job MarginStat_PercentCurrency106
40DATES_I_1 SearchDates[1]DateDate46
41DATES_I_2 SearchDates[2]DateDate46
42ACTUALJOBREVENUE_I SearchActual Job RevenueDLR19_RBS0_STR$Currency1019
43DATES_I_3 SearchDates[3]DateDate46
44ACTUALJOBEXPENSES_I SearchActual Job ExpensesDLR19_RBSO_STR$Currency1019
45ACTUALJOBPROFIT_I SearchActual Job ProfitDLR19_RBS0_STR$Currency1019
46DATES_I_4 SearchDates[4]DateDate46
47DATES_I_5 SearchDates[5]DateDate46
48ACTUALJOBMARGIN_I SearchActual Job MarginDLR5_%2Currency108
49DOLLARS_I_1 SearchDollars[1]DLR14Currency1014
50CHANGEDATE_I SearchChange DateDTDate48
51USERID SearchUser IDSTR15_User_IDString1615
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
52DOLLARS_I_2 SearchDollars[2]DLR14Currency1014
53MFGNOTEINDEX_I SearchMFG Note IndexDLR14Currency1014
54DOLLARS_I_3 SearchDollars[3]DLR14Currency1014
55DOLLARS_I_4 SearchDollars[4]DLR14Currency1014
56DOLLARS_I_5 SearchDollars[5]DLR14Currency1014
57LONGINTARRAY_1 SearchLong Integer Array[1]LI_14Long Integer414
58LONGINTARRAY_2 SearchLong Integer Array[2]LI_14Long Integer414
59LONGINTARRAY_3 SearchLong Integer Array[3]LI_14Long Integer414
60LONGINTARRAY_4 SearchLong Integer Array[4]LI_14Long Integer414
61LONGINTARRAY_5 SearchLong Integer Array[5]LI_14Long Integer414
62DEX_ROW_ID Searchintint1010

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.

Leave a Reply

Your email address will not be published. Required fields are marked *