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

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Work Check (UPR10208)

Click to show/hide Printed flag

Click to show/hide

Leave a Reply Cancel reply