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 TypeLength
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
2PYYTDARR SearchPay YTD ArrayDLR11_$S2Currency14
3PYYTDARR_1 SearchPay YTD Array[1]DLR11_$S2Currency14
4PYYTDARR_2 SearchPay YTD Array[2]DLR11_$S2Currency14
5PYYTDARR_3 SearchPay YTD Array[3]DLR11_$S2Currency14
6PYYTDARR_4 SearchPay YTD Array[4]DLR11_$S2Currency14
7PYYTDARR_5 SearchPay YTD Array[5]DLR11_$S2Currency14
8PYYTDARR_6 SearchPay YTD Array[6]DLR11_$S2Currency14
9PYYTDARR_7 SearchPay YTD Array[7]DLR11_$S2Currency14
10PYYTDARR_8 SearchPay YTD Array[8]DLR11_$S2Currency14
11PYYTDARR_9 SearchPay YTD Array[9]DLR11_$S2Currency14
12PYYTDARR_10 SearchPay YTD Array[10]DLR11_$S2Currency14
13PYYTDARR_11 SearchPay YTD Array[11]DLR11_$S2Currency14
14PYYTDARR_12 SearchPay YTD Array[12]DLR11_$S2Currency14
15PYYTDARR_13 SearchPay YTD Array[13]DLR11_$S2Currency14
16PYYTDARR_14 SearchPay YTD Array[14]DLR11_$S2Currency14
17PYYTDARR_15 SearchPay YTD Array[15]DLR11_$S2Currency14
18PYYTDARR_16 SearchPay YTD Array[16]DLR11_$S2Currency14
19PYYTDARR_17 SearchPay YTD Array[17]DLR11_$S2Currency14
20PYYTDARR_18 SearchPay YTD Array[18]DLR11_$S2Currency14
21PYYTDARR_19 SearchPay YTD Array[19]DLR11_$S2Currency14
22PYYTDARR_20 SearchPay YTD Array[20]DLR11_$S2Currency14
23PYYTDARR_21 SearchPay YTD Array[21]DLR11_$S2Currency14
24PYYTDARR_22 SearchPay YTD Array[22]DLR11_$S2Currency14
25PYYTDARR_23 SearchPay YTD Array[23]DLR11_$S2Currency14
26PYYTDARR_24 SearchPay YTD Array[24]DLR11_$S2Currency14
27PYYTDARR_25 SearchPay YTD Array[25]DLR11_$S2Currency14
28DAMYTDAR SearchDeduction Amount YTD ArrayDLR11_$S2Currency14
29DAMYTDAR_1 SearchDeduction Amount YTD Array[1]DLR11_$S2Currency14
30DAMYTDAR_2 SearchDeduction Amount YTD Array[2]DLR11_$S2Currency14
31DAMYTDAR_3 SearchDeduction Amount YTD Array[3]DLR11_$S2Currency14
32DAMYTDAR_4 SearchDeduction Amount YTD Array[4]DLR11_$S2Currency14
33DAMYTDAR_5 SearchDeduction Amount YTD Array[5]DLR11_$S2Currency14
34DAMYTDAR_6 SearchDeduction Amount YTD Array[6]DLR11_$S2Currency14
35DAMYTDAR_7 SearchDeduction Amount YTD Array[7]DLR11_$S2Currency14
36DAMYTDAR_8 SearchDeduction Amount YTD Array[8]DLR11_$S2Currency14
37DAMYTDAR_9 SearchDeduction Amount YTD Array[9]DLR11_$S2Currency14
38DAMYTDAR_10 SearchDeduction Amount YTD Array[10]DLR11_$S2Currency14
39DAMYTDAR_11 SearchDeduction Amount YTD Array[11]DLR11_$S2Currency14
40DAMYTDAR_12 SearchDeduction Amount YTD Array[12]DLR11_$S2Currency14
41DAMYTDAR_13 SearchDeduction Amount YTD Array[13]DLR11_$S2Currency14
42DAMYTDAR_14 SearchDeduction Amount YTD Array[14]DLR11_$S2Currency14
43DAMYTDAR_15 SearchDeduction Amount YTD Array[15]DLR11_$S2Currency14
44DAMYTDAR_16 SearchDeduction Amount YTD Array[16]DLR11_$S2Currency14
45DAMYTDAR_17 SearchDeduction Amount YTD Array[17]DLR11_$S2Currency14
46DAMYTDAR_18 SearchDeduction Amount YTD Array[18]DLR11_$S2Currency14
47DAMYTDAR_19 SearchDeduction Amount YTD Array[19]DLR11_$S2Currency14
48DAMYTDAR_20 SearchDeduction Amount YTD Array[20]DLR11_$S2Currency14
49DAMYTDAR_21 SearchDeduction Amount YTD Array[21]DLR11_$S2Currency14
50DAMYTDAR_22 SearchDeduction Amount YTD Array[22]DLR11_$S2Currency14
51DAMYTDAR_23 SearchDeduction Amount YTD Array[23]DLR11_$S2Currency14
52DAMYTDAR_24 SearchDeduction Amount YTD Array[24]DLR11_$S2Currency14
53DAMYTDAR_25 SearchDeduction Amount YTD Array[25]DLR11_$S2Currency14
54BAMYTDAR SearchBenefit Amount YTD ArrayDLR11_$S2Currency14
55BAMYTDAR_1 SearchBenefit Amount YTD Array[1]DLR11_$S2Currency14
56BAMYTDAR_2 SearchBenefit Amount YTD Array[2]DLR11_$S2Currency14
57BAMYTDAR_3 SearchBenefit Amount YTD Array[3]DLR11_$S2Currency14
58BAMYTDAR_4 SearchBenefit Amount YTD Array[4]DLR11_$S2Currency14
59BAMYTDAR_5 SearchBenefit Amount YTD Array[5]DLR11_$S2Currency14
60BAMYTDAR_6 SearchBenefit Amount YTD Array[6]DLR11_$S2Currency14
61BAMYTDAR_7 SearchBenefit Amount YTD Array[7]DLR11_$S2Currency14
62BAMYTDAR_8 SearchBenefit Amount YTD Array[8]DLR11_$S2Currency14
63BAMYTDAR_9 SearchBenefit Amount YTD Array[9]DLR11_$S2Currency14
64BAMYTDAR_10 SearchBenefit Amount YTD Array[10]DLR11_$S2Currency14
65BAMYTDAR_11 SearchBenefit Amount YTD Array[11]DLR11_$S2Currency14
66BAMYTDAR_12 SearchBenefit Amount YTD Array[12]DLR11_$S2Currency14
67BAMYTDAR_13 SearchBenefit Amount YTD Array[13]DLR11_$S2Currency14
68BAMYTDAR_14 SearchBenefit Amount YTD Array[14]DLR11_$S2Currency14
69BAMYTDAR_15 SearchBenefit Amount YTD Array[15]DLR11_$S2Currency14
70BAMYTDAR_16 SearchBenefit Amount YTD Array[16]DLR11_$S2Currency14
71BAMYTDAR_17 SearchBenefit Amount YTD Array[17]DLR11_$S2Currency14
72BAMYTDAR_18 SearchBenefit Amount YTD Array[18]DLR11_$S2Currency14
73BAMYTDAR_19 SearchBenefit Amount YTD Array[19]DLR11_$S2Currency14
74BAMYTDAR_20 SearchBenefit Amount YTD Array[20]DLR11_$S2Currency14
75BAMYTDAR_21 SearchBenefit Amount YTD Array[21]DLR11_$S2Currency14
76BAMYTDAR_22 SearchBenefit Amount YTD Array[22]DLR11_$S2Currency14
77BAMYTDAR_23 SearchBenefit Amount YTD Array[23]DLR11_$S2Currency14
78BAMYTDAR_24 SearchBenefit Amount YTD Array[24]DLR11_$S2Currency14
79BAMYTDAR_25 SearchBenefit Amount YTD Array[25]DLR11_$S2Currency14
80STATXYTD SearchState Tax YTDDLR11_$S2Currency14
81STATXYTD_1 SearchState Tax YTD[1]DLR11_$S2Currency14
82STATXYTD_2 SearchState Tax YTD[2]DLR11_$S2Currency14
83STATXYTD_3 SearchState Tax YTD[3]DLR11_$S2Currency14
84STATXYTD_4 SearchState Tax YTD[4]DLR11_$S2Currency14
85STATXYTD_5 SearchState Tax YTD[5]DLR11_$S2Currency14
86STATXYTD_6 SearchState Tax YTD[6]DLR11_$S2Currency14
87STATXYTD_7 SearchState Tax YTD[7]DLR11_$S2Currency14
88STATXYTD_8 SearchState Tax YTD[8]DLR11_$S2Currency14
89STATXYTD_9 SearchState Tax YTD[9]DLR11_$S2Currency14
90STATXYTD_10 SearchState Tax YTD[10]DLR11_$S2Currency14
91STATXYTD_11 SearchState Tax YTD[11]DLR11_$S2Currency14
92STATXYTD_12 SearchState Tax YTD[12]DLR11_$S2Currency14
93STATXYTD_13 SearchState Tax YTD[13]DLR11_$S2Currency14
94STATXYTD_14 SearchState Tax YTD[14]DLR11_$S2Currency14
95STATXYTD_15 SearchState Tax YTD[15]DLR11_$S2Currency14
96STATXYTD_16 SearchState Tax YTD[16]DLR11_$S2Currency14
97STATXYTD_17 SearchState Tax YTD[17]DLR11_$S2Currency14
98STATXYTD_18 SearchState Tax YTD[18]DLR11_$S2Currency14
99STATXYTD_19 SearchState Tax YTD[19]DLR11_$S2Currency14
100STATXYTD_20 SearchState Tax YTD[20]DLR11_$S2Currency14
101STATXYTD_21 SearchState Tax YTD[21]DLR11_$S2Currency14
102STATXYTD_22 SearchState Tax YTD[22]DLR11_$S2Currency14
103STATXYTD_23 SearchState Tax YTD[23]DLR11_$S2Currency14
104STATXYTD_24 SearchState Tax YTD[24]DLR11_$S2Currency14
105STATXYTD_25 SearchState Tax YTD[25]DLR11_$S2Currency14
106LCLTXYTD SearchLocal Tax YTDDLR11_$S2Currency14
107LCLTXYTD_1 SearchLocal Tax YTD[1]DLR11_$S2Currency14
108LCLTXYTD_2 SearchLocal Tax YTD[2]DLR11_$S2Currency14
109LCLTXYTD_3 SearchLocal Tax YTD[3]DLR11_$S2Currency14
110LCLTXYTD_4 SearchLocal Tax YTD[4]DLR11_$S2Currency14
111LCLTXYTD_5 SearchLocal Tax YTD[5]DLR11_$S2Currency14
112LCLTXYTD_6 SearchLocal Tax YTD[6]DLR11_$S2Currency14
113LCLTXYTD_7 SearchLocal Tax YTD[7]DLR11_$S2Currency14
114LCLTXYTD_8 SearchLocal Tax YTD[8]DLR11_$S2Currency14
115LCLTXYTD_9 SearchLocal Tax YTD[9]DLR11_$S2Currency14
116LCLTXYTD_10 SearchLocal Tax YTD[10]DLR11_$S2Currency14
117LCLTXYTD_11 SearchLocal Tax YTD[11]DLR11_$S2Currency14
118LCLTXYTD_12 SearchLocal Tax YTD[12]DLR11_$S2Currency14
119LCLTXYTD_13 SearchLocal Tax YTD[13]DLR11_$S2Currency14
120LCLTXYTD_14 SearchLocal Tax YTD[14]DLR11_$S2Currency14
121LCLTXYTD_15 SearchLocal Tax YTD[15]DLR11_$S2Currency14
122LCLTXYTD_16 SearchLocal Tax YTD[16]DLR11_$S2Currency14
123LCLTXYTD_17 SearchLocal Tax YTD[17]DLR11_$S2Currency14
124LCLTXYTD_18 SearchLocal Tax YTD[18]DLR11_$S2Currency14
125LCLTXYTD_19 SearchLocal Tax YTD[19]DLR11_$S2Currency14
126LCLTXYTD_20 SearchLocal Tax YTD[20]DLR11_$S2Currency14
127LCLTXYTD_21 SearchLocal Tax YTD[21]DLR11_$S2Currency14
128LCLTXYTD_22 SearchLocal Tax YTD[22]DLR11_$S2Currency14
129LCLTXYTD_23 SearchLocal Tax YTD[23]DLR11_$S2Currency14
130LCLTXYTD_24 SearchLocal Tax YTD[24]DLR11_$S2Currency14
131LCLTXYTD_25 SearchLocal Tax YTD[25]DLR11_$S2Currency14
132GRSWGYTD SearchGross Wages YTDDLR11_$S2Currency14
133NTWGSYTD SearchNet Wages YTDDLR11_$S2Currency14
134FICAWYTD SearchFICA Withholding YTDDLR11_$S2Currency14
135FCASSYTD SearchFICA/Social Security Withholding YTDDLR11_$S2Currency14
136FICAMYTD SearchFICA/Medicare Withholding YTDDLR11_$S2Currency14
137FDWDGYTD SearchFederal Withholding YTDDLR11_$S2Currency14
138SWHDGYTD SearchState Withholding YTDDLR11_$S2Currency14
139LCWHGYTD SearchLocal Withholding YTDDLR11_$S2Currency14
140USERID SearchUser IDSTR15_User_IDString15
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_$S2Currency14
142PYFYTDARR_1 SearchPay Fiscal YTD Array[1]DLR11_$S2Currency14
143PYFYTDARR_2 SearchPay Fiscal YTD Array[2]DLR11_$S2Currency14
144PYFYTDARR_3 SearchPay Fiscal YTD Array[3]DLR11_$S2Currency14
145PYFYTDARR_4 SearchPay Fiscal YTD Array[4]DLR11_$S2Currency14
146PYFYTDARR_5 SearchPay Fiscal YTD Array[5]DLR11_$S2Currency14
147PYFYTDARR_6 SearchPay Fiscal YTD Array[6]DLR11_$S2Currency14
148PYFYTDARR_7 SearchPay Fiscal YTD Array[7]DLR11_$S2Currency14
149PYFYTDARR_8 SearchPay Fiscal YTD Array[8]DLR11_$S2Currency14
150PYFYTDARR_9 SearchPay Fiscal YTD Array[9]DLR11_$S2Currency14
151PYFYTDARR_10 SearchPay Fiscal YTD Array[10]DLR11_$S2Currency14
152PYFYTDARR_11 SearchPay Fiscal YTD Array[11]DLR11_$S2Currency14
153PYFYTDARR_12 SearchPay Fiscal YTD Array[12]DLR11_$S2Currency14
154PYFYTDARR_13 SearchPay Fiscal YTD Array[13]DLR11_$S2Currency14
155PYFYTDARR_14 SearchPay Fiscal YTD Array[14]DLR11_$S2Currency14
156PYFYTDARR_15 SearchPay Fiscal YTD Array[15]DLR11_$S2Currency14
157PYFYTDARR_16 SearchPay Fiscal YTD Array[16]DLR11_$S2Currency14
158PYFYTDARR_17 SearchPay Fiscal YTD Array[17]DLR11_$S2Currency14
159PYFYTDARR_18 SearchPay Fiscal YTD Array[18]DLR11_$S2Currency14
160PYFYTDARR_19 SearchPay Fiscal YTD Array[19]DLR11_$S2Currency14
161PYFYTDARR_20 SearchPay Fiscal YTD Array[20]DLR11_$S2Currency14
162PYFYTDARR_21 SearchPay Fiscal YTD Array[21]DLR11_$S2Currency14
163PYFYTDARR_22 SearchPay Fiscal YTD Array[22]DLR11_$S2Currency14
164PYFYTDARR_23 SearchPay Fiscal YTD Array[23]DLR11_$S2Currency14
165PYFYTDARR_24 SearchPay Fiscal YTD Array[24]DLR11_$S2Currency14
166PYFYTDARR_25 SearchPay Fiscal YTD Array[25]DLR11_$S2Currency14
167DAMFYTDAR SearchDeduction Amount Fiscal YTD ArrayDLR11_$S2Currency14
168DAMFYTDAR_1 SearchDeduction Amount Fiscal YTD Array[1]DLR11_$S2Currency14
169DAMFYTDAR_2 SearchDeduction Amount Fiscal YTD Array[2]DLR11_$S2Currency14
170DAMFYTDAR_3 SearchDeduction Amount Fiscal YTD Array[3]DLR11_$S2Currency14
171DAMFYTDAR_4 SearchDeduction Amount Fiscal YTD Array[4]DLR11_$S2Currency14
172DAMFYTDAR_5 SearchDeduction Amount Fiscal YTD Array[5]DLR11_$S2Currency14
173DAMFYTDAR_6 SearchDeduction Amount Fiscal YTD Array[6]DLR11_$S2Currency14
174DAMFYTDAR_7 SearchDeduction Amount Fiscal YTD Array[7]DLR11_$S2Currency14
175DAMFYTDAR_8 SearchDeduction Amount Fiscal YTD Array[8]DLR11_$S2Currency14
176DAMFYTDAR_9 SearchDeduction Amount Fiscal YTD Array[9]DLR11_$S2Currency14
177DAMFYTDAR_10 SearchDeduction Amount Fiscal YTD Array[10]DLR11_$S2Currency14
178DAMFYTDAR_11 SearchDeduction Amount Fiscal YTD Array[11]DLR11_$S2Currency14
179DAMFYTDAR_12 SearchDeduction Amount Fiscal YTD Array[12]DLR11_$S2Currency14
180DAMFYTDAR_13 SearchDeduction Amount Fiscal YTD Array[13]DLR11_$S2Currency14
181DAMFYTDAR_14 SearchDeduction Amount Fiscal YTD Array[14]DLR11_$S2Currency14
182DAMFYTDAR_15 SearchDeduction Amount Fiscal YTD Array[15]DLR11_$S2Currency14
183DAMFYTDAR_16 SearchDeduction Amount Fiscal YTD Array[16]DLR11_$S2Currency14
184DAMFYTDAR_17 SearchDeduction Amount Fiscal YTD Array[17]DLR11_$S2Currency14
185DAMFYTDAR_18 SearchDeduction Amount Fiscal YTD Array[18]DLR11_$S2Currency14
186DAMFYTDAR_19 SearchDeduction Amount Fiscal YTD Array[19]DLR11_$S2Currency14
187DAMFYTDAR_20 SearchDeduction Amount Fiscal YTD Array[20]DLR11_$S2Currency14
188DAMFYTDAR_21 SearchDeduction Amount Fiscal YTD Array[21]DLR11_$S2Currency14
189DAMFYTDAR_22 SearchDeduction Amount Fiscal YTD Array[22]DLR11_$S2Currency14
190DAMFYTDAR_23 SearchDeduction Amount Fiscal YTD Array[23]DLR11_$S2Currency14
191DAMFYTDAR_24 SearchDeduction Amount Fiscal YTD Array[24]DLR11_$S2Currency14
192DAMFYTDAR_25 SearchDeduction Amount Fiscal YTD Array[25]DLR11_$S2Currency14
193BAMFYTDAR SearchBenefit Amount Fiscal YTD ArrayDLR11_$S2Currency14
194BAMFYTDAR_1 SearchBenefit Amount Fiscal YTD Array[1]DLR11_$S2Currency14
195BAMFYTDAR_2 SearchBenefit Amount Fiscal YTD Array[2]DLR11_$S2Currency14
196BAMFYTDAR_3 SearchBenefit Amount Fiscal YTD Array[3]DLR11_$S2Currency14
197BAMFYTDAR_4 SearchBenefit Amount Fiscal YTD Array[4]DLR11_$S2Currency14
198BAMFYTDAR_5 SearchBenefit Amount Fiscal YTD Array[5]DLR11_$S2Currency14
199BAMFYTDAR_6 SearchBenefit Amount Fiscal YTD Array[6]DLR11_$S2Currency14
200BAMFYTDAR_7 SearchBenefit Amount Fiscal YTD Array[7]DLR11_$S2Currency14
201BAMFYTDAR_8 SearchBenefit Amount Fiscal YTD Array[8]DLR11_$S2Currency14
202BAMFYTDAR_9 SearchBenefit Amount Fiscal YTD Array[9]DLR11_$S2Currency14
203BAMFYTDAR_10 SearchBenefit Amount Fiscal YTD Array[10]DLR11_$S2Currency14
204BAMFYTDAR_11 SearchBenefit Amount Fiscal YTD Array[11]DLR11_$S2Currency14
205BAMFYTDAR_12 SearchBenefit Amount Fiscal YTD Array[12]DLR11_$S2Currency14
206BAMFYTDAR_13 SearchBenefit Amount Fiscal YTD Array[13]DLR11_$S2Currency14
207BAMFYTDAR_14 SearchBenefit Amount Fiscal YTD Array[14]DLR11_$S2Currency14
208BAMFYTDAR_15 SearchBenefit Amount Fiscal YTD Array[15]DLR11_$S2Currency14
209BAMFYTDAR_16 SearchBenefit Amount Fiscal YTD Array[16]DLR11_$S2Currency14
210BAMFYTDAR_17 SearchBenefit Amount Fiscal YTD Array[17]DLR11_$S2Currency14
211BAMFYTDAR_18 SearchBenefit Amount Fiscal YTD Array[18]DLR11_$S2Currency14
212BAMFYTDAR_19 SearchBenefit Amount Fiscal YTD Array[19]DLR11_$S2Currency14
213BAMFYTDAR_20 SearchBenefit Amount Fiscal YTD Array[20]DLR11_$S2Currency14
214BAMFYTDAR_21 SearchBenefit Amount Fiscal YTD Array[21]DLR11_$S2Currency14
215BAMFYTDAR_22 SearchBenefit Amount Fiscal YTD Array[22]DLR11_$S2Currency14
216BAMFYTDAR_23 SearchBenefit Amount Fiscal YTD Array[23]DLR11_$S2Currency14
217BAMFYTDAR_24 SearchBenefit Amount Fiscal YTD Array[24]DLR11_$S2Currency14
218BAMFYTDAR_25 SearchBenefit Amount Fiscal YTD Array[25]DLR11_$S2Currency14
219DEX_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 Work Check YTD Amounts (UPR10214)

Leave a Reply

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