Results for “item_fk_key”
50+ results
-
Table: MTH_ITEM_COST_MV 12.1.1
-
Table: MTH_ITEM_DENORM_D 12.2.2
This table stores denormalized data for item hierarchy.
-
Staging table to move device data in MTH_EQUIPMENTS_EXT_B
-
This table stores information on assembly completion transactions at the operation level of the work orders
-
For Internal Use Only. Summary Fact table
-
Table: MTH_ITEM_DENORM_D_TMP 12.1.1
-
Table: MTH_ITEM_DENORM_D_TMP 12.2.2
-
Event forecast fact table .
-
Event forecast fact table .
-
Table: MTH_ITEM_COST_MV 12.2.2
-
Table: MTH_MTL_PROD_IT_MV 12.1.1
-
It contains similar information in equipment production performace with more granular status information.
-
Table: MTH_MTL_PROD_IT_MV 12.2.2
-
Table: MTH_ITEM_DENORM_D 12.1.1
-
This is the Job Resource Fact. It contains detailed information regarding resources used in Jobs/Batches. It will contain usage, value and count information for resources. It will also contain quantities produced by resources and the assoc
-
This table stores information on standard production rates for equipments.
-
This table stores information on scheduled quantity on every equipment. It holds additional information on the work order and operation it is scheduled.
-
Table: MTH_TAG_READINGS 12.1.1
This table contains the Manufacturing Hub processed tag data
-
Table: MTH_TAG_READINGS 12.2.2
This table contains the Manufacturing Operations Center processed tag data
-
This table stores external attributes data for Workorder Segments
-
This table stores information on operations for various types of work orders. It holds information on Scheduled quantity, actual completed, scrapped, rejected, reworked and actual start and completion dates.
-
Table: MTH_EQUIP_OUTPUT 12.2.2
This table stores the output information by reading time. It holds information on quantity completed, rejected, scrapped, reworked and good quantity.
-
Campaign Forecast fact table .
-
Campaign Forecast fact table .
-
Custom Measure fact table
-
This table stores information on actual equipment production schedule for each work order at the shift and operations level.
-
Lead fact table .
-
Lead fact table .
-
Opportunity fact table .
-
Table: MTH_ITEM_COST 12.1.1
-
Table: MTH_ITEM_COST 12.2.2
This table stores the information about item cost history. It holds information on item cost for every cost element of the item.
-
Monthly summarized fact table .
-
Monthly summarized fact table .
-
Daily derived fact table .
-
Daily derived fact table .
-
Interface table for Consolidated Revenue fact
-
Interface table for the Job Resource Fact. This will be the staging area for data coming into the Warehouse from Discrete and Process Manufacturing sources.
-
This table stores information about the intra-operation transactions that take place at the operation level. It holds information on quantity moved from one intra-operation type to another intra-operation type of the same or a different ope
-
Interface table for campaign forecast fact .
-
Table: POA_EDW_SUP_PERF_F 12.1.1
Supplier Performance fact
-
This table stores the work order item information. It holds information about the quantity of each item to be assembled, the actual quantity completed along with the scrap, reject and the reworked quantities, the type of the item and its e
-
Interface table for opportunity fact .
-
Interface table for event forecast fact .