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 TypeSQL DB LengthKeyable Length
1PRINTED SearchPrintedCBBoolean20

Click to show/hide Printed flag


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

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 *