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
-
Table: MTH_ITEM_COST_MV 12.2.2
-
It contains similar information in equipment production performace with more granular status information.
-
Event forecast fact table .
-
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
-
Event forecast fact table .
-
Table: MTH_ITEM_DENORM_D 12.1.1
-
Table: MTH_MTL_PROD_IT_MV 12.1.1
-
Table: MTH_MTL_PROD_IT_MV 12.2.2
-
This table stores information on standard production rates for equipments.
-
This table stores external attributes data for Workorder Segments
-
Table: MTH_TAG_READINGS 12.1.1
This table contains the Manufacturing Hub processed tag data
-
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.2.2
This table contains the Manufacturing Operations Center processed tag data
-
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.
-
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.
-
This table stores information on actual equipment production schedule for each work order at the shift and operations level.
-
Custom Measure fact table
-
Campaign Forecast fact table .
-
Campaign Forecast fact table .
-
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.
-
Table: MTH_ITEM_COST 12.1.1
-
Lead fact table .
-
Opportunity fact table .
-
Lead fact table .
-
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
-
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 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.
-
Interface table for campaign forecast fact .
-
Interface table for opportunity fact .
-
Interface table for event forecast fact .
-
Table: POA_EDW_SUP_PERF_F 12.1.1
Supplier Performance fact
-
Table: MTH_TAG_READINGS_ERR 12.2.2
Error table for MTH_TAG_READINGS
-
Monthly summarized fact table .
-
Job Detail Fact Staging Table Sourced from the Fllowing Views OPI_EDW_OPM_JOB_DETAIL_FCV and OPI_EDW_OPI_JOB_DETAILS_FCV