Entity | Initial Process Flow | Incremental Process Flow | Error Table |
---|---|---|---|
Organization | MTH_PLANTS_DIM_EBS_INIT_PF | MTH_PLANTS_DIM_EBS_INCR_PF | N/A |
Production Schedule | MTH_WO_EBS_INIT_PF | MTH_WO_EBS_INCR_PF | MTH_PRODUCTION_SCHEDULES_ERR |
Material Produced | MTH_WO_EBS_INIT_PF | MTH_WO_EBS_INCR_PF | MTH_PROD_MTL_PRODUCED_ERR |
Equipment Shifts | MTH_EQUIP_SHIFTS_EBS_INIT_PF | MTH_EQUIP_SHIFTS_EBS_INCR_PF | MTH_EQUIPMENT_SHIFTS_ERR |
Equipment Entities | MTH_EQUIP_ENT_EBS_INIT_PF | MTH_EQUIP_ENT_EBS_INCR_PF | MTH_EQUIP_ENTITIES_ERR |
Item | MTH_ITEMS_DIM_EBS_INIT_PF | MTH_ITEMS_DIM_EBS_INCR_PF | MTH_ITEMS_ERR |
Item Cost | MTH_ITEM_COST_EBS_INIT_PF | MTH_ITEM_COST_EBS_INCR_PF | MTH_ITEM_COST_ERR |
Item Category | MTH_ITEM_HRCHY_EBS_INIT_PF | MTH_ITEM_HRCHY_EBS_INCR_PF | N/A |
Resource | MTH_RES_DIM_EBS_INIT_PF | MTH_RES_DIM_EBS_INCR_PF | MTH_RESOURCES_ERR |
Resource Cost | MTH_RES_COST_EBS_INIT_PF | MTH_RES_COST_EBS_INCR_PF | MTH_RESURCE_COST_ERR |
Workday Shifts | MTH_WORKDAY_SHIFTS_EBS_INIT_PF | MTH_WORKDAY_SHIFTS_EBS_INCR_PF | MTH_WORKDAY_SHIFTS_ERR |
Sales Orders | MTH_WO_SALES_ORDERS_EBS_INIT_PF | MTH_WO_SALES_ORDERS_EBS_INCR_PF | MTH_WO_SALES_ORDERS_ERR |
For data collected by .CSV templates:
Entity | CSV File | XS Mapping | Initial PF | Incremental PF | Error Table |
System | MTH_SYSTEMS_SETUP.csv | MTH_SYSTEMS_SETUP_XS_ALL_MAP | N/A | N/A | N/A |
Organization | MTH_ORG.csv | MTH_ORG_XS_ALL_MAP&MTH_PLANTS_ORG_ALL_MAP | N/A | N/A | N/A |
Workday Shifts | MTH_WORKDAY_SHIFTS.csv | MTH_WORKDAY_SHIFTS_XS_ALL_MAP | MTH_WORKDAY_SHIFTS_EXT_INIT_PF | MTH_WORKDAY_SHIFTS_EXT_INCR_PF | MTH_WORKDAY_SHIFTS_ERR |
Item Master | MTH_ITEMS_MASTER.csv | MTH_ITEM_MASTER_XS_ALL_MAP | MTH_ITEMS_DIM_EXT_INIT_PF | MTH_ITEMS_DIM_EXT_INCR_PF | MTH_ITEMS_ERR |
Item Categories | MTH_ITEM_CATEGORY.csv | MTH_ITEM_CATEGORIES_XS_MAP | MTH_CAT_DIM_EXT_INIT_PF | MTH_CAT_DIM_EXT_INCR_PF | N/A |
Item Hierarchy | MTH_ITEM_HIERARCHY.csv | MTH_ITEM_HIERARCHY_XS_MAP | MTH_ITEM_HRCHY_EXT_INIT_PF | MTH_ITEM_HRCHY_EXT_INCR_PF | MTH_ITEM_HIERARCHY_ERR |
Item Cost | MTH_ITEM_COST.csv | MTH_ITEM_COST_XS_MAP | MTH_ITEM_COST_EXT_INIT_PF | MTH_ITEM_COST_EXT_INCR_PF | MTH_ITEM_COST_ERR |
Equipment Entities | MTH_ENTITY_MASTER.csv | MTH_EQUIP_ENT_XS_ALL_MAP | MTH_EQUIP_ENT_EXT_INIT_PF | MTH_EQUIP_ENT_EXT_INCR_PF | MTH_EQUIP_ENTITIES_ERR |
Equipment Master | MTH_EQUIP_MASTER.csv | MTH_EQUIP_XS_ALL_MAP | MTH_EQUIP_DIM_EXT_INIT_PF | MTH_EQUIP_DIM_EXT_INCR_PF | MTH_EQUIPMENTS_ERR |
Equipment Hierarchy | MTH_EQUIP_HRCHY_DEF.csv | MTH_EQUIP_HRCHY_XS_ALL_MAP | MTH_EQUIP_HRCHY_EXT_INIT_PF | MTH_EQUIP_HRCHY_EXT_INCR_PF | MTH_EQUIP_HIERARCHY_ERR |
Equipment Standard Rates | MTH_EQUIP_STANDARD_RATES.csv | MTH_EQUIP_STD_RATES_XS_ALL_MAP | MTH_EQUIP_STD_RATE_EXT_INIT_PF | MTH_EQUIP_STD_RATE_EXT_INCR_PF | MTH_EQUIP_STANDARD_RATES_ERR |
Equipment Production Schedule | MTH_EQUIP_PROD_SCHEDULE.csv | MTH_EQUIP_PROD_SCHD_XS_ALL_MAP | MTH_EQUIP_PRD_SCHD_EXT_INIT_PF | MTH_EQUIP_PRD_SCHD_EXT_INCR_PF | MTH_EQUIP_PROD_SCHEDULE_ERR |
Planned Usage | MTH_ENTITY_PLANNED_USAGE.csv | MTH_ENT_PLANNED_USG_XS_MAP | MTH_PLANNED_USG_EXT_INIT_PF | MTH_PLANNED_USG_EXT_INCR_PF | MTH_ENTITY_PLANNED_USAGE_ERR |
Asset | MTH_ASSET_MASTER.csv | MTH_ASSET_XS_MAP | MTH_ASSET_EXT_INIT_PF | MTH_ASSET_EXT_INCR_PF | MTH_ASSET_ERR |
Resource | MTH_RESOURCES.csv | MTH_RESOURCE_XS_ALL_MAP | MTH_RES_DIM_EXT_INIT_PF | MTH_RES_DIM_EXT_INCR_PF | MTH_RESOURCES_ERR |
Resource Cost | MTH_RESOURCE_COST.csv | MTH_RESOURCE_COST_XS_ALL_MAP | MTH_RES_COST_EXT_INIT_PF | MTH_RES_COST_EXT_INCR_PF | MTH_RESOURCE_COST_ERR |
Production Schedule | MTH_PROD_SCHEDULES.csv | MTH_WO_XS_ALL_MAP | MTH_WO_EXT_INIT_PF | MTH_WO_EXT_INCR_PF | MTH_PRODUCTION_SCHEDULES_ERR |
Material Produced | MTH_PROD_MTL_PRODUCED.csv | MTH_WO_ITEMS_XS_ALL_MAP | MTH_WO_ITEMS_EXT_INIT_PF | MTH_WO_ITEMS_EXT_INCR_PF | MTH_PROD_MTL_PRODUCED_ERR |
Material Produced Transactions | MTH_MTL_PRODUCED_TXN.csv | MTH_MTL_PRD_TXN_XS_ALL_MAP | MTH_MTL_PRD_TXN_EXT_INIT_PF | MTH_MTL_PRD_TXN_EXT_INCR_PF | MTH_PROD_MTL_PRODUCED_TXN_ERR |
Produced Transaction Lots | MTH_MTL_PRODUCED_TXN_LOT.csv | MTH_MTL_PRD_TXN_LOT_XS_ALL_MAP | MTH_MTL_PRD_TX_LOT_EXT_INIT_PF | MTH_MTL_PRD_TX_LOT_EXT_INCR_PF | MTH_MTL_PRODUCED_TXN_LOT_ERR |
Production Segments | MTH_PROD_SEGMENTS.csv | MTH_PROD_SEGMENTS_XS_ALL_MAP | MTH_PROD_SEG_EXT_INIT_PF | MTH_PROD_SEG_EXT_INCR_PF | MTH_PRODUCTION_SEGMENTS_ERR |
Production Sub Segments | MTH_PROD_SUB_SEGMENTS.csv | MTH_PROD_SUB_SEG_XS_OPM_MAP | MTH_PROD_SUB_SEG_EXT_INIT_PF | MTH_PROD_SUB_SEG_EXT_INCR_PF | MTH_PROD_SUB_SEGMENTS_ERR |
Production Segment Transactions | MTH_PROD_SEGMENTS_TXN.csv | MTH_PROD_SEG_TXN_XS_ALL_MAP | MTH_WO_SEG_EXT_INIT_PF | MTH_WO_SEG_EXT_INCR_PF | MTH_PROD_SEGMENTS_TXN_ERR |
Material Consumed | MTH_MTL_CONSUMED.csv | MTH_MTL_CNS_XS_ALL_MAP | MTH_MTL_CMD_EXT_INIT_PF | MTH_MTL_CMD_EXT_INCR_PF | MTH_PROD_MTL_CONSUMED_ERR |
Consumed Transactions | MTH_MTL_CONSUMED_TXN.csv | MTH_MTL_CNS_TXN_XS_ALL_MAP | MTH_MTL_CMD_TXN_EXT_INIT_PF | MTH_MTL_CMD_TXN_EXT_INCR_PF | MTH_PROD_MTL_CONSUMED_TXN_ERR |
Consumed Transaction Lots | MTH_MTL_CONSUMED_TXN_LOT.csv | MTH_MTL_CNS_TXN_LOT_XS_ALL_MAP | MTH_MTL_CMD_TX_LOT_EXT_INIT_PF | MTH_MTL_CMD_TX_LOT_EXT_INCR_PF | MTH_MTL_CONSUMED_TXN_LOT_ERR |
Tag Data Source | MTH_TAG_DATA_SOURCES.csv | MTH_TAG_DATA_SRCS_XS_ALL_MAP | MTH_TAG_DATA_SRCS_EXT_INIT_PF | MTH_TAG_DATA_SRCS_EXT_INCR_PF | MTH_TAG_DATA_SOURCES_ERR |
Tag Master | MTH_TAG_MASTER_UI.csv | MTH_TAG_MASTER_XS_MAP | MTH_TAG_MASTER_EXT_INIT_PF | MTH_TAG_MASTER_EXT_INCR_PF | MTH_TAG_MASTER_ERR |
Resource Requirement | MTH_RES_REQ.csv | MTH_RES_REQ_XS_ALL_MAP | MTH_RES_REQ_EXT_INIT_PF | MTH_RES_REQ_EXT_INCR_PF | MTH_RESOURCE_REQUIREMENTS_ERR |
Resource Transactions | MTH_RES_TXN.csv | MTH_RES_TXN_XS_ALL_MAP | MTH_RES_TXN_EXT_INIT_PF | MTH_RES_TXN_EXT_INCR_PF | MTH_RESOURCE_TXN_ERR |
Sales Orders | MTH_WO_SALES_ORDERS.csv | MTH_WO_SALES_ORDERS_XS_ALL_MAP | MTH_WO_SALES_ORDER_EXT_INIT_PF | MTH_WO_SALES_ORDER_EXT_INCR_PF | MTH_WO_SALES_ORDERS_ERR |
Equipment Shifts | MTH_EQUIP_SHIFTS.csv | MTH_EQUIP_SHIFTS_XS_MAP | MTH_EQUIP_SHIFTS_EXT_INIT_PF | MTH_EQUIP_SHIFTS_EXT_INCR_PF | MTH_EQUIPMENT_SHIFTS_ERR |
Meter Reading | MTH_METER_READINGS.csv | MTH_METER_READINGS_XS_ALL_MAP | MTH_METER_READINGS_EXT_INIT_PF | MTH_METER_READINGS_EXT_INCR_PF | MTH_METER_READINGS_ERR |
Equipment Output | MTH_EQUIP_OUTPUT.csv | MTH_EQUIP_OUTPUT_XS_ALL_MAP | MTH_EQUIP_OUTPUT_EXT_INIT_PF | MTH_EQUIP_OUTPUT_EXT_INCR_PF | MTH_EQUIP_OUTPUT_ERR |
Equipment Status | MTH_EQUIP_STATUS.csv | MTH_EQUIP_STATUS_XS_ALL_MAP | MTH_EQUIP_STATUS_EXT_INIT_PF | MTH_EQUIP_STATUS_EXT_INCR_PF | MTH_EQUIP_STATUSES_ERR |
If you load the status readings through CSV template, then you must provide equipment status readings for all the 24 hours. When you provide From Date and To Date in the CSV template, the application subtracts one second from the To Date while loading the Status information. If the reading time for the equipment status is outside a valid shift, then the reading should be provided using a catchall shift reference. If continuous readings are not provided, then the MOC application errors out the readings.
If you are loading the energy meter readings or equipment output for the following entities using CSV, you must pass the reading time as one second less than the actual reading time as the MOC application considers the end of the hour as XX:59:59 for separating the hourly boundaries by one second:
Scrap Quantity
Output Quantity
Rework Quantity
Rejected Quantity
Completed Quantity