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 |