Table name for Employee Location field?

(0) Share

Report

Posted on by Community Member

I know that the table named CPY10100 have ALMOST all employee information. But the Location field is not there. The Location field is located on the main Employee creation dialog right under the Position field.

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Lyn Barr 1 on at

Like (1)

Report

RE: Table name for Employee Location field?

Your table structure may be different, because I assume you are using Canadian payroll, however, the location ID field (LOCATNID) should be in the PAYROLL MASTER table. In my database, that is table UPR00100.

If you go to Microsoft Dynamics GP >> Tools >> Resource Descriptions >> Tables, you should be able to find the relevant table. Begin by clicking the ellipse button (looks like three dots ...) to open the TABLE NAMES lookup.

Next, change your "Series" to PAYROLL. You can change the "View by" option to whatever is easiest for you. I usually use Table Physical Name but you may prefer the Display Name.

Once you find the table you think is correct, you can double-click it so that it loads into the "Table Descriptions" window. This will show a list of every field in the table.

These two screens are extremely helpful when trying to understand the table structure of Dynamics GP.

Was this reply helpful? Yes No