# 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

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

Copyright © 2019, 2025, Oracle and/or its affiliates.