Archive_HR_Applicant_User_Defined (AAU10130)

azurecurveProductsHuman Resources (414)SystemArchive_HR_Applicant_User_Defined (AAU10130)

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

Product: Human Resources (414)
Series: System

Display Name: Archive_HR_Applicant_User_Defined
Physical Name: AAU10130
Technical Name: Archive_HR_Applicant_User_Defined

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1MSEQUENCE_I SearchMSequenceIINT4Integer4
2APPLICANTNUMBER_I SearchApplicant NumberDOLLARCurrency0
3MSTRING_I_1 SearchMString[1]STR30_I0String30
4MSTRING_I_2 SearchMString[2]STR30_I0String30
5MSTRING_I_3 SearchMString[3]STR30_I0String30
6MSTRING_I_4 SearchMString[4]STR30_I0String30
7MSTRING_I_5 SearchMString[5]STR30_I0String30
8MLINT_I_1 SearchMLint[1]LI_8Long Integer8
9MLINT_I_2 SearchMLint[2]LI_8Long Integer8
10MLINT_I_3 SearchMLint[3]LI_8Long Integer8
11MLINT_I_4 SearchMLint[4]LI_8Long Integer8
12MLINT_I_5 SearchMLint[5]LI_8Long Integer8
13MDLR_I_1 SearchMDLR[1]DLR14_SalaryCurrency14
14MDLR_I_2 SearchMDLR[2]DLR14_SalaryCurrency14
15MDLR_I_3 SearchMDLR[3]DLR14_SalaryCurrency14
16MDLR_I_4 SearchMDLR[4]DLR14_SalaryCurrency14
17MDLR_I_5 SearchMDLR[5]DLR14_SalaryCurrency14
18MCHECK_I_1 SearchMCheck[1]CB_IBoolean0
19MCHECK_I_2 SearchMCheck[2]CB_IBoolean0
20MCHECK_I_3 SearchMCheck[3]CB_IBoolean0
21MCHECK_I_4 SearchMCheck[4]CB_IBoolean0
22MCHECK_I_5 SearchMCheck[5]CB_IBoolean0
23MCHECK_I_6 SearchMCheck[6]CB_IBoolean0
24MCHECK_I_7 SearchMCheck[7]CB_IBoolean0
25MCHECK_I_8 SearchMCheck[8]CB_IBoolean0
26MCHECK_I_9 SearchMCheck[9]CB_IBoolean0
27MCHECK_I_10 SearchMCheck[10]CB_IBoolean0
28MDATE1_I SearchMDate1DTDate8
29MDATE2_I SearchMDate2DTDate8
30MDATE3_I SearchMDate3DTDate8
31MDATE4_I SearchMDate4DTDate8
32MDATE5_I SearchMDate5DTDate8
33MTIME_I_1 SearchMTime[1]STR_TimeString5
34MTIME_I_2 SearchMTime[2]STR_TimeString5
35MTIME_I_3 SearchMTime[3]STR_TimeString5
36MTIME_I_4 SearchMTime[4]STR_TimeString5
37MTIME_I_5 SearchMTime[5]STR_TimeString5
38NOTESINDEX_I SearchNotes IndexDOLLARCurrency0
39DEX_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.

azurecurveProductsHuman Resources (414)SystemArchive_HR_Applicant_User_Defined (AAU10130)

Leave a Reply

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