UPR10204 - Payroll Work Deduction | Prospr - Dynamics GP Table Reference

UPR10204 - Payroll Work Deduction

Query Builder

Select * from UPR10204

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
DEDUCTON	Deduction	String	8	View
TXSHANTY	Tax Sheltered Annuity	Boolean	2	View
DEDNSQNC	Deduction Sequence	Integer	2	View
VARDEDTN	Variable Deduction	Boolean	2	View
VARDBAMT	Variable Ded/Ben Amount	Currency	10	View
VARDBPCT	Variable Ded/Ben Percent	Long Integer	4	View
DEDNFREQ	Deduction Frequency	Integer	2	View
TTLDEDTN	Total Deduction	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
DEDNMTHD	Deduction Method	Integer	2	View
PRCSSQNC	Process Sequence	Integer	2	View
SEQCOUNT	Sequence Count	Long Integer	4	View
SEQUENCESUM	Sequence Sum	Currency	10	View
CALCCHKWRN	Calc Check Warnings	Long Integer	4	View
ATTEMPTEDAMT	Attempted Amount	Currency	10	View
SPLITMTHD	Split Method	Integer	2	View
MAXAMOUNT	Maximum Amount	Currency	10	View
BASEDONWAGES	Based On Wages	Currency	10	View