Maintenance Tables for mWorkOrder

List of tables available for mWorkOrder.

Environment Table Name Usage
Gateway /INVMWO/SCRCONFI To maintain Screens/Tabs to display in Work Order and Notifications details.
ECC /INVMWO/DOCTYPES To maintain Document types for Work Order and Notifications.
ECC /INVMWO/EMGDOC To maintain Document types for Emergency Work Order creation.
Gateway /INVCEC/SOURCTYP To maintain Source types for getting drop down values in RACE extension source type field.
Gateway /INVCEC/STORETYP

To maintain store types to display DBs progressing bars, while syncing data to application.

Note: Without maintaining these store types configuration, sync cannot be processed.

Gateway /INVCEC/SYSTEMS To maintain system destinations for connection between Gateway and ECC.
Gateway /INVCEC/SCHEMA

To maintain Schema to overcome backward slash issue with SMP 3.0 SP16 library.

Note: To Maintain Schema configuration, application names should be defined in the RACE at prior.

ECC /INVMWO/FCHEADER

To maintain Functional Location data staging table to fetch data into application.

Note: To fill data into Functional Location Staging tables, please use program '/INVMWO/FM_FL_EXPAND_STG'.

ECC /INVMWO/EQ_HEADR

To maintain Equipment data staging table to fetch data into application.

Note: To fill data into Equipment Staging tables, please use program '/INVMWO/FM_EQ_EXPAND_STG'.

Gateway /INVCEC/FILTERS To configure IDs, to get dropdown values for static filters (Like to Configure WOOPRA to apply filter for operation requirement assignment tab).
ECC /INVMWO/TASK_RCS To maintain Task Skip Reason codes while executing rounds.
ECC /INVMWO/SCAN_RCS To maintain Asset scan skip Reason codes while executing rounds.
ECC /INVMWO/PRICOLOU To maintain color codes for objects based on Priority value.
ECC /INVMWO/OBJ_STAT To maintain Filters for WOs and NOs based on System Status and User Status combination.
Gateway /INVCEC/CTRLTYPK