Payroll Work Check (UPR10208)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Work Check
Physical Name: UPR10208
Technical Name: UPR_WORK_Check

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PRINTED SearchPrintedCBBoolean0

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
2VOIDED SearchVoidedCBBoolean0
3USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Payroll Work Check'].USERID AS 'Payroll Work Check-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       UPR10208 AS ['Payroll Work Check']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Payroll Work Check'].USERID = ['Users Master'].USERID
4EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
5EMPLNAME SearchEmployee NameSTR40String40
6LASTNAME SearchLast NameSTR20String20
7FRSTNAME SearchFirst NameSTR15String15
8MIDLNAME SearchMiddle NameSTR15String15
9CHEKDATE SearchCheck DateDATEDate6
10CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
11PYADNMBR SearchPayment/Adjustment NumberLI8_U0Long Integer8
12DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString6
13EMPLCLAS SearchEmployee ClassSTR15_Employee_ClassString15
14SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString15
15PAYRTARR SearchPay Rate ArrayDLR11_$U2Currency14
16PAYRTARR_1 SearchPay Rate Array[1]DLR11_$U2Currency14
17PAYRTARR_2 SearchPay Rate Array[2]DLR11_$U2Currency14
18PAYRTARR_3 SearchPay Rate Array[3]DLR11_$U2Currency14
19PAYRTARR_4 SearchPay Rate Array[4]DLR11_$U2Currency14
20PAYRTARR_5 SearchPay Rate Array[5]DLR11_$U2Currency14
21PAYRTARR_6 SearchPay Rate Array[6]DLR11_$U2Currency14
22PAYRTARR_7 SearchPay Rate Array[7]DLR11_$U2Currency14
23PAYRTARR_8 SearchPay Rate Array[8]DLR11_$U2Currency14
24PAYRTARR_9 SearchPay Rate Array[9]DLR11_$U2Currency14
25PAYRTARR_10 SearchPay Rate Array[10]DLR11_$U2Currency14
26PAYRTARR_11 SearchPay Rate Array[11]DLR11_$U2Currency14
27PAYRTARR_12 SearchPay Rate Array[12]DLR11_$U2Currency14
28PAYRTARR_13 SearchPay Rate Array[13]DLR11_$U2Currency14
29PAYRTARR_14 SearchPay Rate Array[14]DLR11_$U2Currency14
30PAYRTARR_15 SearchPay Rate Array[15]DLR11_$U2Currency14
31PAYRTARR_16 SearchPay Rate Array[16]DLR11_$U2Currency14
32PAYRTARR_17 SearchPay Rate Array[17]DLR11_$U2Currency14
33PAYRTARR_18 SearchPay Rate Array[18]DLR11_$U2Currency14
34PAYRTARR_19 SearchPay Rate Array[19]DLR11_$U2Currency14
35PAYRTARR_20 SearchPay Rate Array[20]DLR11_$U2Currency14
36PAYRTARR_21 SearchPay Rate Array[21]DLR11_$U2Currency14
37PAYRTARR_22 SearchPay Rate Array[22]DLR11_$U2Currency14
38PAYRTARR_23 SearchPay Rate Array[23]DLR11_$U2Currency14
39PAYRTARR_24 SearchPay Rate Array[24]DLR11_$U2Currency14
40PAYRTARR_25 SearchPay Rate Array[25]DLR11_$U2Currency14
41PAYHRSAR SearchPay Hours ArrayLI6_S2Long Integer6
42PAYHRSAR_1 SearchPay Hours Array[1]LI6_S2Long Integer6
43PAYHRSAR_2 SearchPay Hours Array[2]LI6_S2Long Integer6
44PAYHRSAR_3 SearchPay Hours Array[3]LI6_S2Long Integer6
45PAYHRSAR_4 SearchPay Hours Array[4]LI6_S2Long Integer6
46PAYHRSAR_5 SearchPay Hours Array[5]LI6_S2Long Integer6
47PAYHRSAR_6 SearchPay Hours Array[6]LI6_S2Long Integer6
48PAYHRSAR_7 SearchPay Hours Array[7]LI6_S2Long Integer6
49PAYHRSAR_8 SearchPay Hours Array[8]LI6_S2Long Integer6
50PAYHRSAR_9 SearchPay Hours Array[9]LI6_S2Long Integer6
51PAYHRSAR_10 SearchPay Hours Array[10]LI6_S2Long Integer6
52PAYHRSAR_11 SearchPay Hours Array[11]LI6_S2Long Integer6
53PAYHRSAR_12 SearchPay Hours Array[12]LI6_S2Long Integer6
54PAYHRSAR_13 SearchPay Hours Array[13]LI6_S2Long Integer6
55PAYHRSAR_14 SearchPay Hours Array[14]LI6_S2Long Integer6
56PAYHRSAR_15 SearchPay Hours Array[15]LI6_S2Long Integer6
57PAYHRSAR_16 SearchPay Hours Array[16]LI6_S2Long Integer6
58PAYHRSAR_17 SearchPay Hours Array[17]LI6_S2Long Integer6
59PAYHRSAR_18 SearchPay Hours Array[18]LI6_S2Long Integer6
60PAYHRSAR_19 SearchPay Hours Array[19]LI6_S2Long Integer6
61PAYHRSAR_20 SearchPay Hours Array[20]LI6_S2Long Integer6
62PAYHRSAR_21 SearchPay Hours Array[21]LI6_S2Long Integer6
63PAYHRSAR_22 SearchPay Hours Array[22]LI6_S2Long Integer6
64PAYHRSAR_23 SearchPay Hours Array[23]LI6_S2Long Integer6
65PAYHRSAR_24 SearchPay Hours Array[24]LI6_S2Long Integer6
66PAYHRSAR_25 SearchPay Hours Array[25]LI6_S2Long Integer6
67PAYERNAR SearchPay Earnings ArrayDLR11_$S2Currency14
68PAYERNAR_1 SearchPay Earnings Array[1]DLR11_$S2Currency14
69PAYERNAR_2 SearchPay Earnings Array[2]DLR11_$S2Currency14
70PAYERNAR_3 SearchPay Earnings Array[3]DLR11_$S2Currency14
71PAYERNAR_4 SearchPay Earnings Array[4]DLR11_$S2Currency14
72PAYERNAR_5 SearchPay Earnings Array[5]DLR11_$S2Currency14
73PAYERNAR_6 SearchPay Earnings Array[6]DLR11_$S2Currency14
74PAYERNAR_7 SearchPay Earnings Array[7]DLR11_$S2Currency14
75PAYERNAR_8 SearchPay Earnings Array[8]DLR11_$S2Currency14
76PAYERNAR_9 SearchPay Earnings Array[9]DLR11_$S2Currency14
77PAYERNAR_10 SearchPay Earnings Array[10]DLR11_$S2Currency14
78PAYERNAR_11 SearchPay Earnings Array[11]DLR11_$S2Currency14
79PAYERNAR_12 SearchPay Earnings Array[12]DLR11_$S2Currency14
80PAYERNAR_13 SearchPay Earnings Array[13]DLR11_$S2Currency14
81PAYERNAR_14 SearchPay Earnings Array[14]DLR11_$S2Currency14
82PAYERNAR_15 SearchPay Earnings Array[15]DLR11_$S2Currency14
83PAYERNAR_16 SearchPay Earnings Array[16]DLR11_$S2Currency14
84PAYERNAR_17 SearchPay Earnings Array[17]DLR11_$S2Currency14
85PAYERNAR_18 SearchPay Earnings Array[18]DLR11_$S2Currency14
86PAYERNAR_19 SearchPay Earnings Array[19]DLR11_$S2Currency14
87PAYERNAR_20 SearchPay Earnings Array[20]DLR11_$S2Currency14
88PAYERNAR_21 SearchPay Earnings Array[21]DLR11_$S2Currency14
89PAYERNAR_22 SearchPay Earnings Array[22]DLR11_$S2Currency14
90PAYERNAR_23 SearchPay Earnings Array[23]DLR11_$S2Currency14
91PAYERNAR_24 SearchPay Earnings Array[24]DLR11_$S2Currency14
92PAYERNAR_25 SearchPay Earnings Array[25]DLR11_$S2Currency14
93TFICATWH SearchTotal FICA Tax WithheldDLR11_$S2Currency14
94FCASWPR SearchFICA/Social Security Withholding/Pay RunDLR11_$S2Currency14
95FICAMWPR SearchFICA/Medicare Withholding/Pay RunDLR11_$S2Currency14
96FDWDGPRN SearchFederal Withholding/Pay RunDLR11_$S2Currency14
97STWHDARR SearchState Tax Withholding ArrayDLR11_$S2Currency14
98STWHDARR_1 SearchState Tax Withholding Array[1]DLR11_$S2Currency14
99STWHDARR_2 SearchState Tax Withholding Array[2]DLR11_$S2Currency14
100STWHDARR_3 SearchState Tax Withholding Array[3]DLR11_$S2Currency14
101STWHDARR_4 SearchState Tax Withholding Array[4]DLR11_$S2Currency14
102STWHDARR_5 SearchState Tax Withholding Array[5]DLR11_$S2Currency14
103STWHDARR_6 SearchState Tax Withholding Array[6]DLR11_$S2Currency14
104STWHDARR_7 SearchState Tax Withholding Array[7]DLR11_$S2Currency14
105STWHDARR_8 SearchState Tax Withholding Array[8]DLR11_$S2Currency14
106STWHDARR_9 SearchState Tax Withholding Array[9]DLR11_$S2Currency14
107STWHDARR_10 SearchState Tax Withholding Array[10]DLR11_$S2Currency14
108STWHDARR_11 SearchState Tax Withholding Array[11]DLR11_$S2Currency14
109STWHDARR_12 SearchState Tax Withholding Array[12]DLR11_$S2Currency14
110STWHDARR_13 SearchState Tax Withholding Array[13]DLR11_$S2Currency14
111STWHDARR_14 SearchState Tax Withholding Array[14]DLR11_$S2Currency14
112STWHDARR_15 SearchState Tax Withholding Array[15]DLR11_$S2Currency14
113STWHDARR_16 SearchState Tax Withholding Array[16]DLR11_$S2Currency14
114STWHDARR_17 SearchState Tax Withholding Array[17]DLR11_$S2Currency14
115STWHDARR_18 SearchState Tax Withholding Array[18]DLR11_$S2Currency14
116STWHDARR_19 SearchState Tax Withholding Array[19]DLR11_$S2Currency14
117STWHDARR_20 SearchState Tax Withholding Array[20]DLR11_$S2Currency14
118STWHDARR_21 SearchState Tax Withholding Array[21]DLR11_$S2Currency14
119STWHDARR_22 SearchState Tax Withholding Array[22]DLR11_$S2Currency14
120STWHDARR_23 SearchState Tax Withholding Array[23]DLR11_$S2Currency14
121STWHDARR_24 SearchState Tax Withholding Array[24]DLR11_$S2Currency14
122STWHDARR_25 SearchState Tax Withholding Array[25]DLR11_$S2Currency14
123LTXWHGAR SearchLocal Tax Withholding ArrayDLR11_$S2Currency14
124LTXWHGAR_1 SearchLocal Tax Withholding Array[1]DLR11_$S2Currency14
125LTXWHGAR_2 SearchLocal Tax Withholding Array[2]DLR11_$S2Currency14
126LTXWHGAR_3 SearchLocal Tax Withholding Array[3]DLR11_$S2Currency14
127LTXWHGAR_4 SearchLocal Tax Withholding Array[4]DLR11_$S2Currency14
128LTXWHGAR_5 SearchLocal Tax Withholding Array[5]DLR11_$S2Currency14
129LTXWHGAR_6 SearchLocal Tax Withholding Array[6]DLR11_$S2Currency14
130LTXWHGAR_7 SearchLocal Tax Withholding Array[7]DLR11_$S2Currency14
131LTXWHGAR_8 SearchLocal Tax Withholding Array[8]DLR11_$S2Currency14
132LTXWHGAR_9 SearchLocal Tax Withholding Array[9]DLR11_$S2Currency14
133LTXWHGAR_10 SearchLocal Tax Withholding Array[10]DLR11_$S2Currency14
134LTXWHGAR_11 SearchLocal Tax Withholding Array[11]DLR11_$S2Currency14
135LTXWHGAR_12 SearchLocal Tax Withholding Array[12]DLR11_$S2Currency14
136LTXWHGAR_13 SearchLocal Tax Withholding Array[13]DLR11_$S2Currency14
137LTXWHGAR_14 SearchLocal Tax Withholding Array[14]DLR11_$S2Currency14
138LTXWHGAR_15 SearchLocal Tax Withholding Array[15]DLR11_$S2Currency14
139LTXWHGAR_16 SearchLocal Tax Withholding Array[16]DLR11_$S2Currency14
140LTXWHGAR_17 SearchLocal Tax Withholding Array[17]DLR11_$S2Currency14
141LTXWHGAR_18 SearchLocal Tax Withholding Array[18]DLR11_$S2Currency14
142LTXWHGAR_19 SearchLocal Tax Withholding Array[19]DLR11_$S2Currency14
143LTXWHGAR_20 SearchLocal Tax Withholding Array[20]DLR11_$S2Currency14
144LTXWHGAR_21 SearchLocal Tax Withholding Array[21]DLR11_$S2Currency14
145LTXWHGAR_22 SearchLocal Tax Withholding Array[22]DLR11_$S2Currency14
146LTXWHGAR_23 SearchLocal Tax Withholding Array[23]DLR11_$S2Currency14
147LTXWHGAR_24 SearchLocal Tax Withholding Array[24]DLR11_$S2Currency14
148LTXWHGAR_25 SearchLocal Tax Withholding Array[25]DLR11_$S2Currency14
149DEDAMARR SearchDeduction Amount ArrayDLR11_$S2Currency14
150DEDAMARR_1 SearchDeduction Amount Array[1]DLR11_$S2Currency14
151DEDAMARR_2 SearchDeduction Amount Array[2]DLR11_$S2Currency14
152DEDAMARR_3 SearchDeduction Amount Array[3]DLR11_$S2Currency14
153DEDAMARR_4 SearchDeduction Amount Array[4]DLR11_$S2Currency14
154DEDAMARR_5 SearchDeduction Amount Array[5]DLR11_$S2Currency14
155DEDAMARR_6 SearchDeduction Amount Array[6]DLR11_$S2Currency14
156DEDAMARR_7 SearchDeduction Amount Array[7]DLR11_$S2Currency14
157DEDAMARR_8 SearchDeduction Amount Array[8]DLR11_$S2Currency14
158DEDAMARR_9 SearchDeduction Amount Array[9]DLR11_$S2Currency14
159DEDAMARR_10 SearchDeduction Amount Array[10]DLR11_$S2Currency14
160DEDAMARR_11 SearchDeduction Amount Array[11]DLR11_$S2Currency14
161DEDAMARR_12 SearchDeduction Amount Array[12]DLR11_$S2Currency14
162DEDAMARR_13 SearchDeduction Amount Array[13]DLR11_$S2Currency14
163DEDAMARR_14 SearchDeduction Amount Array[14]DLR11_$S2Currency14
164DEDAMARR_15 SearchDeduction Amount Array[15]DLR11_$S2Currency14
165DEDAMARR_16 SearchDeduction Amount Array[16]DLR11_$S2Currency14
166DEDAMARR_17 SearchDeduction Amount Array[17]DLR11_$S2Currency14
167DEDAMARR_18 SearchDeduction Amount Array[18]DLR11_$S2Currency14
168DEDAMARR_19 SearchDeduction Amount Array[19]DLR11_$S2Currency14
169DEDAMARR_20 SearchDeduction Amount Array[20]DLR11_$S2Currency14
170DEDAMARR_21 SearchDeduction Amount Array[21]DLR11_$S2Currency14
171DEDAMARR_22 SearchDeduction Amount Array[22]DLR11_$S2Currency14
172DEDAMARR_23 SearchDeduction Amount Array[23]DLR11_$S2Currency14
173DEDAMARR_24 SearchDeduction Amount Array[24]DLR11_$S2Currency14
174DEDAMARR_25 SearchDeduction Amount Array[25]DLR11_$S2Currency14
175BNFAMARR SearchBenefit Amount ArrayDLR11_$S2Currency14
176BNFAMARR_1 SearchBenefit Amount Array[1]DLR11_$S2Currency14
177BNFAMARR_2 SearchBenefit Amount Array[2]DLR11_$S2Currency14
178BNFAMARR_3 SearchBenefit Amount Array[3]DLR11_$S2Currency14
179BNFAMARR_4 SearchBenefit Amount Array[4]DLR11_$S2Currency14
180BNFAMARR_5 SearchBenefit Amount Array[5]DLR11_$S2Currency14
181BNFAMARR_6 SearchBenefit Amount Array[6]DLR11_$S2Currency14
182BNFAMARR_7 SearchBenefit Amount Array[7]DLR11_$S2Currency14
183BNFAMARR_8 SearchBenefit Amount Array[8]DLR11_$S2Currency14
184BNFAMARR_9 SearchBenefit Amount Array[9]DLR11_$S2Currency14
185BNFAMARR_10 SearchBenefit Amount Array[10]DLR11_$S2Currency14
186BNFAMARR_11 SearchBenefit Amount Array[11]DLR11_$S2Currency14
187BNFAMARR_12 SearchBenefit Amount Array[12]DLR11_$S2Currency14
188BNFAMARR_13 SearchBenefit Amount Array[13]DLR11_$S2Currency14
189BNFAMARR_14 SearchBenefit Amount Array[14]DLR11_$S2Currency14
190BNFAMARR_15 SearchBenefit Amount Array[15]DLR11_$S2Currency14
191BNFAMARR_16 SearchBenefit Amount Array[16]DLR11_$S2Currency14
192BNFAMARR_17 SearchBenefit Amount Array[17]DLR11_$S2Currency14
193BNFAMARR_18 SearchBenefit Amount Array[18]DLR11_$S2Currency14
194BNFAMARR_19 SearchBenefit Amount Array[19]DLR11_$S2Currency14
195BNFAMARR_20 SearchBenefit Amount Array[20]DLR11_$S2Currency14
196BNFAMARR_21 SearchBenefit Amount Array[21]DLR11_$S2Currency14
197BNFAMARR_22 SearchBenefit Amount Array[22]DLR11_$S2Currency14
198BNFAMARR_23 SearchBenefit Amount Array[23]DLR11_$S2Currency14
199BNFAMARR_24 SearchBenefit Amount Array[24]DLR11_$S2Currency14
200BNFAMARR_25 SearchBenefit Amount Array[25]DLR11_$S2Currency14
201TIMEAVAILARRAY SearchTime Available ArrayDLR11_S2Currency11
202TIMEAVAILARRAY_1 SearchTime Available Array[1]DLR11_S2Currency11
203TIMEAVAILARRAY_2 SearchTime Available Array[2]DLR11_S2Currency11
204TIMEAVAILARRAY_3 SearchTime Available Array[3]DLR11_S2Currency11
205TIMEAVAILARRAY_4 SearchTime Available Array[4]DLR11_S2Currency11
206TIMEAVAILARRAY_5 SearchTime Available Array[5]DLR11_S2Currency11
207TIMEAVAILARRAY_6 SearchTime Available Array[6]DLR11_S2Currency11
208TIMEAVAILARRAY_7 SearchTime Available Array[7]DLR11_S2Currency11
209TIMEAVAILARRAY_8 SearchTime Available Array[8]DLR11_S2Currency11
210TIMEAVAILARRAY_9 SearchTime Available Array[9]DLR11_S2Currency11
211TIMEAVAILARRAY_10 SearchTime Available Array[10]DLR11_S2Currency11
212TIMEAVAILARRAY_11 SearchTime Available Array[11]DLR11_S2Currency11
213TIMEAVAILARRAY_12 SearchTime Available Array[12]DLR11_S2Currency11
214TIMEAVAILARRAY_13 SearchTime Available Array[13]DLR11_S2Currency11
215TIMEAVAILARRAY_14 SearchTime Available Array[14]DLR11_S2Currency11
216TIMEAVAILARRAY_15 SearchTime Available Array[15]DLR11_S2Currency11
217TIMEAVAILARRAY_16 SearchTime Available Array[16]DLR11_S2Currency11
218TIMEAVAILARRAY_17 SearchTime Available Array[17]DLR11_S2Currency11
219TIMEAVAILARRAY_18 SearchTime Available Array[18]DLR11_S2Currency11
220TIMEAVAILARRAY_19 SearchTime Available Array[19]DLR11_S2Currency11
221TIMEAVAILARRAY_20 SearchTime Available Array[20]DLR11_S2Currency11
222TIMEAVAILARRAY_21 SearchTime Available Array[21]DLR11_S2Currency11
223TIMEAVAILARRAY_22 SearchTime Available Array[22]DLR11_S2Currency11
224TIMEAVAILARRAY_23 SearchTime Available Array[23]DLR11_S2Currency11
225TIMEAVAILARRAY_24 SearchTime Available Array[24]DLR11_S2Currency11
226TIMEAVAILARRAY_25 SearchTime Available Array[25]DLR11_S2Currency11
227TTLHOURS SearchTotal HoursLI6_S2Long Integer6
228TTLERNGS SearchTotal EarningsDLR11_$S2Currency14
229TOTLTAXS SearchTotal TaxesDLR11_$S2Currency14
230TTLDDTNS SearchTotal DeductionsDLR11_$S2Currency14
231TTLBNFTS SearchTotal BenefitsDLR11_$S2Currency14
232NTWPYRN SearchNet Wages/Pay RunDLR11_$S2Currency14
233GRWGPRN SearchGross Wages/Pay RunDLR11_$S2Currency14
234REGHOURS SearchRegular HoursLI6_S2Long Integer6
235REGERNGS SearchRegular EarningsDLR11_$S2Currency14
236OVRTMHRS SearchOvertime HoursLI6_S2Long Integer6
237OVTMEARN SearchOvertime EarningsDLR11_$S2Currency14
238DBLTMHRS SearchDouble Time HoursLI6_S2Long Integer6
239DBLTMERN SearchDouble Time EarningsDLR11_$S2Currency14
240EICERNGS SearchEIC EarningsDLR11_$S2Currency14
241COMMERNG SearchCommission EarningsDLR11_$S2Currency14
242BSNEXERN SearchBusiness Expense EarningsDLR11_$S2Currency14
243PNSNERNG SearchPension EarningsDLR11_$S2Currency14
244HOLDYHRS SearchHoliday HoursLI6_S2Long Integer6
245HLDYEARN SearchHoliday EarningsDLR11_$S2Currency14
246VACTNHRS SearchVacation HoursLI6_S2Long Integer6
247VCTNERNG SearchVacation EarningsDLR11_$S2Currency14
248SKTIMHRS SearchSick Time HoursLI6_S2Long Integer6
249SKTMERNG SearchSick Time EarningsDLR11_$S2Currency14
250PCWKUNIT SearchPiecework UnitsLI6_S2Long Integer6
251PCWKERNG SearchPiecework EarningsDLR11_$S2Currency14
252SPCLERNG SearchSpecial EarningsDLR11_$S2Currency14
253CHGTPERN SearchCharged Tips EarningsDLR11_$S2Currency14
254REPTPERN SearchReported Tips EarningsDLR11_$S2Currency14
255MNWGBLER SearchMin Wage Bal EarningsDLR11_$S2Currency14
256VACAVLBL SearchVacation AvailableLI6_S2Long Integer6
257SIKTIMAV SearchSick Time AvailableLI6_S2Long Integer6
258STTPYPRD SearchStart Pay PeriodDTDate8
259ENPAYPRD SearchEnd Pay PeriodDTDate8
260Uncollected_FICAMed_TaxP SearchUncollected FICA/Med Tax/Pay RunDLR11_$S2Currency14
261Uncollected_FICASS_TaxP SearchUncollected FICA/SS Tax/Pay RunDLR11_$S2Currency14
262RSNCHKVD SearchReason Check VoidedSTR30String30
263AMTINWDS SearchAmount in WordsTX500Text500
264DEX_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.

Leave a Reply

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