20250725080300am
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 ('CPI',				'TM100295',		'2025-07-25 13:00',			'IZZAT',			'MG3 ',				
			'N',			3.03,			NaN,					1.00,			0.00,				
			NaN,				'CWO100464',		'AST100125',				'DAIKIN1001',		'',		
			NULL,						NULL,						'P',						'IZZAT',			GetDate(),					
			'IZZAT',			GetDate(),					'IZZAT',				GetDate(),					'2025-07-25 13:00',
			'2025-07-25 16:02')
SQLSTATE: 42S22
code: 207
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'NaN'.

20250725080300am
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 ('CPI',				'TM100295',		'2025-07-25 13:00',			'IZZAT',			'MG3 ',				
			'N',			3.03,			NaN,					1.00,			0.00,				
			NaN,				'CWO100464',		'AST100125',				'DAIKIN1001',		'',		
			NULL,						NULL,						'P',						'IZZAT',			GetDate(),					
			'IZZAT',			GetDate(),					'IZZAT',				GetDate(),					'2025-07-25 13:00',
			'2025-07-25 16:02')
SQLSTATE: 42S22
code: 207
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'NaN'.

20250725080303am
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 ('CPI',				'TM100296',		'2025-07-25 13:00',			'IZZAT',			'MG3 ',				
			'N',			3.03,			NaN,					1.00,			0.00,				
			NaN,				'CWO100464',		'AST100125',				'DAIKIN1001',		'',		
			NULL,						NULL,						'P',						'IZZAT',			GetDate(),					
			'IZZAT',			GetDate(),					'IZZAT',				GetDate(),					'2025-07-25 13:00',
			'2025-07-25 16:02')
SQLSTATE: 42S22
code: 207
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'NaN'.

20250725080303am
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 ('CPI',				'TM100296',		'2025-07-25 13:00',			'IZZAT',			'MG3 ',				
			'N',			3.03,			NaN,					1.00,			0.00,				
			NaN,				'CWO100464',		'AST100125',				'DAIKIN1001',		'',		
			NULL,						NULL,						'P',						'IZZAT',			GetDate(),					
			'IZZAT',			GetDate(),					'IZZAT',				GetDate(),					'2025-07-25 13:00',
			'2025-07-25 16:02')
SQLSTATE: 42S22
code: 207
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'NaN'.

20250725080306am
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 ('CPI',				'TM100297',		'2025-07-25 13:00',			'IZZAT',			'MG3 ',				
			'N',			3.05,			NaN,					1.00,			0.00,				
			NaN,				'CWO100464',		'AST100125',				'DAIKIN1001',		'',		
			NULL,						NULL,						'P',						'IZZAT',			GetDate(),					
			'IZZAT',			GetDate(),					'IZZAT',				GetDate(),					'2025-07-25 13:00',
			'2025-07-25 16:03')
SQLSTATE: 42S22
code: 207
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'NaN'.

20250725080306am
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 ('CPI',				'TM100297',		'2025-07-25 13:00',			'IZZAT',			'MG3 ',				
			'N',			3.05,			NaN,					1.00,			0.00,				
			NaN,				'CWO100464',		'AST100125',				'DAIKIN1001',		'',		
			NULL,						NULL,						'P',						'IZZAT',			GetDate(),					
			'IZZAT',			GetDate(),					'IZZAT',				GetDate(),					'2025-07-25 13:00',
			'2025-07-25 16:03')
SQLSTATE: 42S22
code: 207
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'NaN'.