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_3 | Federal Tax On Tips[3] | Currency | DLR11_$S2 | 14 |
31 | Federal_Tax_On_Tips | Federal Tax On Tips | DLR11_$S2 | Currency | 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 | Uncollected FICA/SS Tax | DLR11_$S2 | Currency | 14 |
73 | Uncollected_FICASS_Tax_6 | Uncollected FICA/SS Tax[6] | Currency | DLR11_$S2 | 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 | FICA/Med Tips | DLR11_$S2 | Currency | 14 |
87 | FICAMed_Tips_7 | FICA/Med Tips[7] | Currency | DLR11_$S2 | 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 |