# DW_MFG_WORK_ORDERS_CF (Preview)

This table requires activation of Manufacturing functional area. This table stores information about work order details. It identifies the primary product and can optionally refer to the Item Structure used to define material requirements.

## Details

Module:

## Key Columns

WORK_ORDER_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
WORK_ORDER_ID | NUMBER | 38 | 0 | True | The unique identifier of work order record | DW_MFG_WORK_ORDERS_TL | WORK_ORDER_ID
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. System Generated |  |
WORK_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Represents the user-facing identifier of the work order. |  |
WORK_ORDER_ASSET_ID | NUMBER | 38 | 0 |  | To be deprecated in the future. |  |
ASSET_ID | NUMBER | 38 | 0 |  | To be deprecated in the future. |  |
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Refers to the top level, final assembly, subassembly, or model item which belongs to the given organization #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ORGANIZATION_ID | NUMBER | 38 | 0 |  | The organization identifier that represents the manufacturing plant to which this work order belongs. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business unit for the manufacturing plant | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
LEDGER_ID | NUMBER | 38 | 0 |  | Ledger associated to the business unit | DW_LEDGER_D | LEDGER_ID
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Fiscal period type #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Fiscal period name. #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity for the manufacturing plant | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
WORK_METHOD_ID | NUMBER | 38 | 0 |  | Represents the work method identifier for this work order. The work method indicates the type of work being executed within the Fusion Manufacturing application. | DW_MFG_WORK_METHODS_TL | WORK_METHOD_ID
WORK_METHOD_CODE | VARCHAR2 | 32 |  |  | Work method code |  |
WORK_ORDER_TYPE_CODE | VARCHAR2 | 32 |  |  | Indicates the type of this work order. #3 | DW_ORA_WIE_WO_TYPE_LKP_TL | ORA_WIE_WO_TYPE_CODE
WORK_ORDER_SUB_TYPE_CODE | VARCHAR2 | 32 |  |  | The subtype specifically will be populated for non-standard work. This is used to derive the appropriate costing account for non-standard work. #4 | DW_ORA_WIE_WO_SUB_TYPE_LKP_TL | ORA_WIE_WO_SUB_TYPE_CODE
WORK_ORDER_STATUS_ID | NUMBER | 38 | 0 |  | Represents the internal identifier of the user-defined status of the work order. | DW_MFG_STATUSES_TL | WO_STATUS_ID
WORK_ORDER_SYSTEM_STATUS_CODE | VARCHAR2 | 32 |  |  | Represents the system status code for a given work order status. | DW_ORA_WIE_WO_SYSTEM_STATUS_LKP_TL | ORA_WIE_WO_SYSTEM_STATUS_CODE
SCHEDULING_METHOD_CODE | VARCHAR2 | 32 |  |  | Indicates the scheduling method for this work order. | DW_ORA_WIE_WO_SCHEDULING_METHOD_LKP_TL | ORA_WIE_WO_SCHEDULING_METHOD_CODE
PLANNED_START_DATE | DATE |  |  |  | Planned start date of the work order without timestamp | DW_DAY_D | CALENDAR_DATE
PLANNED_START_TIMESTAMP | TIMESTAMP |  |  |  | Planned start date of the work order with timestamp |  |
ACTUAL_START_DATE | DATE |  |  |  | Actual start date of the work order without timestamp | DW_DAY_D | CALENDAR_DATE
ACTUAL_START_TIMESTAMP | TIMESTAMP |  |  |  | Actual start date of the work order with timestamp |  |
RELEASED_DATE | DATE |  |  |  | Date when the work order is released, without timestamp | DW_DAY_D | CALENDAR_DATE
RELEASED_TIMESTAMP | TIMESTAMP |  |  |  | Date when the work order is released, with timestamp |  |
PLANNED_COMPLETION_DATE | DATE |  |  |  | Planned completion date of the work order without timestamp | DW_DAY_D | CALENDAR_DATE
PLANNED_COMPLETION_TIMESTAMP | TIMESTAMP |  |  |  | Planned completion date of the work order with timestamp |  |
ACTUAL_COMPLETION_DATE | DATE |  |  |  | Actual completion date of the work order without timestamp | DW_DAY_D | CALENDAR_DATE
ACTUAL_COMPLETION_TIMESTAMP | TIMESTAMP |  |  |  | Actual completion date of the work order with timestamp |  |
CLOSED_DATE | DATE |  |  |  | Date when the work order is closed, without timestamp | DW_DAY_D | CALENDAR_DATE
CLOSED_TIMESTAMP | TIMESTAMP |  |  |  | Date when the work order is closed, with timestamp |  |
CANCELED_DATE | DATE |  |  |  | Date when the work order is canceled, without timestamp | DW_DAY_D | CALENDAR_DATE
CANCELED_TIMESTAMP | TIMESTAMP |  |  |  | Date when the work order is canceled, with timestamp |  |
CANCELED_REASON | VARCHAR2 | 256 |  |  | Cancellation Reason |  |
WORK_DEFINITION_ID | NUMBER | 38 | 0 |  | Unique identifier to the work definition |  |
WORK_DEFINITION_VERSION_ID | NUMBER | 38 | 0 |  | Work definition version identifier |  |
PJC_PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of the project used for project-related transaction distributions | DW_PROJECT_D | PROJECT_ID
PJC_TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task used for project-related transaction distributions | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
PJC_EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Identifier of the expenditure type used for project-related transaction distributions | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID
PJC_EXPENDITURE_ITEM_DATE | DATE |  |  |  | Date on which a project-related transaction is incurred. | DW_DAY_D | CALENDAR_DATE
PJC_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifier of the expenditure organization used for project-related transaction distributions | DW_INTERNAL_ORG_D | ORGANIZATION_ID
CREATION_DATE | TIMESTAMP |  |  |  | Work order creation date |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Work order last update date |  |
UOM_CODE | VARCHAR2 | 16 |  |  | Represents the unit of measure code. The assembly quantity will be produced in this UOM. The transactions that moves the assembly from operation to operation and also eventually the completions will be performed in this UOM. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PLANNED_START_QUANTITY | NUMBER |  |  |  | Refers to the planned work order quantity which should be greater than zero for standard work orders, and can be equal to or greater than zero for non standard work orders |  |
COMPLETED_QUANTITY | NUMBER |  |  |  | Primary product quantity completed so far in the work order. |  |
SCRAPPED_QUANTITY | NUMBER |  |  |  | Primary product quantity that is scrapped in the work order. |  |
REJECTED_QUANTITY | NUMBER |  |  |  | Primary product quantity that is rejected in the work order. |  |
PUOM_CODE | VARCHAR2 | 16 |  |  | Primary UOM code | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PUOM_CONVERSION_FACTOR | NUMBER |  |  |  | Transaction UOM to Primary UOM conversion factor |  |
PUOM_PLANNED_START_QUANTITY | NUMBER |  |  |  | Refers to the planned work order quantity in primary UOM which should be greater than zero for standard work orders, and can be equal to or greater than zero for non standard work orders |  |
PUOM_COMPLETED_QUANTITY | NUMBER |  |  |  | Primary product quantity completed so far in the work order in primary UOM. |  |
PUOM_SCRAPPED_QUANTITY | NUMBER |  |  |  | Primary product quantity that is scrapped in the work order in primary UOM. |  |
PUOM_REJECTED_QUANTITY | NUMBER |  |  |  | Primary product quantity that is rejected in the work order in primary UOM. |  |
HISTORIC_REJECT_FLAG | VARCHAR2 | 16 |  |  | Flag to denote whether any reject operation transaction happened on work order or not |  |
HISTORIC_REJECT_QUANTITIES | NUMBER |  |  |  | Aggregated value of transaction quantities of all reject operation transactions |  |
PUOM_HISTORIC_REJECT_QUANTITIES | NUMBER |  |  |  | Aggregated value of primary UOM quantities of all reject operation transactions |  |
WORK_ORDER_DATE | DATE |  |  |  | Stores Planned Start Date for Unreleased Work Orders and Released Date for Released Work Orders. Used in joining with Fiscal Dates #2 | DW_DAY_D | CALENDAR_DATE
PRIMARY_PRODUCT_UOM_CODE | VARCHAR2 | 16 |  |  | Represents the unit of measure code of the primary product used to create the work order | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PRIMARY_PRODUCT_PUOM_CONVERSION_FACTOR | NUMBER |  |  |  | Primary Product UOM to Primary UOM conversion factor |  |
PRIMARY_PRODUCT_QUANTITY | NUMBER |  |  |  | Represents the output quantity of the primary product used to create the work order |  |
PUOM_PRIMARY_PRODUCT_QUANTITY | NUMBER |  |  |  | Represents the output quantity of the primary product used to create the work order in Primary UOM |  |
BACK_TO_BACK_FLAG | VARCHAR2 | 16 |  |  | Flag to indicate that the work order is created as a result of a back-to-back flow | DW_YN_LKP_TL | YN_LKP_CODE
CONTRACT_MFG_FLAG | VARCHAR2 | 16 |  |  | Flag to indicate that the work order is a contract manufacturing work order | DW_YN_LKP_TL | YN_LKP_CODE
CM_PO_HEADER_ID | NUMBER | 38 | 0 |  | Represents the internal identifier of the contract manufacturer's purchase order |  |
CM_PO_LINE_ID | NUMBER | 38 | 0 |  | The reference to the contract manufacturer's PO line identifier |  |
CM_PO_LINE_LOC_ID | NUMBER | 38 | 0 |  | The reference to the contract manufacturer's PO schedule line reference |  |
SOURCE_HEADER_REF_ID | NUMBER | 38 | 0 |  | Represents the source system's internal header reference identifier |  |
SOURCE_LINE_REF_ID | NUMBER | 38 | 0 |  | Represents the source system's internal line reference identifier |  |
BEHIND_PLAN_RATIO | BIGDECIMAL |  | 10 |  | This is the ratio of quantities by which Work Order is lagging to the planned start quantity in primary UOM |  |
UNDER_COMPLETED_FLAG | VARCHAR2 | 16 |  |  | Flag to indicate that the work order is marked as under-completed | DW_YN_LKP_TL | YN_LKP_CODE
WORK_ORDER_PRIORITY | NUMBER |  |  |  | Used to set the priority of the work order depending on the demand that needed to be prioritized. |  |
FIRM_PLANNED_FLAG | VARCHAR2 | 16 |  |  | Flag to allow or prevent Planning from suggesting rescheduling and re-planning recommendations with respect to the Work Order. When the flag is on, this work order will not be considered by MRP to reschedule or re-plan. |  |
RESEQUENCE_FLAG | VARCHAR2 | 16 |  |  | Flag used to indicate if the work order has operations which can be re-sequenced while executing the operation. Valid values are Y or N. |  |

## Notes

#1 In these cases in addition to the inventory item id column, ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D #2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on WORK_ORDER_DATE column #3 Dimensional Reference for WORK_ORDER_TYPE_CODE is derived from DW_ORA_WIE_WO_TYPE_LKP_TL lookup in case this work order is a manufacturing work order and DW_ORA_MNT_WO_TYPE_LKP_TL lookup when it is a maintenance work order #4 Dimensional Reference for WORK_ORDER_SUB_TYPE_CODE is derived from DW_ORA_WIE_WO_SUB_TYPE_LKP_TL lookup in case this work order is a manufacturing work order and DW_ORA_MNT_WO_SUB_TYPE_LKP_TL lookup when it is a maintenance work order

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