HR_Applicant_User_Defined (AU010130)

azurecurveProductsHuman Resources (414)SystemHR_Applicant_User_Defined (AU010130)

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

Product: Human Resources (414)
Series: System

Display Name: HR_Applicant_User_Defined
Physical Name: AU010130
Technical Name: HR_Applicant_User_Defined

Group Display Name: HR Multi-Company
Group Technical Name: HR_MultiCmp_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1MSEQUENCE_I SearchMSequenceIINT4Integer24
2APPLICANTNUMBER_I SearchApplicant NumberDOLLARCurrency100
3MSTRING_I_1 SearchMString[1]STR30_I0String3230
4MSTRING_I_2 SearchMString[2]STR30_I0String3230
5MSTRING_I_3 SearchMString[3]STR30_I0String3230
6MSTRING_I_4 SearchMString[4]STR30_I0String3230
7MSTRING_I_5 SearchMString[5]STR30_I0String3230
8MLINT_I_1 SearchMLint[1]LI_8Long Integer48
9MLINT_I_2 SearchMLint[2]LI_8Long Integer48
10MLINT_I_3 SearchMLint[3]LI_8Long Integer48
11MLINT_I_4 SearchMLint[4]LI_8Long Integer48
12MLINT_I_5 SearchMLint[5]LI_8Long Integer48
13MDLR_I_1 SearchMDLR[1]DLR14_SalaryCurrency1014
14MDLR_I_2 SearchMDLR[2]DLR14_SalaryCurrency1014
15MDLR_I_3 SearchMDLR[3]DLR14_SalaryCurrency1014
16MDLR_I_4 SearchMDLR[4]DLR14_SalaryCurrency1014
17MDLR_I_5 SearchMDLR[5]DLR14_SalaryCurrency1014
18MCHECK_I_1 SearchMCheck[1]CB_IBoolean20
19MCHECK_I_2 SearchMCheck[2]CB_IBoolean20
20MCHECK_I_3 SearchMCheck[3]CB_IBoolean20
21MCHECK_I_4 SearchMCheck[4]CB_IBoolean20
22MCHECK_I_5 SearchMCheck[5]CB_IBoolean20
23MCHECK_I_6 SearchMCheck[6]CB_IBoolean20
24MCHECK_I_7 SearchMCheck[7]CB_IBoolean20
25MCHECK_I_8 SearchMCheck[8]CB_IBoolean20
26MCHECK_I_9 SearchMCheck[9]CB_IBoolean20
27MCHECK_I_10 SearchMCheck[10]CB_IBoolean20
28MDATE1_I SearchMDate1DTDate48
29MDATE2_I SearchMDate2DTDate48
30MDATE3_I SearchMDate3DTDate48
31MDATE4_I SearchMDate4DTDate48
32MDATE5_I SearchMDate5DTDate48
33MTIME_I_1 SearchMTime[1]STR_TimeString65
34MTIME_I_2 SearchMTime[2]STR_TimeString65
35MTIME_I_3 SearchMTime[3]STR_TimeString65
36MTIME_I_4 SearchMTime[4]STR_TimeString65
37MTIME_I_5 SearchMTime[5]STR_TimeString65
38NOTESINDEX_I SearchNotes IndexDOLLARCurrency100
39DEX_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.

azurecurveProductsHuman Resources (414)SystemHR_Applicant_User_Defined (AU010130)

Leave a Reply

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