UPR10302 - Payroll Transactions | Prospr - Dynamics GP Table Reference

UPR10302 - Payroll Transactions

Query Builder

Select * from UPR10302

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
COMPTRNM	Computer TRX Number	Long Integer	4	View
BACHNUMB	Batch Number	String	16	View
EMPLOYID	Employee ID	String	16	View
COMPTRTP	Computer TRX Type	Integer	2	View
SALCHG	Salary Change	Integer	2	View
UPRTRXCD	UPR TRX Code	String	8	View
TRXBEGDT	TRX Beginning Date	Date	4	View
TRXENDDT	TRX Ending Date	Date	4	View
TRXHRUNT	TRX Hours/Units	Long Integer	4	View
HRLYPYRT	Hourly Pay Rate	Currency	10	View
PAYRTAMT	Pay Rate Amount	Currency	10	View
VARDBAMT	Variable Ded/Ben Amount	Currency	10	View
VARDBPCT	Variable Ded/Ben Percent	Long Integer	4	View
RECEIPTS	Receipts	Currency	10	View
DAYSWRDK	Days Worked	Long Integer	4	View
WKSWRKD	Weeks Worked	Long Integer	4	View
DEPRTMNT	Department	String	8	View
JOBTITLE	Job Title	String	8	View
STATECD	State Code	String	4	View
LOCALTAX	Local Tax	String	8	View
SUTASTAT	Suta State	String	4	View
WRKRCOMP	Workers Comp	String	8	View
LASTUSER	Last User	String	16	View
LSTDTEDT	Last Date Edited	Date	4	View
TRXSORCE	TRX Source	String	14	View
DOCTYPE	Document Type	Integer	2	View
VOIDED	Voided	Boolean	2	View
NOTEINDX	Note Index	Currency	10	View
INADDNTOSAL	In Addition To Salary	Boolean	2	View
SHFTCODE	Shift Code	String	8	View
SHFTPREM	Shift Premium	Currency	10	View
JOBNUMBR	Job Number	String	18	View
UNIONCD	Union Code	String	8	View