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 TypeLength
1JOBNUMBER_I SearchJob NumSTR30String30
2JOBDESCRIPTION_I SearchJob DescriptionSTR50String50
3JOBSTATUS_I SearchJob StatusDDL_JC_StatusInteger0
4JOBONHOLD_I SearchJob On HoldCB Job On HoldBoolean0
5JOBCANCELLED_I SearchJob CancelledCB Job CancelledBoolean0
6JOBCATEGORIES_I_1 SearchJob Categories[1]DDLInteger0
7JOBCATEGORIES_I SearchJob CategoriesDDLInteger0
8JOBCATEGORIES_I_2 SearchJob Categories[2]DDLInteger0
9CUSTOMERID_I SearchCustomer IDSTR30String30
10JOBCATEGORIES_I_3 SearchJob Categories[3]DDLInteger0
11CHECKLISTI SearchChecklistSTR30_IString30
12CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
13ESTIMATEDSTARTDATE_I SearchEstimated Start Date MfgDateDate6
14ESTIMATEDENDDATE_I SearchEstimated End DateDateDate6
15ACTUALSTARTDATE_I SearchActualStartDateDATEDate6
16ACTUALENDDATE_I SearchActual End DateDateDate6
17CHECKBOXES_I SearchCheckboxesCBBoolean0
18STRINGS_I SearchStringsSTR30_IString30
19DATES_I SearchDatesDateDate6
20CHECKBOXES_I_1 SearchCheckboxes[1]CBBoolean0
21CHECKBOXES_I_2 SearchCheckboxes[2]CBBoolean0
22DOLLARS_I SearchDollarsDLR14Currency14
23CHECKBOXES_I_3 SearchCheckboxes[3]CBBoolean0
24LONGINTARRAY SearchLong Integer ArrayLI_14Long Integer14
25ESTIMATEDJOBREVENUE_I SearchEstimated Job RevenueDLR19_RBSO_STR$Currency19
26CHECKBOXES_I_4 SearchCheckboxes[4]CBBoolean0
27ESTIMATEDJOBEXPENSES_I SearchEstimated Job ExpensesDLR19_RBS0_STR$Currency19
28CHECKBOXES_I_5 SearchCheckboxes[5]CBBoolean0
29ESTIMATEDJOBPROFIT_I SearchEstimated Job ProfitDLR19_RBS0_STR$Currency19
30STRINGS_I_1 SearchStrings[1]STR30_IString30
31ESTIMATEDJOBMARGIN_I SearchEstimated Job MarginDLR5_%2Currency8
32STRINGS_I_2 SearchStrings[2]STR30_IString30
33PLANNEDJOBREVENUE_I SearchPlanned Job RevenueDOLLARCurrency0
34STRINGS_I_3 SearchStrings[3]STR30_IString30
35STRINGS_I_4 SearchStrings[4]STR30_IString30
36PLANNEDJOBEXPENSES_I SearchPlanned Job ExpensesDOLLARCurrency0
37STRINGS_I_5 SearchStrings[5]STR30_IString30
38PLANNEDJOBPROFIT_I SearchPlanned Job ProfitDOLLARCurrency0
39PLANNEDJOBMARGIN_I SearchPlanned Job MarginStat_PercentCurrency6
40DATES_I_1 SearchDates[1]DateDate6
41DATES_I_2 SearchDates[2]DateDate6
42ACTUALJOBREVENUE_I SearchActual Job RevenueDLR19_RBS0_STR$Currency19
43DATES_I_3 SearchDates[3]DateDate6
44ACTUALJOBEXPENSES_I SearchActual Job ExpensesDLR19_RBSO_STR$Currency19
45ACTUALJOBPROFIT_I SearchActual Job ProfitDLR19_RBS0_STR$Currency19
46DATES_I_4 SearchDates[4]DateDate6
47DATES_I_5 SearchDates[5]DateDate6
48ACTUALJOBMARGIN_I SearchActual Job MarginDLR5_%2Currency8
49DOLLARS_I_1 SearchDollars[1]DLR14Currency14
50CHANGEDATE_I SearchChange DateDTDate8
51USERID SearchUser IDSTR15_User_IDString15
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]DLR14Currency14
53MFGNOTEINDEX_I SearchMFG Note IndexDLR14Currency14
54DOLLARS_I_3 SearchDollars[3]DLR14Currency14
55DOLLARS_I_4 SearchDollars[4]DLR14Currency14
56DOLLARS_I_5 SearchDollars[5]DLR14Currency14
57LONGINTARRAY_1 SearchLong Integer Array[1]LI_14Long Integer14
58LONGINTARRAY_2 SearchLong Integer Array[2]LI_14Long Integer14
59LONGINTARRAY_3 SearchLong Integer Array[3]LI_14Long Integer14
60LONGINTARRAY_4 SearchLong Integer Array[4]LI_14Long Integer14
61LONGINTARRAY_5 SearchLong Integer Array[5]LI_14Long Integer14
62DEX_ROW_ID Searchintint10

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 *