Results for “instance_fk_key”
24 results
-
Table: OPI_EDW_MRG_KEYS 12.1.1
-
Table: OPI_EDW_IDS_NET_CHG 12.1.1
-
This is resource utilization fact table. Resource utilization is a measure indicating how much your resources are used in production.It is a comparison of the resource time used and the total resource available.The Resource Utilization 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.
-
COGS Shipment Fact table
-
Table: OPI_EDW_UOM_CONV_F 12.1.1
Unit Of Measure Conversion fact table
-
Fact Table for the Inventory Daily Status Fact
-
Interface table for Unit Of Measure Conversion fact
-
This is the product gross margin fact table summarized at period level, and is derived from product gross margin fact. It contains the product sales revenue and the matching cost of goods sold by period.
-
Table: OPI_EDW_MARGIN_F 12.1.1
Margin fact table
-
Fact Table for the Inventory Period Status Derived Fact
-
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 is the interface table for Resource Utilization Fact. Data from multiple transactional systems is staged here for verification and cleansing before being loaded into the fact table.
-
Interface table for COGS Shipment Fact
-
Table: OPI_EDW_COGS_F_DLOG 12.1.1
COGS Shipment Fact table
-
Fact Staging Table for the Inventory Daily Status Fact
-
Job Detail fact will store the detail information of the Jobs/Batches. There will be one row for each jobs and each end products. For example, if a batch produces two products ( one main product and one co-product) then the fact table will
-
Job Detail Fact Staging Table Sourced from the Fllowing Views OPI_EDW_OPM_JOB_DETAIL_FCV and OPI_EDW_OPI_JOB_DETAILS_FCV
-
Fact Delete log Table for the Inventory Daily Status Fact