JC_Monthly_Union_Report_TEMP (JCUNION1)

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: JC_Monthly_Union_Report_TEMP
Physical Name: JCUNION1
Technical Name: JC_Monthly_Union_Report_TEMP

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	UNIONCD	Union Code	STR6	String	6
2	LNSEQNBR	Line SEQ Number	Sequence_Number	Currency	19
3	Union_Sort_Code	Union Sort Code	INT2	Integer	2
4	EMPLOYID	Employee ID	STR15_Employee_ID	String	15
5	RATECLSS	Rate Class	STR15	String	15
6	WS_Benefit_Ded_Name	WS Benefit Deduction Name	STR15	String	15
7	Payroll_Pay_Type	Payroll Pay Type	INT2_U0	Integer	2
8	TTLHOURS	Total Hours	LI6_S2	Long Integer	6
9	REGHOURS	Regular Hours	LI6_S2	Long Integer	6
10	OVRTMHRS	Overtime Hours	LI6_S2	Long Integer	6
11	DBLTMHRS	Double Time Hours	LI6_S2	Long Integer	6
12	GROSWAGS_1	Gross Wages[1]	DLR11_$S2	Currency	14
13	GROSWAGS_2	Gross Wages[2]	DLR11_$S2	Currency	14
14	GROSWAGS_3	Gross Wages[3]	DLR11_$S2	Currency	14
15	GROSWAGS_4	Gross Wages[4]	DLR11_$S2	Currency	14
16	GROSWAGS_5	Gross Wages[5]	DLR11_$S2	Currency	14
17	GROSWAGS_6	Gross Wages[6]	DLR11_$S2	Currency	14
18	GROSWAGS_7	Gross Wages[7]	DLR11_$S2	Currency	14
19	GROSWAGS_8	Gross Wages[8]	DLR11_$S2	Currency	14
20	GROSWAGS_9	Gross Wages[9]	DLR11_$S2	Currency	14
21	GROSWAGS_10	Gross Wages[10]	DLR11_$S2	Currency	14
22	GROSWAGS_11	Gross Wages[11]	DLR11_$S2	Currency	14
23	GROSWAGS_12	Gross Wages[12]	DLR11_$S2	Currency	14
24	STRGA255	String A 255	STR255	String	255
25	STRGB255	String B 255	STR255	String	255