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 Group Display Name: Payroll Check Work
Physical Name: UPR10208
Technical Name: UPR_WORK_Check
Group Technical Name: Payroll Check Work
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PRINTED ![]() | Printed | CB | Boolean | 0 | |
Click to show/hide Printed flag
0 Record has not been printed.
1 Record has been printed. | ||||||
2 | VOIDED ![]() | Voided | CB | Boolean | 0 | |
3 | USERID ![]() | User ID | STR15_User_ID | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
4 | EMPLOYID ![]() | Employee ID | STR15_Employee_ID | String | 15 | |
5 | EMPLNAME ![]() | Employee Name | STR40 | String | 40 | |
6 | LASTNAME ![]() | Last Name | STR20 | String | 20 | |
7 | FRSTNAME ![]() | First Name | STR15 | String | 15 | |
8 | MIDLNAME ![]() | Middle Name | STR15 | String | 15 | |
9 | CHEKDATE ![]() | Check Date | DATE | Date | 6 | |
10 | CHEKNMBR ![]() | Check Number | STR20_Document_Number | String | 20 | |
11 | PYADNMBR ![]() | Payment/Adjustment Number | LI8_U0 | Long Integer | 8 | |
12 | DEPRTMNT ![]() | Department | STR6_Payroll_Code | String | 6 | |
13 | EMPLCLAS ![]() | Employee Class | STR15_Employee_Class | String | 15 | |
14 | SOCSCNUM ![]() | Social Security Number | STR15_Social_Security_Number | String | 15 | |
15 | PAYRTARR ![]() | Pay Rate Array | DLR11_$U2 | Currency | 14 | |
16 | PAYRTARR_1 ![]() | Pay Rate Array[1] | DLR11_$U2 | Currency | 14 | |
17 | PAYRTARR_2 ![]() | Pay Rate Array[2] | DLR11_$U2 | Currency | 14 | |
18 | PAYRTARR_3 ![]() | Pay Rate Array[3] | DLR11_$U2 | Currency | 14 | |
19 | PAYRTARR_4 ![]() | Pay Rate Array[4] | DLR11_$U2 | Currency | 14 | |
20 | PAYRTARR_5 ![]() | Pay Rate Array[5] | DLR11_$U2 | Currency | 14 | |
21 | PAYRTARR_6 ![]() | Pay Rate Array[6] | DLR11_$U2 | Currency | 14 | |
22 | PAYRTARR_7 ![]() | Pay Rate Array[7] | DLR11_$U2 | Currency | 14 | |
23 | PAYRTARR_8 ![]() | Pay Rate Array[8] | DLR11_$U2 | Currency | 14 | |
24 | PAYRTARR_9 ![]() | Pay Rate Array[9] | DLR11_$U2 | Currency | 14 | |
25 | PAYRTARR_10 ![]() | Pay Rate Array[10] | DLR11_$U2 | Currency | 14 | |
26 | PAYRTARR_11 ![]() | Pay Rate Array[11] | DLR11_$U2 | Currency | 14 | |
27 | PAYRTARR_12 ![]() | Pay Rate Array[12] | DLR11_$U2 | Currency | 14 | |
28 | PAYRTARR_13 ![]() | Pay Rate Array[13] | DLR11_$U2 | Currency | 14 | |
29 | PAYRTARR_14 ![]() | Pay Rate Array[14] | DLR11_$U2 | Currency | 14 | |
30 | PAYRTARR_15 ![]() | Pay Rate Array[15] | DLR11_$U2 | Currency | 14 | |
31 | PAYRTARR_16 ![]() | Pay Rate Array[16] | DLR11_$U2 | Currency | 14 | |
32 | PAYRTARR_17 ![]() | Pay Rate Array[17] | DLR11_$U2 | Currency | 14 | |
33 | PAYRTARR_18 ![]() | Pay Rate Array[18] | DLR11_$U2 | Currency | 14 | |
34 | PAYRTARR_19 ![]() | Pay Rate Array[19] | DLR11_$U2 | Currency | 14 | |
35 | PAYRTARR_20 ![]() | Pay Rate Array[20] | DLR11_$U2 | Currency | 14 | |
36 | PAYRTARR_21 ![]() | Pay Rate Array[21] | DLR11_$U2 | Currency | 14 | |
37 | PAYRTARR_22 ![]() | Pay Rate Array[22] | DLR11_$U2 | Currency | 14 | |
38 | PAYRTARR_23 ![]() | Pay Rate Array[23] | DLR11_$U2 | Currency | 14 | |
39 | PAYRTARR_24 ![]() | Pay Rate Array[24] | DLR11_$U2 | Currency | 14 | |
40 | PAYRTARR_25 ![]() | Pay Rate Array[25] | DLR11_$U2 | Currency | 14 | |
41 | PAYHRSAR ![]() | Pay Hours Array | LI6_S2 | Long Integer | 6 | |
42 | PAYHRSAR_1 ![]() | Pay Hours Array[1] | LI6_S2 | Long Integer | 6 | |
43 | PAYHRSAR_2 ![]() | Pay Hours Array[2] | LI6_S2 | Long Integer | 6 | |
44 | PAYHRSAR_3 ![]() | Pay Hours Array[3] | LI6_S2 | Long Integer | 6 | |
45 | PAYHRSAR_4 ![]() | Pay Hours Array[4] | LI6_S2 | Long Integer | 6 | |
46 | PAYHRSAR_5 ![]() | Pay Hours Array[5] | LI6_S2 | Long Integer | 6 | |
47 | PAYHRSAR_6 ![]() | Pay Hours Array[6] | LI6_S2 | Long Integer | 6 | |
48 | PAYHRSAR_7 ![]() | Pay Hours Array[7] | LI6_S2 | Long Integer | 6 | |
49 | PAYHRSAR_8 ![]() | Pay Hours Array[8] | LI6_S2 | Long Integer | 6 | |
50 | PAYHRSAR_9 ![]() | Pay Hours Array[9] | LI6_S2 | Long Integer | 6 | |
51 | PAYHRSAR_10 ![]() | Pay Hours Array[10] | LI6_S2 | Long Integer | 6 | |
52 | PAYHRSAR_11 ![]() | Pay Hours Array[11] | LI6_S2 | Long Integer | 6 | |
53 | PAYHRSAR_12 ![]() | Pay Hours Array[12] | LI6_S2 | Long Integer | 6 | |
54 | PAYHRSAR_13 ![]() | Pay Hours Array[13] | LI6_S2 | Long Integer | 6 | |
55 | PAYHRSAR_14 ![]() | Pay Hours Array[14] | LI6_S2 | Long Integer | 6 | |
56 | PAYHRSAR_15 ![]() | Pay Hours Array[15] | LI6_S2 | Long Integer | 6 | |
57 | PAYHRSAR_16 ![]() | Pay Hours Array[16] | LI6_S2 | Long Integer | 6 | |
58 | PAYHRSAR_17 ![]() | Pay Hours Array[17] | LI6_S2 | Long Integer | 6 | |
59 | PAYHRSAR_18 ![]() | Pay Hours Array[18] | LI6_S2 | Long Integer | 6 | |
60 | PAYHRSAR_19 ![]() | Pay Hours Array[19] | LI6_S2 | Long Integer | 6 | |
61 | PAYHRSAR_20 ![]() | Pay Hours Array[20] | LI6_S2 | Long Integer | 6 | |
62 | PAYHRSAR_21 ![]() | Pay Hours Array[21] | LI6_S2 | Long Integer | 6 | |
63 | PAYHRSAR_22 ![]() | Pay Hours Array[22] | LI6_S2 | Long Integer | 6 | |
64 | PAYHRSAR_23 ![]() | Pay Hours Array[23] | LI6_S2 | Long Integer | 6 | |
65 | PAYHRSAR_24 ![]() | Pay Hours Array[24] | LI6_S2 | Long Integer | 6 | |
66 | PAYHRSAR_25 ![]() | Pay Hours Array[25] | LI6_S2 | Long Integer | 6 | |
67 | PAYERNAR ![]() | Pay Earnings Array | DLR11_$S2 | Currency | 14 | |
68 | PAYERNAR_1 ![]() | Pay Earnings Array[1] | DLR11_$S2 | Currency | 14 | |
69 | PAYERNAR_2 ![]() | Pay Earnings Array[2] | DLR11_$S2 | Currency | 14 | |
70 | PAYERNAR_3 ![]() | Pay Earnings Array[3] | DLR11_$S2 | Currency | 14 | |
71 | PAYERNAR_4 ![]() | Pay Earnings Array[4] | DLR11_$S2 | Currency | 14 | |
72 | PAYERNAR_5 ![]() | Pay Earnings Array[5] | DLR11_$S2 | Currency | 14 | |
73 | PAYERNAR_6 ![]() | Pay Earnings Array[6] | DLR11_$S2 | Currency | 14 | |
74 | PAYERNAR_7 ![]() | Pay Earnings Array[7] | DLR11_$S2 | Currency | 14 | |
75 | PAYERNAR_8 ![]() | Pay Earnings Array[8] | DLR11_$S2 | Currency | 14 | |
76 | PAYERNAR_9 ![]() | Pay Earnings Array[9] | DLR11_$S2 | Currency | 14 | |
77 | PAYERNAR_10 ![]() | Pay Earnings Array[10] | DLR11_$S2 | Currency | 14 | |
78 | PAYERNAR_11 ![]() | Pay Earnings Array[11] | DLR11_$S2 | Currency | 14 | |
79 | PAYERNAR_12 ![]() | Pay Earnings Array[12] | DLR11_$S2 | Currency | 14 | |
80 | PAYERNAR_13 ![]() | Pay Earnings Array[13] | DLR11_$S2 | Currency | 14 | |
81 | PAYERNAR_14 ![]() | Pay Earnings Array[14] | DLR11_$S2 | Currency | 14 | |
82 | PAYERNAR_15 ![]() | Pay Earnings Array[15] | DLR11_$S2 | Currency | 14 | |
83 | PAYERNAR_16 ![]() | Pay Earnings Array[16] | DLR11_$S2 | Currency | 14 | |
84 | PAYERNAR_17 ![]() | Pay Earnings Array[17] | DLR11_$S2 | Currency | 14 | |
85 | PAYERNAR_18 ![]() | Pay Earnings Array[18] | DLR11_$S2 | Currency | 14 | |
86 | PAYERNAR_19 ![]() | Pay Earnings Array[19] | DLR11_$S2 | Currency | 14 | |
87 | PAYERNAR_20 ![]() | Pay Earnings Array[20] | DLR11_$S2 | Currency | 14 | |
88 | PAYERNAR_21 ![]() | Pay Earnings Array[21] | DLR11_$S2 | Currency | 14 | |
89 | PAYERNAR_22 ![]() | Pay Earnings Array[22] | DLR11_$S2 | Currency | 14 | |
90 | PAYERNAR_23 ![]() | Pay Earnings Array[23] | DLR11_$S2 | Currency | 14 | |
91 | PAYERNAR_24 ![]() | Pay Earnings Array[24] | DLR11_$S2 | Currency | 14 | |
92 | PAYERNAR_25 ![]() | Pay Earnings Array[25] | DLR11_$S2 | Currency | 14 | |
93 | TFICATWH ![]() | Total FICA Tax Withheld | DLR11_$S2 | Currency | 14 | |
94 | FCASWPR ![]() | FICA/Social Security Withholding/Pay Run | DLR11_$S2 | Currency | 14 | |
95 | FICAMWPR ![]() | FICA/Medicare Withholding/Pay Run | DLR11_$S2 | Currency | 14 | |
96 | FDWDGPRN ![]() | Federal Withholding/Pay Run | DLR11_$S2 | Currency | 14 | |
97 | STWHDARR ![]() | State Tax Withholding Array | DLR11_$S2 | Currency | 14 | |
98 | STWHDARR_1 ![]() | State Tax Withholding Array[1] | DLR11_$S2 | Currency | 14 | |
99 | STWHDARR_2 ![]() | State Tax Withholding Array[2] | DLR11_$S2 | Currency | 14 | |
100 | STWHDARR_3 ![]() | State Tax Withholding Array[3] | DLR11_$S2 | Currency | 14 | |
101 | STWHDARR_4 ![]() | State Tax Withholding Array[4] | DLR11_$S2 | Currency | 14 | |
102 | STWHDARR_5 ![]() | State Tax Withholding Array[5] | DLR11_$S2 | Currency | 14 | |
103 | STWHDARR_6 ![]() | State Tax Withholding Array[6] | DLR11_$S2 | Currency | 14 | |
104 | STWHDARR_7 ![]() | State Tax Withholding Array[7] | DLR11_$S2 | Currency | 14 | |
105 | STWHDARR_8 ![]() | State Tax Withholding Array[8] | DLR11_$S2 | Currency | 14 | |
106 | STWHDARR_9 ![]() | State Tax Withholding Array[9] | DLR11_$S2 | Currency | 14 | |
107 | STWHDARR_10 ![]() | State Tax Withholding Array[10] | DLR11_$S2 | Currency | 14 | |
108 | STWHDARR_11 ![]() | State Tax Withholding Array[11] | DLR11_$S2 | Currency | 14 | |
109 | STWHDARR_12 ![]() | State Tax Withholding Array[12] | DLR11_$S2 | Currency | 14 | |
110 | STWHDARR_13 ![]() | State Tax Withholding Array[13] | DLR11_$S2 | Currency | 14 | |
111 | STWHDARR_14 ![]() | State Tax Withholding Array[14] | DLR11_$S2 | Currency | 14 | |
112 | STWHDARR_15 ![]() | State Tax Withholding Array[15] | DLR11_$S2 | Currency | 14 | |
113 | STWHDARR_16 ![]() | State Tax Withholding Array[16] | DLR11_$S2 | Currency | 14 | |
114 | STWHDARR_17 ![]() | State Tax Withholding Array[17] | DLR11_$S2 | Currency | 14 | |
115 | STWHDARR_18 ![]() | State Tax Withholding Array[18] | DLR11_$S2 | Currency | 14 | |
116 | STWHDARR_19 ![]() | State Tax Withholding Array[19] | DLR11_$S2 | Currency | 14 | |
117 | STWHDARR_20 ![]() | State Tax Withholding Array[20] | DLR11_$S2 | Currency | 14 | |
118 | STWHDARR_21 ![]() | State Tax Withholding Array[21] | DLR11_$S2 | Currency | 14 | |
119 | STWHDARR_22 ![]() | State Tax Withholding Array[22] | DLR11_$S2 | Currency | 14 | |
120 | STWHDARR_23 ![]() | State Tax Withholding Array[23] | DLR11_$S2 | Currency | 14 | |
121 | STWHDARR_24 ![]() | State Tax Withholding Array[24] | DLR11_$S2 | Currency | 14 | |
122 | STWHDARR_25 ![]() | State Tax Withholding Array[25] | DLR11_$S2 | Currency | 14 | |
123 | LTXWHGAR ![]() | Local Tax Withholding Array | DLR11_$S2 | Currency | 14 | |
124 | LTXWHGAR_1 ![]() | Local Tax Withholding Array[1] | DLR11_$S2 | Currency | 14 | |
125 | LTXWHGAR_2 ![]() | Local Tax Withholding Array[2] | DLR11_$S2 | Currency | 14 | |
126 | LTXWHGAR_3 ![]() | Local Tax Withholding Array[3] | DLR11_$S2 | Currency | 14 | |
127 | LTXWHGAR_4 ![]() | Local Tax Withholding Array[4] | DLR11_$S2 | Currency | 14 | |
128 | LTXWHGAR_5 ![]() | Local Tax Withholding Array[5] | DLR11_$S2 | Currency | 14 | |
129 | LTXWHGAR_6 ![]() | Local Tax Withholding Array[6] | DLR11_$S2 | Currency | 14 | |
130 | LTXWHGAR_7 ![]() | Local Tax Withholding Array[7] | DLR11_$S2 | Currency | 14 | |
131 | LTXWHGAR_8 ![]() | Local Tax Withholding Array[8] | DLR11_$S2 | Currency | 14 | |
132 | LTXWHGAR_9 ![]() | Local Tax Withholding Array[9] | DLR11_$S2 | Currency | 14 | |
133 | LTXWHGAR_10 ![]() | Local Tax Withholding Array[10] | DLR11_$S2 | Currency | 14 | |
134 | LTXWHGAR_11 ![]() | Local Tax Withholding Array[11] | DLR11_$S2 | Currency | 14 | |
135 | LTXWHGAR_12 ![]() | Local Tax Withholding Array[12] | DLR11_$S2 | Currency | 14 | |
136 | LTXWHGAR_13 ![]() | Local Tax Withholding Array[13] | DLR11_$S2 | Currency | 14 | |
137 | LTXWHGAR_14 ![]() | Local Tax Withholding Array[14] | DLR11_$S2 | Currency | 14 | |
138 | LTXWHGAR_15 ![]() | Local Tax Withholding Array[15] | DLR11_$S2 | Currency | 14 | |
139 | LTXWHGAR_16 ![]() | Local Tax Withholding Array[16] | DLR11_$S2 | Currency | 14 | |
140 | LTXWHGAR_17 ![]() | Local Tax Withholding Array[17] | DLR11_$S2 | Currency | 14 | |
141 | LTXWHGAR_18 ![]() | Local Tax Withholding Array[18] | DLR11_$S2 | Currency | 14 | |
142 | LTXWHGAR_19 ![]() | Local Tax Withholding Array[19] | DLR11_$S2 | Currency | 14 | |
143 | LTXWHGAR_20 ![]() | Local Tax Withholding Array[20] | DLR11_$S2 | Currency | 14 | |
144 | LTXWHGAR_21 ![]() | Local Tax Withholding Array[21] | DLR11_$S2 | Currency | 14 | |
145 | LTXWHGAR_22 ![]() | Local Tax Withholding Array[22] | DLR11_$S2 | Currency | 14 | |
146 | LTXWHGAR_23 ![]() | Local Tax Withholding Array[23] | DLR11_$S2 | Currency | 14 | |
147 | LTXWHGAR_24 ![]() | Local Tax Withholding Array[24] | DLR11_$S2 | Currency | 14 | |
148 | LTXWHGAR_25 ![]() | Local Tax Withholding Array[25] | DLR11_$S2 | Currency | 14 | |
149 | DEDAMARR ![]() | Deduction Amount Array | DLR11_$S2 | Currency | 14 | |
150 | DEDAMARR_1 ![]() | Deduction Amount Array[1] | DLR11_$S2 | Currency | 14 | |
151 | DEDAMARR_2 ![]() | Deduction Amount Array[2] | DLR11_$S2 | Currency | 14 | |
152 | DEDAMARR_3 ![]() | Deduction Amount Array[3] | DLR11_$S2 | Currency | 14 | |
153 | DEDAMARR_4 ![]() | Deduction Amount Array[4] | DLR11_$S2 | Currency | 14 | |
154 | DEDAMARR_5 ![]() | Deduction Amount Array[5] | DLR11_$S2 | Currency | 14 | |
155 | DEDAMARR_6 ![]() | Deduction Amount Array[6] | DLR11_$S2 | Currency | 14 | |
156 | DEDAMARR_7 ![]() | Deduction Amount Array[7] | DLR11_$S2 | Currency | 14 | |
157 | DEDAMARR_8 ![]() | Deduction Amount Array[8] | DLR11_$S2 | Currency | 14 | |
158 | DEDAMARR_9 ![]() | Deduction Amount Array[9] | DLR11_$S2 | Currency | 14 | |
159 | DEDAMARR_10 ![]() | Deduction Amount Array[10] | DLR11_$S2 | Currency | 14 | |
160 | DEDAMARR_11 ![]() | Deduction Amount Array[11] | DLR11_$S2 | Currency | 14 | |
161 | DEDAMARR_12 ![]() | Deduction Amount Array[12] | DLR11_$S2 | Currency | 14 | |
162 | DEDAMARR_13 ![]() | Deduction Amount Array[13] | DLR11_$S2 | Currency | 14 | |
163 | DEDAMARR_14 ![]() | Deduction Amount Array[14] | DLR11_$S2 | Currency | 14 | |
164 | DEDAMARR_15 ![]() | Deduction Amount Array[15] | DLR11_$S2 | Currency | 14 | |
165 | DEDAMARR_16 ![]() | Deduction Amount Array[16] | DLR11_$S2 | Currency | 14 | |
166 | DEDAMARR_17 ![]() | Deduction Amount Array[17] | DLR11_$S2 | Currency | 14 | |
167 | DEDAMARR_18 ![]() | Deduction Amount Array[18] | DLR11_$S2 | Currency | 14 | |
168 | DEDAMARR_19 ![]() | Deduction Amount Array[19] | DLR11_$S2 | Currency | 14 | |
169 | DEDAMARR_20 ![]() | Deduction Amount Array[20] | DLR11_$S2 | Currency | 14 | |
170 | DEDAMARR_21 ![]() | Deduction Amount Array[21] | DLR11_$S2 | Currency | 14 | |
171 | DEDAMARR_22 ![]() | Deduction Amount Array[22] | DLR11_$S2 | Currency | 14 | |
172 | DEDAMARR_23 ![]() | Deduction Amount Array[23] | DLR11_$S2 | Currency | 14 | |
173 | DEDAMARR_24 ![]() | Deduction Amount Array[24] | DLR11_$S2 | Currency | 14 | |
174 | DEDAMARR_25 ![]() | Deduction Amount Array[25] | DLR11_$S2 | Currency | 14 | |
175 | BNFAMARR ![]() | Benefit Amount Array | DLR11_$S2 | Currency | 14 | |
176 | BNFAMARR_1 ![]() | Benefit Amount Array[1] | DLR11_$S2 | Currency | 14 | |
177 | BNFAMARR_2 ![]() | Benefit Amount Array[2] | DLR11_$S2 | Currency | 14 | |
178 | BNFAMARR_3 ![]() | Benefit Amount Array[3] | DLR11_$S2 | Currency | 14 | |
179 | BNFAMARR_4 ![]() | Benefit Amount Array[4] | DLR11_$S2 | Currency | 14 | |
180 | BNFAMARR_5 ![]() | Benefit Amount Array[5] | DLR11_$S2 | Currency | 14 | |
181 | BNFAMARR_6 ![]() | Benefit Amount Array[6] | DLR11_$S2 | Currency | 14 | |
182 | BNFAMARR_7 ![]() | Benefit Amount Array[7] | DLR11_$S2 | Currency | 14 | |
183 | BNFAMARR_8 ![]() | Benefit Amount Array[8] | DLR11_$S2 | Currency | 14 | |
184 | BNFAMARR_9 ![]() | Benefit Amount Array[9] | DLR11_$S2 | Currency | 14 | |
185 | BNFAMARR_10 ![]() | Benefit Amount Array[10] | DLR11_$S2 | Currency | 14 | |
186 | BNFAMARR_11 ![]() | Benefit Amount Array[11] | DLR11_$S2 | Currency | 14 | |
187 | BNFAMARR_12 ![]() | Benefit Amount Array[12] | DLR11_$S2 | Currency | 14 | |
188 | BNFAMARR_13 ![]() | Benefit Amount Array[13] | DLR11_$S2 | Currency | 14 | |
189 | BNFAMARR_14 ![]() | Benefit Amount Array[14] | DLR11_$S2 | Currency | 14 | |
190 | BNFAMARR_15 ![]() | Benefit Amount Array[15] | DLR11_$S2 | Currency | 14 | |
191 | BNFAMARR_16 ![]() | Benefit Amount Array[16] | DLR11_$S2 | Currency | 14 | |
192 | BNFAMARR_17 ![]() | Benefit Amount Array[17] | DLR11_$S2 | Currency | 14 | |
193 | BNFAMARR_18 ![]() | Benefit Amount Array[18] | DLR11_$S2 | Currency | 14 | |
194 | BNFAMARR_19 ![]() | Benefit Amount Array[19] | DLR11_$S2 | Currency | 14 | |
195 | BNFAMARR_20 ![]() | Benefit Amount Array[20] | DLR11_$S2 | Currency | 14 | |
196 | BNFAMARR_21 ![]() | Benefit Amount Array[21] | DLR11_$S2 | Currency | 14 | |
197 | BNFAMARR_22 ![]() | Benefit Amount Array[22] | DLR11_$S2 | Currency | 14 | |
198 | BNFAMARR_23 ![]() | Benefit Amount Array[23] | DLR11_$S2 | Currency | 14 | |
199 | BNFAMARR_24 ![]() | Benefit Amount Array[24] | DLR11_$S2 | Currency | 14 | |
200 | BNFAMARR_25 ![]() | Benefit Amount Array[25] | DLR11_$S2 | Currency | 14 | |
201 | TIMEAVAILARRAY ![]() | Time Available Array | DLR11_S2 | Currency | 11 | |
202 | TIMEAVAILARRAY_1 ![]() | Time Available Array[1] | DLR11_S2 | Currency | 11 | |
203 | TIMEAVAILARRAY_2 ![]() | Time Available Array[2] | DLR11_S2 | Currency | 11 | |
204 | TIMEAVAILARRAY_3 ![]() | Time Available Array[3] | DLR11_S2 | Currency | 11 | |
205 | TIMEAVAILARRAY_4 ![]() | Time Available Array[4] | DLR11_S2 | Currency | 11 | |
206 | TIMEAVAILARRAY_5 ![]() | Time Available Array[5] | DLR11_S2 | Currency | 11 | |
207 | TIMEAVAILARRAY_6 ![]() | Time Available Array[6] | DLR11_S2 | Currency | 11 | |
208 | TIMEAVAILARRAY_7 ![]() | Time Available Array[7] | DLR11_S2 | Currency | 11 | |
209 | TIMEAVAILARRAY_8 ![]() | Time Available Array[8] | DLR11_S2 | Currency | 11 | |
210 | TIMEAVAILARRAY_9 ![]() | Time Available Array[9] | DLR11_S2 | Currency | 11 | |
211 | TIMEAVAILARRAY_10 ![]() | Time Available Array[10] | DLR11_S2 | Currency | 11 | |
212 | TIMEAVAILARRAY_11 ![]() | Time Available Array[11] | DLR11_S2 | Currency | 11 | |
213 | TIMEAVAILARRAY_12 ![]() | Time Available Array[12] | DLR11_S2 | Currency | 11 | |
214 | TIMEAVAILARRAY_13 ![]() | Time Available Array[13] | DLR11_S2 | Currency | 11 | |
215 | TIMEAVAILARRAY_14 ![]() | Time Available Array[14] | DLR11_S2 | Currency | 11 | |
216 | TIMEAVAILARRAY_15 ![]() | Time Available Array[15] | DLR11_S2 | Currency | 11 | |
217 | TIMEAVAILARRAY_16 ![]() | Time Available Array[16] | DLR11_S2 | Currency | 11 | |
218 | TIMEAVAILARRAY_17 ![]() | Time Available Array[17] | DLR11_S2 | Currency | 11 | |
219 | TIMEAVAILARRAY_18 ![]() | Time Available Array[18] | DLR11_S2 | Currency | 11 | |
220 | TIMEAVAILARRAY_19 ![]() | Time Available Array[19] | DLR11_S2 | Currency | 11 | |
221 | TIMEAVAILARRAY_20 ![]() | Time Available Array[20] | DLR11_S2 | Currency | 11 | |
222 | TIMEAVAILARRAY_21 ![]() | Time Available Array[21] | DLR11_S2 | Currency | 11 | |
223 | TIMEAVAILARRAY_22 ![]() | Time Available Array[22] | DLR11_S2 | Currency | 11 | |
224 | TIMEAVAILARRAY_23 ![]() | Time Available Array[23] | DLR11_S2 | Currency | 11 | |
225 | TIMEAVAILARRAY_24 ![]() | Time Available Array[24] | DLR11_S2 | Currency | 11 | |
226 | TIMEAVAILARRAY_25 ![]() | Time Available Array[25] | DLR11_S2 | Currency | 11 | |
227 | TTLHOURS ![]() | Total Hours | LI6_S2 | Long Integer | 6 | |
228 | TTLERNGS ![]() | Total Earnings | DLR11_$S2 | Currency | 14 | |
229 | TOTLTAXS ![]() | Total Taxes | DLR11_$S2 | Currency | 14 | |
230 | TTLDDTNS ![]() | Total Deductions | DLR11_$S2 | Currency | 14 | |
231 | TTLBNFTS ![]() | Total Benefits | DLR11_$S2 | Currency | 14 | |
232 | NTWPYRN ![]() | Net Wages/Pay Run | DLR11_$S2 | Currency | 14 | |
233 | GRWGPRN ![]() | Gross Wages/Pay Run | DLR11_$S2 | Currency | 14 | |
234 | REGHOURS ![]() | Regular Hours | LI6_S2 | Long Integer | 6 | |
235 | REGERNGS ![]() | Regular Earnings | DLR11_$S2 | Currency | 14 | |
236 | OVRTMHRS ![]() | Overtime Hours | LI6_S2 | Long Integer | 6 | |
237 | OVTMEARN ![]() | Overtime Earnings | DLR11_$S2 | Currency | 14 | |
238 | DBLTMHRS ![]() | Double Time Hours | LI6_S2 | Long Integer | 6 | |
239 | DBLTMERN ![]() | Double Time Earnings | DLR11_$S2 | Currency | 14 | |
240 | EICERNGS ![]() | EIC Earnings | DLR11_$S2 | Currency | 14 | |
241 | COMMERNG ![]() | Commission Earnings | DLR11_$S2 | Currency | 14 | |
242 | BSNEXERN ![]() | Business Expense Earnings | DLR11_$S2 | Currency | 14 | |
243 | PNSNERNG ![]() | Pension Earnings | DLR11_$S2 | Currency | 14 | |
244 | HOLDYHRS ![]() | Holiday Hours | LI6_S2 | Long Integer | 6 | |
245 | HLDYEARN ![]() | Holiday Earnings | DLR11_$S2 | Currency | 14 | |
246 | VACTNHRS ![]() | Vacation Hours | LI6_S2 | Long Integer | 6 | |
247 | VCTNERNG ![]() | Vacation Earnings | DLR11_$S2 | Currency | 14 | |
248 | SKTIMHRS ![]() | Sick Time Hours | LI6_S2 | Long Integer | 6 | |
249 | SKTMERNG ![]() | Sick Time Earnings | DLR11_$S2 | Currency | 14 | |
250 | PCWKUNIT ![]() | Piecework Units | LI6_S2 | Long Integer | 6 | |
251 | PCWKERNG ![]() | Piecework Earnings | DLR11_$S2 | Currency | 14 | |
252 | SPCLERNG ![]() | Special Earnings | DLR11_$S2 | Currency | 14 | |
253 | CHGTPERN ![]() | Charged Tips Earnings | DLR11_$S2 | Currency | 14 | |
254 | REPTPERN ![]() | Reported Tips Earnings | DLR11_$S2 | Currency | 14 | |
255 | MNWGBLER ![]() | Min Wage Bal Earnings | DLR11_$S2 | Currency | 14 | |
256 | VACAVLBL ![]() | Vacation Available | LI6_S2 | Long Integer | 6 | |
257 | SIKTIMAV ![]() | Sick Time Available | LI6_S2 | Long Integer | 6 | |
258 | STTPYPRD ![]() | Start Pay Period | DT | Date | 8 | |
259 | ENPAYPRD ![]() | End Pay Period | DT | Date | 8 | |
260 | Uncollected_FICAMed_TaxP ![]() | Uncollected FICA/Med Tax/Pay Run | DLR11_$S2 | Currency | 14 | |
261 | Uncollected_FICASS_TaxP ![]() | Uncollected FICA/SS Tax/Pay Run | DLR11_$S2 | Currency | 14 | |
262 | RSNCHKVD ![]() | Reason Check Voided | STR30 | String | 30 | |
263 | AMTINWDS ![]() | Amount in Words | TX500 | Text | 500 | |
264 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |