HR_Company2_Extra (HRCOM022)

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

Product: Human Resources (414)
Series: 3rd Party

Display Name: HR_Company2_Extra
Physical Name: HRCOM022
Technical Name: HR_Company2_Extra

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1COMPANYCODE_I SearchCompany CodeSTR6_Payroll_CodeString6
2DATES_I_1 SearchDates[1]DTDate8
3DATES_I_2 SearchDates[2]DTDate8
4DATES_I_3 SearchDates[3]DTDate8
5DATES_I_4 SearchDates[4]DTDate8
6DATES_I_5 SearchDates[5]DTDate8
7STRINGS_I_1 SearchStrings[1]STR30_I0String30
8STRINGS_I_2 SearchStrings[2]STR30_I0String30
9STRINGS_I_3 SearchStrings[3]STR30_I0String30
10STRINGS_I_4 SearchStrings[4]STR30_I0String30
11STRINGS_I_5 SearchStrings[5]STR30_I0String30
12NUMERICEXTRA_1 SearchNumericExtra[1]LI5_NoFormatLong Integer5
13NUMERICEXTRA_2 SearchNumericExtra[2]LI5_NoFormatLong Integer5
14NUMERICEXTRA_3 SearchNumericExtra[3]LI5_NoFormatLong Integer5
15NUMERICEXTRA_4 SearchNumericExtra[4]LI5_NoFormatLong Integer5
16NUMERICEXTRA_5 SearchNumericExtra[5]LI5_NoFormatLong Integer5
17DOLLARS_I_1 SearchDollars[1]DLR14Currency14
18DOLLARS_I_2 SearchDollars[2]DLR14Currency14
19DOLLARS_I_3 SearchDollars[3]DLR14Currency14
20DOLLARS_I_4 SearchDollars[4]DLR14Currency14
21DOLLARS_I_5 SearchDollars[5]DLR14Currency14
22CHECKBOXES_I_1 SearchCheckboxes[1]CBBoolean0
23CHECKBOXES_I_2 SearchCheckboxes[2]CBBoolean0
24CHECKBOXES_I_3 SearchCheckboxes[3]CBBoolean0
25CHECKBOXES_I_4 SearchCheckboxes[4]CBBoolean0
26CHECKBOXES_I_5 SearchCheckboxes[5]CBBoolean0
27NOTESINDEX_I SearchNotes IndexDOLLARCurrency0
28CHANGEBY_I SearchChange BySTR15_User_IDString15
29CHANGEDATE_I SearchChange DateDTDate8
30DEX_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 *