UPR10203 - Payroll Work Pay Code | Prospr - Dynamics GP Table Reference

UPR10203 - Payroll Work Pay Code

Query Builder

Select * from UPR10203

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
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
PAYRCORD	Pay Record	String	8	View
PRCSSQNC	Process Sequence	Integer	2	View
PAYTYPE	Pay Type 1. Hourly 2. Salary 3. Piecework 4. Commission 5. Business Expense 6. Overtime 7. Double Time 8. Vacation 9. Sick 10. Holiday 11. Pension 12. Other 13. Earned Income Credit 14. Charged Tips 15. Reported Tips 16. Minimum Wage Balance	Integer	2	View
BSPAYRCD	Base Pay Record	String	8	View
BSPAYTYP	Base Pay Type	Integer	2	View
BSDONRTE	Based On Rate	Currency	10	View
PAYRTAMT	Pay Rate Amount	Currency	10	View
PAYUNIT	Pay Unit	String	26	View
PAYUNPER	Pay Unit Period	Integer	2	View
PAYPEROD	Pay Period	Integer	2	View
PAYPRPRD	Pay Per Period	Currency	10	View
PAYADVNC	Pay Advance	Currency	10	View
TIMETYPE_I	Time Type	Integer	2	View
TIMEAVAILABLE	Time Available	Currency	10	View
ACRUVACN	Accrue Vacation	Boolean	2	View
ACRUSTIM	Accrue Sick Time	Boolean	2	View
RPTASWGS	Report As Wages	Boolean	2	View
DAYSWRDK	Days Worked	Long Integer	4	View
WKSWRKD	Weeks Worked	Long Integer	4	View
RECEIPTS	Receipts	Currency	10	View
TipType	Tip Type	Integer	2	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
UNTSTOPY	Units To Pay	Currency	10	View
ADJUNITS	Adjusted Units	Currency	10	View
TOTALPAY	Total Pay	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
SHFTCODE	Shift Code	String	8	View
SHFTPREM	Shift Premium	Currency	10	View

UPR10203 - Payroll Work Pay Code

Query Builder

Customer Service

Information

My Account

Contact Us