Attendance_Report_Options (ATUF0130)

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

Product: Human Resources (414)
Series: System

Display Name: Attendance_Report_Options
Physical Name: ATUF0130
Technical Name: Attendance_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	REPORTFORMAT	Report Format	GB	Integer	2	0
11	RNGE	Range	STR132	String	134	132
12	SORTBYNUMBER_I	Sort By Number	INT2	Integer	2	2
13	SORTBY_I	sortby	STR_30	String	32	30
14	SORTOPTION_I	Sort Option	INT	Integer	2	0
15	FROMAPPLYDATE_I	from Apply Date	DT	Date	4	8
16	TOAPPLYDATE_I	to Apply Date	DT	Date	4	8
17	APPLYDATE_I	Apply Date	DT	Date	4	8
18	FROMBATCH_I	from Batch	STR15_LBAU	String	16	15
19	TOBATCH_I	to Batch	STR15_LBAU	String	16	15
20	FROMBATCHNUMBER_I	from Batch Number	STR15_LBAU	String	16	15
21	TOBATCHNUMBER_I	to Batch Number	STR15_LBAU	String	16	15
22	BACHNUMB	Batch Number	STR15_LBAU	String	16	15
23	FROMCARDNAME_I	from Card Name	STR30_I0	String	32	30
24	TOCARDNAME_I	to Card Name	STR30_I0	String	32	30
25	COLORCODE_I	Color Code	VS_Color_Code	Integer	2	0
26	FROMDATE_I	from Date	DT	Date	4	8
27	TODATE_I	to Date	DT	Date	4	8
28	DATE1	Date	DT6	Date	4	6
29	FROMDEPARTMENTCODE_I	from Department Code	STR6_Payroll_Code	String	8	6
30	TODEPARTMENTCODE_I	to Department Code	STR6_Payroll_Code	String	8	6
31	DEPARTMENTCODE_I	Department Code	STR6_Payroll_Code	String	8	6
32	FDISLINENUMBER_I	from Discipline Number	IINT5_U0	Integer	2	5
33	TODISCIPLINENUMBER_I	to Discipline Number	IINT5_U0	Integer	2	5
34	ENTRYNUMBER_I	Entry Number	IINT5_U0	Integer	2	5
35	FROMDIVISIONCODE_I	from Division Code	STR6_Payroll_Code	String	8	6
36	TODIVISIONCODE_I	to Division Code	STR6_Payroll_Code	String	8	6
37	DIVISIONCODE_I	Division Code	STR6_Payroll_Code	String	8	6
38	FROMEMPLOYEEID_I	from Employee ID	STR15_Employee_ID	String	16	15
39	TOEMPLOYEEID_I	to Employee ID	STR15_Employee_ID	String	16	15
40	EMPID_I	Emp ID	STR15_Employee_ID_I	String	16	15
41	FROMENTRYNUMBER_I	from Entry Number	IINT5_U0	Integer	2	5
42	TOENTRYNUMBER_I	to Entry Number	IINT5_U0	Integer	2	5
43	FROMFIRSTNAME_I	from First Name	STR15_I	String	16	15
44	TOFIRSTNAME_I	to First Name	STR15_I	String	16	15
45	FFIRSTNAME_I	FFirst Name	STR15_I	String	16	15
46	ETHNICORIGIN_I	IEthnic Origin	IDDL_Ethnic_Origin	Integer	2	0
47	FROMISSN_I	from ISSN	STR15_Social_Security_Number	String	16	15
48	TOISSN_I	to ISSN	STR15_Social_Security_Number	String	16	15
49	SSN_I	ISSN	STR15_Social_Security_Number	String	16	15
50	FROMLASTNAME_I	from Last Name	STR20	String	22	20
51	TOLASTNAME_I	to Last Name	STR20	String	22	20
52	LLASTNAME_I	LLast Name	STR20	String	22	20
53	FROMPOSITIONCODE_I	from Position Code	STR6_Payroll_Code	String	8	6
54	TOPOSITIONCODE_I	to Position Code	STR6_Payroll_Code	String	8	6
55	POSITIONCODE_I	Position Code	STR6_Payroll_Code	String	8	6
56	FROMTIMECODE_I	from Time Code	STR6_Payroll_Code	String	8	6
57	TOTIMECODE_I	to Time Code	STR6_Payroll_Code	String	8	6
58	TIMECODE_I	Time Code	STR6_Payroll_Code	String	8	6
59	INCINEMP	Include Inactive Employees	CB_Include_Inactive_Employees	Boolean	2	0
60	RESID	Resid	ID_INT	Integer	2	4
61	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.

azurecurve Products Human Resources (414)SystemAttendance_Report_Options (ATUF0130)

Leave a Reply Cancel reply