Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR00113
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Payroll Master Contacts Group Display Name: Payroll Employee Master
Physical Name: UPR00113
Technical Name: uprMstrContacts
Group Technical Name: Payroll Employee Master
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | EMPLOYID ![]() | Employee ID | STR15_Employee_ID | String | 15 | |
2 | SEQNUMBR ![]() | Sequence Number | LI_Sequence_Number | Long Integer | 10 | |
3 | EMERGENCYCONTACT ![]() | Emergency Contact | STR60 | String | 60 | |
4 | EMERGENCYRELATION ![]() | Emergency Relation | STR10 | String | 10 | |
5 | ADDRESS1 ![]() | Address 1 | STR60 | String | 60 | |
6 | CITY ![]() | City | STR35 | String | 35 | |
7 | STATE ![]() | State | STR30_State | String | 29 | |
8 | ZIPCODE ![]() | Zip Code | STR10 | String | 10 | |
9 | HOMEPHONE ![]() | Home Phone | STR10_Phone | String | 10 | |
10 | WORKPHONE ![]() | Work Phone | STR10_Phone | String | 10 | |
11 | EXTENSION ![]() | Extension | STR4 | String | 4 | |
12 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |