Payroll Employee Tips Summary (UPR00901)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Employee Tips Summary (UPR00901)

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
Physical Name: UPR00901
Technical Name: UPR_Employee_Tips_SUM

Group Display Name: Payroll Employee Master
Group Technical Name: Payroll Employee Master

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

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Employee Tips Summary (UPR00901)

Leave a Reply

Your email address will not be published. Required fields are marked *