Payroll Address Master (UPR00102)

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

Display Name: Payroll Address Master
Physical Name: UPR00102
Technical Name: uprMstrAddress

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
2	ADRSCODE	Address Code	String	STR15_Address_Code	15
3	ADDRESS1	Address 1	String	STR60	60
4	ADDRESS2	Address 2	String	STR60	60
5	ADDRESS3	Address 3	String	STR60	60
6	CITY	City	String	STR35	35
7	STATE	State	String	STR30_State	29
8	ZIPCODE	Zip Code	String	STR10	10
9	COUNTY	County	String	STR60	60
10	COUNTRY	Country	String	STR60	60
11	PHONE1	Phone 1	String	Phone_Number	14
12	PHONE2	Phone 2	String	Phone_Number	14
13	PHONE3	Phone 3	String	Phone_Number3	14
14	FAX	Fax	String	STR14_FAX	14
15	Foreign_Address	Foreign Address	Boolean	CB_Foreign_Address	0
16	Foreign_StateProvince	Foreign State/Province	String	STR23	23
17	Foreign_Postal_Code	Foreign Postal Code	String	STR15_LBAU	15
18	CCode	Country Code	String	STR6_VAT	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['Payroll Address Master'].CCode AS 'Payroll Address Master-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM UPR00102 AS ['Payroll Address Master'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['Payroll Address Master'].CCode = ['VAT Country Code MSTR'].CCode