UPR00900 - Payroll Employee Summary | Prospr - Dynamics GP Table Reference

UPR00900 - Payroll Employee Summary

Query Builder

Select * from UPR00900

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
LPCHKNUM	Last Paycheck Number	String	22	View
LSTPCKDT	Last Paycheck Date	Date	4	View
LPCHKAMT	Last Paycheck Amount	Currency	10	View
GROSWAGS_1	Gross Wages[1]	Currency	10	View
GROSWAGS_2	Gross Wages[2]	Currency	10	View
GROSWAGS_3	Gross Wages[3]	Currency	10	View
GROSWAGS_4	Gross Wages[4]	Currency	10	View
GROSWAGS_5	Gross Wages[5]	Currency	10	View
GROSWAGS_6	Gross Wages[6]	Currency	10	View
GROSWAGS_7	Gross Wages[7]	Currency	10	View
GROSWAGS_8	Gross Wages[8]	Currency	10	View
GROSWAGS_9	Gross Wages[9]	Currency	10	View
GROSWAGS_10	Gross Wages[10]	Currency	10	View
GROSWAGS_11	Gross Wages[11]	Currency	10	View
GROSWAGS_12	Gross Wages[12]	Currency	10	View
FDWTHLDG_1	Federal Withholding[1]	Currency	10	View
FDWTHLDG_2	Federal Withholding[2]	Currency	10	View
FDWTHLDG_3	Federal Withholding[3]	Currency	10	View
FDWTHLDG_4	Federal Withholding[4]	Currency	10	View
FDWTHLDG_5	Federal Withholding[5]	Currency	10	View
FDWTHLDG_6	Federal Withholding[6]	Currency	10	View
FDWTHLDG_7	Federal Withholding[7]	Currency	10	View
FDWTHLDG_8	Federal Withholding[8]	Currency	10	View
FDWTHLDG_9	Federal Withholding[9]	Currency	10	View
FDWTHLDG_10	Federal Withholding[10]	Currency	10	View
FDWTHLDG_11	Federal Withholding[11]	Currency	10	View
FDWTHLDG_12	Federal Withholding[12]	Currency	10	View
FICASSWG_1	FICA/Social Security Wages[1]	Currency	10	View
FICASSWG_2	FICA/Social Security Wages[2]	Currency	10	View
FICASSWG_3	FICA/Social Security Wages[3]	Currency	10	View
FICASSWG_4	FICA/Social Security Wages[4]	Currency	10	View
FICASSWG_5	FICA/Social Security Wages[5]	Currency	10	View
FICASSWG_6	FICA/Social Security Wages[6]	Currency	10	View
FICASSWG_7	FICA/Social Security Wages[7]	Currency	10	View
FICASSWG_8	FICA/Social Security Wages[8]	Currency	10	View
FICASSWG_9	FICA/Social Security Wages[9]	Currency	10	View
FICASSWG_10	FICA/Social Security Wages[10]	Currency	10	View
FICASSWG_11	FICA/Social Security Wages[11]	Currency	10	View
FICASSWG_12	FICA/Social Security Wages[12]	Currency	10	View
FICAMWGS_1	FICA/Medicare Wages[1]	Currency	10	View
FICAMWGS_2	FICA/Medicare Wages[2]	Currency	10	View
FICAMWGS_3	FICA/Medicare Wages[3]	Currency	10	View
FICAMWGS_4	FICA/Medicare Wages[4]	Currency	10	View
FICAMWGS_5	FICA/Medicare Wages[5]	Currency	10	View
FICAMWGS_6	FICA/Medicare Wages[6]	Currency	10	View
FICAMWGS_7	FICA/Medicare Wages[7]	Currency	10	View
FICAMWGS_8	FICA/Medicare Wages[8]	Currency	10	View
FICAMWGS_9	FICA/Medicare Wages[9]	Currency	10	View
FICAMWGS_10	FICA/Medicare Wages[10]	Currency	10	View
FICAMWGS_11	FICA/Medicare Wages[11]	Currency	10	View
FICAMWGS_12	FICA/Medicare Wages[12]	Currency	10	View
FICASSWH_1	FICA/Social Security Withholding[1]	Currency	10	View
FICASSWH_2	FICA/Social Security Withholding[2]	Currency	10	View
FICASSWH_3	FICA/Social Security Withholding[3]	Currency	10	View
FICASSWH_4	FICA/Social Security Withholding[4]	Currency	10	View
FICASSWH_5	FICA/Social Security Withholding[5]	Currency	10	View
FICASSWH_6	FICA/Social Security Withholding[6]	Currency	10	View
FICASSWH_7	FICA/Social Security Withholding[7]	Currency	10	View
FICASSWH_8	FICA/Social Security Withholding[8]	Currency	10	View
FICASSWH_9	FICA/Social Security Withholding[9]	Currency	10	View
FICASSWH_10	FICA/Social Security Withholding[10]	Currency	10	View
FICASSWH_11	FICA/Social Security Withholding[11]	Currency	10	View
FICASSWH_12	FICA/Social Security Withholding[12]	Currency	10	View
FICAMWDG_1	FICA/Medicare Withholding[1]	Currency	10	View
FICAMWDG_2	FICA/Medicare Withholding[2]	Currency	10	View
FICAMWDG_3	FICA/Medicare Withholding[3]	Currency	10	View
FICAMWDG_4	FICA/Medicare Withholding[4]	Currency	10	View
FICAMWDG_5	FICA/Medicare Withholding[5]	Currency	10	View
FICAMWDG_6	FICA/Medicare Withholding[6]	Currency	10	View
FICAMWDG_7	FICA/Medicare Withholding[7]	Currency	10	View
FICAMWDG_8	FICA/Medicare Withholding[8]	Currency	10	View
FICAMWDG_9	FICA/Medicare Withholding[9]	Currency	10	View
FICAMWDG_10	FICA/Medicare Withholding[10]	Currency	10	View
FICAMWDG_11	FICA/Medicare Withholding[11]	Currency	10	View
FICAMWDG_12	FICA/Medicare Withholding[12]	Currency	10	View
SUTAWAGS_1	Suta Wages[1]	Currency	10	View
SUTAWAGS_2	Suta Wages[2]	Currency	10	View
SUTAWAGS_3	Suta Wages[3]	Currency	10	View
SUTAWAGS_4	Suta Wages[4]	Currency	10	View
SUTAWAGS_5	Suta Wages[5]	Currency	10	View
SUTAWAGS_6	Suta Wages[6]	Currency	10	View
SUTAWAGS_7	Suta Wages[7]	Currency	10	View
SUTAWAGS_8	Suta Wages[8]	Currency	10	View
SUTAWAGS_9	Suta Wages[9]	Currency	10	View
SUTAWAGS_10	Suta Wages[10]	Currency	10	View
SUTAWAGS_11	Suta Wages[11]	Currency	10	View
SUTAWAGS_12	Suta Wages[12]	Currency	10	View
FUTAWAGS_1	Futa Wages[1]	Currency	10	View
FUTAWAGS_2	Futa Wages[2]	Currency	10	View
FUTAWAGS_3	Futa Wages[3]	Currency	10	View
FUTAWAGS_4	Futa Wages[4]	Currency	10	View
FUTAWAGS_5	Futa Wages[5]	Currency	10	View
FUTAWAGS_6	Futa Wages[6]	Currency	10	View
FUTAWAGS_7	Futa Wages[7]	Currency	10	View
FUTAWAGS_8	Futa Wages[8]	Currency	10	View
FUTAWAGS_9	Futa Wages[9]	Currency	10	View
FUTAWAGS_10	Futa Wages[10]	Currency	10	View
FUTAWAGS_11	Futa Wages[11]	Currency	10	View
FUTAWAGS_12	Futa Wages[12]	Currency	10	View
NETWAGES_1	Net Wages[1]	Currency	10	View
NETWAGES_2	Net Wages[2]	Currency	10	View
NETWAGES_3	Net Wages[3]	Currency	10	View
NETWAGES_4	Net Wages[4]	Currency	10	View
NETWAGES_5	Net Wages[5]	Currency	10	View
NETWAGES_6	Net Wages[6]	Currency	10	View
NETWAGES_7	Net Wages[7]	Currency	10	View
NETWAGES_8	Net Wages[8]	Currency	10	View
NETWAGES_9	Net Wages[9]	Currency	10	View
NETWAGES_10	Net Wages[10]	Currency	10	View
NETWAGES_11	Net Wages[11]	Currency	10	View
NETWAGES_12	Net Wages[12]	Currency	10	View
YEAR1	Year	Integer	2	View
Federal_Wages_1	Federal Wages[1]	Currency	10	View
Federal_Wages_2	Federal Wages[2]	Currency	10	View
Federal_Wages_3	Federal Wages[3]	Currency	10	View
Federal_Wages_4	Federal Wages[4]	Currency	10	View
Federal_Wages_5	Federal Wages[5]	Currency	10	View
Federal_Wages_6	Federal Wages[6]	Currency	10	View
Federal_Wages_7	Federal Wages[7]	Currency	10	View
Federal_Wages_8	Federal Wages[8]	Currency	10	View
Federal_Wages_9	Federal Wages[9]	Currency	10	View
Federal_Wages_10	Federal Wages[10]	Currency	10	View
Federal_Wages_11	Federal Wages[11]	Currency	10	View
Federal_Wages_12	Federal Wages[12]	Currency	10	View

UPR00900 - Payroll Employee Summary

Query Builder

Customer Service

Information

My Account

Contact Us