Payroll Work Check YTD Amounts (UPR10214)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Work Check YTD Amounts (UPR10214)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR10214

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Work Check YTD Amounts
Physical Name: UPR10214
Technical Name: uprWorkChkYTD

Group Display Name: Payroll Check Work
Group Technical Name: Payroll Check Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
2PYYTDARR SearchPay YTD ArrayDLR11_$S2Currency1014
3PYYTDARR_1 SearchPay YTD Array[1]DLR11_$S2Currency1014
4PYYTDARR_2 SearchPay YTD Array[2]DLR11_$S2Currency1014
5PYYTDARR_3 SearchPay YTD Array[3]DLR11_$S2Currency1014
6PYYTDARR_4 SearchPay YTD Array[4]DLR11_$S2Currency1014
7PYYTDARR_5 SearchPay YTD Array[5]DLR11_$S2Currency1014
8PYYTDARR_6 SearchPay YTD Array[6]DLR11_$S2Currency1014
9PYYTDARR_7 SearchPay YTD Array[7]DLR11_$S2Currency1014
10PYYTDARR_8 SearchPay YTD Array[8]DLR11_$S2Currency1014
11PYYTDARR_9 SearchPay YTD Array[9]DLR11_$S2Currency1014
12PYYTDARR_10 SearchPay YTD Array[10]DLR11_$S2Currency1014
13PYYTDARR_11 SearchPay YTD Array[11]DLR11_$S2Currency1014
14PYYTDARR_12 SearchPay YTD Array[12]DLR11_$S2Currency1014
15PYYTDARR_13 SearchPay YTD Array[13]DLR11_$S2Currency1014
16PYYTDARR_14 SearchPay YTD Array[14]DLR11_$S2Currency1014
17PYYTDARR_15 SearchPay YTD Array[15]DLR11_$S2Currency1014
18PYYTDARR_16 SearchPay YTD Array[16]DLR11_$S2Currency1014
19PYYTDARR_17 SearchPay YTD Array[17]DLR11_$S2Currency1014
20PYYTDARR_18 SearchPay YTD Array[18]DLR11_$S2Currency1014
21PYYTDARR_19 SearchPay YTD Array[19]DLR11_$S2Currency1014
22PYYTDARR_20 SearchPay YTD Array[20]DLR11_$S2Currency1014
23PYYTDARR_21 SearchPay YTD Array[21]DLR11_$S2Currency1014
24PYYTDARR_22 SearchPay YTD Array[22]DLR11_$S2Currency1014
25PYYTDARR_23 SearchPay YTD Array[23]DLR11_$S2Currency1014
26PYYTDARR_24 SearchPay YTD Array[24]DLR11_$S2Currency1014
27PYYTDARR_25 SearchPay YTD Array[25]DLR11_$S2Currency1014
28DAMYTDAR SearchDeduction Amount YTD ArrayDLR11_$S2Currency1014
29DAMYTDAR_1 SearchDeduction Amount YTD Array[1]DLR11_$S2Currency1014
30DAMYTDAR_2 SearchDeduction Amount YTD Array[2]DLR11_$S2Currency1014
31DAMYTDAR_3 SearchDeduction Amount YTD Array[3]DLR11_$S2Currency1014
32DAMYTDAR_4 SearchDeduction Amount YTD Array[4]DLR11_$S2Currency1014
33DAMYTDAR_5 SearchDeduction Amount YTD Array[5]DLR11_$S2Currency1014
34DAMYTDAR_6 SearchDeduction Amount YTD Array[6]DLR11_$S2Currency1014
35DAMYTDAR_7 SearchDeduction Amount YTD Array[7]DLR11_$S2Currency1014
36DAMYTDAR_8 SearchDeduction Amount YTD Array[8]DLR11_$S2Currency1014
37DAMYTDAR_9 SearchDeduction Amount YTD Array[9]DLR11_$S2Currency1014
38DAMYTDAR_10 SearchDeduction Amount YTD Array[10]DLR11_$S2Currency1014
39DAMYTDAR_11 SearchDeduction Amount YTD Array[11]DLR11_$S2Currency1014
40DAMYTDAR_12 SearchDeduction Amount YTD Array[12]DLR11_$S2Currency1014
41DAMYTDAR_13 SearchDeduction Amount YTD Array[13]DLR11_$S2Currency1014
42DAMYTDAR_14 SearchDeduction Amount YTD Array[14]DLR11_$S2Currency1014
43DAMYTDAR_15 SearchDeduction Amount YTD Array[15]DLR11_$S2Currency1014
44DAMYTDAR_16 SearchDeduction Amount YTD Array[16]DLR11_$S2Currency1014
45DAMYTDAR_17 SearchDeduction Amount YTD Array[17]DLR11_$S2Currency1014
46DAMYTDAR_18 SearchDeduction Amount YTD Array[18]DLR11_$S2Currency1014
47DAMYTDAR_19 SearchDeduction Amount YTD Array[19]DLR11_$S2Currency1014
48DAMYTDAR_20 SearchDeduction Amount YTD Array[20]DLR11_$S2Currency1014
49DAMYTDAR_21 SearchDeduction Amount YTD Array[21]DLR11_$S2Currency1014
50DAMYTDAR_22 SearchDeduction Amount YTD Array[22]DLR11_$S2Currency1014
51DAMYTDAR_23 SearchDeduction Amount YTD Array[23]DLR11_$S2Currency1014
52DAMYTDAR_24 SearchDeduction Amount YTD Array[24]DLR11_$S2Currency1014
53DAMYTDAR_25 SearchDeduction Amount YTD Array[25]DLR11_$S2Currency1014
54BAMYTDAR SearchBenefit Amount YTD ArrayDLR11_$S2Currency1014
55BAMYTDAR_1 SearchBenefit Amount YTD Array[1]DLR11_$S2Currency1014
56BAMYTDAR_2 SearchBenefit Amount YTD Array[2]DLR11_$S2Currency1014
57BAMYTDAR_3 SearchBenefit Amount YTD Array[3]DLR11_$S2Currency1014
58BAMYTDAR_4 SearchBenefit Amount YTD Array[4]DLR11_$S2Currency1014
59BAMYTDAR_5 SearchBenefit Amount YTD Array[5]DLR11_$S2Currency1014
60BAMYTDAR_6 SearchBenefit Amount YTD Array[6]DLR11_$S2Currency1014
61BAMYTDAR_7 SearchBenefit Amount YTD Array[7]DLR11_$S2Currency1014
62BAMYTDAR_8 SearchBenefit Amount YTD Array[8]DLR11_$S2Currency1014
63BAMYTDAR_9 SearchBenefit Amount YTD Array[9]DLR11_$S2Currency1014
64BAMYTDAR_10 SearchBenefit Amount YTD Array[10]DLR11_$S2Currency1014
65BAMYTDAR_11 SearchBenefit Amount YTD Array[11]DLR11_$S2Currency1014
66BAMYTDAR_12 SearchBenefit Amount YTD Array[12]DLR11_$S2Currency1014
67BAMYTDAR_13 SearchBenefit Amount YTD Array[13]DLR11_$S2Currency1014
68BAMYTDAR_14 SearchBenefit Amount YTD Array[14]DLR11_$S2Currency1014
69BAMYTDAR_15 SearchBenefit Amount YTD Array[15]DLR11_$S2Currency1014
70BAMYTDAR_16 SearchBenefit Amount YTD Array[16]DLR11_$S2Currency1014
71BAMYTDAR_17 SearchBenefit Amount YTD Array[17]DLR11_$S2Currency1014
72BAMYTDAR_18 SearchBenefit Amount YTD Array[18]DLR11_$S2Currency1014
73BAMYTDAR_19 SearchBenefit Amount YTD Array[19]DLR11_$S2Currency1014
74BAMYTDAR_20 SearchBenefit Amount YTD Array[20]DLR11_$S2Currency1014
75BAMYTDAR_21 SearchBenefit Amount YTD Array[21]DLR11_$S2Currency1014
76BAMYTDAR_22 SearchBenefit Amount YTD Array[22]DLR11_$S2Currency1014
77BAMYTDAR_23 SearchBenefit Amount YTD Array[23]DLR11_$S2Currency1014
78BAMYTDAR_24 SearchBenefit Amount YTD Array[24]DLR11_$S2Currency1014
79BAMYTDAR_25 SearchBenefit Amount YTD Array[25]DLR11_$S2Currency1014
80STATXYTD SearchState Tax YTDDLR11_$S2Currency1014
81STATXYTD_1 SearchState Tax YTD[1]DLR11_$S2Currency1014
82STATXYTD_2 SearchState Tax YTD[2]DLR11_$S2Currency1014
83STATXYTD_3 SearchState Tax YTD[3]DLR11_$S2Currency1014
84STATXYTD_4 SearchState Tax YTD[4]DLR11_$S2Currency1014
85STATXYTD_5 SearchState Tax YTD[5]DLR11_$S2Currency1014
86STATXYTD_6 SearchState Tax YTD[6]DLR11_$S2Currency1014
87STATXYTD_7 SearchState Tax YTD[7]DLR11_$S2Currency1014
88STATXYTD_8 SearchState Tax YTD[8]DLR11_$S2Currency1014
89STATXYTD_9 SearchState Tax YTD[9]DLR11_$S2Currency1014
90STATXYTD_10 SearchState Tax YTD[10]DLR11_$S2Currency1014
91STATXYTD_11 SearchState Tax YTD[11]DLR11_$S2Currency1014
92STATXYTD_12 SearchState Tax YTD[12]DLR11_$S2Currency1014
93STATXYTD_13 SearchState Tax YTD[13]DLR11_$S2Currency1014
94STATXYTD_14 SearchState Tax YTD[14]DLR11_$S2Currency1014
95STATXYTD_15 SearchState Tax YTD[15]DLR11_$S2Currency1014
96STATXYTD_16 SearchState Tax YTD[16]DLR11_$S2Currency1014
97STATXYTD_17 SearchState Tax YTD[17]DLR11_$S2Currency1014
98STATXYTD_18 SearchState Tax YTD[18]DLR11_$S2Currency1014
99STATXYTD_19 SearchState Tax YTD[19]DLR11_$S2Currency1014
100STATXYTD_20 SearchState Tax YTD[20]DLR11_$S2Currency1014
101STATXYTD_21 SearchState Tax YTD[21]DLR11_$S2Currency1014
102STATXYTD_22 SearchState Tax YTD[22]DLR11_$S2Currency1014
103STATXYTD_23 SearchState Tax YTD[23]DLR11_$S2Currency1014
104STATXYTD_24 SearchState Tax YTD[24]DLR11_$S2Currency1014
105STATXYTD_25 SearchState Tax YTD[25]DLR11_$S2Currency1014
106LCLTXYTD SearchLocal Tax YTDDLR11_$S2Currency1014
107LCLTXYTD_1 SearchLocal Tax YTD[1]DLR11_$S2Currency1014
108LCLTXYTD_2 SearchLocal Tax YTD[2]DLR11_$S2Currency1014
109LCLTXYTD_3 SearchLocal Tax YTD[3]DLR11_$S2Currency1014
110LCLTXYTD_4 SearchLocal Tax YTD[4]DLR11_$S2Currency1014
111LCLTXYTD_5 SearchLocal Tax YTD[5]DLR11_$S2Currency1014
112LCLTXYTD_6 SearchLocal Tax YTD[6]DLR11_$S2Currency1014
113LCLTXYTD_7 SearchLocal Tax YTD[7]DLR11_$S2Currency1014
114LCLTXYTD_8 SearchLocal Tax YTD[8]DLR11_$S2Currency1014
115LCLTXYTD_9 SearchLocal Tax YTD[9]DLR11_$S2Currency1014
116LCLTXYTD_10 SearchLocal Tax YTD[10]DLR11_$S2Currency1014
117LCLTXYTD_11 SearchLocal Tax YTD[11]DLR11_$S2Currency1014
118LCLTXYTD_12 SearchLocal Tax YTD[12]DLR11_$S2Currency1014
119LCLTXYTD_13 SearchLocal Tax YTD[13]DLR11_$S2Currency1014
120LCLTXYTD_14 SearchLocal Tax YTD[14]DLR11_$S2Currency1014
121LCLTXYTD_15 SearchLocal Tax YTD[15]DLR11_$S2Currency1014
122LCLTXYTD_16 SearchLocal Tax YTD[16]DLR11_$S2Currency1014
123LCLTXYTD_17 SearchLocal Tax YTD[17]DLR11_$S2Currency1014
124LCLTXYTD_18 SearchLocal Tax YTD[18]DLR11_$S2Currency1014
125LCLTXYTD_19 SearchLocal Tax YTD[19]DLR11_$S2Currency1014
126LCLTXYTD_20 SearchLocal Tax YTD[20]DLR11_$S2Currency1014
127LCLTXYTD_21 SearchLocal Tax YTD[21]DLR11_$S2Currency1014
128LCLTXYTD_22 SearchLocal Tax YTD[22]DLR11_$S2Currency1014
129LCLTXYTD_23 SearchLocal Tax YTD[23]DLR11_$S2Currency1014
130LCLTXYTD_24 SearchLocal Tax YTD[24]DLR11_$S2Currency1014
131LCLTXYTD_25 SearchLocal Tax YTD[25]DLR11_$S2Currency1014
132GRSWGYTD SearchGross Wages YTDDLR11_$S2Currency1014
133NTWGSYTD SearchNet Wages YTDDLR11_$S2Currency1014
134FICAWYTD SearchFICA Withholding YTDDLR11_$S2Currency1014
135FCASSYTD SearchFICA/Social Security Withholding YTDDLR11_$S2Currency1014
136FICAMYTD SearchFICA/Medicare Withholding YTDDLR11_$S2Currency1014
137FDWDGYTD SearchFederal Withholding YTDDLR11_$S2Currency1014
138SWHDGYTD SearchState Withholding YTDDLR11_$S2Currency1014
139LCWHGYTD SearchLocal Withholding YTDDLR11_$S2Currency1014
140USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Work Check YTD Amounts'].USERID AS 'Payroll Work Check YTD Amounts-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       UPR10214 AS ['Payroll Work Check YTD Amounts']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Work Check YTD Amounts'].USERID = ['Users Master'].USERID
141PYFYTDARR SearchPay Fiscal YTD ArrayDLR11_$S2Currency1014
142PYFYTDARR_1 SearchPay Fiscal YTD Array[1]DLR11_$S2Currency1014
143PYFYTDARR_2 SearchPay Fiscal YTD Array[2]DLR11_$S2Currency1014
144PYFYTDARR_3 SearchPay Fiscal YTD Array[3]DLR11_$S2Currency1014
145PYFYTDARR_4 SearchPay Fiscal YTD Array[4]DLR11_$S2Currency1014
146PYFYTDARR_5 SearchPay Fiscal YTD Array[5]DLR11_$S2Currency1014
147PYFYTDARR_6 SearchPay Fiscal YTD Array[6]DLR11_$S2Currency1014
148PYFYTDARR_7 SearchPay Fiscal YTD Array[7]DLR11_$S2Currency1014
149PYFYTDARR_8 SearchPay Fiscal YTD Array[8]DLR11_$S2Currency1014
150PYFYTDARR_9 SearchPay Fiscal YTD Array[9]DLR11_$S2Currency1014
151PYFYTDARR_10 SearchPay Fiscal YTD Array[10]DLR11_$S2Currency1014
152PYFYTDARR_11 SearchPay Fiscal YTD Array[11]DLR11_$S2Currency1014
153PYFYTDARR_12 SearchPay Fiscal YTD Array[12]DLR11_$S2Currency1014
154PYFYTDARR_13 SearchPay Fiscal YTD Array[13]DLR11_$S2Currency1014
155PYFYTDARR_14 SearchPay Fiscal YTD Array[14]DLR11_$S2Currency1014
156PYFYTDARR_15 SearchPay Fiscal YTD Array[15]DLR11_$S2Currency1014
157PYFYTDARR_16 SearchPay Fiscal YTD Array[16]DLR11_$S2Currency1014
158PYFYTDARR_17 SearchPay Fiscal YTD Array[17]DLR11_$S2Currency1014
159PYFYTDARR_18 SearchPay Fiscal YTD Array[18]DLR11_$S2Currency1014
160PYFYTDARR_19 SearchPay Fiscal YTD Array[19]DLR11_$S2Currency1014
161PYFYTDARR_20 SearchPay Fiscal YTD Array[20]DLR11_$S2Currency1014
162PYFYTDARR_21 SearchPay Fiscal YTD Array[21]DLR11_$S2Currency1014
163PYFYTDARR_22 SearchPay Fiscal YTD Array[22]DLR11_$S2Currency1014
164PYFYTDARR_23 SearchPay Fiscal YTD Array[23]DLR11_$S2Currency1014
165PYFYTDARR_24 SearchPay Fiscal YTD Array[24]DLR11_$S2Currency1014
166PYFYTDARR_25 SearchPay Fiscal YTD Array[25]DLR11_$S2Currency1014
167DAMFYTDAR SearchDeduction Amount Fiscal YTD ArrayDLR11_$S2Currency1014
168DAMFYTDAR_1 SearchDeduction Amount Fiscal YTD Array[1]DLR11_$S2Currency1014
169DAMFYTDAR_2 SearchDeduction Amount Fiscal YTD Array[2]DLR11_$S2Currency1014
170DAMFYTDAR_3 SearchDeduction Amount Fiscal YTD Array[3]DLR11_$S2Currency1014
171DAMFYTDAR_4 SearchDeduction Amount Fiscal YTD Array[4]DLR11_$S2Currency1014
172DAMFYTDAR_5 SearchDeduction Amount Fiscal YTD Array[5]DLR11_$S2Currency1014
173DAMFYTDAR_6 SearchDeduction Amount Fiscal YTD Array[6]DLR11_$S2Currency1014
174DAMFYTDAR_7 SearchDeduction Amount Fiscal YTD Array[7]DLR11_$S2Currency1014
175DAMFYTDAR_8 SearchDeduction Amount Fiscal YTD Array[8]DLR11_$S2Currency1014
176DAMFYTDAR_9 SearchDeduction Amount Fiscal YTD Array[9]DLR11_$S2Currency1014
177DAMFYTDAR_10 SearchDeduction Amount Fiscal YTD Array[10]DLR11_$S2Currency1014
178DAMFYTDAR_11 SearchDeduction Amount Fiscal YTD Array[11]DLR11_$S2Currency1014
179DAMFYTDAR_12 SearchDeduction Amount Fiscal YTD Array[12]DLR11_$S2Currency1014
180DAMFYTDAR_13 SearchDeduction Amount Fiscal YTD Array[13]DLR11_$S2Currency1014
181DAMFYTDAR_14 SearchDeduction Amount Fiscal YTD Array[14]DLR11_$S2Currency1014
182DAMFYTDAR_15 SearchDeduction Amount Fiscal YTD Array[15]DLR11_$S2Currency1014
183DAMFYTDAR_16 SearchDeduction Amount Fiscal YTD Array[16]DLR11_$S2Currency1014
184DAMFYTDAR_17 SearchDeduction Amount Fiscal YTD Array[17]DLR11_$S2Currency1014
185DAMFYTDAR_18 SearchDeduction Amount Fiscal YTD Array[18]DLR11_$S2Currency1014
186DAMFYTDAR_19 SearchDeduction Amount Fiscal YTD Array[19]DLR11_$S2Currency1014
187DAMFYTDAR_20 SearchDeduction Amount Fiscal YTD Array[20]DLR11_$S2Currency1014
188DAMFYTDAR_21 SearchDeduction Amount Fiscal YTD Array[21]DLR11_$S2Currency1014
189DAMFYTDAR_22 SearchDeduction Amount Fiscal YTD Array[22]DLR11_$S2Currency1014
190DAMFYTDAR_23 SearchDeduction Amount Fiscal YTD Array[23]DLR11_$S2Currency1014
191DAMFYTDAR_24 SearchDeduction Amount Fiscal YTD Array[24]DLR11_$S2Currency1014
192DAMFYTDAR_25 SearchDeduction Amount Fiscal YTD Array[25]DLR11_$S2Currency1014
193BAMFYTDAR SearchBenefit Amount Fiscal YTD ArrayDLR11_$S2Currency1014
194BAMFYTDAR_1 SearchBenefit Amount Fiscal YTD Array[1]DLR11_$S2Currency1014
195BAMFYTDAR_2 SearchBenefit Amount Fiscal YTD Array[2]DLR11_$S2Currency1014
196BAMFYTDAR_3 SearchBenefit Amount Fiscal YTD Array[3]DLR11_$S2Currency1014
197BAMFYTDAR_4 SearchBenefit Amount Fiscal YTD Array[4]DLR11_$S2Currency1014
198BAMFYTDAR_5 SearchBenefit Amount Fiscal YTD Array[5]DLR11_$S2Currency1014
199BAMFYTDAR_6 SearchBenefit Amount Fiscal YTD Array[6]DLR11_$S2Currency1014
200BAMFYTDAR_7 SearchBenefit Amount Fiscal YTD Array[7]DLR11_$S2Currency1014
201BAMFYTDAR_8 SearchBenefit Amount Fiscal YTD Array[8]DLR11_$S2Currency1014
202BAMFYTDAR_9 SearchBenefit Amount Fiscal YTD Array[9]DLR11_$S2Currency1014
203BAMFYTDAR_10 SearchBenefit Amount Fiscal YTD Array[10]DLR11_$S2Currency1014
204BAMFYTDAR_11 SearchBenefit Amount Fiscal YTD Array[11]DLR11_$S2Currency1014
205BAMFYTDAR_12 SearchBenefit Amount Fiscal YTD Array[12]DLR11_$S2Currency1014
206BAMFYTDAR_13 SearchBenefit Amount Fiscal YTD Array[13]DLR11_$S2Currency1014
207BAMFYTDAR_14 SearchBenefit Amount Fiscal YTD Array[14]DLR11_$S2Currency1014
208BAMFYTDAR_15 SearchBenefit Amount Fiscal YTD Array[15]DLR11_$S2Currency1014
209BAMFYTDAR_16 SearchBenefit Amount Fiscal YTD Array[16]DLR11_$S2Currency1014
210BAMFYTDAR_17 SearchBenefit Amount Fiscal YTD Array[17]DLR11_$S2Currency1014
211BAMFYTDAR_18 SearchBenefit Amount Fiscal YTD Array[18]DLR11_$S2Currency1014
212BAMFYTDAR_19 SearchBenefit Amount Fiscal YTD Array[19]DLR11_$S2Currency1014
213BAMFYTDAR_20 SearchBenefit Amount Fiscal YTD Array[20]DLR11_$S2Currency1014
214BAMFYTDAR_21 SearchBenefit Amount Fiscal YTD Array[21]DLR11_$S2Currency1014
215BAMFYTDAR_22 SearchBenefit Amount Fiscal YTD Array[22]DLR11_$S2Currency1014
216BAMFYTDAR_23 SearchBenefit Amount Fiscal YTD Array[23]DLR11_$S2Currency1014
217BAMFYTDAR_24 SearchBenefit Amount Fiscal YTD Array[24]DLR11_$S2Currency1014
218BAMFYTDAR_25 SearchBenefit Amount Fiscal YTD Array[25]DLR11_$S2Currency1014
219DEX_ROW_ID Searchintint1010

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 Work Check YTD Amounts (UPR10214)

Leave a Reply

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