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

Leave a Reply

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