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.
Module:
WORK_ORDER_ID
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 | System Generated | ||||
WORK_ORDER_NUMBER | VARCHAR2 | 128 | Represents the user-facing identifier of the work order. | ||||
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_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. |
#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, 2023, Oracle and/or its affiliates.