UPR10308 - Payroll Manual Check Detail | Prospr - Dynamics GP Table Reference

UPR10308 - Payroll Manual Check Detail

Query Builder

Select * from UPR10308

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
MLCHKTYP	Manual Check Type	Integer	2	View
PYADNMBR	Payment/Adjustment Number	Long Integer	4	View
EMPLOYID	Employee ID	String	16	View
MLTRXNBR	Manual TRX Number	Long Integer	4	View
MLTRXTYP	Manual TRX Type	Integer	2	View
UPRTRXCD	UPR TRX Code	String	8	View
TRXBEGDT	TRX Beginning Date	Date	4	View
TRXENDDT	TRX Ending Date	Date	4	View
HRLYPYRT	Hourly Pay Rate	Currency	10	View
MLTRXAMT	Manual TRX Amount	Currency	10	View
MLTRXHRS	Manual TRX Hours	Long Integer	4	View
TXBLWAGS	Taxable Wages	Currency	10	View
RECEIPTS	Receipts	Currency	10	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
SUTASTAT	Suta State	String	4	View
DAYSWRDK	Days Worked	Long Integer	4	View
WKSWRKD	Weeks Worked	Long Integer	4	View
LASTUSER	Last User	String	16	View
LSTDTEDT	Last Date Edited	Date	4	View
NOTEINDX	Note Index	Currency	10	View
SHFTCODE	Shift Code	String	8	View
SHFTPREM	Shift Premium	Currency	10	View
EFICAMT	EFIC Amount	Currency	10	View