20240906070211am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW102643',		
						wko_ls8_empl_id='ADMIN : Admin',		
						wko_ls8_craft='HSK  : Housekeeping',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs=0.00,			
						wko_ls8_rate=2.0000,			
						wko_ls8_multiplier=2.0000,		
						wko_ls8_adder=0.0000,			
						wko_ls8_act_cost=0.0000,		  
						wko_ls8_chg_costcenter='0070.ADMIN', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-06 14:07',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 42000
code: 2628
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated in table 'cmms_sunway_1011.dbo.wko_ls8', column 'wko_ls8_hours_type'. Truncated value: 'D '.

20240906070211am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW102643',		
						wko_ls8_empl_id='ADMIN : Admin',		
						wko_ls8_craft='HSK  : Housekeeping',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs=0.00,			
						wko_ls8_rate=2.0000,			
						wko_ls8_multiplier=2.0000,		
						wko_ls8_adder=0.0000,			
						wko_ls8_act_cost=0.0000,		  
						wko_ls8_chg_costcenter='0070.ADMIN', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-06 14:07',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 01000
code: 3621
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.

20240910082705am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 42000
code: 2628
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated in table 'cmms_sunway_1011.dbo.wko_ls8', column 'wko_ls8_empl_id'. Truncated value: '074534 : Arman Shahrin Yu'.

20240910082705am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 01000
code: 3621
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.

20240910082956am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 42000
code: 2628
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated in table 'cmms_sunway_1011.dbo.wko_ls8', column 'wko_ls8_empl_id'. Truncated value: '074534 : Arman Shahrin Yu'.

20240910082956am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 01000
code: 3621
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.

20240910083008am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 42000
code: 2628
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated in table 'cmms_sunway_1011.dbo.wko_ls8', column 'wko_ls8_empl_id'. Truncated value: '074534 : Arman Shahrin Yu'.

20240910083008am
UPDATE wko_ls8 WITH (UPDLOCK) SET
							
						wko_ls8_assetno ='MSW100931',		
						wko_ls8_empl_id='074534 : Arman Shahrin Yusuf',		
						wko_ls8_craft='ADM  : Administration',			
						wko_ls8_hours_type='D : DOUBLE TIME',		
						wko_ls8_hrs='0.00',			
						wko_ls8_rate='0.0000',			
						wko_ls8_multiplier='2.0000',		
						wko_ls8_adder='0.0000',			
						wko_ls8_act_cost='0.0000',		  
						wko_ls8_chg_costcenter='TNTS', 
						wko_ls8_chg_account='',	
						wko_ls8_datetime1='2024-09-10 16:11',		
						wko_ls8_datetime2=Null,
						wko_ls8_time_card_no ='',
						mbl_audit_user = 'ADMIN', 
						mbl_audit_date = GetDate () 
						WHERE 	site_cd = ? 
						AND 	Rowid = ? ;	
SQLSTATE: 01000
code: 3621
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated.

20240911065737am
INSERT wko_ls8 
				
					(	site_cd ,					mst_RowID,					wko_ls8_assetno,				wko_ls8_empl_id,				
						wko_ls8_craft,				wko_ls8_hours_type ,		wko_ls8_hrs ,					wko_ls8_rate ,
						wko_ls8_multiplier ,		wko_ls8_adder ,				wko_ls8_act_cost ,				wko_ls8_chg_costcenter ,
						wko_ls8_chg_account ,		wko_ls8_crd_costcenter ,	wko_ls8_crd_account ,			wko_ls8_time_card_no ,
						wko_ls8_datetime1 ,			audit_user ,				audit_date ,					wko_ls8_datetime2,
						mbl_audit_user,				mbl_audit_date) 
						
			VALUES 	(	'MSW',				'602709',			'MSW100931',					'000485',		
						'ADM ',				'PL',			0.00,				0.00,							
						1.00,			0.00,					,				'TNTS',						
						'',			Null,						Null,							'',	
						'2024-09-11 14:57',			'000485',			'2024-09-11 14:57',				Null,
						'ADMIN',				'2024-09-11 14:57')
SQLSTATE: 42000
code: 102
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ','.

20240924102251am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES ('MSW',				'TM141441',		'2024-09-24 18:22',			'000485',			'BWK',				
			'D',			0.05,			5.00,					2.00,			0.00,				
			0.50,				'P112132',		'MSW-1010103',				'TNTS',		'',		
			NULL,						NULL,						'P',						'000485',			GetDate(),					
			'000485',			GetDate(),					'ADMIN',				GetDate(),					'2024-09-24 18:22',
			'2024-09-24 18:25',)
SQLSTATE: 42000
code: 102
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.

20240924102340am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES ('MSW',				'TM141442',		'2024-09-24 18:23',			'SEKHAR_EMP',			'BWK ',				
			'D',			2.45,			0.00,					2.00,			0.00,				
			0.00,				'C140147',		'MSW102625',				'0070.0083',		'',		
			NULL,						NULL,						'P',						'SEKHAR_EMP',			GetDate(),					
			'SEKHAR_EMP',			GetDate(),					'SEKHAR_LOG',				GetDate(),					'2024-09-24 18:23',
			'2024-09-24 20:50',)
SQLSTATE: 42000
code: 102
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.

20240924102503am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES ('MSW',				'TM141443',		'2024-09-24 18:23',			'SEKHAR_EMP',			'BWK ',				
			'D',			2.45,			0.00,					2.00,			0.00,				
			0.00,				'C140147',		'MSW102625',				'0070.0083',		'',		
			NULL,						NULL,						'P',						'SEKHAR_EMP',			GetDate(),					
			'SEKHAR_EMP',			GetDate(),					'SEKHAR_LOG',				GetDate(),					'2024-09-24 18:23',
			'2024-09-24 20:50',)
SQLSTATE: 42000
code: 102
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.

20240924102540am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES ('MSW',				'TM141444',		'2024-09-24 18:23',			'SEKHAR_EMP',			'BWK ',				
			'D',			2.45,			0.00,					2.00,			0.00,				
			0.00,				'C140147',		'MSW102625',				'0070.0083',		'',		
			NULL,						NULL,						'P',						'SEKHAR_EMP',			GetDate(),					
			'SEKHAR_EMP',			GetDate(),					'SEKHAR_LOG',				GetDate(),					'2024-09-24 18:23',
			'2024-09-24 20:50',)
SQLSTATE: 42000
code: 102
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.