Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Payroll Table Definitions/Column Descriptions in GP 10.0 SDK?

Posted on by 55

Hello.  I'm looking for the Payroll table definitions with the column descriptions for GP 10.0.  I've downloaded the 10.0 SDK but I can't find the payroll information I need.  I'm specifically looking for information on the UPR_Transaction_HIST (UPR30300) table.

I'm looking for something similar to the hratt.doc which is for Human Resources.  This document gives a table description then provides a description for every column in the table.

Below is an example.

If searched through the 10.0 SDK but can't seem to find it but I might be over looking it.  Does anybody know what file it is located in or if there is another source I should be checking?

Thanks in advance!

Table: TA_TRX_Detail                                        TATX1030

This file contains attendance transactions - records of what hours an employee worked or used and when.


Field descriptions: (Required fields appear in bold and are underlined)


TRX      This field indicates the transaction number for this record.  The next available transaction number can be found by incrementing the value of the ‘TRX’ field in the TA_TRX_Next table.

Emp ID     This field identifies the employee.  This employee ID must also exist in the UPR_MSTR table.

Time Code    This field identifies the time code.  This ‘Time Code’ must also exist in the TA_SETP_Types table.

*This post is locked for comments

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Re: Payroll Table Definitions/Column Descriptions in GP 10.0 SDK?

    Have you looked into the SDK files that are installed on your drive ? there is a file called UprTrx.doc and HR-TimeAttendanceAPI.doc that should provide you a fairly good idea about the Payroll process...

  • cctbrent Profile Picture
    cctbrent 55 on at
    Re: Payroll Table Definitions/Column Descriptions in GP 10.0 SDK?

    Thank you for the information.  

    This isn't everything I was hoping for but it seems to be the only thing available.  It at least gives me a readable column name but not really any details on what the column is used for.  

    Thanks again.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Payroll Table Definitions/Column Descriptions in GP 10.0 SDK?

    you can always go to Tools > Resource Descriptions > Tables

    Leave Microsoft Dynamics GP as the product

    Choose Payroll as Series

    order by Physical Name

    Scroll down to UPR30300

    then double click on it and you will have the field descriptions as well order and field type as well other information

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans