UPR10303 - Payroll Transaction Audit | Prospr - Dynamics GP Table Reference

UPR10303 - Payroll Transaction Audit

Query Builder

Select * from UPR10303

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
BACHNUMB	Batch Number	String	16	View
EMPLOYID	Employee ID	String	16	View
COMPTRTP	Computer TRX Type	Integer	2	View
UPRTRXCD	UPR TRX Code	String	8	View
TRXAUFLG_1	TRX Audit Flag[1]	Boolean	2	View
TRXAUFLG_2	TRX Audit Flag[2]	Boolean	2	View
TRXAUFLG_3	TRX Audit Flag[3]	Boolean	2	View
TRXAUFLG_4	TRX Audit Flag[4]	Boolean	2	View
TRXAUFLG_5	TRX Audit Flag[5]	Boolean	2	View
TRXAUFLG_6	TRX Audit Flag[6]	Boolean	2	View
TRXAUFLG_7	TRX Audit Flag[7]	Boolean	2	View
TRXAUFLG_8	TRX Audit Flag[8]	Boolean	2	View
TRXAUFLG_9	TRX Audit Flag[9]	Boolean	2	View
TRXAUFLG_10	TRX Audit Flag[10]	Boolean	2	View
TRXBEGDT	TRX Beginning Date	Date	4	View
TRXENDDT	TRX Ending Date	Date	4	View
TRXHRUNT	TRX Hours/Units	Long Integer	4	View
PAYRTAMT	Pay Rate Amount	Currency	10	View
HRLYPYRT	Hourly Pay Rate	Currency	10	View
VARDBAMT	Variable Ded/Ben Amount	Currency	10	View
VARDBPCT	Variable Ded/Ben Percent	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
WRKRCOMP	Workers Comp	String	8	View
DAYSWRDK	Days Worked	Long Integer	4	View
SUTASTAT	Suta State	String	4	View
WKSWRKD	Weeks Worked	Long Integer	4	View
SHFTPREM	Shift Premium	Currency	10	View
SALCHG	Salary Change	Integer	2	View