JC_Union_Trx_OPEN_Summary_VIEW (JC92601)

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

Display Name: JC_Union_Trx_OPEN_Summary_VIEW
Physical Name: JC92601
Technical Name: JC_Union_Trx_OPEN_Summary_VIEW

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	UNIONCD	Union Code	STR6	String	6
2	RATECLSS	Rate Class	STR15	String	15
3	EMPLOYID	Employee ID	STR15_Employee_ID	String	15
4	JOBTITLE	Job Title	STR6_Payroll_Code	String	6
5	UPRTRXCD	UPR TRX Code	STR6_Payroll_Code	String	6
6	TRXBEGDT	TRX Beginning Date	DT	Date	8
7	TRXENDDT	TRX Ending Date	DT	Date	8
8	PAYRTAMT	Pay Rate Amount	DLR11_$S2	Currency	14
9	TRXHRUNT	TRX Hours/Units	LI6_S2	Long Integer	6
10	VARDBAMT	Variable Ded/Ben Amount	DLR11_$S2	Currency	14
11	Payroll_Pay_Type	Payroll Pay Type	INT2_U0	Integer	2