Payroll Master Contacts (UPR00113)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR00113

Display Name: Payroll Master Contacts
Physical Name: UPR00113
Technical Name: uprMstrContacts

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	EMPLOYID	Employee ID	STR15_Employee_ID	String	16	15
2	SEQNUMBR	Sequence Number	LI_Sequence_Number	Long Integer	4	10
3	EMERGENCYCONTACT	Emergency Contact	STR60	String	62	60
4	EMERGENCYRELATION	Emergency Relation	STR10	String	12	10
5	ADDRESS1	Address 1	STR60	String	62	60
6	CITY	City	STR35	String	36	35
7	STATE	State	STR30_State	String	30	29
8	ZIPCODE	Zip Code	STR10	String	12	10
9	HOMEPHONE	Home Phone	STR10_Phone	String	22	10
10	WORKPHONE	Work Phone	STR10_Phone	String	22	10
11	EXTENSION	Extension	STR4	String	6	4
12	DEX_ROW_ID		int	int	10	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.