

----------------------------------------Adding label Asset Master & Asset Sparelist-----------------------------------------------------------------------------------------

--Step 01 adding column From Date
DELETE	cf_label
WHERE	table_name = 'ast_det'
AND 	column_name = 'ast_det_from_Date'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'ast_det', 'ast_det_from_date', 
		'From Date:', 
		'From Date:', 
		'From Date', 
		'From Date', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

--Step 02 adding column To Date
DELETE	cf_label
WHERE	table_name = 'ast_det'
AND 	column_name = 'ast_det_to_Date'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'ast_det', 'ast_det_to_date', 
		'To Date:', 
		'To Date:', 
		'To Date', 
		'To Date', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


--Step 03 adding column Total OH
DELETE	cf_label
WHERE	table_name = 'ast_ls1'
AND 	column_name = 'ast_ls1_ttl_oh'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'ast_ls1', 'ast_ls1_ttl_oh', 
		'Total OH:', 
		'Total OH:', 
		'Total OH', 
		'Total OH', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

------------------------------------------------------Adding label Work Request-----------------------------------------------------------------------------------------------------

--Step 04 adding column From Date
DELETE	cf_label
WHERE	table_name = 'wkr_det'
AND 	column_name = 'wkr_det_from_Date'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'wkr_det', 'wkr_det_from_date', 
		'From Date:', 
		'From Date:', 
		'From Date', 
		'From Date', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

--Step 05 adding column To Date
DELETE	cf_label
WHERE	table_name = 'wkr_det'
AND 	column_name = 'wkr_det_to_Date'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'wkr_det', 'wkr_det_to_date', 
		'To Date:', 
		'To Date:', 
		'To Date', 
		'To Date', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


--Step 06 adding column Due Time
DELETE	cf_label
WHERE	table_name = 'wkr_mst'
AND 	column_name = 'wkr_mst_due_time'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'wkr_mst', 'wkr_mst_due_time', 
		'Due Time:', 
		'Due Time:', 
		'Due Time', 
		'Due Time', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

------------------------------------------------------Adding label Work Order-----------------------------------------------------------------------------------------------------

--Step 07 adding column From Date
DELETE	cf_label
WHERE	table_name = 'wko_det'
AND 	column_name = 'wko_det_from_Date'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'wko_det', 'wko_det_from_date', 
		'From Date:', 
		'From Date:', 
		'From Date', 
		'From Date', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

--Step 08 adding column To Date
DELETE	cf_label
WHERE	table_name = 'wko_det'
AND 	column_name = 'wko_det_to_Date'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'wko_det', 'wko_det_to_date', 
		'To Date:', 
		'To Date:', 
		'To Date', 
		'To Date', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


--Step 09 adding column Org Time
DELETE	cf_label
WHERE	table_name = 'wko_mst'
AND 	column_name = 'wko_mst_org_time'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'wko_mst', 'wko_mst_org_time', 
		'Origination Time:', 
		'Origination Time:', 
		'Origination Time', 
		'Origination Time:', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


--Step 10 adding column Due Time
DELETE	cf_label
WHERE	table_name = 'wko_mst'
AND 	column_name = 'wko_mst_due_time'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'wko_mst', 'wko_mst_due_time', 
		'Due Time:', 
		'Due Time:', 
		'Due Time', 
		'Due Time', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO