gpUPRCPR - gptsCertUPR | Prospr - Dynamics GP Table Reference

gpUPRCPR - gptsCertUPR

Query Builder

Select * from gpUPRCPR

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
COMPTRNM	Computer TRX Number	Long Integer	4	View
JOBNUMBR	Job Number	String	18	View
TRXENDDT	TRX Ending Date	Date	4	View
EMPLOYID	Employee ID	String	16	View
HOURSWKD	Hours Worked	Long Integer	4	View
HRLYPYRT	Hourly Pay Rate	Currency	10	View
PYADNMBR	Payment/Adjustment Number	Long Integer	4	View
AUCTRLCD	Audit Control Code	String	14	View
TOTALPAY	Total Pay	Currency	10	View
DEPRTMNT	Department	String	8	View
JOBTITLE	Job Title	String	8	View
PAYRCORD	Pay Record	String	8	View
BRKFLD1	Break Field 1	Integer	2	View