1. Tables and Views for SCM
  2. DOS_WORKORDER_DETAILS_INT

DOS_WORKORDER_DETAILS_INT

Interface table to capture all Supply Order Work Order Details Supplemental Info and batch processing interface attributes

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

DOS_WORKORDER_DTLS_ITF_PK

WORKORDER_DETAILS_INTF_ID

Columns

Name Datatype Length Precision Not-null Comments
WORKORDER_DETAILS_INTF_ID NUMBER 18 Yes Unique Identifier System Generated value (Required)
MATERIAL_QTY_PER_PRODUCT NUMBER Original Component item quantity per product or assembly. This needs to be passed to manufacturing application as received from the requesting application.
SUBSTITUTE_QTY_PER_PRODUCT NUMBER Substitute item quantity per product/assembly.This needs to be passed to manufacturing application as received from the requesting application.
WD_OP_ALT_RESOURCE_ID NUMBER 18 Work Definition Operation Alternate Resource ID.. This needs to be passed to manufacturing application as received from the requesting application.
LINE_INTERFACE_ID NUMBER 18 Yes Unique Identifier System Generated value (Required)
HEADER_INTERFACE_ID NUMBER 18 Yes Unique Identifier System Generated value (Required)
INTERFACE_BATCH_NUMBER VARCHAR2 50 Yes Batch Number for planning, GOP and inventory. Same as SUPPLY_ORDER_REFERENCE_NUMBER.
INTERFACE_STATUS_CODE VARCHAR2 30 Represents the status of the work order details interface record. This status needs to be passed to Manufacturing application as received from the requesting application. Ex. 'Ready'.
ACTION_CODE VARCHAR2 30 A code used to indicate what action the manufacturing system should perform on the work order detail entity. This code need to be passed to manufacturing application as received from the requesting application. Ex. 'REPLACE'.
LOAD_TYPE VARCHAR2 30 A code used to indicate the type of data that the work order detail record contains. This code need to be passed to manufacturing application as received from the requesting application. Ex. 'RESOURCE', 'MATERIAL'.
MATERIAL_SEQ_NUMBER NUMBER A sequence number that represents the order of consumption of material at a given operation. This number need to be passed to manufacturing application as received from the requesting application.
DETAIL_TYPE VARCHAR2 30 Type of work order details provided
WIP_ENTITY_ID NUMBER WIP job or repetitive assembly Identifier
OPERATION_SEQUENCE_ID NUMBER Routing operation sequence Identifier
OPERATION_SEQUENCE_NUMBER NUMBER Routing operation sequence number (used both on components and resources)
SCHEDULED_FLAG NUMBER Indicates of work order detail is scheduled
ASSIGNED_UNITS NUMBER Units assigned for the work order
WIP_SUPPLY_TYPE NUMBER The supply type for this work order detail
WO_PROCESS_PHASE NUMBER Used by WIP interface controls - Set to 2 (validation)
WO_PROCESS_STATUS NUMBER Used by WIP interface controls - Set to 1 (Pending)
ALTERNATE_NUMBER NUMBER Alternate resource priority number
COMP_ITEM_ID_NEW NUMBER Component new material requirement identifier
COMP_ITEM_NAME_NEW VARCHAR2 20 New name of the component item used in the work order
COMP_ITEM_REVISION VARCHAR2 18 Component Item Revision to be used
COMP_REQUIRED_QUANTITY NUMBER Required Quantity of the component
COMP_REQUIRED_QUANTITY_UOM VARCHAR2 3 Component Required Quantity Unit of Measure
COMP_QUANTITY_PER_ASSEMBLY NUMBER Needed component Quantity Per Assembly
COMP_QUANTITY_ISSUED NUMBER Component quantity already issued to the job
COMP_DATE_REQUIRED DATE Component requirement date in work order
COMP_SUPPLY_LOCATOR_ID NUMBER Component supply locator Identifier
COMP_SUPPLY_LOCATOR_NAME VARCHAR2 20 Component supply locator Name in system
COMP_SUPPLY_SUB_INVENTORY VARCHAR2 10 Component supply subinventory to source components
COMP_MRP_NET_FLAG NUMBER Component MRP nettable inidcator
COMP_CHARGE_ACCNT_ID NUMBER Charge account identifier for the component
COMP_ITEM_ID_OLD NUMBER Old material requirement identifier which is only used when there is a substitute component
COMP_ITEM_NAME_OLD VARCHAR2 20 Old Item Name of the component used in the Work Order
STANDARD_OPERATION_ID NUMBER Routing standard operation Identifier
STANDARD_OPERATION_NAME VARCHAR2 20 Standard Operation Name in work order
STANDARD_RATE_FLAG NUMBER Indicates if the Standard Rate used
SUBSTITUTION_TYPE NUMBER Must be one of these:1 Delete, 2 Add, 3 Change
MIN_TRANSFER_QUANTITY NUMBER Minimum Transfer Quantity for operation
MIN_TRANSFER_QUANTITY_UOM VARCHAR2 3 Minimum Transfer Quantity Unit of Measure
BACKFLUSH_FLAG NUMBER Backflush flag of the work order
SOURCE_CODE VARCHAR2 20 Code of the process that generated the interface record
COUNT_POINT_TYPE NUMBER Count point type for the operation
MPS_REQUIRED_QUANTITY NUMBER Quantity required by MPS Relief
MPS_REQUIRED_QUANTITY_UOM VARCHAR2 3 Mps Required Quantity Unit of Measure Code
MPS_DATE_REQUIRED DATE Date required by MPS Relief for operation
APPLIED_RESOURCE_UNITS NUMBER Applied resource units to the job
APPLIED_RESOURCE_VALUE NUMBER Applied resource value to the job
RESOURCE_SEQUENCE_NUMBER NUMBER Resource sequence number in operation
RESOURCE_ACTIVITY_ID NUMBER Resource activity ID used for activity based costing
RESOURCE_LOAD_TYPE NUMBER Cannot be NULL - .1 for loading a resource, 2 for loading a component, 3 for loading an operation, 5 for changing between primary and alternate resources
RESOURCE_START_DATE NUMBER Resource activity start date in opeartion
RESOURCE_ID_NEW NUMBER Resource identifier to be added or changed to
RESOURCE_NAME_NEW VARCHAR2 20 New name for the Resource in operation
RESOURCE_DEPARTMENT_ID NUMBER Department Identifier for the Resource
RESOURE_DEPARTMENT_NAME VARCHAR2 20 Department Name of the Resource
RESOURCE_BASIS_TYPE NUMBER Resource basis type (each or lot) for operation
RESOURCE_USAGE_RATE_OR_AMOUNT NUMBER Resource Usage Rate or amount needed
RESOURCE_UOM_CODE VARCHAR2 3 Resource unit of measure for the amount
RESOURCE_AUTO_CHARGE_TYPE NUMBER Method of charging the resource
RESOURCE_COMPLETION_DATE DATE Resource completion date in operation
RESOURCE_ID_OLD NUMBER Resource identifier existing in current jobs
RESOURCE_NAME_OLD VARCHAR2 20 Name of old resource used in operation
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index Uniqueness Tablespace Columns
DOS_WORKORDER_DTLS_INT_U1 Unique FUSION_TS_ARCHIVE WORKORDER_DETAILS_INTF_ID