Payroll Report Options (UPR70500)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Report Options
Physical Name: UPR70500
Technical Name: UPR_Options_ROPT

Group Display Name: Payroll Report Options
Group Technical Name: Payroll Report Options

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1FINRPTNM SearchFinancial Report NameSTR30String3230
2PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean20
3PRNTTYPE SearchPrint TypeGBInteger20
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
5INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
6PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
7PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
8PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
9IFFILXST SearchIf File ExistingGBInteger20
10FILEXPNM SearchFile Export NameSTR255String256255
11EXPTTYPE SearchExport TypeINTInteger20
12RPTGRIND SearchReport Group IndexINTInteger20
13RTPACHIN SearchReport Palette Choice IndexINTInteger20
14RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
15SORTBY SearchSort ByDDL_Sort_ByInteger20
16MTHSLCTD SearchMonth SelectedMonthInteger20
17AUCTRLCD SearchAudit Control CodeSTR13_LBAUString1413
18INCINEMP SearchInclude Inactive EmployeesCB_Include_Inactive_EmployeesBoolean20
19SFUTASUT SearchStart FUTA/SUTASTR3_Futa/SutaString43
20STTACNCD SearchStart Audit Control CodeSTR13_LBAUString1413
21STTEMPID SearchStart Employee IDSTR15_Employee_IDString1615
22STTEMNAM SearchStart Employee NameSTR20String2220
23STRTDEPT SearchStart DepartmentSTR6_Payroll_CodeString86
24STRTPYCD SearchStart Pay CodeSTR6_Payroll_CodeString86
25STTDEDCD SearchStart Deduction CodeSTR6_Payroll_CodeString86
26STTBFTCD SearchStart Benefit CodeSTR6_Payroll_CodeString86
27STTLTXCD SearchStart Local Tax CodeSTR6_Payroll_CodeString86
28STTSTXCD SearchStart State Tax CodeSTR2_State_CodeString42
29STTJBTIT SearchStart Job TitleSTR6_Payroll_CodeString86
30STCHKNUM SearchStart Check NumberSTR20String2220
31STRTDATE SearchStart DateDTDate48
32STRTPYDT SearchStart Pay DateDT6Date46
33STPSTDDT SearchStart Posted DateDTDate48
34STTEMPCL SearchStart Employee ClassSTR15_Employee_ClassString1615
35STPRTKDT SearchStart Payroll Token DateDDL_Payroll_DatesInteger20
36STTLOCID SearchStart Location IDSTR15_Location_IDString1615
37STRTSPRVSRCD SearchStart Supervisor CodeSTR6_UString86
38ENAUCNCD SearchEnd Audit Control CodeSTR13_LBAUString1413
39EFUTASUT SearchEnd FUTA/SUTASTR3_Futa/SutaString43
40ENDEMPL SearchEnd Employee IDSTR15_Employee_IDString1615
41ENEMPNAM SearchEnd Employee NameSTR20String2220
42ENDDEPT SearchEnd DepartmentSTR6_Payroll_CodeString86
43ENDPAYCD SearchEnd Pay CodeSTR6_Payroll_CodeString86
44ENDEDCCD SearchEnd Deduction CodeSTR6_Payroll_CodeString86
45ENBNFTCD SearchEnd Benefit CodeSTR6_Payroll_CodeString86
46ELCLTXCD SearchEnd Local Tax CodeSTR6_Payroll_CodeString86
47ENSTTXCD SearchEnd State Tax CodeSTR2_State_CodeString42
48ENJBTITL SearchEnd Job TitleSTR6_Payroll_CodeString86
49ENCHKNUM SearchEnd Check NumberSTR20String2220
50ENDDATE SearchEnd DateDTDate48
51ENDPAYDT SearchEnd Pay DateDT6Date46
52ENPSTDDT SearchEnd Posted DateDTDate48
53ENEMPCLS SearchEnd Employee ClassSTR15_Employee_ClassString1615
54EPRTKNDT SearchEnd Payroll Token DateDDL_Payroll_DatesInteger20
55ENDLOCID SearchEnd Location IDSTR15_Location_IDString1615
56ENDSPRVSRCD SearchEnd Supervisor CodeSTR6_UString86
57SEGSRTBY SearchSegment Sort ByINT1Integer21
58STTACNUM SearchStart Account NumberAccount_NumberComposite 8080
59STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
60STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
61STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
62STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
63STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
64STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
65STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
66STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
67STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
68STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
69EACCNBR SearchEnd Account NumberAccount_NumberComposite 8080
70EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
71EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
72EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
73EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
74EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
75EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
76EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
77EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
78EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
79EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
80RANGEBY SearchRange ByINTInteger20
81EMPLINFO SearchEmployee InformationCB_Employee_InformationBoolean20
82EMPLSUMM SearchEmployee SummaryCB_Employee_SummaryBoolean20
83PAYCODES SearchPay CodesCB_Pay_CodesBoolean20
84DEDUCTNS SearchDeductionsCB_DeductionsBoolean20
85BENEFITS SearchBenefitsCB_BenefitsBoolean20
86TAXINFOR SearchTax InformationCB_Tax_InformationBoolean20
87STATETAX SearchState TaxCB_State_TaxBoolean20
88LOCALTX1 SearchLocal Tax-1CB_Local_TaxBoolean20
89YEAR1 SearchYearYearInteger24
90DEX_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 *