SmartList Payroll Employee Summary (ASIEXP32)

azurecurve Products SmartList (1493)PathnameSmartList Payroll Employee Summary (ASIEXP32)

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

Display Name: SmartList Payroll Employee Summary
Physical Name: ASIEXP32
Technical Name: ASI_UPR_Employee_SUM_Explorer

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
2	YEAR1	Year	Integer	Year	4
3	EMPLCLAS	Employee Class	String	STR15_Employee_Class	15
4	INACTIVE	Inactive	Boolean	CB_Inactive	0
5	LASTNAME	Last Name	String	STR20	20
6	FRSTNAME	First Name	String	STR15	15
7	MIDLNAME	Middle Name	String	STR15	15
8	SOCSCNUM	Social Security Number	String	STR15_Social_Security_Number	15
9	BRTHDATE	Birth Date	Date	DT	8
10	GENDER	Gender	Integer	DDL_Gender	0
11	ETHNORGN	Ethnic Origin	Integer	DDL_Ethnic Origin	0
12	Calc_Min_Wage_Bal	Calc Min Wage Bal	Boolean	CB_CalcMinWageBal	0
13	DEPRTMNT	Department	String	STR6_Payroll_Code	6
14	JOBTITLE	Job Title	String	STR6_Payroll_Code	6
15	WCACFPAY	Which Cash Account For Pay	Integer	GB	0
16	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payroll Employee Summary'].ACTINDX AS 'SmartList Payroll Employee Summary-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP32 AS ['SmartList Payroll Employee Summary'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payroll Employee Summary'].ACTINDX = ['Account Index Master'].ACTINDX
17	WKHRPRYR	Work Hours Per Year	Integer	INT4_U0	4
18	STRTDATE	Start Date	Date	DT	8
19	DEMPINAC	Date Employee Inactivated	Date	DT	8
20	RSNEMPIN	Reason Employee Inactivated	String	STR30	30
21	MINETPAY	Minimum Net Pay	Currency	DLR11_$U2	14
22	SUTASTAT	Suta State	String	STR2_State_Code	2
23	WRKRCOMP	Workers Comp	String	STR6_Payroll_Code	6
24	ATACRVAC	Auto Accrue Vacation	Boolean	CB_Accrue_Vacation:	0
25	VACCRAMT	Vacation Accrual Amount	Long Integer	LI6_U2	6
26	VACCRMTH	Vacation Accrual Method	Integer	GB	0
27	VACAPRYR	Vacation Hours Per Year	Long Integer	LI6_U2	6
28	VACAVLBL	Vacation Available	Long Integer	LI6_S2	6
29	ATACRSTM	Auto Accrue Sick Time	Boolean	CB_Accrue_Sick_Time:	0
30	STMACMTH	Sick Time Accrual Method	Integer	GB	0
31	SKTMACAM	Sick Time Accrual Amount	Long Integer	LI6_U2	6
32	SIKTIMAV	Sick Time Available	Long Integer	LI6_S2	6
33	SKTMHPYR	Sick Time Hours Per Year	Long Integer	LI6_U2	6
34	USERDEF1	User Defined 1	String	STR20	20
35	USERDEF2	User Defined 2	String	STR20	20
36	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SmartList Payroll Employee Summary'].NOTEINDX AS 'SmartList Payroll Employee Summary-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ASIEXP32 AS ['SmartList Payroll Employee Summary'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SmartList Payroll Employee Summary'].NOTEINDX = ['Record Notes Master'].NOTEINDX
37	LPCHKNUM	Last Paycheck Number	String	Check_Number	20
38	LSTPCKDT	Last Paycheck Date	Date	DT	8
39	LPCHKAMT	Last Paycheck Amount	Currency	DLR11_$S2	14
40	GROSWAGS_1	Gross Wages[1]	Currency	DLR11_$S2	14
41	GROSWAGS_2	Gross Wages[2]	Currency	DLR11_$S2	14
42	GROSWAGS_3	Gross Wages[3]	Currency	DLR11_$S2	14
43	GROSWAGS_4	Gross Wages[4]	Currency	DLR11_$S2	14
44	GROSWAGS_5	Gross Wages[5]	Currency	DLR11_$S2	14
45	GROSWAGS_6	Gross Wages[6]	Currency	DLR11_$S2	14
46	GROSWAGS_7	Gross Wages[7]	Currency	DLR11_$S2	14
47	GROSWAGS_8	Gross Wages[8]	Currency	DLR11_$S2	14
48	GROSWAGS_9	Gross Wages[9]	Currency	DLR11_$S2	14
49	GROSWAGS_10	Gross Wages[10]	Currency	DLR11_$S2	14
50	GROSWAGS_11	Gross Wages[11]	Currency	DLR11_$S2	14
51	GROSWAGS_12	Gross Wages[12]	Currency	DLR11_$S2	14
52	Federal_Wages_1	Federal Wages[1]	Currency	DLR11_$S2	14
53	Federal_Wages_2	Federal Wages[2]	Currency	DLR11_$S2	14
54	Federal_Wages_3	Federal Wages[3]	Currency	DLR11_$S2	14
55	Federal_Wages_4	Federal Wages[4]	Currency	DLR11_$S2	14
56	Federal_Wages_5	Federal Wages[5]	Currency	DLR11_$S2	14
57	Federal_Wages_6	Federal Wages[6]	Currency	DLR11_$S2	14
58	Federal_Wages_7	Federal Wages[7]	Currency	DLR11_$S2	14
59	Federal_Wages_8	Federal Wages[8]	Currency	DLR11_$S2	14
60	Federal_Wages_9	Federal Wages[9]	Currency	DLR11_$S2	14
61	Federal_Wages_10	Federal Wages[10]	Currency	DLR11_$S2	14
62	Federal_Wages_11	Federal Wages[11]	Currency	DLR11_$S2	14
63	Federal_Wages_12	Federal Wages[12]	Currency	DLR11_$S2	14
64	Federal_Tips_1	Federal Tips[1]	Currency	DLR11_$S2	14
65	Federal_Tips_2	Federal Tips[2]	Currency	DLR11_$S2	14
66	Federal_Tips_3	Federal Tips[3]	Currency	DLR11_$S2	14
67	Federal_Tips_4	Federal Tips[4]	Currency	DLR11_$S2	14
68	Federal_Tips_5	Federal Tips[5]	Currency	DLR11_$S2	14
69	Federal_Tips_6	Federal Tips[6]	Currency	DLR11_$S2	14
70	Federal_Tips_7	Federal Tips[7]	Currency	DLR11_$S2	14
71	Federal_Tips_8	Federal Tips[8]	Currency	DLR11_$S2	14
72	Federal_Tips_9	Federal Tips[9]	Currency	DLR11_$S2	14
73	Federal_Tips_10	Federal Tips[10]	Currency	DLR11_$S2	14
74	Federal_Tips_11	Federal Tips[11]	Currency	DLR11_$S2	14
75	Federal_Tips_12	Federal Tips[12]	Currency	DLR11_$S2	14
76	FDWTHLDG_1	Federal Withholding[1]	Currency	DLR11_$S2	14
77	FDWTHLDG_2	Federal Withholding[2]	Currency	DLR11_$S2	14
78	FDWTHLDG_3	Federal Withholding[3]	Currency	DLR11_$S2	14
79	FDWTHLDG_4	Federal Withholding[4]	Currency	DLR11_$S2	14
80	FDWTHLDG_5	Federal Withholding[5]	Currency	DLR11_$S2	14
81	FDWTHLDG_6	Federal Withholding[6]	Currency	DLR11_$S2	14
82	FDWTHLDG_7	Federal Withholding[7]	Currency	DLR11_$S2	14
83	FDWTHLDG_8	Federal Withholding[8]	Currency	DLR11_$S2	14
84	FDWTHLDG_9	Federal Withholding[9]	Currency	DLR11_$S2	14
85	FDWTHLDG_10	Federal Withholding[10]	Currency	DLR11_$S2	14
86	FDWTHLDG_11	Federal Withholding[11]	Currency	DLR11_$S2	14
87	FDWTHLDG_12	Federal Withholding[12]	Currency	DLR11_$S2	14
88	FICASSWG_1	FICA/Social Security Wages[1]	Currency	DLR11_$S2	14
89	FICASSWG_2	FICA/Social Security Wages[2]	Currency	DLR11_$S2	14
90	FICASSWG_3	FICA/Social Security Wages[3]	Currency	DLR11_$S2	14
91	FICASSWG_4	FICA/Social Security Wages[4]	Currency	DLR11_$S2	14
92	FICASSWG_5	FICA/Social Security Wages[5]	Currency	DLR11_$S2	14
93	FICASSWG_6	FICA/Social Security Wages[6]	Currency	DLR11_$S2	14
94	FICASSWG_7	FICA/Social Security Wages[7]	Currency	DLR11_$S2	14
95	FICASSWG_8	FICA/Social Security Wages[8]	Currency	DLR11_$S2	14
96	FICASSWG_9	FICA/Social Security Wages[9]	Currency	DLR11_$S2	14
97	FICASSWG_10	FICA/Social Security Wages[10]	Currency	DLR11_$S2	14
98	FICASSWG_11	FICA/Social Security Wages[11]	Currency	DLR11_$S2	14
99	FICASSWG_12	FICA/Social Security Wages[12]	Currency	DLR11_$S2	14
100	FICAMWGS_1	FICA/Medicare Wages[1]	Currency	DLR11_$S2	14
101	FICAMWGS_2	FICA/Medicare Wages[2]	Currency	DLR11_$S2	14
102	FICAMWGS_3	FICA/Medicare Wages[3]	Currency	DLR11_$S2	14
103	FICAMWGS_4	FICA/Medicare Wages[4]	Currency	DLR11_$S2	14
104	FICAMWGS_5	FICA/Medicare Wages[5]	Currency	DLR11_$S2	14
105	FICAMWGS_6	FICA/Medicare Wages[6]	Currency	DLR11_$S2	14
106	FICAMWGS_7	FICA/Medicare Wages[7]	Currency	DLR11_$S2	14
107	FICAMWGS_8	FICA/Medicare Wages[8]	Currency	DLR11_$S2	14
108	FICAMWGS_9	FICA/Medicare Wages[9]	Currency	DLR11_$S2	14
109	FICAMWGS_10	FICA/Medicare Wages[10]	Currency	DLR11_$S2	14
110	FICAMWGS_11	FICA/Medicare Wages[11]	Currency	DLR11_$S2	14
111	FICAMWGS_12	FICA/Medicare Wages[12]	Currency	DLR11_$S2	14
112	FICASSWH_1	FICA/Social Security Withholding[1]	Currency	DLR11_$S2	14
113	FICASSWH_2	FICA/Social Security Withholding[2]	Currency	DLR11_$S2	14
114	FICASSWH_3	FICA/Social Security Withholding[3]	Currency	DLR11_$S2	14
115	FICASSWH_4	FICA/Social Security Withholding[4]	Currency	DLR11_$S2	14
116	FICASSWH_5	FICA/Social Security Withholding[5]	Currency	DLR11_$S2	14
117	FICASSWH_6	FICA/Social Security Withholding[6]	Currency	DLR11_$S2	14
118	FICASSWH_7	FICA/Social Security Withholding[7]	Currency	DLR11_$S2	14
119	FICASSWH_8	FICA/Social Security Withholding[8]	Currency	DLR11_$S2	14
120	FICASSWH_9	FICA/Social Security Withholding[9]	Currency	DLR11_$S2	14
121	FICASSWH_10	FICA/Social Security Withholding[10]	Currency	DLR11_$S2	14
122	FICASSWH_11	FICA/Social Security Withholding[11]	Currency	DLR11_$S2	14
123	FICASSWH_12	FICA/Social Security Withholding[12]	Currency	DLR11_$S2	14
124	FICAMWDG_1	FICA/Medicare Withholding[1]	Currency	DLR11_$S2	14
125	FICAMWDG_2	FICA/Medicare Withholding[2]	Currency	DLR11_$S2	14
126	FICAMWDG_3	FICA/Medicare Withholding[3]	Currency	DLR11_$S2	14
127	FICAMWDG_4	FICA/Medicare Withholding[4]	Currency	DLR11_$S2	14
128	FICAMWDG_5	FICA/Medicare Withholding[5]	Currency	DLR11_$S2	14
129	FICAMWDG_6	FICA/Medicare Withholding[6]	Currency	DLR11_$S2	14
130	FICAMWDG_7	FICA/Medicare Withholding[7]	Currency	DLR11_$S2	14
131	FICAMWDG_8	FICA/Medicare Withholding[8]	Currency	DLR11_$S2	14
132	FICAMWDG_9	FICA/Medicare Withholding[9]	Currency	DLR11_$S2	14
133	FICAMWDG_10	FICA/Medicare Withholding[10]	Currency	DLR11_$S2	14
134	FICAMWDG_11	FICA/Medicare Withholding[11]	Currency	DLR11_$S2	14
135	FICAMWDG_12	FICA/Medicare Withholding[12]	Currency	DLR11_$S2	14
136	SUTAWAGS_1	Suta Wages[1]	Currency	DLR11_$S2	14
137	SUTAWAGS_2	Suta Wages[2]	Currency	DLR11_$S2	14
138	SUTAWAGS_3	Suta Wages[3]	Currency	DLR11_$S2	14
139	SUTAWAGS_4	Suta Wages[4]	Currency	DLR11_$S2	14
140	SUTAWAGS_5	Suta Wages[5]	Currency	DLR11_$S2	14
141	SUTAWAGS_6	Suta Wages[6]	Currency	DLR11_$S2	14
142	SUTAWAGS_7	Suta Wages[7]	Currency	DLR11_$S2	14
143	SUTAWAGS_8	Suta Wages[8]	Currency	DLR11_$S2	14
144	SUTAWAGS_9	Suta Wages[9]	Currency	DLR11_$S2	14
145	SUTAWAGS_10	Suta Wages[10]	Currency	DLR11_$S2	14
146	SUTAWAGS_11	Suta Wages[11]	Currency	DLR11_$S2	14
147	SUTAWAGS_12	Suta Wages[12]	Currency	DLR11_$S2	14
148	FUTAWAGS_1	Futa Wages[1]	Currency	DLR11_$S2	14
149	FUTAWAGS_2	Futa Wages[2]	Currency	DLR11_$S2	14
150	FUTAWAGS_3	Futa Wages[3]	Currency	DLR11_$S2	14
151	FUTAWAGS_4	Futa Wages[4]	Currency	DLR11_$S2	14
152	FUTAWAGS_5	Futa Wages[5]	Currency	DLR11_$S2	14
153	FUTAWAGS_6	Futa Wages[6]	Currency	DLR11_$S2	14
154	FUTAWAGS_7	Futa Wages[7]	Currency	DLR11_$S2	14
155	FUTAWAGS_8	Futa Wages[8]	Currency	DLR11_$S2	14
156	FUTAWAGS_9	Futa Wages[9]	Currency	DLR11_$S2	14
157	FUTAWAGS_10	Futa Wages[10]	Currency	DLR11_$S2	14
158	FUTAWAGS_11	Futa Wages[11]	Currency	DLR11_$S2	14
159	FUTAWAGS_12	Futa Wages[12]	Currency	DLR11_$S2	14
160	NETWAGES_1	Net Wages[1]	Currency	DLR11_$S2	14
161	NETWAGES_2	Net Wages[2]	Currency	DLR11_$S2	14
162	NETWAGES_3	Net Wages[3]	Currency	DLR11_$S2	14
163	NETWAGES_4	Net Wages[4]	Currency	DLR11_$S2	14
164	NETWAGES_5	Net Wages[5]	Currency	DLR11_$S2	14
165	NETWAGES_6	Net Wages[6]	Currency	DLR11_$S2	14
166	NETWAGES_7	Net Wages[7]	Currency	DLR11_$S2	14
167	NETWAGES_8	Net Wages[8]	Currency	DLR11_$S2	14
168	NETWAGES_9	Net Wages[9]	Currency	DLR11_$S2	14
169	NETWAGES_10	Net Wages[10]	Currency	DLR11_$S2	14
170	NETWAGES_11	Net Wages[11]	Currency	DLR11_$S2	14
171	NETWAGES_12	Net Wages[12]	Currency	DLR11_$S2	14
172	Reported_Tips12_1	Reported Tips Array[1]	Currency	DLR11_$S2	14
173	Reported_Tips12_2	Reported Tips Array[2]	Currency	DLR11_$S2	14
174	Reported_Tips12_3	Reported Tips Array[3]	Currency	DLR11_$S2	14
175	Reported_Tips12_4	Reported Tips Array[4]	Currency	DLR11_$S2	14
176	Reported_Tips12_5	Reported Tips Array[5]	Currency	DLR11_$S2	14
177	Reported_Tips12_6	Reported Tips Array[6]	Currency	DLR11_$S2	14
178	Reported_Tips12_7	Reported Tips Array[7]	Currency	DLR11_$S2	14
179	Reported_Tips12_8	Reported Tips Array[8]	Currency	DLR11_$S2	14
180	Reported_Tips12_9	Reported Tips Array[9]	Currency	DLR11_$S2	14
181	Reported_Tips12_10	Reported Tips Array[10]	Currency	DLR11_$S2	14
182	Reported_Tips12_11	Reported Tips Array[11]	Currency	DLR11_$S2	14
183	Reported_Tips12_12	Reported Tips Array[12]	Currency	DLR11_$S2	14
184	Charged_Tips12_1	Charged Tips Array[1]	Currency	DLR11_$S2	14
185	Charged_Tips12_2	Charged Tips Array[2]	Currency	DLR11_$S2	14
186	Charged_Tips12_3	Charged Tips Array[3]	Currency	DLR11_$S2	14
187	Charged_Tips12_4	Charged Tips Array[4]	Currency	DLR11_$S2	14
188	Charged_Tips12_5	Charged Tips Array[5]	Currency	DLR11_$S2	14
189	Charged_Tips12_6	Charged Tips Array[6]	Currency	DLR11_$S2	14
190	Charged_Tips12_7	Charged Tips Array[7]	Currency	DLR11_$S2	14
191	Charged_Tips12_8	Charged Tips Array[8]	Currency	DLR11_$S2	14
192	Charged_Tips12_9	Charged Tips Array[9]	Currency	DLR11_$S2	14
193	Charged_Tips12_10	Charged Tips Array[10]	Currency	DLR11_$S2	14
194	Charged_Tips12_11	Charged Tips Array[11]	Currency	DLR11_$S2	14
195	Charged_Tips12_12	Charged Tips Array[12]	Currency	DLR11_$S2	14
196	Federal_Tax_On_Tips_1	Federal Tax On Tips[1]	Currency	DLR11_$S2	14
197	Federal_Tax_On_Tips_2	Federal Tax On Tips[2]	Currency	DLR11_$S2	14
198	Federal_Tax_On_Tips_3	Federal Tax On Tips[3]	Currency	DLR11_$S2	14
199	Federal_Tax_On_Tips_4	Federal Tax On Tips[4]	Currency	DLR11_$S2	14
200	Federal_Tax_On_Tips_5	Federal Tax On Tips[5]	Currency	DLR11_$S2	14
201	Federal_Tax_On_Tips_6	Federal Tax On Tips[6]	Currency	DLR11_$S2	14
202	Federal_Tax_On_Tips_7	Federal Tax On Tips[7]	Currency	DLR11_$S2	14
203	Federal_Tax_On_Tips_8	Federal Tax On Tips[8]	Currency	DLR11_$S2	14
204	Federal_Tax_On_Tips_9	Federal Tax On Tips[9]	Currency	DLR11_$S2	14
205	Federal_Tax_On_Tips_10	Federal Tax On Tips[10]	Currency	DLR11_$S2	14
206	Federal_Tax_On_Tips_11	Federal Tax On Tips[11]	Currency	DLR11_$S2	14
207	Federal_Tax_On_Tips_12	Federal Tax On Tips[12]	Currency	DLR11_$S2	14
208	FICASS_Tips_1	FICA/SS Tips[1]	Currency	DLR11_$S2	14
209	FICASS_Tips_2	FICA/SS Tips[2]	Currency	DLR11_$S2	14
210	FICASS_Tips_3	FICA/SS Tips[3]	Currency	DLR11_$S2	14
211	FICASS_Tips_4	FICA/SS Tips[4]	Currency	DLR11_$S2	14
212	FICASS_Tips_5	FICA/SS Tips[5]	Currency	DLR11_$S2	14
213	FICASS_Tips_6	FICA/SS Tips[6]	Currency	DLR11_$S2	14
214	FICASS_Tips_7	FICA/SS Tips[7]	Currency	DLR11_$S2	14
215	FICASS_Tips_8	FICA/SS Tips[8]	Currency	DLR11_$S2	14
216	FICASS_Tips_9	FICA/SS Tips[9]	Currency	DLR11_$S2	14
217	FICASS_Tips_10	FICA/SS Tips[10]	Currency	DLR11_$S2	14
218	FICASS_Tips_11	FICA/SS Tips[11]	Currency	DLR11_$S2	14
219	FICASS_Tips_12	FICA/SS Tips[12]	Currency	DLR11_$S2	14
220	FICASS_Tax_On_Tips_1	FICA/SS Tax On Tips[1]	Currency	DLR11_$S2	14
221	FICASS_Tax_On_Tips_2	FICA/SS Tax On Tips[2]	Currency	DLR11_$S2	14
222	FICASS_Tax_On_Tips_3	FICA/SS Tax On Tips[3]	Currency	DLR11_$S2	14
223	FICASS_Tax_On_Tips_4	FICA/SS Tax On Tips[4]	Currency	DLR11_$S2	14
224	FICASS_Tax_On_Tips_5	FICA/SS Tax On Tips[5]	Currency	DLR11_$S2	14
225	FICASS_Tax_On_Tips_6	FICA/SS Tax On Tips[6]	Currency	DLR11_$S2	14
226	FICASS_Tax_On_Tips_7	FICA/SS Tax On Tips[7]	Currency	DLR11_$S2	14
227	FICASS_Tax_On_Tips_8	FICA/SS Tax On Tips[8]	Currency	DLR11_$S2	14
228	FICASS_Tax_On_Tips_9	FICA/SS Tax On Tips[9]	Currency	DLR11_$S2	14
229	FICASS_Tax_On_Tips_10	FICA/SS Tax On Tips[10]	Currency	DLR11_$S2	14
230	FICASS_Tax_On_Tips_11	FICA/SS Tax On Tips[11]	Currency	DLR11_$S2	14
231	FICASS_Tax_On_Tips_12	FICA/SS Tax On Tips[12]	Currency	DLR11_$S2	14
232	Uncollected_FICASS_Tax_1	Uncollected FICA/SS Tax[1]	Currency	DLR11_$S2	14
233	Uncollected_FICASS_Tax_2	Uncollected FICA/SS Tax[2]	Currency	DLR11_$S2	14
234	Uncollected_FICASS_Tax_3	Uncollected FICA/SS Tax[3]	Currency	DLR11_$S2	14
235	Uncollected_FICASS_Tax_4	Uncollected FICA/SS Tax[4]	Currency	DLR11_$S2	14
236	Uncollected_FICASS_Tax_5	Uncollected FICA/SS Tax[5]	Currency	DLR11_$S2	14
237	Uncollected_FICASS_Tax_6	Uncollected FICA/SS Tax[6]	Currency	DLR11_$S2	14
238	Uncollected_FICASS_Tax_7	Uncollected FICA/SS Tax[7]	Currency	DLR11_$S2	14
239	Uncollected_FICASS_Tax_8	Uncollected FICA/SS Tax[8]	Currency	DLR11_$S2	14
240	Uncollected_FICASS_Tax_9	Uncollected FICA/SS Tax[9]	Currency	DLR11_$S2	14
241	Uncollected_FICASS_Tax_10	Uncollected FICA/SS Tax[10]	Currency	DLR11_$S2	14
242	Uncollected_FICASS_Tax_11	Uncollected FICA/SS Tax[11]	Currency	DLR11_$S2	14
243	Uncollected_FICASS_Tax_12	Uncollected FICA/SS Tax[12]	Currency	DLR11_$S2	14
244	FICAMed_Tips_1	FICA/Med Tips[1]	Currency	DLR11_$S2	14
245	FICAMed_Tips_2	FICA/Med Tips[2]	Currency	DLR11_$S2	14
246	FICAMed_Tips_3	FICA/Med Tips[3]	Currency	DLR11_$S2	14
247	FICAMed_Tips_4	FICA/Med Tips[4]	Currency	DLR11_$S2	14
248	FICAMed_Tips_5	FICA/Med Tips[5]	Currency	DLR11_$S2	14
249	FICAMed_Tips_6	FICA/Med Tips[6]	Currency	DLR11_$S2	14
250	FICAMed_Tips_7	FICA/Med Tips[7]	Currency	DLR11_$S2	14
251	FICAMed_Tips_8	FICA/Med Tips[8]	Currency	DLR11_$S2	14
252	FICAMed_Tips_9	FICA/Med Tips[9]	Currency	DLR11_$S2	14
253	FICAMed_Tips_10	FICA/Med Tips[10]	Currency	DLR11_$S2	14
254	FICAMed_Tips_11	FICA/Med Tips[11]	Currency	DLR11_$S2	14
255	FICAMed_Tips_12	FICA/Med Tips[12]	Currency	DLR11_$S2	14
256	FICAMed_Tax_On_Tips_1	FICA/Med Tax On Tips[1]	Currency	DLR11_$S2	14
257	FICAMed_Tax_On_Tips_2	FICA/Med Tax On Tips[2]	Currency	DLR11_$S2	14
258	FICAMed_Tax_On_Tips_3	FICA/Med Tax On Tips[3]	Currency	DLR11_$S2	14
259	FICAMed_Tax_On_Tips_4	FICA/Med Tax On Tips[4]	Currency	DLR11_$S2	14
260	FICAMed_Tax_On_Tips_5	FICA/Med Tax On Tips[5]	Currency	DLR11_$S2	14
261	FICAMed_Tax_On_Tips_6	FICA/Med Tax On Tips[6]	Currency	DLR11_$S2	14
262	FICAMed_Tax_On_Tips_7	FICA/Med Tax On Tips[7]	Currency	DLR11_$S2	14
263	FICAMed_Tax_On_Tips_8	FICA/Med Tax On Tips[8]	Currency	DLR11_$S2	14
264	FICAMed_Tax_On_Tips_9	FICA/Med Tax On Tips[9]	Currency	DLR11_$S2	14
265	FICAMed_Tax_On_Tips_10	FICA/Med Tax On Tips[10]	Currency	DLR11_$S2	14
266	FICAMed_Tax_On_Tips_11	FICA/Med Tax On Tips[11]	Currency	DLR11_$S2	14
267	FICAMed_Tax_On_Tips_12	FICA/Med Tax On Tips[12]	Currency	DLR11_$S2	14
268	Uncollected_FICAMed_Tax_1	Uncollected FICA/Med Tax[1]	Currency	DLR11_$S2	14
269	Uncollected_FICAMed_Tax_2	Uncollected FICA/Med Tax[2]	Currency	DLR11_$S2	14
270	Uncollected_FICAMed_Tax_3	Uncollected FICA/Med Tax[3]	Currency	DLR11_$S2	14
271	Uncollected_FICAMed_Tax_4	Uncollected FICA/Med Tax[4]	Currency	DLR11_$S2	14
272	Uncollected_FICAMed_Tax_5	Uncollected FICA/Med Tax[5]	Currency	DLR11_$S2	14
273	Uncollected_FICAMed_Tax_6	Uncollected FICA/Med Tax[6]	Currency	DLR11_$S2	14
274	Uncollected_FICAMed_Tax_7	Uncollected FICA/Med Tax[7]	Currency	DLR11_$S2	14
275	Uncollected_FICAMed_Tax_8	Uncollected FICA/Med Tax[8]	Currency	DLR11_$S2	14
276	Uncollected_FICAMed_Tax_9	Uncollected FICA/Med Tax[9]	Currency	DLR11_$S2	14
277	Uncollected_FICAMed_Tax_10	Uncollected FICA/Med Tax[10]	Currency	DLR11_$S2	14
278	Uncollected_FICAMed_Tax_11	Uncollected FICA/Med Tax[11]	Currency	DLR11_$S2	14
279	Uncollected_FICAMed_Tax_12	Uncollected FICA/Med Tax[12]	Currency	DLR11_$S2	14
280	Reported_Receipts12_1	Reported Receipts Array[1]	Currency	DLR11_$S2	14
281	Reported_Receipts12_2	Reported Receipts Array[2]	Currency	DLR11_$S2	14
282	Reported_Receipts12_3	Reported Receipts Array[3]	Currency	DLR11_$S2	14
283	Reported_Receipts12_4	Reported Receipts Array[4]	Currency	DLR11_$S2	14
284	Reported_Receipts12_5	Reported Receipts Array[5]	Currency	DLR11_$S2	14
285	Reported_Receipts12_6	Reported Receipts Array[6]	Currency	DLR11_$S2	14
286	Reported_Receipts12_7	Reported Receipts Array[7]	Currency	DLR11_$S2	14
287	Reported_Receipts12_8	Reported Receipts Array[8]	Currency	DLR11_$S2	14
288	Reported_Receipts12_9	Reported Receipts Array[9]	Currency	DLR11_$S2	14
289	Reported_Receipts12_10	Reported Receipts Array[10]	Currency	DLR11_$S2	14
290	Reported_Receipts12_11	Reported Receipts Array[11]	Currency	DLR11_$S2	14
291	Reported_Receipts12_12	Reported Receipts Array[12]	Currency	DLR11_$S2	14
292	Charged_Receipts12_1	Charged Receipts Array[1]	Currency	DLR11_$S2	14
293	Charged_Receipts12_2	Charged Receipts Array[2]	Currency	DLR11_$S2	14
294	Charged_Receipts12_3	Charged Receipts Array[3]	Currency	DLR11_$S2	14
295	Charged_Receipts12_4	Charged Receipts Array[4]	Currency	DLR11_$S2	14
296	Charged_Receipts12_5	Charged Receipts Array[5]	Currency	DLR11_$S2	14
297	Charged_Receipts12_6	Charged Receipts Array[6]	Currency	DLR11_$S2	14
298	Charged_Receipts12_7	Charged Receipts Array[7]	Currency	DLR11_$S2	14
299	Charged_Receipts12_8	Charged Receipts Array[8]	Currency	DLR11_$S2	14
300	Charged_Receipts12_9	Charged Receipts Array[9]	Currency	DLR11_$S2	14
301	Charged_Receipts12_10	Charged Receipts Array[10]	Currency	DLR11_$S2	14
302	Charged_Receipts12_11	Charged Receipts Array[11]	Currency	DLR11_$S2	14
303	Charged_Receipts12_12	Charged Receipts Array[12]	Currency	DLR11_$S2	14
304	Allocated_Tips_Array_1	Allocated Tips Array[1]	Currency	DLR11_$S2	14
305	Allocated_Tips_Array_2	Allocated Tips Array[2]	Currency	DLR11_$S2	14
306	Allocated_Tips_Array_3	Allocated Tips Array[3]	Currency	DLR11_$S2	14
307	Allocated_Tips_Array_4	Allocated Tips Array[4]	Currency	DLR11_$S2	14
308	Allocated_Tips_Array_5	Allocated Tips Array[5]	Currency	DLR11_$S2	14
309	Allocated_Tips_Array_6	Allocated Tips Array[6]	Currency	DLR11_$S2	14
310	Allocated_Tips_Array_7	Allocated Tips Array[7]	Currency	DLR11_$S2	14
311	Allocated_Tips_Array_8	Allocated Tips Array[8]	Currency	DLR11_$S2	14
312	Allocated_Tips_Array_9	Allocated Tips Array[9]	Currency	DLR11_$S2	14
313	Allocated_Tips_Array_10	Allocated Tips Array[10]	Currency	DLR11_$S2	14
314	Allocated_Tips_Array_11	Allocated Tips Array[11]	Currency	DLR11_$S2	14
315	Allocated_Tips_Array_12	Allocated Tips Array[12]	Currency	DLR11_$S2	14
316	EXMFRFED	Exempt From Federal	Boolean	CB_Exempt_From_Federal_Withholding	0
317	FDFLGSTS	Federal Filing Status	String	STR6_Payroll_Code	6
318	FEDEXMPT	Federal Exemptions	Integer	INT2_U0	2
319	ADFDWHDG	Additional Federal Withholding	Currency	DLR11_$S2	14
320	ESTFEDWH	Estimated Federal Withholding	Currency	DLR11_$U2	14
321	STATECD	State Code	String	STR2_State_Code	2
322	LOCALTAX	Local Tax	String	STR6_Payroll_Code	6
323	W2BF942E	W2 Box For 942 Employee	Boolean	CB_942_Employee	0
324	W2BFDCSD	W2 Box For Deceased	Boolean	CB_Deceased	0
325	W2BFDCMP	W2 Box For Deferred Compensation	Boolean	CB_Deferred_Compensation	0
326	W2BFLREP	W2 Box For Legal Representative	Boolean	CB_Legal_Representative	0
327	W2BFPPLN	W2 Box For Pension Plan	Boolean	CB_Pension_Plan	0
328	W2BFSTEM	W2 Box For Statutory Employee	Boolean	CB_Statutory_Employee	0
329	MCRQGEMP	Medicare Qualified Govt Employee	Boolean	CB_Medicare_Qualified_Govt_Employee	0
330	EICFLGST	EIC Filing Status	String	STR6_Payroll_Code	6
331	NYTXDiff	Withhold NY Tax Diff	Boolean	CB_Withhold_NY_Diff	0
332	ADRSCODE	Address Code	String	STR15_Address_Code	15
333	ALTERNATENAME	Alternate Name	String	STR20	20
334	BENADJDATE	Ben Adj Date	Date	DT	8
335	BENEFITEXPIRE_I	Benefit Expire	Date	DT	8
336	BIRTHDAY	Birth Day	Integer	INT	0
337	BIRTHMONTH	Birth Month	Integer	INT	0
338	CHANGEBY_I	Change By	String	STR15_User_ID	15
339	CHANGEDATE_I	Change Date	Date	DT	8
340	CITIZEN	Citizen	Boolean	CB_Citizen	0
341	DATEOFLASTREVIEW_I	Date Of Last Review	Date	DT	8
342	DATEOFNEXTREVIEW_I	Date Of Next Review	Date	DT	8
343	DISABLEDVETERAN	Disabled Veteran	Boolean	CB_DisableVet	0
344	DIVISIONCODE_I	Division Code	String	STR6_Payroll_Code	6
345	FEDCLSSCD	Federal Classification Code	String	STR10_LBAU	10
346	HANDICAPPED	Handicapped	Boolean	CB_Handicap	0
347	HRSTATUS	HR Status	Integer	DDL_HRStatus	0
348	I9RENEW	I9renew	Date	DT	8
349	LASTDAYWORKED_I	Last Day Worked	Date	DT	8
350	LOCATNID	Location ID	String	STR15_Location_ID	15
351	MARITALSTATUS	MaritalStatus	Integer	DDL_MaritalStatus	0
352	NICKNAME	NickName	String	STR20	20
353	NOTEINDX2	Note Index2	Currency	DLR14	14
354	Primary_Pay_Record	Primary Pay Record	String	STR6_Payroll_Code	6
355	RATECLSS	Rate Class	String	STR15	15
356	SMOKER_I	Smoker	Boolean	CB_Smoker	0
357	SPOUSE	Spouse	String	STR15	15
358	SPOUSESSN	Spouse SSN	String	STR15_Social_Security_Number	15
359	SUPERVISORCODE_I	Supervisor Code	String	STR6_U	6
360	EMPLOYMENTTYPE	Type of Employment	Integer	DDL_Employment_Type	0
361	UNIONCD	Union Code	String	STR6	6
362	UNIONEMPLOYEE	Union Employee	Boolean	CB_Union_Emp	0
363	VERIFIED	Verified	Boolean	CB_Verifed	0
364	VETERAN	Veteran	Boolean	CB_Military	0
365	VIETNAMVETERAN	Vietnam Veteran	Boolean	CB_Vietnam	0
366	OTHERVET	Other Veterans	Boolean	CB_OtherVet	0
367	WRNSTFLSBLWZR	Warn Sick Time Falls Below Zero	Boolean	CB_WarnSickTimeFallsBelowZero	0
368	WRNVCNFLSBLWZR	Warn Vacation Falls Below Zero	Boolean	CB_WarnVacationFallsBelowZero	0
369	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
370	ASI_Order_By	ASI_Order_By	Long Integer	LI_14	14
371	ASI_Document_Status	ASI_Document_Status	Integer	INT	0

azurecurve Products SmartList (1493)PathnameSmartList Payroll Employee Summary (ASIEXP32)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply