Payroll Check Descriptions (UPR10213)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Check Descriptions (UPR10213)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Check Descriptions
Physical Name: UPR10213
Technical Name: uprWorkChkDesc

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
2PYCDDSAR SearchPay Code Description ArraySTR30String30
3PYCDDSAR_1 SearchPay Code Description Array[1]StringSTR3030
4PYCDDSAR_2 SearchPay Code Description Array[2]StringSTR3030
5PYCDDSAR_3 SearchPay Code Description Array[3]StringSTR3030
6PYCDDSAR_4 SearchPay Code Description Array[4]StringSTR3030
7PYCDDSAR_5 SearchPay Code Description Array[5]StringSTR3030
8PYCDDSAR_6 SearchPay Code Description Array[6]StringSTR3030
9PYCDDSAR_7 SearchPay Code Description Array[7]StringSTR3030
10PYCDDSAR_8 SearchPay Code Description Array[8]StringSTR3030
11PYCDDSAR_9 SearchPay Code Description Array[9]StringSTR3030
12PYCDDSAR_10 SearchPay Code Description Array[10]StringSTR3030
13PYCDDSAR_11 SearchPay Code Description Array[11]StringSTR3030
14PYCDDSAR_12 SearchPay Code Description Array[12]StringSTR3030
15PYCDDSAR_13 SearchPay Code Description Array[13]StringSTR3030
16PYCDDSAR_14 SearchPay Code Description Array[14]StringSTR3030
17PYCDDSAR_15 SearchPay Code Description Array[15]StringSTR3030
18PYCDDSAR_16 SearchPay Code Description Array[16]StringSTR3030
19PYCDDSAR_17 SearchPay Code Description Array[17]StringSTR3030
20PYCDDSAR_18 SearchPay Code Description Array[18]StringSTR3030
21PYCDDSAR_19 SearchPay Code Description Array[19]StringSTR3030
22PYCDDSAR_20 SearchPay Code Description Array[20]StringSTR3030
23PYCDDSAR_21 SearchPay Code Description Array[21]StringSTR3030
24PYCDDSAR_22 SearchPay Code Description Array[22]StringSTR3030
25PYCDDSAR_23 SearchPay Code Description Array[23]StringSTR3030
26PYCDDSAR_24 SearchPay Code Description Array[24]StringSTR3030
27PYCDDSAR_25 SearchPay Code Description Array[25]StringSTR3030
28deddesar_1 SearchDeduction Description Array[1]StringSTR3030
29deddesar_2 SearchDeduction Description Array[2]StringSTR3030
30deddesar SearchDeduction Description ArraySTR30String30
31deddesar_3 SearchDeduction Description Array[3]StringSTR3030
32deddesar_4 SearchDeduction Description Array[4]StringSTR3030
33deddesar_5 SearchDeduction Description Array[5]StringSTR3030
34deddesar_6 SearchDeduction Description Array[6]StringSTR3030
35deddesar_7 SearchDeduction Description Array[7]StringSTR3030
36deddesar_8 SearchDeduction Description Array[8]StringSTR3030
37deddesar_9 SearchDeduction Description Array[9]StringSTR3030
38deddesar_10 SearchDeduction Description Array[10]StringSTR3030
39deddesar_11 SearchDeduction Description Array[11]StringSTR3030
40deddesar_12 SearchDeduction Description Array[12]StringSTR3030
41deddesar_13 SearchDeduction Description Array[13]StringSTR3030
42deddesar_14 SearchDeduction Description Array[14]StringSTR3030
43deddesar_15 SearchDeduction Description Array[15]StringSTR3030
44deddesar_16 SearchDeduction Description Array[16]StringSTR3030
45deddesar_17 SearchDeduction Description Array[17]StringSTR3030
46deddesar_18 SearchDeduction Description Array[18]StringSTR3030
47deddesar_19 SearchDeduction Description Array[19]StringSTR3030
48deddesar_20 SearchDeduction Description Array[20]StringSTR3030
49deddesar_21 SearchDeduction Description Array[21]StringSTR3030
50deddesar_22 SearchDeduction Description Array[22]StringSTR3030
51deddesar_23 SearchDeduction Description Array[23]StringSTR3030
52deddesar_24 SearchDeduction Description Array[24]StringSTR3030
53deddesar_25 SearchDeduction Description Array[25]StringSTR3030
54BENDESAR_1 SearchBenefit Description Array[1]StringSTR3030
55BENDESAR_2 SearchBenefit Description Array[2]StringSTR3030
56BENDESAR_3 SearchBenefit Description Array[3]StringSTR3030
57BENDESAR SearchBenefit Description ArraySTR30String30
58BENDESAR_4 SearchBenefit Description Array[4]StringSTR3030
59BENDESAR_5 SearchBenefit Description Array[5]StringSTR3030
60BENDESAR_6 SearchBenefit Description Array[6]StringSTR3030
61BENDESAR_7 SearchBenefit Description Array[7]StringSTR3030
62BENDESAR_8 SearchBenefit Description Array[8]StringSTR3030
63BENDESAR_9 SearchBenefit Description Array[9]StringSTR3030
64BENDESAR_10 SearchBenefit Description Array[10]StringSTR3030
65BENDESAR_11 SearchBenefit Description Array[11]StringSTR3030
66BENDESAR_12 SearchBenefit Description Array[12]StringSTR3030
67BENDESAR_13 SearchBenefit Description Array[13]StringSTR3030
68BENDESAR_14 SearchBenefit Description Array[14]StringSTR3030
69BENDESAR_15 SearchBenefit Description Array[15]StringSTR3030
70BENDESAR_16 SearchBenefit Description Array[16]StringSTR3030
71BENDESAR_17 SearchBenefit Description Array[17]StringSTR3030
72BENDESAR_18 SearchBenefit Description Array[18]StringSTR3030
73BENDESAR_19 SearchBenefit Description Array[19]StringSTR3030
74BENDESAR_20 SearchBenefit Description Array[20]StringSTR3030
75BENDESAR_21 SearchBenefit Description Array[21]StringSTR3030
76BENDESAR_22 SearchBenefit Description Array[22]StringSTR3030
77BENDESAR_23 SearchBenefit Description Array[23]StringSTR3030
78BENDESAR_24 SearchBenefit Description Array[24]StringSTR3030
79BENDESAR_25 SearchBenefit Description Array[25]StringSTR3030
80TIMECODEDESCARRAY_1 SearchTime Code Description Array[1]StringSTR3030
81TIMECODEDESCARRAY_2 SearchTime Code Description Array[2]StringSTR3030
82TIMECODEDESCARRAY_3 SearchTime Code Description Array[3]StringSTR3030
83TIMECODEDESCARRAY SearchTime Code Description ArraySTR30String30
84TIMECODEDESCARRAY_4 SearchTime Code Description Array[4]StringSTR3030
85TIMECODEDESCARRAY_5 SearchTime Code Description Array[5]StringSTR3030
86TIMECODEDESCARRAY_6 SearchTime Code Description Array[6]StringSTR3030
87TIMECODEDESCARRAY_7 SearchTime Code Description Array[7]StringSTR3030
88TIMECODEDESCARRAY_8 SearchTime Code Description Array[8]StringSTR3030
89TIMECODEDESCARRAY_9 SearchTime Code Description Array[9]StringSTR3030
90TIMECODEDESCARRAY_10 SearchTime Code Description Array[10]StringSTR3030
91TIMECODEDESCARRAY_11 SearchTime Code Description Array[11]StringSTR3030
92TIMECODEDESCARRAY_12 SearchTime Code Description Array[12]StringSTR3030
93TIMECODEDESCARRAY_13 SearchTime Code Description Array[13]StringSTR3030
94TIMECODEDESCARRAY_14 SearchTime Code Description Array[14]StringSTR3030
95TIMECODEDESCARRAY_15 SearchTime Code Description Array[15]StringSTR3030
96TIMECODEDESCARRAY_16 SearchTime Code Description Array[16]StringSTR3030
97TIMECODEDESCARRAY_17 SearchTime Code Description Array[17]StringSTR3030
98TIMECODEDESCARRAY_18 SearchTime Code Description Array[18]StringSTR3030
99TIMECODEDESCARRAY_19 SearchTime Code Description Array[19]StringSTR3030
100TIMECODEDESCARRAY_20 SearchTime Code Description Array[20]StringSTR3030
101TIMECODEDESCARRAY_21 SearchTime Code Description Array[21]StringSTR3030
102TIMECODEDESCARRAY_22 SearchTime Code Description Array[22]StringSTR3030
103TIMECODEDESCARRAY_23 SearchTime Code Description Array[23]StringSTR3030
104TIMECODEDESCARRAY_24 SearchTime Code Description Array[24]StringSTR3030
105TIMECODEDESCARRAY_25 SearchTime Code Description Array[25]StringSTR3030
106PAYARRCD_1 SearchPay Code Array[1]StringSTR6_Payroll_Code6
107PAYARRCD_2 SearchPay Code Array[2]StringSTR6_Payroll_Code6
108PAYARRCD_3 SearchPay Code Array[3]StringSTR6_Payroll_Code6
109PAYARRCD_4 SearchPay Code Array[4]StringSTR6_Payroll_Code6
110PAYARRCD_5 SearchPay Code Array[5]StringSTR6_Payroll_Code6
111PAYARRCD SearchPay Code ArraySTR6_Payroll_CodeString6
112PAYARRCD_6 SearchPay Code Array[6]StringSTR6_Payroll_Code6
113PAYARRCD_7 SearchPay Code Array[7]StringSTR6_Payroll_Code6
114PAYARRCD_8 SearchPay Code Array[8]StringSTR6_Payroll_Code6
115PAYARRCD_9 SearchPay Code Array[9]StringSTR6_Payroll_Code6
116PAYARRCD_10 SearchPay Code Array[10]StringSTR6_Payroll_Code6
117PAYARRCD_11 SearchPay Code Array[11]StringSTR6_Payroll_Code6
118PAYARRCD_12 SearchPay Code Array[12]StringSTR6_Payroll_Code6
119PAYARRCD_13 SearchPay Code Array[13]StringSTR6_Payroll_Code6
120PAYARRCD_14 SearchPay Code Array[14]StringSTR6_Payroll_Code6
121PAYARRCD_15 SearchPay Code Array[15]StringSTR6_Payroll_Code6
122PAYARRCD_16 SearchPay Code Array[16]StringSTR6_Payroll_Code6
123PAYARRCD_17 SearchPay Code Array[17]StringSTR6_Payroll_Code6
124PAYARRCD_18 SearchPay Code Array[18]StringSTR6_Payroll_Code6
125PAYARRCD_19 SearchPay Code Array[19]StringSTR6_Payroll_Code6
126PAYARRCD_20 SearchPay Code Array[20]StringSTR6_Payroll_Code6
127PAYARRCD_21 SearchPay Code Array[21]StringSTR6_Payroll_Code6
128PAYARRCD_22 SearchPay Code Array[22]StringSTR6_Payroll_Code6
129PAYARRCD_23 SearchPay Code Array[23]StringSTR6_Payroll_Code6
130PAYARRCD_24 SearchPay Code Array[24]StringSTR6_Payroll_Code6
131PAYARRCD_25 SearchPay Code Array[25]StringSTR6_Payroll_Code6
132DEDCDARR_1 SearchDeduction Code Array[1]StringSTR6_Payroll_Code6
133DEDCDARR_2 SearchDeduction Code Array[2]StringSTR6_Payroll_Code6
134DEDCDARR_3 SearchDeduction Code Array[3]StringSTR6_Payroll_Code6
135DEDCDARR_4 SearchDeduction Code Array[4]StringSTR6_Payroll_Code6
136DEDCDARR_5 SearchDeduction Code Array[5]StringSTR6_Payroll_Code6
137DEDCDARR_6 SearchDeduction Code Array[6]StringSTR6_Payroll_Code6
138DEDCDARR SearchDeduction Code ArraySTR6_Payroll_CodeString6
139DEDCDARR_7 SearchDeduction Code Array[7]StringSTR6_Payroll_Code6
140DEDCDARR_8 SearchDeduction Code Array[8]StringSTR6_Payroll_Code6
141DEDCDARR_9 SearchDeduction Code Array[9]StringSTR6_Payroll_Code6
142DEDCDARR_10 SearchDeduction Code Array[10]StringSTR6_Payroll_Code6
143DEDCDARR_11 SearchDeduction Code Array[11]StringSTR6_Payroll_Code6
144DEDCDARR_12 SearchDeduction Code Array[12]StringSTR6_Payroll_Code6
145DEDCDARR_13 SearchDeduction Code Array[13]StringSTR6_Payroll_Code6
146DEDCDARR_14 SearchDeduction Code Array[14]StringSTR6_Payroll_Code6
147DEDCDARR_15 SearchDeduction Code Array[15]StringSTR6_Payroll_Code6
148DEDCDARR_16 SearchDeduction Code Array[16]StringSTR6_Payroll_Code6
149DEDCDARR_17 SearchDeduction Code Array[17]StringSTR6_Payroll_Code6
150DEDCDARR_18 SearchDeduction Code Array[18]StringSTR6_Payroll_Code6
151DEDCDARR_19 SearchDeduction Code Array[19]StringSTR6_Payroll_Code6
152DEDCDARR_20 SearchDeduction Code Array[20]StringSTR6_Payroll_Code6
153DEDCDARR_21 SearchDeduction Code Array[21]StringSTR6_Payroll_Code6
154DEDCDARR_22 SearchDeduction Code Array[22]StringSTR6_Payroll_Code6
155DEDCDARR_23 SearchDeduction Code Array[23]StringSTR6_Payroll_Code6
156DEDCDARR_24 SearchDeduction Code Array[24]StringSTR6_Payroll_Code6
157DEDCDARR_25 SearchDeduction Code Array[25]StringSTR6_Payroll_Code6
158BNFCDARR_1 SearchBenefit Code Array[1]StringSTR6_Payroll_Code6
159BNFCDARR_2 SearchBenefit Code Array[2]StringSTR6_Payroll_Code6
160BNFCDARR_3 SearchBenefit Code Array[3]StringSTR6_Payroll_Code6
161BNFCDARR_4 SearchBenefit Code Array[4]StringSTR6_Payroll_Code6
162BNFCDARR_5 SearchBenefit Code Array[5]StringSTR6_Payroll_Code6
163BNFCDARR_6 SearchBenefit Code Array[6]StringSTR6_Payroll_Code6
164BNFCDARR_7 SearchBenefit Code Array[7]StringSTR6_Payroll_Code6
165BNFCDARR SearchBenefit Code ArraySTR6_Payroll_CodeString6
166BNFCDARR_8 SearchBenefit Code Array[8]StringSTR6_Payroll_Code6
167BNFCDARR_9 SearchBenefit Code Array[9]StringSTR6_Payroll_Code6
168BNFCDARR_10 SearchBenefit Code Array[10]StringSTR6_Payroll_Code6
169BNFCDARR_11 SearchBenefit Code Array[11]StringSTR6_Payroll_Code6
170BNFCDARR_12 SearchBenefit Code Array[12]StringSTR6_Payroll_Code6
171BNFCDARR_13 SearchBenefit Code Array[13]StringSTR6_Payroll_Code6
172BNFCDARR_14 SearchBenefit Code Array[14]StringSTR6_Payroll_Code6
173BNFCDARR_15 SearchBenefit Code Array[15]StringSTR6_Payroll_Code6
174BNFCDARR_16 SearchBenefit Code Array[16]StringSTR6_Payroll_Code6
175BNFCDARR_17 SearchBenefit Code Array[17]StringSTR6_Payroll_Code6
176BNFCDARR_18 SearchBenefit Code Array[18]StringSTR6_Payroll_Code6
177BNFCDARR_19 SearchBenefit Code Array[19]StringSTR6_Payroll_Code6
178BNFCDARR_20 SearchBenefit Code Array[20]StringSTR6_Payroll_Code6
179BNFCDARR_21 SearchBenefit Code Array[21]StringSTR6_Payroll_Code6
180BNFCDARR_22 SearchBenefit Code Array[22]StringSTR6_Payroll_Code6
181BNFCDARR_23 SearchBenefit Code Array[23]StringSTR6_Payroll_Code6
182BNFCDARR_24 SearchBenefit Code Array[24]StringSTR6_Payroll_Code6
183BNFCDARR_25 SearchBenefit Code Array[25]StringSTR6_Payroll_Code6
184TIMECODEARRAY_1 SearchTime Code Array[1]StringSTR6_Payroll_Code6
185TIMECODEARRAY_2 SearchTime Code Array[2]StringSTR6_Payroll_Code6
186TIMECODEARRAY_3 SearchTime Code Array[3]StringSTR6_Payroll_Code6
187TIMECODEARRAY_4 SearchTime Code Array[4]StringSTR6_Payroll_Code6
188TIMECODEARRAY_5 SearchTime Code Array[5]StringSTR6_Payroll_Code6
189TIMECODEARRAY_6 SearchTime Code Array[6]StringSTR6_Payroll_Code6
190TIMECODEARRAY_7 SearchTime Code Array[7]StringSTR6_Payroll_Code6
191TIMECODEARRAY SearchTime Code ArraySTR6_Payroll_CodeString6
192TIMECODEARRAY_8 SearchTime Code Array[8]StringSTR6_Payroll_Code6
193TIMECODEARRAY_9 SearchTime Code Array[9]StringSTR6_Payroll_Code6
194TIMECODEARRAY_10 SearchTime Code Array[10]StringSTR6_Payroll_Code6
195TIMECODEARRAY_11 SearchTime Code Array[11]StringSTR6_Payroll_Code6
196TIMECODEARRAY_12 SearchTime Code Array[12]StringSTR6_Payroll_Code6
197TIMECODEARRAY_13 SearchTime Code Array[13]StringSTR6_Payroll_Code6
198TIMECODEARRAY_14 SearchTime Code Array[14]StringSTR6_Payroll_Code6
199TIMECODEARRAY_15 SearchTime Code Array[15]StringSTR6_Payroll_Code6
200TIMECODEARRAY_16 SearchTime Code Array[16]StringSTR6_Payroll_Code6
201TIMECODEARRAY_17 SearchTime Code Array[17]StringSTR6_Payroll_Code6
202TIMECODEARRAY_18 SearchTime Code Array[18]StringSTR6_Payroll_Code6
203TIMECODEARRAY_19 SearchTime Code Array[19]StringSTR6_Payroll_Code6
204TIMECODEARRAY_20 SearchTime Code Array[20]StringSTR6_Payroll_Code6
205TIMECODEARRAY_21 SearchTime Code Array[21]StringSTR6_Payroll_Code6
206TIMECODEARRAY_22 SearchTime Code Array[22]StringSTR6_Payroll_Code6
207TIMECODEARRAY_23 SearchTime Code Array[23]StringSTR6_Payroll_Code6
208TIMECODEARRAY_24 SearchTime Code Array[24]StringSTR6_Payroll_Code6
209TIMECODEARRAY_25 SearchTime Code Array[25]StringSTR6_Payroll_Code6
210STATXARR_1 SearchState Tax Array[1]StringSTR2_State_Code2
211STATXARR_2 SearchState Tax Array[2]StringSTR2_State_Code2
212STATXARR_3 SearchState Tax Array[3]StringSTR2_State_Code2
213STATXARR_4 SearchState Tax Array[4]StringSTR2_State_Code2
214STATXARR_5 SearchState Tax Array[5]StringSTR2_State_Code2
215STATXARR_6 SearchState Tax Array[6]StringSTR2_State_Code2
216STATXARR_7 SearchState Tax Array[7]StringSTR2_State_Code2
217STATXARR_8 SearchState Tax Array[8]StringSTR2_State_Code2
218STATXARR SearchState Tax ArraySTR2_State_CodeString2
219STATXARR_9 SearchState Tax Array[9]StringSTR2_State_Code2
220STATXARR_10 SearchState Tax Array[10]StringSTR2_State_Code2
221STATXARR_11 SearchState Tax Array[11]StringSTR2_State_Code2
222STATXARR_12 SearchState Tax Array[12]StringSTR2_State_Code2
223STATXARR_13 SearchState Tax Array[13]StringSTR2_State_Code2
224STATXARR_14 SearchState Tax Array[14]StringSTR2_State_Code2
225STATXARR_15 SearchState Tax Array[15]StringSTR2_State_Code2
226STATXARR_16 SearchState Tax Array[16]StringSTR2_State_Code2
227STATXARR_17 SearchState Tax Array[17]StringSTR2_State_Code2
228STATXARR_18 SearchState Tax Array[18]StringSTR2_State_Code2
229STATXARR_19 SearchState Tax Array[19]StringSTR2_State_Code2
230STATXARR_20 SearchState Tax Array[20]StringSTR2_State_Code2
231STATXARR_21 SearchState Tax Array[21]StringSTR2_State_Code2
232STATXARR_22 SearchState Tax Array[22]StringSTR2_State_Code2
233STATXARR_23 SearchState Tax Array[23]StringSTR2_State_Code2
234STATXARR_24 SearchState Tax Array[24]StringSTR2_State_Code2
235STATXARR_25 SearchState Tax Array[25]StringSTR2_State_Code2
236LCLTXARR_1 SearchLocal Tax Array[1]StringSTR6_Payroll_Code6
237LCLTXARR_2 SearchLocal Tax Array[2]StringSTR6_Payroll_Code6
238LCLTXARR_3 SearchLocal Tax Array[3]StringSTR6_Payroll_Code6
239LCLTXARR_4 SearchLocal Tax Array[4]StringSTR6_Payroll_Code6
240LCLTXARR_5 SearchLocal Tax Array[5]StringSTR6_Payroll_Code6
241LCLTXARR_6 SearchLocal Tax Array[6]StringSTR6_Payroll_Code6
242LCLTXARR_7 SearchLocal Tax Array[7]StringSTR6_Payroll_Code6
243LCLTXARR_8 SearchLocal Tax Array[8]StringSTR6_Payroll_Code6
244LCLTXARR_9 SearchLocal Tax Array[9]StringSTR6_Payroll_Code6
245LCLTXARR_10 SearchLocal Tax Array[10]StringSTR6_Payroll_Code6
246LCLTXARR SearchLocal Tax ArraySTR6_Payroll_CodeString6
247LCLTXARR_11 SearchLocal Tax Array[11]StringSTR6_Payroll_Code6
248LCLTXARR_12 SearchLocal Tax Array[12]StringSTR6_Payroll_Code6
249LCLTXARR_13 SearchLocal Tax Array[13]StringSTR6_Payroll_Code6
250LCLTXARR_14 SearchLocal Tax Array[14]StringSTR6_Payroll_Code6
251LCLTXARR_15 SearchLocal Tax Array[15]StringSTR6_Payroll_Code6
252LCLTXARR_16 SearchLocal Tax Array[16]StringSTR6_Payroll_Code6
253LCLTXARR_17 SearchLocal Tax Array[17]StringSTR6_Payroll_Code6
254LCLTXARR_18 SearchLocal Tax Array[18]StringSTR6_Payroll_Code6
255LCLTXARR_19 SearchLocal Tax Array[19]StringSTR6_Payroll_Code6
256LCLTXARR_20 SearchLocal Tax Array[20]StringSTR6_Payroll_Code6
257LCLTXARR_21 SearchLocal Tax Array[21]StringSTR6_Payroll_Code6
258LCLTXARR_22 SearchLocal Tax Array[22]StringSTR6_Payroll_Code6
259LCLTXARR_23 SearchLocal Tax Array[23]StringSTR6_Payroll_Code6
260LCLTXARR_24 SearchLocal Tax Array[24]StringSTR6_Payroll_Code6
261LCLTXARR_25 SearchLocal Tax Array[25]StringSTR6_Payroll_Code6
262USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Check Descriptions'].USERID AS 'Payroll Check Descriptions-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       UPR10213 AS ['Payroll Check Descriptions']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Check Descriptions'].USERID = ['Users Master'].USERID
azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Check Descriptions (UPR10213)

Leave a Reply

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