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 | Length | |
---|---|---|---|---|---|---|
1 | REPORTOPTION_I ![]() | Report Option | STR20 | String | 20 | |
2 | REPORTINDEX_I ![]() | Report Index | DLR14 | Currency | 14 | |
3 | ASKECHTM ![]() | Ask Each Time | CB_Ask_Each_Time | Boolean | 0 | |
4 | PRNTOFIL ![]() | Print to File | CB_Print_to_File | Boolean | 0 | |
5 | PRTOPRTR ![]() | Print to Printer | CB_Print_to_Printer | Boolean | 0 | |
6 | PRTOSCRN ![]() | Print to Screen | CB_Print_to_Screen | Boolean | 0 | |
7 | IFFILXST ![]() | If File Existing | GB | Integer | 0 | |
8 | FILEXPNM ![]() | File Export Name | STR255 | String | 255 | |
9 | EXPTTYPE ![]() | Export Type | INT | Integer | 0 | |
10 | RNGE ![]() | Range | STR132 | String | 132 | |
11 | SORTBYNUMBER_I ![]() | Sort By Number | INT2 | Integer | 2 | |
12 | SORTOPTION_I ![]() | Sort Option | INT | Integer | 0 | |
13 | FROMDATE_I ![]() | from Date | DT | Date | 8 | |
14 | TODATE_I ![]() | to Date | DT | Date | 8 | |
15 | DIVISIONCODE_I ![]() | Division Code | STR6_Payroll_Code | String | 6 | |
16 | FROMEMPLOYEEID_I ![]() | from Employee ID | STR15_Employee_ID | String | 15 | |
17 | TOEMPLOYEEID_I ![]() | to Employee ID | STR15_Employee_ID | String | 15 | |
18 | FROMFIRSTNAME_I ![]() | from First Name | STR15_I | String | 15 | |
19 | TOFIRSTNAME_I ![]() | to First Name | STR15_I | String | 15 | |
20 | FROMISSN_I ![]() | from ISSN | STR15_Social_Security_Number | String | 15 | |
21 | TOISSN_I ![]() | to ISSN | STR15_Social_Security_Number | String | 15 | |
22 | FROMLASTNAME_I ![]() | from Last Name | STR20 | String | 20 | |
23 | TOLASTNAME_I ![]() | to Last Name | STR20 | String | 20 | |
24 | TERMSETUPCODE_I ![]() | Termination Setup Code | STR30_I0 | String | 30 | |
25 | RESID ![]() | Resid | ID_INT | Integer | 4 | |
26 | DEX_ROW_ID ![]() | int | int | 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. |