UPR10208 - Payroll Work Check | Prospr - Dynamics GP Table Reference

UPR10208 - Payroll Work Check

Query Builder

Select * from UPR10208

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PRINTED	Printed	Boolean	2	View
VOIDED	Voided	Boolean	2	View
USERID	User ID	String	16	View
EMPLOYID	Employee ID	String	16	View
EMPLNAME	Employee Name	String	42	View
LASTNAME	Last Name	String	22	View
FRSTNAME	First Name	String	16	View
MIDLNAME	Middle Name	String	16	View
CHEKDATE	Check Date	Date	4	View
CHEKNMBR	Check Number	String	22	View
PYADNMBR	Payment/Adjustment Number	Long Integer	4	View
DEPRTMNT	Department	String	8	View
EMPLCLAS	Employee Class	String	16	View
SOCSCNUM	Social Security Number	String	16	View
PAYRTARR_1	Pay Rate Array[1]	Currency	10	View
PAYRTARR_2	Pay Rate Array[2]	Currency	10	View
PAYRTARR_3	Pay Rate Array[3]	Currency	10	View
PAYRTARR_4	Pay Rate Array[4]	Currency	10	View
PAYRTARR_5	Pay Rate Array[5]	Currency	10	View
PAYRTARR_6	Pay Rate Array[6]	Currency	10	View
PAYRTARR_7	Pay Rate Array[7]	Currency	10	View
PAYRTARR_8	Pay Rate Array[8]	Currency	10	View
PAYRTARR_9	Pay Rate Array[9]	Currency	10	View
PAYRTARR_10	Pay Rate Array[10]	Currency	10	View
PAYRTARR_11	Pay Rate Array[11]	Currency	10	View
PAYRTARR_12	Pay Rate Array[12]	Currency	10	View
PAYRTARR_13	Pay Rate Array[13]	Currency	10	View
PAYRTARR_14	Pay Rate Array[14]	Currency	10	View
PAYRTARR_15	Pay Rate Array[15]	Currency	10	View
PAYRTARR_16	Pay Rate Array[16]	Currency	10	View
PAYRTARR_17	Pay Rate Array[17]	Currency	10	View
PAYRTARR_18	Pay Rate Array[18]	Currency	10	View
PAYRTARR_19	Pay Rate Array[19]	Currency	10	View
PAYRTARR_20	Pay Rate Array[20]	Currency	10	View
PAYRTARR_21	Pay Rate Array[21]	Currency	10	View
PAYRTARR_22	Pay Rate Array[22]	Currency	10	View
PAYRTARR_23	Pay Rate Array[23]	Currency	10	View
PAYRTARR_24	Pay Rate Array[24]	Currency	10	View
PAYRTARR_25	Pay Rate Array[25]	Currency	10	View
PAYHRSAR_1	Pay Hours Array[1]	Long Integer	4	View
PAYHRSAR_2	Pay Hours Array[2]	Long Integer	4	View
PAYHRSAR_3	Pay Hours Array[3]	Long Integer	4	View
PAYHRSAR_4	Pay Hours Array[4]	Long Integer	4	View
PAYHRSAR_5	Pay Hours Array[5]	Long Integer	4	View
PAYHRSAR_6	Pay Hours Array[6]	Long Integer	4	View
PAYHRSAR_7	Pay Hours Array[7]	Long Integer	4	View
PAYHRSAR_8	Pay Hours Array[8]	Long Integer	4	View
PAYHRSAR_9	Pay Hours Array[9]	Long Integer	4	View
PAYHRSAR_10	Pay Hours Array[10]	Long Integer	4	View
PAYHRSAR_11	Pay Hours Array[11]	Long Integer	4	View
PAYHRSAR_12	Pay Hours Array[12]	Long Integer	4	View
PAYHRSAR_13	Pay Hours Array[13]	Long Integer	4	View
PAYHRSAR_14	Pay Hours Array[14]	Long Integer	4	View
PAYHRSAR_15	Pay Hours Array[15]	Long Integer	4	View
PAYHRSAR_16	Pay Hours Array[16]	Long Integer	4	View
PAYHRSAR_17	Pay Hours Array[17]	Long Integer	4	View
PAYHRSAR_18	Pay Hours Array[18]	Long Integer	4	View
PAYHRSAR_19	Pay Hours Array[19]	Long Integer	4	View
PAYHRSAR_20	Pay Hours Array[20]	Long Integer	4	View
PAYHRSAR_21	Pay Hours Array[21]	Long Integer	4	View
PAYHRSAR_22	Pay Hours Array[22]	Long Integer	4	View
PAYHRSAR_23	Pay Hours Array[23]	Long Integer	4	View
PAYHRSAR_24	Pay Hours Array[24]	Long Integer	4	View
PAYHRSAR_25	Pay Hours Array[25]	Long Integer	4	View
PAYERNAR_1	Pay Earnings Array[1]	Currency	10	View
PAYERNAR_2	Pay Earnings Array[2]	Currency	10	View
PAYERNAR_3	Pay Earnings Array[3]	Currency	10	View
PAYERNAR_4	Pay Earnings Array[4]	Currency	10	View
PAYERNAR_5	Pay Earnings Array[5]	Currency	10	View
PAYERNAR_6	Pay Earnings Array[6]	Currency	10	View
PAYERNAR_7	Pay Earnings Array[7]	Currency	10	View
PAYERNAR_8	Pay Earnings Array[8]	Currency	10	View
PAYERNAR_9	Pay Earnings Array[9]	Currency	10	View
PAYERNAR_10	Pay Earnings Array[10]	Currency	10	View
PAYERNAR_11	Pay Earnings Array[11]	Currency	10	View
PAYERNAR_12	Pay Earnings Array[12]	Currency	10	View
PAYERNAR_13	Pay Earnings Array[13]	Currency	10	View
PAYERNAR_14	Pay Earnings Array[14]	Currency	10	View
PAYERNAR_15	Pay Earnings Array[15]	Currency	10	View
PAYERNAR_16	Pay Earnings Array[16]	Currency	10	View
PAYERNAR_17	Pay Earnings Array[17]	Currency	10	View
PAYERNAR_18	Pay Earnings Array[18]	Currency	10	View
PAYERNAR_19	Pay Earnings Array[19]	Currency	10	View
PAYERNAR_20	Pay Earnings Array[20]	Currency	10	View
PAYERNAR_21	Pay Earnings Array[21]	Currency	10	View
PAYERNAR_22	Pay Earnings Array[22]	Currency	10	View
PAYERNAR_23	Pay Earnings Array[23]	Currency	10	View
PAYERNAR_24	Pay Earnings Array[24]	Currency	10	View
PAYERNAR_25	Pay Earnings Array[25]	Currency	10	View
TFICATWH	Total FICA Tax Withheld	Currency	10	View
FCASWPR	FICA/Social Security Withholding/Pay Run	Currency	10	View
FICAMWPR	FICA/Medicare Withholding/Pay Run	Currency	10	View
FDWDGPRN	Federal Withholding/Pay Run	Currency	10	View
STWHDARR_1	State Tax Withholding Array[1]	Currency	10	View
STWHDARR_2	State Tax Withholding Array[2]	Currency	10	View
STWHDARR_3	State Tax Withholding Array[3]	Currency	10	View
STWHDARR_4	State Tax Withholding Array[4]	Currency	10	View
STWHDARR_5	State Tax Withholding Array[5]	Currency	10	View
STWHDARR_6	State Tax Withholding Array[6]	Currency	10	View
STWHDARR_7	State Tax Withholding Array[7]	Currency	10	View
STWHDARR_8	State Tax Withholding Array[8]	Currency	10	View
STWHDARR_9	State Tax Withholding Array[9]	Currency	10	View
STWHDARR_10	State Tax Withholding Array[10]	Currency	10	View
STWHDARR_11	State Tax Withholding Array[11]	Currency	10	View
STWHDARR_12	State Tax Withholding Array[12]	Currency	10	View
STWHDARR_13	State Tax Withholding Array[13]	Currency	10	View
STWHDARR_14	State Tax Withholding Array[14]	Currency	10	View
STWHDARR_15	State Tax Withholding Array[15]	Currency	10	View
STWHDARR_16	State Tax Withholding Array[16]	Currency	10	View
STWHDARR_17	State Tax Withholding Array[17]	Currency	10	View
STWHDARR_18	State Tax Withholding Array[18]	Currency	10	View
STWHDARR_19	State Tax Withholding Array[19]	Currency	10	View
STWHDARR_20	State Tax Withholding Array[20]	Currency	10	View
STWHDARR_21	State Tax Withholding Array[21]	Currency	10	View
STWHDARR_22	State Tax Withholding Array[22]	Currency	10	View
STWHDARR_23	State Tax Withholding Array[23]	Currency	10	View
STWHDARR_24	State Tax Withholding Array[24]	Currency	10	View
STWHDARR_25	State Tax Withholding Array[25]	Currency	10	View
LTXWHGAR_1	Local Tax Withholding Array[1]	Currency	10	View
LTXWHGAR_2	Local Tax Withholding Array[2]	Currency	10	View
LTXWHGAR_3	Local Tax Withholding Array[3]	Currency	10	View
LTXWHGAR_4	Local Tax Withholding Array[4]	Currency	10	View
LTXWHGAR_5	Local Tax Withholding Array[5]	Currency	10	View
LTXWHGAR_6	Local Tax Withholding Array[6]	Currency	10	View
LTXWHGAR_7	Local Tax Withholding Array[7]	Currency	10	View
LTXWHGAR_8	Local Tax Withholding Array[8]	Currency	10	View
LTXWHGAR_9	Local Tax Withholding Array[9]	Currency	10	View
LTXWHGAR_10	Local Tax Withholding Array[10]	Currency	10	View
LTXWHGAR_11	Local Tax Withholding Array[11]	Currency	10	View
LTXWHGAR_12	Local Tax Withholding Array[12]	Currency	10	View
LTXWHGAR_13	Local Tax Withholding Array[13]	Currency	10	View
LTXWHGAR_14	Local Tax Withholding Array[14]	Currency	10	View
LTXWHGAR_15	Local Tax Withholding Array[15]	Currency	10	View
LTXWHGAR_16	Local Tax Withholding Array[16]	Currency	10	View
LTXWHGAR_17	Local Tax Withholding Array[17]	Currency	10	View
LTXWHGAR_18	Local Tax Withholding Array[18]	Currency	10	View
LTXWHGAR_19	Local Tax Withholding Array[19]	Currency	10	View
LTXWHGAR_20	Local Tax Withholding Array[20]	Currency	10	View
LTXWHGAR_21	Local Tax Withholding Array[21]	Currency	10	View
LTXWHGAR_22	Local Tax Withholding Array[22]	Currency	10	View
LTXWHGAR_23	Local Tax Withholding Array[23]	Currency	10	View
LTXWHGAR_24	Local Tax Withholding Array[24]	Currency	10	View
LTXWHGAR_25	Local Tax Withholding Array[25]	Currency	10	View
DEDAMARR_1	Deduction Amount Array[1]	Currency	10	View
DEDAMARR_2	Deduction Amount Array[2]	Currency	10	View
DEDAMARR_3	Deduction Amount Array[3]	Currency	10	View
DEDAMARR_4	Deduction Amount Array[4]	Currency	10	View
DEDAMARR_5	Deduction Amount Array[5]	Currency	10	View
DEDAMARR_6	Deduction Amount Array[6]	Currency	10	View
DEDAMARR_7	Deduction Amount Array[7]	Currency	10	View
DEDAMARR_8	Deduction Amount Array[8]	Currency	10	View
DEDAMARR_9	Deduction Amount Array[9]	Currency	10	View
DEDAMARR_10	Deduction Amount Array[10]	Currency	10	View
DEDAMARR_11	Deduction Amount Array[11]	Currency	10	View
DEDAMARR_12	Deduction Amount Array[12]	Currency	10	View
DEDAMARR_13	Deduction Amount Array[13]	Currency	10	View
DEDAMARR_14	Deduction Amount Array[14]	Currency	10	View
DEDAMARR_15	Deduction Amount Array[15]	Currency	10	View
DEDAMARR_16	Deduction Amount Array[16]	Currency	10	View
DEDAMARR_17	Deduction Amount Array[17]	Currency	10	View
DEDAMARR_18	Deduction Amount Array[18]	Currency	10	View
DEDAMARR_19	Deduction Amount Array[19]	Currency	10	View
DEDAMARR_20	Deduction Amount Array[20]	Currency	10	View
DEDAMARR_21	Deduction Amount Array[21]	Currency	10	View
DEDAMARR_22	Deduction Amount Array[22]	Currency	10	View
DEDAMARR_23	Deduction Amount Array[23]	Currency	10	View
DEDAMARR_24	Deduction Amount Array[24]	Currency	10	View
DEDAMARR_25	Deduction Amount Array[25]	Currency	10	View
BNFAMARR_1	Benefit Amount Array[1]	Currency	10	View
BNFAMARR_2	Benefit Amount Array[2]	Currency	10	View
BNFAMARR_3	Benefit Amount Array[3]	Currency	10	View
BNFAMARR_4	Benefit Amount Array[4]	Currency	10	View
BNFAMARR_5	Benefit Amount Array[5]	Currency	10	View
BNFAMARR_6	Benefit Amount Array[6]	Currency	10	View
BNFAMARR_7	Benefit Amount Array[7]	Currency	10	View
BNFAMARR_8	Benefit Amount Array[8]	Currency	10	View
BNFAMARR_9	Benefit Amount Array[9]	Currency	10	View
BNFAMARR_10	Benefit Amount Array[10]	Currency	10	View
BNFAMARR_11	Benefit Amount Array[11]	Currency	10	View
BNFAMARR_12	Benefit Amount Array[12]	Currency	10	View
BNFAMARR_13	Benefit Amount Array[13]	Currency	10	View
BNFAMARR_14	Benefit Amount Array[14]	Currency	10	View
BNFAMARR_15	Benefit Amount Array[15]	Currency	10	View
BNFAMARR_16	Benefit Amount Array[16]	Currency	10	View
BNFAMARR_17	Benefit Amount Array[17]	Currency	10	View
BNFAMARR_18	Benefit Amount Array[18]	Currency	10	View
BNFAMARR_19	Benefit Amount Array[19]	Currency	10	View
BNFAMARR_20	Benefit Amount Array[20]	Currency	10	View
BNFAMARR_21	Benefit Amount Array[21]	Currency	10	View
BNFAMARR_22	Benefit Amount Array[22]	Currency	10	View
BNFAMARR_23	Benefit Amount Array[23]	Currency	10	View
BNFAMARR_24	Benefit Amount Array[24]	Currency	10	View
BNFAMARR_25	Benefit Amount Array[25]	Currency	10	View
TIMEAVAILARRAY_1	Time Available Array[1]	Currency	10	View
TIMEAVAILARRAY_2	Time Available Array[2]	Currency	10	View
TIMEAVAILARRAY_3	Time Available Array[3]	Currency	10	View
TIMEAVAILARRAY_4	Time Available Array[4]	Currency	10	View
TIMEAVAILARRAY_5	Time Available Array[5]	Currency	10	View
TIMEAVAILARRAY_6	Time Available Array[6]	Currency	10	View
TIMEAVAILARRAY_7	Time Available Array[7]	Currency	10	View
TIMEAVAILARRAY_8	Time Available Array[8]	Currency	10	View
TIMEAVAILARRAY_9	Time Available Array[9]	Currency	10	View
TIMEAVAILARRAY_10	Time Available Array[10]	Currency	10	View
TIMEAVAILARRAY_11	Time Available Array[11]	Currency	10	View
TIMEAVAILARRAY_12	Time Available Array[12]	Currency	10	View
TIMEAVAILARRAY_13	Time Available Array[13]	Currency	10	View
TIMEAVAILARRAY_14	Time Available Array[14]	Currency	10	View
TIMEAVAILARRAY_15	Time Available Array[15]	Currency	10	View
TIMEAVAILARRAY_16	Time Available Array[16]	Currency	10	View
TIMEAVAILARRAY_17	Time Available Array[17]	Currency	10	View
TIMEAVAILARRAY_18	Time Available Array[18]	Currency	10	View
TIMEAVAILARRAY_19	Time Available Array[19]	Currency	10	View
TIMEAVAILARRAY_20	Time Available Array[20]	Currency	10	View
TIMEAVAILARRAY_21	Time Available Array[21]	Currency	10	View
TIMEAVAILARRAY_22	Time Available Array[22]	Currency	10	View
TIMEAVAILARRAY_23	Time Available Array[23]	Currency	10	View
TIMEAVAILARRAY_24	Time Available Array[24]	Currency	10	View
TIMEAVAILARRAY_25	Time Available Array[25]	Currency	10	View
TTLHOURS	Total Hours	Long Integer	4	View
TTLERNGS	Total Earnings	Currency	10	View
TOTLTAXS	Total Taxes	Currency	10	View
TTLDDTNS	Total Deductions	Currency	10	View
TTLBNFTS	Total Benefits	Currency	10	View
NTWPYRN	Net Wages/Pay Run	Currency	10	View
GRWGPRN	Gross Wages/Pay Run	Currency	10	View
REGHOURS	Regular Hours	Long Integer	4	View
REGERNGS	Regular Earnings	Currency	10	View
OVRTMHRS	Overtime Hours	Long Integer	4	View
OVTMEARN	Overtime Earnings	Currency	10	View
DBLTMHRS	Double Time Hours	Long Integer	4	View
DBLTMERN	Double Time Earnings	Currency	10	View
EICERNGS	EIC Earnings	Currency	10	View
COMMERNG	Commission Earnings	Currency	10	View
BSNEXERN	Business Expense Earnings	Currency	10	View
PNSNERNG	Pension Earnings	Currency	10	View
HOLDYHRS	Holiday Hours	Long Integer	4	View
HLDYEARN	Holiday Earnings	Currency	10	View
VACTNHRS	Vacation Hours	Long Integer	4	View
VCTNERNG	Vacation Earnings	Currency	10	View
SKTIMHRS	Sick Time Hours	Long Integer	4	View
SKTMERNG	Sick Time Earnings	Currency	10	View
PCWKUNIT	Piecework Units	Long Integer	4	View
PCWKERNG	Piecework Earnings	Currency	10	View
SPCLERNG	Special Earnings	Currency	10	View
CHGTPERN	Charged Tips Earnings	Currency	10	View
REPTPERN	Reported Tips Earnings	Currency	10	View
MNWGBLER	Min Wage Bal Earnings	Currency	10	View
VACAVLBL	Vacation Available	Long Integer	4	View
SIKTIMAV	Sick Time Available	Long Integer	4	View
STTPYPRD	Start Pay Period	Date	4	View
ENPAYPRD	End Pay Period	Date	4	View
Uncollected_FICAMed_TaxP	Uncollected FICA/Med Tax/Pay Run	Currency	10	View
Uncollected_FICASS_TaxP	Uncollected FICA/SS Tax/Pay Run	Currency	10	View
RSNCHKVD	Reason Check Voided	String	32	View
AMTINWDS	Amount in Words	Text	2	View

UPR10208 - Payroll Work Check

Query Builder

Customer Service

Information

My Account

Contact Us