JC_Union_Monthly_Payroll_TEMP (JCUPAY1)

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

Display Name: JC_Union_Monthly_Payroll_TEMP
Physical Name: JCUPAY1
Technical Name: JC_Union_Monthly_Payroll_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	EMPLOYID	Employee ID	STR15_Employee_ID	String	15
4	SOCSCNUM	Social Security Number	STR15_Social_Security_Number	String	15
5	FRSTNAME	First Name	STR15	String	15
6	LASTNAME	Last Name	STR20	String	20
7	WS_Benefit_Ded_Name	WS Benefit Deduction Name	STR15	String	15
8	Payroll_Pay_Type	Payroll Pay Type	INT2_U0	Integer	2
9	REGHOURS	Regular Hours	LI6_S2	Long Integer	6
10	REGERNGS	Regular Earnings	DLR11_$S2	Currency	14
11	OVRTMHRS	Overtime Hours	LI6_S2	Long Integer	6
12	OVTMEARN	Overtime Earnings	DLR11_$S2	Currency	14
13	DBLTMHRS	Double Time Hours	LI6_S2	Long Integer	6
14	DBLTMERN	Double Time Earnings	DLR11_$S2	Currency	14
15	TTLHOURS	Total Hours	LI6_S2	Long Integer	6
16	TTLERNGS	Total Earnings	DLR11_$S2	Currency	14