DW_NS_MANUFACTURING_INSIGHTS_CF
This fact includes essential attributes and metrics needed to calculate critical manufacturing Key Performance Indicators (KPIs) such as Perfect Work Orders, Behind Plan Ratio, Defect (Scrap) Density, and Yield at the work order level. This dataset is crucial for evaluating the quality, speed, and accuracy of the manufacturing process for each work order.
Details
Module:
Key Columns
transaction_id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| transaction_id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 999 | This column is for Oracle Internal use only. | ||||
| subsidiary | NUMBER | 38 | 0 | DW_NS_subsidiary_D | id | ||
| class | NUMBER | 38 | 0 | DW_NS_classification_D | id | ||
| department | NUMBER | 38 | 0 | DW_NS_department_D | id | ||
| location | NUMBER | 38 | 0 | DW_NS_location_D | id | ||
| createddate | TIMESTAMP | ||||||
| createdby | NUMBER | 38 | 0 | DW_NS_entity_D | id | ||
| trandate | TIMESTAMP | ||||||
| closedate | TIMESTAMP | ||||||
| lastmodifiedby | NUMBER | 38 | 0 | DW_NS_entity_D | id | ||
| lastmodifieddate | TIMESTAMP | ||||||
| customer | NUMBER | 38 | 0 | DW_NS_customer_D | id | ||
| posting | VARCHAR2 | 16 | |||||
| postingperiod | NUMBER | 38 | 0 | DW_NS_accountingPeriod_D | id | ||
| iswip | VARCHAR2 | 16 | |||||
| startdate | TIMESTAMP | ||||||
| enddate | TIMESTAMP | ||||||
| actualproductionenddate | TIMESTAMP | ||||||
| actualproductionstartdate | TIMESTAMP | ||||||
| autocalculatelag | VARCHAR2 | 16 | |||||
| isactualprodenddateenteredmanually | VARCHAR2 | 16 | |||||
| isactualprodstartdateenteredmanually | VARCHAR2 | 16 | |||||
| assembly_item | NUMBER | 38 | 0 | DW_NS_item_D | id | ||
| billofmaterials | NUMBER | 38 | 0 | DW_NS_bom_D | id | ||
| billofmaterialsrevision | NUMBER | 38 | 0 | DW_NS_bomRevision_D | id | ||
| manufacturingrouting | NUMBER | 38 | 0 | DW_NS_ManufacturingRouting_D | id | ||
| isbookspecific | VARCHAR2 | 16 | |||||
| outsourced | VARCHAR2 | 16 | |||||
| outsourcingcharge | NUMBER | 38 | 0 | DW_NS_item_D | id | ||
| schedulingmethod | VARCHAR2 | 32 | DW_NS_schedulingMethod_D | key | |||
| firmed | VARCHAR2 | 16 | |||||
| billingstatus | VARCHAR2 | 16 | |||||
| linkedpo | NUMBER | 38 | 0 | DW_NS_PURCHASE_ORDER_F | id | ||
| linkedir | NUMBER | 38 | 0 | DW_NS_ITEM_RECEIPT_F | id | ||
| memo | VARCHAR2 | 999 | |||||
| ns_number | NUMBER | 38 | 0 | ||||
| tranid | VARCHAR2 | 256 | |||||
| trandisplayname | VARCHAR2 | 999 | |||||
| transactionnumber | VARCHAR2 | 256 | |||||
| typebaseddocumentnumber | VARCHAR2 | 512 | |||||
| workord_id | NUMBER | 38 | 0 | DW_NS_WORK_ORDER_F | id | ||
| build_id | NUMBER | 38 | 0 | DW_NS_ASSEMBLY_BUILD_F | id | ||
| unbuild_id | NUMBER | 38 | 0 | DW_NS_ASSEMBLY_UNBUILD_F | id | ||
| status | VARCHAR2 | 16 | DW_NS_STATUS_D | code | |||
| type | VARCHAR2 | 16 | DW_NS_STATUS_D | key | |||
| workorder_quantity | NUMBER | ||||||
| built_quantity | NUMBER | ||||||
| unbuilt_quantity | NUMBER | ||||||
| behind_plan_built_quantity | NUMBER | ||||||
| scrap_quantity | NUMBER | ||||||
| units | NUMBER | 38 | 0 | DW_NS_unitsTypeUom_D | internalid |