UPR00111 - Payroll Master Dependent | Prospr - Dynamics GP Table Reference

UPR00111 - Payroll Master Dependent

Query Builder

Select * from UPR00111

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
SEQNUMBR	Sequence Number	Long Integer	4	View
RELATIONSHIP	Relationship	Integer	2	View
COMMENTSTR20	CommentStr20	String	22	View
FRSTNAME	First Name	String	16	View
MIDDLEINITIAL	Middle Initial	String	2	View
LASTNAME	Last Name	String	22	View
DEPENDENTSSN	Dependent SSN	String	16	View
GENDER	Gender 1 is male 2 is female 3 is N/A.	Integer	2	View
BRTHDATE	Birth Date	Date	4	View
HOMEPHONE	Home Phone	String	22	View
WORKPHONE	Work Phone	String	22	View
EXTENSION	Extension	String	6	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
FLTMSTDNTCB	Full Time Student CB	Boolean	2	View