The windows and the tables that are updated when you process a payrun in Payroll in Microsoft Dynamics GP

INTRODUCTION
This article describes the windows and the tables that are updated in Payroll in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains after you process a payrun.
More information
If you are running Microsoft SQL Server, you can view the table information in SQL Query Analyzer. You can run the following sample Select statement in SQL Query Analyzer against the company database to view the table information.
SELECT * FROM UPR00900

The following report is returned.

Note The Window/report that contains information column displays the window in which the information is displayed. Use the Physical name column for the table name.
Table name			         Window/report that contains information		              Physical name----------------------------------------------------------------------------------------------------------------Payroll Employee Summary             Cards | Payroll | Summary                                     UPR00900Payroll Employee Tips Summary        Cards | Payroll | Summary | Tips Summary                      UPR00901Payroll Pay Code Summary             Cards | Payroll | Pay Code | Summary                          UPR30301Payroll Pay History                  Reports | Payroll | History | Employee Pay History            UPR30300                                               OR                                     Cards | Payroll | Pay Code | HistoryPayroll Deduction Master             Cards | Payroll | Deduction | Summary                         UPR30301Payroll Benefit Master               Cards | Payroll | Benefit | Summary                           UPR30301Payroll State Tax Summary            Cards | Payroll | State Tax | Summary                         UPR30301Payroll Local Tax Master             Cards | Payroll | Local Tax | Summary                         UPR30301Payroll Tax Liability                Tools | Utilities | Payroll | Edit Liabilities                UPR30200Payroll Tax Liability                GP 10.0 | Tools | Utilities | Payroll | Edit Liabilities      UPR30200Payroll Distribution History         Reports | Payroll | History | Distribution Breakdown History  UPR30401Payroll Check History                Inquiry | Payroll | Check                                     UPR30100Payroll Transaction History          Inquiry | Payroll | Transaction                               UPR30300Payroll Distribution History Header  Reports | Payroll | History | Distribution Breakdown History  UPR30400
References
This article was TechKnowledge ID 29906.
Properties

Article ID: 859151 - Last Review: 12/14/2015 18:33:00 - Revision: 8.0

Microsoft Dynamics GP 2015, Microsoft Dynamics GP 2013, Microsoft Dynamics GP 2010, Microsoft Dynamics GP 10.0, Microsoft Dynamics GP 9.0

  • kbnosurvey kbmbsmigrate KB859151
Feedback