8200-LINKSOFT Upgrade to 8300.sql

Invalid object name 'LT_REPL_CONTROL_OUT'.

DELETE FROM LT_SYS_Reports WHERE ReportName = '660-4-05-POSJIWAReconcilationByPeriod.rpt'
DELETE FROM LT_SYS_Reports WHERE ReportName = '660-4-06-POSJIWACostOfGoodsSold.rpt'
DELETE FROM LT_SYS_Reports WHERE Menu_CODE = 'PS152'
DELETE FROM LT_SYS_Reports WHERE Menu_CODE = 'PS151'

DELETE FROM LT_SYS_Reports WHERE ReportName = '332-6-1-PR_GLIntegrationCustomFICAC.rpt'
DELETE FROM LT_SYS_Reports WHERE ReportName = '332-6-1-PR_GLIntegrationEpicorFNPF.rpt'
DELETE FROM LT_SYS_Reports WHERE ReportName = '332-6-1-PR_GLIntegrationHA.rpt'
DELETE FROM LT_SYS_Reports WHERE ReportName = '344-12-PayCodeSummaryReportHA.rpt'
DELETE FROM LT_SYS_Reports WHERE ReportName = '332-6-1-PR_GLIntegrationEpicor9.rpt'
DELETE FROM LT_SYS_Processes where Description = 'ESS Leave Forfeit for ALIEU greater than 12 months'
DELETE FROM LT_ESS_TimesheetImport_Rules WHERE Description IN ('Overtime for working 6 consecutive days','Overtime for working 7 consecutive days','Overtime for working without 10 hours break') AND RuleCode IS NULL

DELETE FROM LT_SYS_Processes where ProcessCode = 'ESS006'
DELETE FROM LT_SYS_Processes where ProcessCode = 'ESS007'
DELETE FROM LT_SYS_ProcessRules where RuleCode = 'FMIS.ServerName'
DELETE FROM LT_SYS_ProcessRules where RuleCode = 'FMIS.DatabaseName'
DELETE FROM LT_SYS_ProcessRules where RuleCode = 'FMIS.LOCATION'
DELETE FROM LT_SYS_ProcessRules where RuleCode = 'FMIS.SYSTEM'
DELETE FROM LT_SYS_ProcessRules where RuleCode = 'JIWA.AutomaticBilling.PartNo'
DELETE FROM LT_REPL_RULE where RuleCode = 'R1090'
DELETE FROM LT_SYS_Processes WHERE ProcessCode = 'POS002'
DELETE FROM LT_SYS_ProcessRules where RuleCode = 'POS011-01'
DELETE FROM LT_SYS_ProcessRules where RuleCode = 'POS011-02'

DELETE FROM LT_SYS_RoleMenuAccess where MENU_CODE NOT IN (SELECT MENU_CODE FROM LT_SYS_Menu)