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

Leave a Reply

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