Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TRUF0232
Product: Human Resources (414)
Series: System
Display Name: Termination_Report_Options Group Display Name: HR Multi-Company
Physical Name: TRUF0232
Technical Name: Termination_Report_Options
Group Technical Name: HR_MultiCmp_File
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
---|---|---|---|---|---|---|
1 | REPORTOPTION_I ![]() | Report Option | STR20 | String | 22 | 20 |
2 | REPORTINDEX_I ![]() | Report Index | DLR14 | Currency | 10 | 14 |
3 | ASKECHTM ![]() | Ask Each Time | CB_Ask_Each_Time | Boolean | 2 | 0 |
4 | PRNTOFIL ![]() | Print to File | CB_Print_to_File | Boolean | 2 | 0 |
5 | PRTOPRTR ![]() | Print to Printer | CB_Print_to_Printer | Boolean | 2 | 0 |
6 | PRTOSCRN ![]() | Print to Screen | CB_Print_to_Screen | Boolean | 2 | 0 |
7 | IFFILXST ![]() | If File Existing | GB | Integer | 2 | 0 |
8 | FILEXPNM ![]() | File Export Name | STR255 | String | 256 | 255 |
9 | EXPTTYPE ![]() | Export Type | INT | Integer | 2 | 0 |
10 | RNGE ![]() | Range | STR132 | String | 134 | 132 |
11 | SORTBYNUMBER_I ![]() | Sort By Number | INT2 | Integer | 2 | 2 |
12 | SORTOPTION_I ![]() | Sort Option | INT | Integer | 2 | 0 |
13 | FROMDATE_I ![]() | from Date | DT | Date | 4 | 8 |
14 | TODATE_I ![]() | to Date | DT | Date | 4 | 8 |
15 | DIVISIONCODE_I ![]() | Division Code | STR6_Payroll_Code | String | 8 | 6 |
16 | FROMEMPLOYEEID_I ![]() | from Employee ID | STR15_Employee_ID | String | 16 | 15 |
17 | TOEMPLOYEEID_I ![]() | to Employee ID | STR15_Employee_ID | String | 16 | 15 |
18 | FROMFIRSTNAME_I ![]() | from First Name | STR15_I | String | 16 | 15 |
19 | TOFIRSTNAME_I ![]() | to First Name | STR15_I | String | 16 | 15 |
20 | FROMISSN_I ![]() | from ISSN | STR15_Social_Security_Number | String | 16 | 15 |
21 | TOISSN_I ![]() | to ISSN | STR15_Social_Security_Number | String | 16 | 15 |
22 | FROMLASTNAME_I ![]() | from Last Name | STR20 | String | 22 | 20 |
23 | TOLASTNAME_I ![]() | to Last Name | STR20 | String | 22 | 20 |
24 | TERMSETUPCODE_I ![]() | Termination Setup Code | STR30_I0 | String | 32 | 30 |
25 | RESID ![]() | Resid | ID_INT | Integer | 2 | 4 |
26 | DEX_ROW_ID ![]() | int | int | 10 | 10 | |
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. |