UPR10209 - Payroll Work Post | Prospr - Dynamics GP Table Reference

UPR10209 - Payroll Work Post

Select * from UPR10209

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
EMPLOYID	Employee ID	String	16	View
PYRNTYPE	Pay Run Type	Integer	2	View
PYRLRTYP	Payroll Record Type 1 = Regular Pay Codes 2 = Deductions 3 = Benefits 4 = Taxes 5 = LocalTax	Integer	2	View
TRXNUMBER	TRX Number	Long Integer	4	View
SEQNUMBR	Sequence Number	Long Integer	4	View
ACTINDX	Account Index	Long Integer	4	View
AMNTOPST	Amount To Post	Currency	10	View
CHEKNMBR	Check Number	String	22	View
POSTEDDT	Posted Date	Date	4	View
DEPRTMNT	Department	String	8	View
JOBTITLE	Job Title	String	8	View
PAYROLCD	Payroll Code	String	8	View
UPRACTYP	UPR Account Type	Integer	2	View
PYADNMBR	Payment/Adjustment Number	Long Integer	4	View