Attendance_Report_Options (ATUF0130)

Easily find this page again using the shortlink: http://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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1REPORTOPTION_I SearchReport OptionSTR20String2220
2REPORTINDEX_I SearchReport IndexDLR14Currency1014
3ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
4PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
5PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
6PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
7IFFILXST SearchIf File ExistingGBInteger20
8FILEXPNM SearchFile Export NameSTR255String256255
9EXPTTYPE SearchExport TypeINTInteger20
10REPORTFORMAT SearchReport FormatGBInteger20
11RNGE SearchRangeSTR132String134132
12SORTBYNUMBER_I SearchSort By NumberINT2Integer22
13SORTBY_I SearchsortbySTR_30String3230
14SORTOPTION_I SearchSort OptionINTInteger20
15FROMAPPLYDATE_I Searchfrom Apply DateDTDate48
16TOAPPLYDATE_I Searchto Apply DateDTDate48
17APPLYDATE_I SearchApply DateDTDate48
18FROMBATCH_I Searchfrom BatchSTR15_LBAUString1615
19TOBATCH_I Searchto BatchSTR15_LBAUString1615
20FROMBATCHNUMBER_I Searchfrom Batch NumberSTR15_LBAUString1615
21TOBATCHNUMBER_I Searchto Batch NumberSTR15_LBAUString1615
22BACHNUMB SearchBatch NumberSTR15_LBAUString1615
23FROMCARDNAME_I Searchfrom Card NameSTR30_I0String3230
24TOCARDNAME_I Searchto Card NameSTR30_I0String3230
25COLORCODE_I SearchColor CodeVS_Color_CodeInteger20
26FROMDATE_I Searchfrom DateDTDate48
27TODATE_I Searchto DateDTDate48
28DATE1 SearchDateDT6Date46
29FROMDEPARTMENTCODE_I Searchfrom Department CodeSTR6_Payroll_CodeString86
30TODEPARTMENTCODE_I Searchto Department CodeSTR6_Payroll_CodeString86
31DEPARTMENTCODE_I SearchDepartment CodeSTR6_Payroll_CodeString86
32FDISLINENUMBER_I Searchfrom Discipline NumberIINT5_U0Integer25
33TODISCIPLINENUMBER_I Searchto Discipline NumberIINT5_U0Integer25
34ENTRYNUMBER_I SearchEntry NumberIINT5_U0Integer25
35FROMDIVISIONCODE_I Searchfrom Division CodeSTR6_Payroll_CodeString86
36TODIVISIONCODE_I Searchto Division CodeSTR6_Payroll_CodeString86
37DIVISIONCODE_I SearchDivision CodeSTR6_Payroll_CodeString86
38FROMEMPLOYEEID_I Searchfrom Employee IDSTR15_Employee_IDString1615
39TOEMPLOYEEID_I Searchto Employee IDSTR15_Employee_IDString1615
40EMPID_I SearchEmp IDSTR15_Employee_ID_IString1615
41FROMENTRYNUMBER_I Searchfrom Entry NumberIINT5_U0Integer25
42TOENTRYNUMBER_I Searchto Entry NumberIINT5_U0Integer25
43FROMFIRSTNAME_I Searchfrom First NameSTR15_IString1615
44TOFIRSTNAME_I Searchto First NameSTR15_IString1615
45FFIRSTNAME_I SearchFFirst NameSTR15_IString1615
46ETHNICORIGIN_I SearchIEthnic OriginIDDL_Ethnic_OriginInteger20
47FROMISSN_I Searchfrom ISSNSTR15_Social_Security_NumberString1615
48TOISSN_I Searchto ISSNSTR15_Social_Security_NumberString1615
49SSN_I SearchISSNSTR15_Social_Security_NumberString1615
50FROMLASTNAME_I Searchfrom Last NameSTR20String2220
51TOLASTNAME_I Searchto Last NameSTR20String2220
52LLASTNAME_I SearchLLast NameSTR20String2220
53FROMPOSITIONCODE_I Searchfrom Position CodeSTR6_Payroll_CodeString86
54TOPOSITIONCODE_I Searchto Position CodeSTR6_Payroll_CodeString86
55POSITIONCODE_I SearchPosition CodeSTR6_Payroll_CodeString86
56FROMTIMECODE_I Searchfrom Time CodeSTR6_Payroll_CodeString86
57TOTIMECODE_I Searchto Time CodeSTR6_Payroll_CodeString86
58TIMECODE_I SearchTime CodeSTR6_Payroll_CodeString86
59INCINEMP SearchInclude Inactive EmployeesCB_Include_Inactive_EmployeesBoolean20
60RESID SearchResidID_INTInteger24
61DEX_ROW_ID Searchintint1010

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.

Leave a Reply

Your email address will not be published. Required fields are marked *