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 TypeLength
1FINRPTNM SearchFinancial Report NameSTR30String30
2PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean0
3PRNTTYPE SearchPrint TypeGBInteger0
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
5INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
6PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
7PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
8PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
9IFFILXST SearchIf File ExistingGBInteger0
10FILEXPNM SearchFile Export NameSTR255String255
11EXPTTYPE SearchExport TypeINTInteger0
12RPTGRIND SearchReport Group IndexINTInteger0
13RTPACHIN SearchReport Palette Choice IndexINTInteger0
14RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
15SORTBY SearchSort ByDDL_Sort_ByInteger0
16MTHSLCTD SearchMonth SelectedMonthInteger0
17AUCTRLCD SearchAudit Control CodeSTR13_LBAUString13
18INCINEMP SearchInclude Inactive EmployeesCB_Include_Inactive_EmployeesBoolean0
19SFUTASUT SearchStart FUTA/SUTASTR3_Futa/SutaString3
20STTACNCD SearchStart Audit Control CodeSTR13_LBAUString13
21STTEMPID SearchStart Employee IDSTR15_Employee_IDString15
22STTEMNAM SearchStart Employee NameSTR20String20
23STRTDEPT SearchStart DepartmentSTR6_Payroll_CodeString6
24STRTPYCD SearchStart Pay CodeSTR6_Payroll_CodeString6
25STTDEDCD SearchStart Deduction CodeSTR6_Payroll_CodeString6
26STTBFTCD SearchStart Benefit CodeSTR6_Payroll_CodeString6
27STTLTXCD SearchStart Local Tax CodeSTR6_Payroll_CodeString6
28STTSTXCD SearchStart State Tax CodeSTR2_State_CodeString2
29STTJBTIT SearchStart Job TitleSTR6_Payroll_CodeString6
30STCHKNUM SearchStart Check NumberSTR20String20
31STRTDATE SearchStart DateDTDate8
32STRTPYDT SearchStart Pay DateDT6Date6
33STPSTDDT SearchStart Posted DateDTDate8
34STTEMPCL SearchStart Employee ClassSTR15_Employee_ClassString15
35STPRTKDT SearchStart Payroll Token DateDDL_Payroll_DatesInteger0
36STTLOCID SearchStart Location IDSTR15_Location_IDString15
37STRTSPRVSRCD SearchStart Supervisor CodeSTR6_UString6
38ENAUCNCD SearchEnd Audit Control CodeSTR13_LBAUString13
39EFUTASUT SearchEnd FUTA/SUTASTR3_Futa/SutaString3
40ENDEMPL SearchEnd Employee IDSTR15_Employee_IDString15
41ENEMPNAM SearchEnd Employee NameSTR20String20
42ENDDEPT SearchEnd DepartmentSTR6_Payroll_CodeString6
43ENDPAYCD SearchEnd Pay CodeSTR6_Payroll_CodeString6
44ENDEDCCD SearchEnd Deduction CodeSTR6_Payroll_CodeString6
45ENBNFTCD SearchEnd Benefit CodeSTR6_Payroll_CodeString6
46ELCLTXCD SearchEnd Local Tax CodeSTR6_Payroll_CodeString6
47ENSTTXCD SearchEnd State Tax CodeSTR2_State_CodeString2
48ENJBTITL SearchEnd Job TitleSTR6_Payroll_CodeString6
49ENCHKNUM SearchEnd Check NumberSTR20String20
50ENDDATE SearchEnd DateDTDate8
51ENDPAYDT SearchEnd Pay DateDT6Date6
52ENPSTDDT SearchEnd Posted DateDTDate8
53ENEMPCLS SearchEnd Employee ClassSTR15_Employee_ClassString15
54EPRTKNDT SearchEnd Payroll Token DateDDL_Payroll_DatesInteger0
55ENDLOCID SearchEnd Location IDSTR15_Location_IDString15
56ENDSPRVSRCD SearchEnd Supervisor CodeSTR6_UString6
57SEGSRTBY SearchSegment Sort ByINT1Integer1
58STTACNUM SearchStart Account NumberAccount_NumberComposite 80
59STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
60STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
61STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
62STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
63STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
64STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
65STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
66STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
67STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
68STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
69EACCNBR SearchEnd Account NumberAccount_NumberComposite 80
70EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
71EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
72EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
73EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
74EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
75EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
76EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
77EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
78EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
79EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
80RANGEBY SearchRange ByINTInteger0
81EMPLINFO SearchEmployee InformationCB_Employee_InformationBoolean0
82EMPLSUMM SearchEmployee SummaryCB_Employee_SummaryBoolean0
83PAYCODES SearchPay CodesCB_Pay_CodesBoolean0
84DEDUCTNS SearchDeductionsCB_DeductionsBoolean0
85BENEFITS SearchBenefitsCB_BenefitsBoolean0
86TAXINFOR SearchTax InformationCB_Tax_InformationBoolean0
87STATETAX SearchState TaxCB_State_TaxBoolean0
88LOCALTX1 SearchLocal Tax-1CB_Local_TaxBoolean0
89YEAR1 SearchYearYearInteger4
90DEX_ROW_ID Searchintint10

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 *