UPR00102 - Payroll Address Master | Prospr - Dynamics GP Table Reference

UPR00102 - Payroll Address Master

Query Builder

Select * from UPR00102

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
ADRSCODE	Address Code	String	16	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
COUNTY	County	String	62	View
COUNTRY	Country	String	62	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE3	Phone 3	String	22	View
FAX	Fax	String	22	View
Foreign_Address	Foreign Address	Boolean	2	View
Foreign_StateProvince	Foreign State/Province	String	24	View
Foreign_Postal_Code	Foreign Postal Code	String	16	View
CCode	Country Code	String	8	View