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