UPR10100 - Payroll Year End Header | Prospr - Dynamics GP Table Reference

UPR10100 - Payroll Year End Header

Select * from UPR10100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RPTNGYR	Reporting Year	Integer	2	View
EPRIDNBR	Employer ID Number	String	10	View
YENDCRTD	Year End Created	Boolean	2	View
ESTIDNBR	Employer State ID Number	String	22	View
LOCATNID	Location ID	String	16	View
CMPNYNAM	Company Name	String	66	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
INACW2RN	Inactives W-2 Run	Boolean	2	View
YEPRW2SK	Year End Print Regular W2 Sort Key	Integer	2	View
YPMQGEW2	Year End Print MQGE W2 Sort Key	Integer	2	View
YP1099RS	Year End Print 1099R Sort Key	Integer	2	View
FICASSTR	FICA/Social Security Tax Rate	Long Integer	4	View
FICASSWL	FICA/Social Security Wage Limit	Currency	10	View
TICAMTRT	FICA/Medicare Tax Rate	Long Integer	4	View
FICAMWLM	FICA/Medicare Wage Limit	Currency	10	View
EICMXWHG	EIC Maximum Withholding	Currency	10	View
Establishment_Type	Establishment Type	Integer	2	View
Establishment_Number	Establishment Number	String	6	View
Charged_Tips	Charged Tips	Currency	10	View
Charged_Receipts	Charged Receipts	Currency	10	View
Indirect_Tips	Indirect Tips	Currency	10	View
Direct_Tips	Direct Tips	Currency	10	View
RECEIPTS	Receipts	Currency	10	View
Directly_Tipped	Directly Tipped	Integer	2	View
Return_Type	Return Type	Integer	2	View
Reported_Tips	Reported Tips	Currency	10	View
ALOCTIPS	Allocated Tips	Currency	10	View
EmployerKind	Employer Kind	Integer	2	View