UPR30100 - Payroll Check History
Query Builder
| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| AUCTRLCD | Audit Control Code |
String | 14 | View | |
| CHEKNMBR | Check Number |
String | 22 | View | |
| PYADNMBR | Payment/Adjustment Number |
Long Integer | 4 | View | |
| VOIDED | Voided |
Boolean | 2 | View | |
| CHEKDATE | Check Date |
Date | 4 | View | |
| POSTEDDT | Posted Date |
Date | 4 | View | |
| EMPLOYID | Employee ID |
String | 16 | View | |
| EMPLNAME | Employee Name |
String | 42 | View | |
| GRWGPRN | Gross Wages/Pay Run |
Currency | 10 | View | |
| FDWDGPRN | Federal Withholding/Pay Run |
Currency | 10 | View | |
| FDTXTIPS | Federal Tax on Tips |
Currency | 10 | View | |
| FICAMWPR | FICA/Medicare Withholding/Pay Run |
Currency | 10 | View | |
| FICMTPTX | FICA/Med Tax on Tips |
Currency | 10 | View | |
| Uncollected_FICAMed_TaxP | Uncollected FICA/Med Tax/Pay Run |
Currency | 10 | View | |
| FCASWPR | FICA/Social Security Withholding/Pay Run |
Currency | 10 | View | |
| FICSTPTX | FICA/SS Tax on Tips |
Currency | 10 | View | |
| Uncollected_FICASS_TaxP | Uncollected FICA/SS Tax/Pay Run |
Currency | 10 | View | |
| ADEICPMT | Advance EIC Payment |
Currency | 10 | View | |
| Reported_Tips | Reported Tips |
Currency | 10 | View | |
| Charged_Tips | Charged Tips |
Currency | 10 | View | |
| ALOCTIPS | Allocated Tips |
Currency | 10 | View | |
| TTLDDTNS | Total Deductions |
Currency | 10 | View | |
| TTLBNFTS | Total Benefits |
Currency | 10 | View | |
| NTWPYRN | Net Wages/Pay Run |
Currency | 10 | View | |
| CHEKBKID | Checkbook ID |
String | 16 | View | |
| DEPRTMNT | Department |
String | 8 | View | |
| SOCSCNUM | Social Security Number |
String | 16 | View | |
| VACTMACC | Vacation Time Accrued |
Currency | 10 | View | |
| VACTMLBL | Vacation Time Liability |
Currency | 10 | View | |
| VACAVLBL | Vacation Available |
Long Integer | 4 | View | |
| SKTMACCR | Sick Time Accrued |
Currency | 10 | View | |
| SKTMLBTY | Sick Time Liability |
Currency | 10 | View | |
| SIKTIMAV | Sick Time Available |
Long Integer | 4 | View | |
| TOTLTAXS | Total Taxes |
Currency | 10 | View | |
| Voided_by_Void_Checks | Voided by Void Checks |
Boolean | 2 | View | |
| FDWGPYRN | Federal Wages/Pay Run |
Currency | 10 | View | |
| Federal_TipsPay_Run | Federal Tips/Pay Run |
Currency | 10 | View | |
| FICASSWP | FICA/Social Security Wages/Pay Run |
Currency | 10 | View | |
| FICASS_TipsPay_Run | FICA/SS Tips/Pay Run |
Currency | 10 | View | |
| FICAMWGP | FICA/Medicare Wages/Pay Run |
Currency | 10 | View | |
| FICAMed_TipsPay_Run | FICA/Med Tips/Pay Run |
Currency | 10 | View | |
| Reported_Receipts | Reported Receipts |
Currency | 10 | View | |
| Charged_Receipts | Charged Receipts |
Currency | 10 | View | |
| YEAR1 | Year |
Integer | 2 | View | |
| ISCHECK | IsCheck |
Boolean | 2 | View | |
| RSNCHKVD | Reason Check Voided |
String | 32 | View | |
| COMPPYRN | Computer Pay Run Type |
Integer | 2 | View | |
| EFICASSWH | Employer FICA/Social Security Withholding |
Currency | 10 | View | |
| EFICASS_Tax_On_Tips | Employer FICA/SS Tax On Tips |
Currency | 10 | View | |
| EFICAMWPR | Employer FICA/Medicare Withholding |
Currency | 10 | View | |
| EFICAMed_Tax_On_Tips | Employer FICA/Med Tax On Tips |
Currency | 10 | View |