UPR30300 - Payroll Transaction History | Prospr

UPR30300 - Payroll Transaction History

Select * from UPR30300

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CMRECNUM	Record Number	Currency	10	View
AUCTRLCD	Audit Control Code	String	14	View
EMPLOYID	Employee ID	String	16	View
CHEKNMBR	Check Number	String	22	View
PYADNMBR	Payment/Adjustment Number	Long Integer	4	View
TRXNUMBER	TRX Number	Long Integer	4	View
YEAR1	Year	Integer	2	View
CHEKDATE	Check Date	Date	4	View
DEPRTMNT	Department	String	8	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
TRXSORCE	TRX Source	String	14	View
DOCTYPE	Document Type	Integer	2	View
JOBTITLE	Job Title	String	8	View
TRXBEGDT	TRX Beginning Date	Date	4	View
TRXENDDT	TRX Ending Date	Date	4	View
UNTSTOPY	Units To Pay	Currency	10	View
PAYRATE	Pay Rate	Currency	10	View
UPRTRXAM	UPR TRX Amount	Currency	10	View
TIMETYPE_I	Time Type	Integer	2	View
TIMEAVAILABLE	Time Available	Currency	10	View
TipType	Tip Type	Integer	2	View
RECEIPTS	Receipts	Currency	10	View
PAYADVNC	Pay Advance	Currency	10	View
STATECD	State Code	String	4	View
LOCALTAX	Local Tax	String	8	View
WRKRCOMP	Workers Comp	String	8	View
USWHPSTD	User Who Posted	String	16	View
LSTDTEDT	Last Date Edited	Date	4	View
LASTUSER	Last User	String	16	View
SHFTCODE	Shift Code	String	8	View
SHFTPREM	Shift Premium	Currency	10	View
TXBLWAGS	Taxable Wages	Currency	10	View
DAYSWRDK	Days Worked	Long Integer	4	View
WKSWRKD	Weeks Worked	Long Integer	4	View
SUTASTAT	Suta State	String	4	View
SBJTFUTA	Subject To Futa	Boolean	2	View
BSDONRTE	Based On Rate	Currency	10	View
EMPLCLAS	Employee Class	String	16	View