Results for “system_fk_key”
50+ results
-
This table stores the latest parent - child relationship for time hierarchy.
-
Table: MTH_RESOURCE_COST 12.1.1
-
This table stores the history of parent - child relationship for equipment hierarchy.
-
Table: MTH_ORGANIZATIONS_L 12.2.2
This table stores information for the organization dimension. It provides information like Organization name, Organization code, Currency code, Primary cost method and whether the organization is Process enabled.
-
This table stores the entity definitions for user-defined dimensions. It holds information on Entity name and Entity type.
-
Table: MTH_HOUR_D 12.2.2
MTH_HOUR_D will store the hourly time buckets for each day generated in the calendar.
-
This table stores the latest parent-child hierarchy relationship for user-defined hierarchies.
-
This table stores information on day level definition for time dimension.
-
This table stores information on week level definition for time dimension hierarchies.
-
This table stores the workday shifts definition for the time dimension. It provides information like Shift date, Shift From Time, Shift To Time, Shift name and Shift number.
-
Table: MTH_TAG_DATA_SOURCES 12.2.2
This table defines the sources for tag
-
Table: MTH_RESOURCE_COST 12.2.2
This table stores the information about resource cost history. It holds information on resource cost for every cost element of the resource.
-
It contains similar information in equipment production performace with more granular status information.
-
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.
-
This table stores the latest parent - child relationship for item hierarchy.
-
Table: MTH_ORGANIZATIONS_L 12.1.1
-
This table stores the information on transactions that consume the component material at the operation level of the work orders
-
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 period level definition for time dimension hierarchies.
-
This table stores information on quarter level definition for time dimension hierarchies.
-
This table stores information on year level definition for time dimension hierarchies.
-
This table stores information on actual equipment production schedule for each work order at the shift and operations level.
-
Table: MTH_ASSET_MST 12.2.2
This table stores information about assets. It holds information like Asset Number, Asset Group, Maintenance Organization code and other asset attributes.
-
This table stores information on activities for each operation (Segment). It holds information on Sub-segment, actual and planned start dates, actual and planned completion dates.
-
This table stores the lot, sub-lot and serial number level information for both the product and components used
-
This table stores information on scheduled quantity on every equipment. It holds additional information on the work order and operation it is scheduled.
-
This table stores information about equipments. It holds information like Equipment name, Equipment description and Fixed asset value and Organization.
-
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 the lot, sub-lot and serial number level information for the products manufactured