Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Ranger 6/12/2018 3:21:55 PM

UPR00111 relationship enum

hi,

is there a setup table (lookup table) for "relationship" on the UPR00111 table?

I'm re-writing my employee self-service portal in MVC and need to know where that number comes from.

The weird thing is, that on the Contacts table (UPR00113), the relationship field (named "emergencyrelation") has text in it (like "wife", "self").  so not sure why the field lookup would change from contacts to dependents.

However, the dependents table currently only has a value of "7", which is "self" on every record, which I suppose is for employee benefit purposes. 

But, If I want to allow the employee to add new dependents, then go to our insurance provider to auto-update new kids or whatever, it would be nice to know the lookup.

thanks,

george

Version: GP 2013
Section: .NET Development, Dynamics GP








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables