Payroll Address Master – Archive (UPRA0102)

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

Display Name: Payroll Address Master - Archive
Physical Name: UPRA0102
Technical Name: Archive_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 - Archive'].CCode AS 'Payroll Address Master - Archive-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM UPRA0102 AS ['Payroll Address Master - Archive'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['Payroll Address Master - Archive'].CCode = ['VAT Country Code MSTR'].CCode