UPR00901 - Payroll Employee Tips Summary | Prospr

UPR00901 - Payroll Employee Tips Summary

Query Builder

Select * from UPR00901

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
Reported_Tips12_1	Reported Tips Array[1]	Currency	10	View
Reported_Tips12_2	Reported Tips Array[2]	Currency	10	View
Reported_Tips12_3	Reported Tips Array[3]	Currency	10	View
Reported_Tips12_4	Reported Tips Array[4]	Currency	10	View
Reported_Tips12_5	Reported Tips Array[5]	Currency	10	View
Reported_Tips12_6	Reported Tips Array[6]	Currency	10	View
Reported_Tips12_7	Reported Tips Array[7]	Currency	10	View
Reported_Tips12_8	Reported Tips Array[8]	Currency	10	View
Reported_Tips12_9	Reported Tips Array[9]	Currency	10	View
Reported_Tips12_10	Reported Tips Array[10]	Currency	10	View
Reported_Tips12_11	Reported Tips Array[11]	Currency	10	View
Reported_Tips12_12	Reported Tips Array[12]	Currency	10	View
Charged_Tips12_1	Charged Tips Array[1]	Currency	10	View
Charged_Tips12_2	Charged Tips Array[2]	Currency	10	View
Charged_Tips12_3	Charged Tips Array[3]	Currency	10	View
Charged_Tips12_4	Charged Tips Array[4]	Currency	10	View
Charged_Tips12_5	Charged Tips Array[5]	Currency	10	View
Charged_Tips12_6	Charged Tips Array[6]	Currency	10	View
Charged_Tips12_7	Charged Tips Array[7]	Currency	10	View
Charged_Tips12_8	Charged Tips Array[8]	Currency	10	View
Charged_Tips12_9	Charged Tips Array[9]	Currency	10	View
Charged_Tips12_10	Charged Tips Array[10]	Currency	10	View
Charged_Tips12_11	Charged Tips Array[11]	Currency	10	View
Charged_Tips12_12	Charged Tips Array[12]	Currency	10	View
Federal_Tax_On_Tips_1	Federal Tax On Tips[1]	Currency	10	View
Federal_Tax_On_Tips_2	Federal Tax On Tips[2]	Currency	10	View
Federal_Tax_On_Tips_3	Federal Tax On Tips[3]	Currency	10	View
Federal_Tax_On_Tips_4	Federal Tax On Tips[4]	Currency	10	View
Federal_Tax_On_Tips_5	Federal Tax On Tips[5]	Currency	10	View
Federal_Tax_On_Tips_6	Federal Tax On Tips[6]	Currency	10	View
Federal_Tax_On_Tips_7	Federal Tax On Tips[7]	Currency	10	View
Federal_Tax_On_Tips_8	Federal Tax On Tips[8]	Currency	10	View
Federal_Tax_On_Tips_9	Federal Tax On Tips[9]	Currency	10	View
Federal_Tax_On_Tips_10	Federal Tax On Tips[10]	Currency	10	View
Federal_Tax_On_Tips_11	Federal Tax On Tips[11]	Currency	10	View
Federal_Tax_On_Tips_12	Federal Tax On Tips[12]	Currency	10	View
FICASS_Tips_1	FICA/SS Tips[1]	Currency	10	View
FICASS_Tips_2	FICA/SS Tips[2]	Currency	10	View
FICASS_Tips_3	FICA/SS Tips[3]	Currency	10	View
FICASS_Tips_4	FICA/SS Tips[4]	Currency	10	View
FICASS_Tips_5	FICA/SS Tips[5]	Currency	10	View
FICASS_Tips_6	FICA/SS Tips[6]	Currency	10	View
FICASS_Tips_7	FICA/SS Tips[7]	Currency	10	View
FICASS_Tips_8	FICA/SS Tips[8]	Currency	10	View
FICASS_Tips_9	FICA/SS Tips[9]	Currency	10	View
FICASS_Tips_10	FICA/SS Tips[10]	Currency	10	View
FICASS_Tips_11	FICA/SS Tips[11]	Currency	10	View
FICASS_Tips_12	FICA/SS Tips[12]	Currency	10	View
FICASS_Tax_On_Tips_1	FICA/SS Tax On Tips[1]	Currency	10	View
FICASS_Tax_On_Tips_2	FICA/SS Tax On Tips[2]	Currency	10	View
FICASS_Tax_On_Tips_3	FICA/SS Tax On Tips[3]	Currency	10	View
FICASS_Tax_On_Tips_4	FICA/SS Tax On Tips[4]	Currency	10	View
FICASS_Tax_On_Tips_5	FICA/SS Tax On Tips[5]	Currency	10	View
FICASS_Tax_On_Tips_6	FICA/SS Tax On Tips[6]	Currency	10	View
FICASS_Tax_On_Tips_7	FICA/SS Tax On Tips[7]	Currency	10	View
FICASS_Tax_On_Tips_8	FICA/SS Tax On Tips[8]	Currency	10	View
FICASS_Tax_On_Tips_9	FICA/SS Tax On Tips[9]	Currency	10	View
FICASS_Tax_On_Tips_10	FICA/SS Tax On Tips[10]	Currency	10	View
FICASS_Tax_On_Tips_11	FICA/SS Tax On Tips[11]	Currency	10	View
FICASS_Tax_On_Tips_12	FICA/SS Tax On Tips[12]	Currency	10	View
Uncollected_FICASS_Tax_1	Uncollected FICA/SS Tax[1]	Currency	10	View
Uncollected_FICASS_Tax_2	Uncollected FICA/SS Tax[2]	Currency	10	View
Uncollected_FICASS_Tax_3	Uncollected FICA/SS Tax[3]	Currency	10	View
Uncollected_FICASS_Tax_4	Uncollected FICA/SS Tax[4]	Currency	10	View
Uncollected_FICASS_Tax_5	Uncollected FICA/SS Tax[5]	Currency	10	View
Uncollected_FICASS_Tax_6	Uncollected FICA/SS Tax[6]	Currency	10	View
Uncollected_FICASS_Tax_7	Uncollected FICA/SS Tax[7]	Currency	10	View
Uncollected_FICASS_Tax_8	Uncollected FICA/SS Tax[8]	Currency	10	View
Uncollected_FICASS_Tax_9	Uncollected FICA/SS Tax[9]	Currency	10	View
Uncollected_FICASS_Tax_10	Uncollected FICA/SS Tax[10]	Currency	10	View
Uncollected_FICASS_Tax_11	Uncollected FICA/SS Tax[11]	Currency	10	View
Uncollected_FICASS_Tax_12	Uncollected FICA/SS Tax[12]	Currency	10	View
FICAMed_Tips_1	FICA/Med Tips[1]	Currency	10	View
FICAMed_Tips_2	FICA/Med Tips[2]	Currency	10	View
FICAMed_Tips_3	FICA/Med Tips[3]	Currency	10	View
FICAMed_Tips_4	FICA/Med Tips[4]	Currency	10	View
FICAMed_Tips_5	FICA/Med Tips[5]	Currency	10	View
FICAMed_Tips_6	FICA/Med Tips[6]	Currency	10	View
FICAMed_Tips_7	FICA/Med Tips[7]	Currency	10	View
FICAMed_Tips_8	FICA/Med Tips[8]	Currency	10	View
FICAMed_Tips_9	FICA/Med Tips[9]	Currency	10	View
FICAMed_Tips_10	FICA/Med Tips[10]	Currency	10	View
FICAMed_Tips_11	FICA/Med Tips[11]	Currency	10	View
FICAMed_Tips_12	FICA/Med Tips[12]	Currency	10	View
FICAMed_Tax_On_Tips_1	FICA/Med Tax On Tips[1]	Currency	10	View
FICAMed_Tax_On_Tips_2	FICA/Med Tax On Tips[2]	Currency	10	View
FICAMed_Tax_On_Tips_3	FICA/Med Tax On Tips[3]	Currency	10	View
FICAMed_Tax_On_Tips_4	FICA/Med Tax On Tips[4]	Currency	10	View
FICAMed_Tax_On_Tips_5	FICA/Med Tax On Tips[5]	Currency	10	View
FICAMed_Tax_On_Tips_6	FICA/Med Tax On Tips[6]	Currency	10	View
FICAMed_Tax_On_Tips_7	FICA/Med Tax On Tips[7]	Currency	10	View
FICAMed_Tax_On_Tips_8	FICA/Med Tax On Tips[8]	Currency	10	View
FICAMed_Tax_On_Tips_9	FICA/Med Tax On Tips[9]	Currency	10	View
FICAMed_Tax_On_Tips_10	FICA/Med Tax On Tips[10]	Currency	10	View
FICAMed_Tax_On_Tips_11	FICA/Med Tax On Tips[11]	Currency	10	View
FICAMed_Tax_On_Tips_12	FICA/Med Tax On Tips[12]	Currency	10	View
Uncollected_FICAMed_Tax_1	Uncollected FICA/Med Tax[1]	Currency	10	View
Uncollected_FICAMed_Tax_2	Uncollected FICA/Med Tax[2]	Currency	10	View
Uncollected_FICAMed_Tax_3	Uncollected FICA/Med Tax[3]	Currency	10	View
Uncollected_FICAMed_Tax_4	Uncollected FICA/Med Tax[4]	Currency	10	View
Uncollected_FICAMed_Tax_5	Uncollected FICA/Med Tax[5]	Currency	10	View
Uncollected_FICAMed_Tax_6	Uncollected FICA/Med Tax[6]	Currency	10	View
Uncollected_FICAMed_Tax_7	Uncollected FICA/Med Tax[7]	Currency	10	View
Uncollected_FICAMed_Tax_8	Uncollected FICA/Med Tax[8]	Currency	10	View
Uncollected_FICAMed_Tax_9	Uncollected FICA/Med Tax[9]	Currency	10	View
Uncollected_FICAMed_Tax_10	Uncollected FICA/Med Tax[10]	Currency	10	View
Uncollected_FICAMed_Tax_11	Uncollected FICA/Med Tax[11]	Currency	10	View
Uncollected_FICAMed_Tax_12	Uncollected FICA/Med Tax[12]	Currency	10	View
Reported_Receipts12_1	Reported Receipts Array[1]	Currency	10	View
Reported_Receipts12_2	Reported Receipts Array[2]	Currency	10	View
Reported_Receipts12_3	Reported Receipts Array[3]	Currency	10	View
Reported_Receipts12_4	Reported Receipts Array[4]	Currency	10	View
Reported_Receipts12_5	Reported Receipts Array[5]	Currency	10	View
Reported_Receipts12_6	Reported Receipts Array[6]	Currency	10	View
Reported_Receipts12_7	Reported Receipts Array[7]	Currency	10	View
Reported_Receipts12_8	Reported Receipts Array[8]	Currency	10	View
Reported_Receipts12_9	Reported Receipts Array[9]	Currency	10	View
Reported_Receipts12_10	Reported Receipts Array[10]	Currency	10	View
Reported_Receipts12_11	Reported Receipts Array[11]	Currency	10	View
Reported_Receipts12_12	Reported Receipts Array[12]	Currency	10	View
Charged_Receipts12_1	Charged Receipts Array[1]	Currency	10	View
Charged_Receipts12_2	Charged Receipts Array[2]	Currency	10	View
Charged_Receipts12_3	Charged Receipts Array[3]	Currency	10	View
Charged_Receipts12_4	Charged Receipts Array[4]	Currency	10	View
Charged_Receipts12_5	Charged Receipts Array[5]	Currency	10	View
Charged_Receipts12_6	Charged Receipts Array[6]	Currency	10	View
Charged_Receipts12_7	Charged Receipts Array[7]	Currency	10	View
Charged_Receipts12_8	Charged Receipts Array[8]	Currency	10	View
Charged_Receipts12_9	Charged Receipts Array[9]	Currency	10	View
Charged_Receipts12_10	Charged Receipts Array[10]	Currency	10	View
Charged_Receipts12_11	Charged Receipts Array[11]	Currency	10	View
Charged_Receipts12_12	Charged Receipts Array[12]	Currency	10	View
Allocated_Tips_Array_1	Allocated Tips Array[1]	Currency	10	View
Allocated_Tips_Array_2	Allocated Tips Array[2]	Currency	10	View
Allocated_Tips_Array_3	Allocated Tips Array[3]	Currency	10	View
Allocated_Tips_Array_4	Allocated Tips Array[4]	Currency	10	View
Allocated_Tips_Array_5	Allocated Tips Array[5]	Currency	10	View
Allocated_Tips_Array_6	Allocated Tips Array[6]	Currency	10	View
Allocated_Tips_Array_7	Allocated Tips Array[7]	Currency	10	View
Allocated_Tips_Array_8	Allocated Tips Array[8]	Currency	10	View
Allocated_Tips_Array_9	Allocated Tips Array[9]	Currency	10	View
Allocated_Tips_Array_10	Allocated Tips Array[10]	Currency	10	View
Allocated_Tips_Array_11	Allocated Tips Array[11]	Currency	10	View
Allocated_Tips_Array_12	Allocated Tips Array[12]	Currency	10	View
YEAR1	Year	Integer	2	View
Federal_Tips_1	Federal Tips[1]	Currency	10	View
Federal_Tips_2	Federal Tips[2]	Currency	10	View
Federal_Tips_3	Federal Tips[3]	Currency	10	View
Federal_Tips_4	Federal Tips[4]	Currency	10	View
Federal_Tips_5	Federal Tips[5]	Currency	10	View
Federal_Tips_6	Federal Tips[6]	Currency	10	View
Federal_Tips_7	Federal Tips[7]	Currency	10	View
Federal_Tips_8	Federal Tips[8]	Currency	10	View
Federal_Tips_9	Federal Tips[9]	Currency	10	View
Federal_Tips_10	Federal Tips[10]	Currency	10	View
Federal_Tips_11	Federal Tips[11]	Currency	10	View
Federal_Tips_12	Federal Tips[12]	Currency	10	View

UPR00901 - Payroll Employee Tips Summary

Query Builder

Customer Service

Information

My Account

Contact Us