Table of Contents

AddWMSystemOptionsForAutoCalculateEstimatedDowntimesMigration

Database Schema Description
Transaction wm Add system options for auto calculation of estimated downtimes and durations

SQL Statements

ALTER TABLE wm.module_option 
                                    ADD COLUMN auto_calculate_estimated_downtime_for_scheduled_work_orders bool NOT NULL DEFAULT true,
                    ADD COLUMN auto_calculate_estimated_downtime_for_manual_work_orders bool NOT NULL DEFAULT true,
                    ADD COLUMN auto_calculate_estimated_downtime_for_follow_up_work_orders bool NOT NULL DEFAULT true,
                    ADD COLUMN auto_calculate_estimated_duration_for_scheduled_work_orders bool NOT NULL DEFAULT true,
                    ADD COLUMN auto_calculate_estimated_duration_for_manual_work_orders bool NOT NULL DEFAULT true,
                    ADD COLUMN auto_calculate_estimated_duration_for_follow_up_work_orders bool NOT NULL DEFAULT true;