UPR00902 - Payroll Employee Fiscal Summary | Prospr - Dynamics GP Table Reference

UPR00902 - Payroll Employee Fiscal Summary

Query Builder

Select * from UPR00902

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
YEAR1	Year	Integer	2	View
PERIODID	Period ID	Integer	2	View
LPCHKNUM	Last Paycheck Number	String	22	View
LSTPCKDT	Last Paycheck Date	Date	4	View
LPCHKAMT	Last Paycheck Amount	Currency	10	View
Gross_Wages_Fiscal	Gross Wages Fiscal	Currency	10	View
Federal_Withholding_Fisc	Federal Withholding Fiscal	Currency	10	View
FICASS_Wages_Fiscal	FICA/SS Wages Fiscal	Currency	10	View
FICAMED_Wages_Fiscal	FICA/MED Wages Fiscal	Currency	10	View
FICASS_Withholding_Fisca	FICA/SS Withholding Fiscal	Currency	10	View
FICAMED_Withholding_Fisc	FICA/MED Withholding Fiscal	Currency	10	View
Suta_Wages_Fiscal	Suta Wages Fiscal	Currency	10	View
Futa_Wages_Fiscal	Futa Wages Fiscal	Currency	10	View
Net_Wages_Fiscal	Net Wages Fiscal	Currency	10	View
Federal_Wages_Fiscal	Federal Wages Fiscal	Currency	10	View