Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR00901
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Payroll Employee Tips Summary Group Display Name: Payroll Employee Master
Physical Name: UPR00901
Technical Name: UPR_Employee_Tips_SUM
Group Technical Name: Payroll Employee Master
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | EMPLOYID ![]() | Employee ID | String | STR15_Employee_ID | 15 |
2 | Reported_Tips12_1 ![]() | Reported Tips Array[1] | Currency | DLR11_$S2 | 14 |
3 | Reported_Tips12 ![]() | Reported Tips Array | DLR11_$S2 | Currency | 14 |
4 | Reported_Tips12_2 ![]() | Reported Tips Array[2] | Currency | DLR11_$S2 | 14 |
5 | Reported_Tips12_3 ![]() | Reported Tips Array[3] | Currency | DLR11_$S2 | 14 |
6 | Reported_Tips12_4 ![]() | Reported Tips Array[4] | Currency | DLR11_$S2 | 14 |
7 | Reported_Tips12_5 ![]() | Reported Tips Array[5] | Currency | DLR11_$S2 | 14 |
8 | Reported_Tips12_6 ![]() | Reported Tips Array[6] | Currency | DLR11_$S2 | 14 |
9 | Reported_Tips12_7 ![]() | Reported Tips Array[7] | Currency | DLR11_$S2 | 14 |
10 | Reported_Tips12_8 ![]() | Reported Tips Array[8] | Currency | DLR11_$S2 | 14 |
11 | Reported_Tips12_9 ![]() | Reported Tips Array[9] | Currency | DLR11_$S2 | 14 |
12 | Reported_Tips12_10 ![]() | Reported Tips Array[10] | Currency | DLR11_$S2 | 14 |
13 | Reported_Tips12_11 ![]() | Reported Tips Array[11] | Currency | DLR11_$S2 | 14 |
14 | Reported_Tips12_12 ![]() | Reported Tips Array[12] | Currency | DLR11_$S2 | 14 |
15 | Charged_Tips12_1 ![]() | Charged Tips Array[1] | Currency | DLR11_$S2 | 14 |
16 | Charged_Tips12 ![]() | Charged Tips Array | DLR11_$S2 | Currency | 14 |
17 | Charged_Tips12_2 ![]() | Charged Tips Array[2] | Currency | DLR11_$S2 | 14 |
18 | Charged_Tips12_3 ![]() | Charged Tips Array[3] | Currency | DLR11_$S2 | 14 |
19 | Charged_Tips12_4 ![]() | Charged Tips Array[4] | Currency | DLR11_$S2 | 14 |
20 | Charged_Tips12_5 ![]() | Charged Tips Array[5] | Currency | DLR11_$S2 | 14 |
21 | Charged_Tips12_6 ![]() | Charged Tips Array[6] | Currency | DLR11_$S2 | 14 |
22 | Charged_Tips12_7 ![]() | Charged Tips Array[7] | Currency | DLR11_$S2 | 14 |
23 | Charged_Tips12_8 ![]() | Charged Tips Array[8] | Currency | DLR11_$S2 | 14 |
24 | Charged_Tips12_9 ![]() | Charged Tips Array[9] | Currency | DLR11_$S2 | 14 |
25 | Charged_Tips12_10 ![]() | Charged Tips Array[10] | Currency | DLR11_$S2 | 14 |
26 | Charged_Tips12_11 ![]() | Charged Tips Array[11] | Currency | DLR11_$S2 | 14 |
27 | Charged_Tips12_12 ![]() | Charged Tips Array[12] | Currency | DLR11_$S2 | 14 |
28 | Federal_Tax_On_Tips_1 ![]() | Federal Tax On Tips[1] | Currency | DLR11_$S2 | 14 |
29 | Federal_Tax_On_Tips_2 ![]() | Federal Tax On Tips[2] | Currency | DLR11_$S2 | 14 |
30 | Federal_Tax_On_Tips ![]() | Federal Tax On Tips | DLR11_$S2 | Currency | 14 |
31 | Federal_Tax_On_Tips_3 ![]() | Federal Tax On Tips[3] | Currency | DLR11_$S2 | 14 |
32 | Federal_Tax_On_Tips_4 ![]() | Federal Tax On Tips[4] | Currency | DLR11_$S2 | 14 |
33 | Federal_Tax_On_Tips_5 ![]() | Federal Tax On Tips[5] | Currency | DLR11_$S2 | 14 |
34 | Federal_Tax_On_Tips_6 ![]() | Federal Tax On Tips[6] | Currency | DLR11_$S2 | 14 |
35 | Federal_Tax_On_Tips_7 ![]() | Federal Tax On Tips[7] | Currency | DLR11_$S2 | 14 |
36 | Federal_Tax_On_Tips_8 ![]() | Federal Tax On Tips[8] | Currency | DLR11_$S2 | 14 |
37 | Federal_Tax_On_Tips_9 ![]() | Federal Tax On Tips[9] | Currency | DLR11_$S2 | 14 |
38 | Federal_Tax_On_Tips_10 ![]() | Federal Tax On Tips[10] | Currency | DLR11_$S2 | 14 |
39 | Federal_Tax_On_Tips_11 ![]() | Federal Tax On Tips[11] | Currency | DLR11_$S2 | 14 |
40 | Federal_Tax_On_Tips_12 ![]() | Federal Tax On Tips[12] | Currency | DLR11_$S2 | 14 |
41 | FICASS_Tips_1 ![]() | FICA/SS Tips[1] | Currency | DLR11_$S2 | 14 |
42 | FICASS_Tips_2 ![]() | FICA/SS Tips[2] | Currency | DLR11_$S2 | 14 |
43 | FICASS_Tips_3 ![]() | FICA/SS Tips[3] | Currency | DLR11_$S2 | 14 |
44 | FICASS_Tips ![]() | FICA/SS Tips | DLR11_$S2 | Currency | 14 |
45 | FICASS_Tips_4 ![]() | FICA/SS Tips[4] | Currency | DLR11_$S2 | 14 |
46 | FICASS_Tips_5 ![]() | FICA/SS Tips[5] | Currency | DLR11_$S2 | 14 |
47 | FICASS_Tips_6 ![]() | FICA/SS Tips[6] | Currency | DLR11_$S2 | 14 |
48 | FICASS_Tips_7 ![]() | FICA/SS Tips[7] | Currency | DLR11_$S2 | 14 |
49 | FICASS_Tips_8 ![]() | FICA/SS Tips[8] | Currency | DLR11_$S2 | 14 |
50 | FICASS_Tips_9 ![]() | FICA/SS Tips[9] | Currency | DLR11_$S2 | 14 |
51 | FICASS_Tips_10 ![]() | FICA/SS Tips[10] | Currency | DLR11_$S2 | 14 |
52 | FICASS_Tips_11 ![]() | FICA/SS Tips[11] | Currency | DLR11_$S2 | 14 |
53 | FICASS_Tips_12 ![]() | FICA/SS Tips[12] | Currency | DLR11_$S2 | 14 |
54 | FICASS_Tax_On_Tips_1 ![]() | FICA/SS Tax On Tips[1] | Currency | DLR11_$S2 | 14 |
55 | FICASS_Tax_On_Tips_2 ![]() | FICA/SS Tax On Tips[2] | Currency | DLR11_$S2 | 14 |
56 | FICASS_Tax_On_Tips_3 ![]() | FICA/SS Tax On Tips[3] | Currency | DLR11_$S2 | 14 |
57 | FICASS_Tax_On_Tips_4 ![]() | FICA/SS Tax On Tips[4] | Currency | DLR11_$S2 | 14 |
58 | FICASS_Tax_On_Tips_5 ![]() | FICA/SS Tax On Tips[5] | Currency | DLR11_$S2 | 14 |
59 | FICASS_Tax_On_Tips ![]() | FICA/SS Tax On Tips | DLR11_$S2 | Currency | 14 |
60 | FICASS_Tax_On_Tips_6 ![]() | FICA/SS Tax On Tips[6] | Currency | DLR11_$S2 | 14 |
61 | FICASS_Tax_On_Tips_7 ![]() | FICA/SS Tax On Tips[7] | Currency | DLR11_$S2 | 14 |
62 | FICASS_Tax_On_Tips_8 ![]() | FICA/SS Tax On Tips[8] | Currency | DLR11_$S2 | 14 |
63 | FICASS_Tax_On_Tips_9 ![]() | FICA/SS Tax On Tips[9] | Currency | DLR11_$S2 | 14 |
64 | FICASS_Tax_On_Tips_10 ![]() | FICA/SS Tax On Tips[10] | Currency | DLR11_$S2 | 14 |
65 | FICASS_Tax_On_Tips_11 ![]() | FICA/SS Tax On Tips[11] | Currency | DLR11_$S2 | 14 |
66 | FICASS_Tax_On_Tips_12 ![]() | FICA/SS Tax On Tips[12] | Currency | DLR11_$S2 | 14 |
67 | Uncollected_FICASS_Tax_1 ![]() | Uncollected FICA/SS Tax[1] | Currency | DLR11_$S2 | 14 |
68 | Uncollected_FICASS_Tax_2 ![]() | Uncollected FICA/SS Tax[2] | Currency | DLR11_$S2 | 14 |
69 | Uncollected_FICASS_Tax_3 ![]() | Uncollected FICA/SS Tax[3] | Currency | DLR11_$S2 | 14 |
70 | Uncollected_FICASS_Tax_4 ![]() | Uncollected FICA/SS Tax[4] | Currency | DLR11_$S2 | 14 |
71 | Uncollected_FICASS_Tax_5 ![]() | Uncollected FICA/SS Tax[5] | Currency | DLR11_$S2 | 14 |
72 | Uncollected_FICASS_Tax_6 ![]() | Uncollected FICA/SS Tax[6] | Currency | DLR11_$S2 | 14 |
73 | Uncollected_FICASS_Tax ![]() | Uncollected FICA/SS Tax | DLR11_$S2 | Currency | 14 |
74 | Uncollected_FICASS_Tax_7 ![]() | Uncollected FICA/SS Tax[7] | Currency | DLR11_$S2 | 14 |
75 | Uncollected_FICASS_Tax_8 ![]() | Uncollected FICA/SS Tax[8] | Currency | DLR11_$S2 | 14 |
76 | Uncollected_FICASS_Tax_9 ![]() | Uncollected FICA/SS Tax[9] | Currency | DLR11_$S2 | 14 |
77 | Uncollected_FICASS_Tax_10 ![]() | Uncollected FICA/SS Tax[10] | Currency | DLR11_$S2 | 14 |
78 | Uncollected_FICASS_Tax_11 ![]() | Uncollected FICA/SS Tax[11] | Currency | DLR11_$S2 | 14 |
79 | Uncollected_FICASS_Tax_12 ![]() | Uncollected FICA/SS Tax[12] | Currency | DLR11_$S2 | 14 |
80 | FICAMed_Tips_1 ![]() | FICA/Med Tips[1] | Currency | DLR11_$S2 | 14 |
81 | FICAMed_Tips_2 ![]() | FICA/Med Tips[2] | Currency | DLR11_$S2 | 14 |
82 | FICAMed_Tips_3 ![]() | FICA/Med Tips[3] | Currency | DLR11_$S2 | 14 |
83 | FICAMed_Tips_4 ![]() | FICA/Med Tips[4] | Currency | DLR11_$S2 | 14 |
84 | FICAMed_Tips_5 ![]() | FICA/Med Tips[5] | Currency | DLR11_$S2 | 14 |
85 | FICAMed_Tips_6 ![]() | FICA/Med Tips[6] | Currency | DLR11_$S2 | 14 |
86 | FICAMed_Tips_7 ![]() | FICA/Med Tips[7] | Currency | DLR11_$S2 | 14 |
87 | FICAMed_Tips ![]() | FICA/Med Tips | DLR11_$S2 | Currency | 14 |
88 | FICAMed_Tips_8 ![]() | FICA/Med Tips[8] | Currency | DLR11_$S2 | 14 |
89 | FICAMed_Tips_9 ![]() | FICA/Med Tips[9] | Currency | DLR11_$S2 | 14 |
90 | FICAMed_Tips_10 ![]() | FICA/Med Tips[10] | Currency | DLR11_$S2 | 14 |
91 | FICAMed_Tips_11 ![]() | FICA/Med Tips[11] | Currency | DLR11_$S2 | 14 |
92 | FICAMed_Tips_12 ![]() | FICA/Med Tips[12] | Currency | DLR11_$S2 | 14 |
93 | FICAMed_Tax_On_Tips_1 ![]() | FICA/Med Tax On Tips[1] | Currency | DLR11_$S2 | 14 |
94 | FICAMed_Tax_On_Tips_2 ![]() | FICA/Med Tax On Tips[2] | Currency | DLR11_$S2 | 14 |
95 | FICAMed_Tax_On_Tips_3 ![]() | FICA/Med Tax On Tips[3] | Currency | DLR11_$S2 | 14 |
96 | FICAMed_Tax_On_Tips_4 ![]() | FICA/Med Tax On Tips[4] | Currency | DLR11_$S2 | 14 |
97 | FICAMed_Tax_On_Tips_5 ![]() | FICA/Med Tax On Tips[5] | Currency | DLR11_$S2 | 14 |
98 | FICAMed_Tax_On_Tips_6 ![]() | FICA/Med Tax On Tips[6] | Currency | DLR11_$S2 | 14 |
99 | FICAMed_Tax_On_Tips_7 ![]() | FICA/Med Tax On Tips[7] | Currency | DLR11_$S2 | 14 |
100 | FICAMed_Tax_On_Tips ![]() | FICA/Med Tax On Tips | DLR11_$S2 | Currency | 14 |
101 | FICAMed_Tax_On_Tips_8 ![]() | FICA/Med Tax On Tips[8] | Currency | DLR11_$S2 | 14 |
102 | FICAMed_Tax_On_Tips_9 ![]() | FICA/Med Tax On Tips[9] | Currency | DLR11_$S2 | 14 |
103 | FICAMed_Tax_On_Tips_10 ![]() | FICA/Med Tax On Tips[10] | Currency | DLR11_$S2 | 14 |
104 | FICAMed_Tax_On_Tips_11 ![]() | FICA/Med Tax On Tips[11] | Currency | DLR11_$S2 | 14 |
105 | FICAMed_Tax_On_Tips_12 ![]() | FICA/Med Tax On Tips[12] | Currency | DLR11_$S2 | 14 |
106 | Uncollected_FICAMed_Tax_1 ![]() | Uncollected FICA/Med Tax[1] | Currency | DLR11_$S2 | 14 |
107 | Uncollected_FICAMed_Tax_2 ![]() | Uncollected FICA/Med Tax[2] | Currency | DLR11_$S2 | 14 |
108 | Uncollected_FICAMed_Tax_3 ![]() | Uncollected FICA/Med Tax[3] | Currency | DLR11_$S2 | 14 |
109 | Uncollected_FICAMed_Tax_4 ![]() | Uncollected FICA/Med Tax[4] | Currency | DLR11_$S2 | 14 |
110 | Uncollected_FICAMed_Tax_5 ![]() | Uncollected FICA/Med Tax[5] | Currency | DLR11_$S2 | 14 |
111 | Uncollected_FICAMed_Tax_6 ![]() | Uncollected FICA/Med Tax[6] | Currency | DLR11_$S2 | 14 |
112 | Uncollected_FICAMed_Tax_7 ![]() | Uncollected FICA/Med Tax[7] | Currency | DLR11_$S2 | 14 |
113 | Uncollected_FICAMed_Tax_8 ![]() | Uncollected FICA/Med Tax[8] | Currency | DLR11_$S2 | 14 |
114 | Uncollected_FICAMed_Tax_9 ![]() | Uncollected FICA/Med Tax[9] | Currency | DLR11_$S2 | 14 |
115 | Uncollected_FICAMed_Tax ![]() | Uncollected FICA/Med Tax | DLR11_$S2 | Currency | 14 |
116 | Uncollected_FICAMed_Tax_10 ![]() | Uncollected FICA/Med Tax[10] | Currency | DLR11_$S2 | 14 |
117 | Uncollected_FICAMed_Tax_11 ![]() | Uncollected FICA/Med Tax[11] | Currency | DLR11_$S2 | 14 |
118 | Uncollected_FICAMed_Tax_12 ![]() | Uncollected FICA/Med Tax[12] | Currency | DLR11_$S2 | 14 |
119 | Reported_Receipts12_1 ![]() | Reported Receipts Array[1] | Currency | DLR11_$S2 | 14 |
120 | Reported_Receipts12_2 ![]() | Reported Receipts Array[2] | Currency | DLR11_$S2 | 14 |
121 | Reported_Receipts12_3 ![]() | Reported Receipts Array[3] | Currency | DLR11_$S2 | 14 |
122 | Reported_Receipts12_4 ![]() | Reported Receipts Array[4] | Currency | DLR11_$S2 | 14 |
123 | Reported_Receipts12_5 ![]() | Reported Receipts Array[5] | Currency | DLR11_$S2 | 14 |
124 | Reported_Receipts12_6 ![]() | Reported Receipts Array[6] | Currency | DLR11_$S2 | 14 |
125 | Reported_Receipts12_7 ![]() | Reported Receipts Array[7] | Currency | DLR11_$S2 | 14 |
126 | Reported_Receipts12_8 ![]() | Reported Receipts Array[8] | Currency | DLR11_$S2 | 14 |
127 | Reported_Receipts12_9 ![]() | Reported Receipts Array[9] | Currency | DLR11_$S2 | 14 |
128 | Reported_Receipts12_10 ![]() | Reported Receipts Array[10] | Currency | DLR11_$S2 | 14 |
129 | Reported_Receipts12 ![]() | Reported Receipts Array | DLR11_$S2 | Currency | 14 |
130 | Reported_Receipts12_11 ![]() | Reported Receipts Array[11] | Currency | DLR11_$S2 | 14 |
131 | Reported_Receipts12_12 ![]() | Reported Receipts Array[12] | Currency | DLR11_$S2 | 14 |
132 | Charged_Receipts12_1 ![]() | Charged Receipts Array[1] | Currency | DLR11_$S2 | 14 |
133 | Charged_Receipts12_2 ![]() | Charged Receipts Array[2] | Currency | DLR11_$S2 | 14 |
134 | Charged_Receipts12_3 ![]() | Charged Receipts Array[3] | Currency | DLR11_$S2 | 14 |
135 | Charged_Receipts12_4 ![]() | Charged Receipts Array[4] | Currency | DLR11_$S2 | 14 |
136 | Charged_Receipts12_5 ![]() | Charged Receipts Array[5] | Currency | DLR11_$S2 | 14 |
137 | Charged_Receipts12_6 ![]() | Charged Receipts Array[6] | Currency | DLR11_$S2 | 14 |
138 | Charged_Receipts12_7 ![]() | Charged Receipts Array[7] | Currency | DLR11_$S2 | 14 |
139 | Charged_Receipts12_8 ![]() | Charged Receipts Array[8] | Currency | DLR11_$S2 | 14 |
140 | Charged_Receipts12_9 ![]() | Charged Receipts Array[9] | Currency | DLR11_$S2 | 14 |
141 | Charged_Receipts12_10 ![]() | Charged Receipts Array[10] | Currency | DLR11_$S2 | 14 |
142 | Charged_Receipts12 ![]() | Charged Receipts Array | DLR11_$S2 | Currency | 14 |
143 | Charged_Receipts12_11 ![]() | Charged Receipts Array[11] | Currency | DLR11_$S2 | 14 |
144 | Charged_Receipts12_12 ![]() | Charged Receipts Array[12] | Currency | DLR11_$S2 | 14 |
145 | Allocated_Tips_Array_1 ![]() | Allocated Tips Array[1] | Currency | DLR11_$S2 | 14 |
146 | Allocated_Tips_Array_2 ![]() | Allocated Tips Array[2] | Currency | DLR11_$S2 | 14 |
147 | Allocated_Tips_Array_3 ![]() | Allocated Tips Array[3] | Currency | DLR11_$S2 | 14 |
148 | Allocated_Tips_Array_4 ![]() | Allocated Tips Array[4] | Currency | DLR11_$S2 | 14 |
149 | Allocated_Tips_Array_5 ![]() | Allocated Tips Array[5] | Currency | DLR11_$S2 | 14 |
150 | Allocated_Tips_Array_6 ![]() | Allocated Tips Array[6] | Currency | DLR11_$S2 | 14 |
151 | Allocated_Tips_Array_7 ![]() | Allocated Tips Array[7] | Currency | DLR11_$S2 | 14 |
152 | Allocated_Tips_Array_8 ![]() | Allocated Tips Array[8] | Currency | DLR11_$S2 | 14 |
153 | Allocated_Tips_Array_9 ![]() | Allocated Tips Array[9] | Currency | DLR11_$S2 | 14 |
154 | Allocated_Tips_Array_10 ![]() | Allocated Tips Array[10] | Currency | DLR11_$S2 | 14 |
155 | Allocated_Tips_Array_11 ![]() | Allocated Tips Array[11] | Currency | DLR11_$S2 | 14 |
156 | Allocated_Tips_Array_12 ![]() | Allocated Tips Array[12] | Currency | DLR11_$S2 | 14 |
157 | Allocated_Tips_Array ![]() | Allocated Tips Array | DLR11_$S2 | Currency | 14 |
158 | YEAR1 ![]() | Year | Integer | Year | 4 |
159 | Federal_Tips_1 ![]() | Federal Tips[1] | Currency | DLR11_$S2 | 14 |
160 | Federal_Tips_2 ![]() | Federal Tips[2] | Currency | DLR11_$S2 | 14 |
161 | Federal_Tips_3 ![]() | Federal Tips[3] | Currency | DLR11_$S2 | 14 |
162 | Federal_Tips_4 ![]() | Federal Tips[4] | Currency | DLR11_$S2 | 14 |
163 | Federal_Tips_5 ![]() | Federal Tips[5] | Currency | DLR11_$S2 | 14 |
164 | Federal_Tips_6 ![]() | Federal Tips[6] | Currency | DLR11_$S2 | 14 |
165 | Federal_Tips_7 ![]() | Federal Tips[7] | Currency | DLR11_$S2 | 14 |
166 | Federal_Tips_8 ![]() | Federal Tips[8] | Currency | DLR11_$S2 | 14 |
167 | Federal_Tips_9 ![]() | Federal Tips[9] | Currency | DLR11_$S2 | 14 |
168 | Federal_Tips_10 ![]() | Federal Tips[10] | Currency | DLR11_$S2 | 14 |
169 | Federal_Tips_11 ![]() | Federal Tips[11] | Currency | DLR11_$S2 | 14 |
170 | Federal_Tips_12 ![]() | Federal Tips[12] | Currency | DLR11_$S2 | 14 |
171 | Federal_Tips ![]() | Federal Tips | DLR11_$S2 | Currency | 14 |