Termination_Report_Options (TRUF0232)

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

Display Name: Termination_Report_Options
Physical Name: TRUF0232
Technical Name: Termination_Report_Options

Group Display Name: HR Multi-Company
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.