UPR30301 - Payroll Transaction History Header | Prospr

UPR30301 - Payroll Transaction History Header

Query Builder

Select * from UPR30301

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
YEAR1	Year	Integer	2	View
PYRLRTYP	Payroll Record Type 1 = Regular Pay Codes 2 = Deductions 3 = Benefits 4 = Taxes 5 = LocalTax	Integer	2	View
PAYROLCD	Payroll Code	String	8	View
MTDWAGES_1	MTD Wages[1]	Currency	10	View
MTDWAGES_2	MTD Wages[2]	Currency	10	View
MTDWAGES_3	MTD Wages[3]	Currency	10	View
MTDWAGES_4	MTD Wages[4]	Currency	10	View
MTDWAGES_5	MTD Wages[5]	Currency	10	View
MTDWAGES_6	MTD Wages[6]	Currency	10	View
MTDWAGES_7	MTD Wages[7]	Currency	10	View
MTDWAGES_8	MTD Wages[8]	Currency	10	View
MTDWAGES_9	MTD Wages[9]	Currency	10	View
MTDWAGES_10	MTD Wages[10]	Currency	10	View
MTDWAGES_11	MTD Wages[11]	Currency	10	View
MTDWAGES_12	MTD Wages[12]	Currency	10	View
MTDHOURS_1	MTD Hours[1]	Long Integer	4	View
MTDHOURS_2	MTD Hours[2]	Long Integer	4	View
MTDHOURS_3	MTD Hours[3]	Long Integer	4	View
MTDHOURS_4	MTD Hours[4]	Long Integer	4	View
MTDHOURS_5	MTD Hours[5]	Long Integer	4	View
MTDHOURS_6	MTD Hours[6]	Long Integer	4	View
MTDHOURS_7	MTD Hours[7]	Long Integer	4	View
MTDHOURS_8	MTD Hours[8]	Long Integer	4	View
MTDHOURS_9	MTD Hours[9]	Long Integer	4	View
MTDHOURS_10	MTD Hours[10]	Long Integer	4	View
MTDHOURS_11	MTD Hours[11]	Long Integer	4	View
MTDHOURS_12	MTD Hours[12]	Long Integer	4	View
STXBLWGS_1	State Taxable Wages[1]	Currency	10	View
STXBLWGS_2	State Taxable Wages[2]	Currency	10	View
STXBLWGS_3	State Taxable Wages[3]	Currency	10	View
STXBLWGS_4	State Taxable Wages[4]	Currency	10	View
STXBLWGS_5	State Taxable Wages[5]	Currency	10	View
STXBLWGS_6	State Taxable Wages[6]	Currency	10	View
STXBLWGS_7	State Taxable Wages[7]	Currency	10	View
STXBLWGS_8	State Taxable Wages[8]	Currency	10	View
STXBLWGS_9	State Taxable Wages[9]	Currency	10	View
STXBLWGS_10	State Taxable Wages[10]	Currency	10	View
STXBLWGS_11	State Taxable Wages[11]	Currency	10	View
STXBLWGS_12	State Taxable Wages[12]	Currency	10	View
LCTXBLWG_1	Local Taxable Wages[1]	Currency	10	View
LCTXBLWG_2	Local Taxable Wages[2]	Currency	10	View
LCTXBLWG_3	Local Taxable Wages[3]	Currency	10	View
LCTXBLWG_4	Local Taxable Wages[4]	Currency	10	View
LCTXBLWG_5	Local Taxable Wages[5]	Currency	10	View
LCTXBLWG_6	Local Taxable Wages[6]	Currency	10	View
LCTXBLWG_7	Local Taxable Wages[7]	Currency	10	View
LCTXBLWG_8	Local Taxable Wages[8]	Currency	10	View
LCTXBLWG_9	Local Taxable Wages[9]	Currency	10	View
LCTXBLWG_10	Local Taxable Wages[10]	Currency	10	View
LCTXBLWG_11	Local Taxable Wages[11]	Currency	10	View
LCTXBLWG_12	Local Taxable Wages[12]	Currency	10	View

UPR30301 - Payroll Transaction History Header

Query Builder

Customer Service

Information

My Account

Contact Us