UPR10205 - Payroll Work Benefit | Prospr - Dynamics GP Table Reference

UPR10205 - Payroll Work Benefit

Query Builder

Select * from UPR10205

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DEPRTMNT	Department	String	8	View
JOBTITLE	Job Title	String	8	View
USERID	User ID	String	16	View
PYRNTYPE	Pay Run Type	Integer	2	View
EMPLOYID	Employee ID	String	16	View
TRXNUMBER	TRX Number	Long Integer	4	View
BENEFIT	Benefit	String	8	View
TAXABLE	Taxable	Boolean	2	View
VARBENFT	Variable Benefit	Boolean	2	View
VARDBAMT	Variable Ded/Ben Amount	Currency	10	View
VARDBPCT	Variable Ded/Ben Percent	Long Integer	4	View
BNFTFREQ	Benefit Frequency	Integer	2	View
TOTLBNFT	Total Benefit	Currency	10	View
AMTBOTIP	Amount Based On Tips	Currency	10	View
BCHSOURC	Batch Source	String	16	View
PRTRXSRC	Payroll TRX Source	Long Integer	4	View
LASTUSER	Last User	String	16	View
LSTDTEDT	Last Date Edited	Date	4	View
TRXBEGDT	TRX Beginning Date	Date	4	View
TRXENDDT	TRX Ending Date	Date	4	View
BLDCHWRG	Build Check Warnings	Long Integer	4	View
BLDCHERR	Build Check Errors	Long Integer	4	View
BNFTMTHD	Benefit Method	Integer	2	View
PRCSSQNC	Process Sequence	Integer	2	View