WIE_WORK_ORDERS_INT
This is the interface table for the work order header. It contains details about the work definition on which the work order is created, the work order type, the assembly quantities, etc.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
WIE_WORK_ORDERS_INT_PK |
INTERFACE_ROW_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INTERFACE_ROW_ID | NUMBER | 18 | Yes | The unique identifier of a work order header interface record. Its value is an application generated unique id. | |
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. | |
INTERFACE_BATCH_CODE | VARCHAR2 | 30 | Yes | Represents the user identified code for the interface batch. | |
INTERFACE_BATCH_ID | NUMBER | 18 | Represents the internal interface batch identifier. This is used to group a batch of interface records for processing. When interface records are brought in via services or the UI, the system will internally generate this value. | ||
INTERFACE_STATUS_CODE | VARCHAR2 | 30 | Yes | Represents the progress of the interface processing with statuses such as ready for processing or currently in process as well as the various flavors of completion statuses. Valid values exist in the lookup with lookup type = ORA_WIE_INTERFACE_STATUS. | |
ACTION_CODE | VARCHAR2 | 30 | Yes | A code used to indicate if the system should create or update this entity. Valid values exist in the lookup with lookup type = ORA_WIE_WO_IMP_HEADER_ACTION. | |
SCHEDULING_METHOD | VARCHAR2 | 30 | Yes | The scheduling method indicates if the work order is scheduled or not. A value of 'NO_SCHEDULING' indicates the work order is not scheduled. A value of 'DEFAULT_SCHEDULER' indicates the work order will be scheduled using the default infinite scheduler. Valid values exist in the lookup with lookup type = ORA_WIE_WO_SCHEDULING_METHOD. | |
HEADER_NUMBER | VARCHAR2 | 18 | Yes | The attributes WORK_ORDER_NUMBER + ORGANIZATION_CODE uniquely identify a work order. However, when the work order number is auto generated at the time of creation, the user will not have the work order number to pass via the open interface. This attribute allows the user to connect the header records with the details in the WIE_WORK_ORDER_DETAILS_INT table. The value of this column is user managed. This is not carried forward to the production tables. | |
WORK_ORDER_NUMBER | VARCHAR2 | 120 | Represents the user-facing identifier of the work order. | ||
WORK_ORDER_ID | NUMBER | 18 | Represents the internal identifier of the work order. | ||
WORK_ORDER_DESCRIPTION | VARCHAR2 | 240 | Represents the description of the work order. | ||
ORGANIZATION_CODE | VARCHAR2 | 18 | The organization code that represents the manufacturing plant to which this work order belongs. | ||
ORGANIZATION_ID | NUMBER | 18 | The organization identifier that represents the manufacturing plant to which this work order belongs. | ||
WORK_METHOD_CODE | VARCHAR2 | 30 | Represents the work method code for this work order. The work method indicates the type of work being executed within the Fusion Manufacturing application. | ||
WORK_METHOD_ID | NUMBER | 18 | Represents the work method identifier for this work order. The work method indicates the type of work being executed within the Fusion Manufacturing application. | ||
WORK_ORDER_TYPE | VARCHAR2 | 30 | Indicates the type of this work order. Values are contained within the ORA_WIE_WO_TYPE lookup if this work order is a manufacturing work order. If this is a maintenance work order, valid values are contained within the ORA_MNT_WO_TYPE lookup. | ||
WORK_ORDER_SUB_TYPE | VARCHAR2 | 30 | The subtype specifically will be populated for non-standard work. This is used to derive the appropriate costing account for non-standard work. Values are contained in the ORA_WIE_WO_SUB_TYPE lookup if this work order is a manufacturing work order. If this is a maintenance work order, valid values are contained within the ORA_MNT_WO_SUB_TYPE lookup. | ||
INVENTORY_ITEM_NUMBER | VARCHAR2 | 300 | Represents the user key to the top level, final assembly, subassembly, or model item which belongs to the given organization. | ||
INVENTORY_ITEM_ID | NUMBER | 18 | Refers to the top level, final assembly, subassembly, or model item which belongs to the given organization. | ||
TRANSFORM_FROM_ITEM_NUMBER | VARCHAR2 | 300 | Refers to the item number of the assembly item that is being transformed to a new assembly item on a Transform work order. | ||
TRANSFORM_FROM_ITEM_ID | NUMBER | 18 | Refers to the item id of the assembly item that is being transformed to a new assembly item on a Transform work order. | ||
WORK_DEFINITION_CODE | VARCHAR2 | 30 | This is the user key to the name of the work definition. This denotes an alternate way of making a product. The combination of the work definition code + Item id + organization id makes the work definition unique. | ||
MAINTENANCE_WD_CODE | VARCHAR2 | 30 | Indicates the user defined maintenance work definition code. | ||
WORK_DEFINITION_ID | NUMBER | 18 | The foreign key reference to the work definition. | ||
WORK_DEFINITION_AS_OF_DATE | TIMESTAMP | The as of date to automatically figure out the work definition when user does not know the exact work definition. | |||
ALLOW_EXPLOSION_FLAG | VARCHAR2 | 1 | This flag controls the behavior whether the work definition should be used in the creation of work order operations, operation resources and operation material. Valid values are 'Y' and 'N'. | ||
WORK_ORDER_PRIORITY | NUMBER | Used to set the priority of the work order depending on the demand that needed to be prioritized. | |||
WORK_ORDER_STATUS_CODE | VARCHAR2 | 30 | Represents the user-key identifier of the work order status. | ||
WORK_ORDER_STATUS_ID | NUMBER | 18 | Represents the internal identifier of the work order status. | ||
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. | |||
NETTABLE_SUPPLY_QTY_OVERRIDE | NUMBER | This is a user entered override of the completion quantity intended to indicate if there are work order specific variances compared to the calculated Completion Quantity. | |||
UOM_CODE | VARCHAR2 | 3 | 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. | ||
WORK_DEFINITION_HEADER_NAME | VARCHAR2 | 120 | Indicates the unique name for the work definition. In the case of process manufacturing, this represents the process name. | ||
PRIMARY_PRODUCT_QUANTITY | NUMBER | Represents the output quantity of the primary product used to create the work order. | |||
PRIMARY_PRODUCT_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the primary product used to create the work order. | ||
FIRM_PLANNED_FLAG | VARCHAR2 | 1 | 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. | ||
PLANNED_START_DATE | TIMESTAMP | Planned start date of the work order. | |||
PLANNED_COMPLETION_DATE | TIMESTAMP | Planned completion date of the work order. | |||
ACTUAL_START_DATE | TIMESTAMP | Actual start date of the work order. | |||
RELEASED_DATE | TIMESTAMP | Date when the work order is released. | |||
CLOSED_DATE | TIMESTAMP | Date when the work order is closed. | |||
CANCELED_REASON | VARCHAR2 | 240 | Reason for which the work order is canceled. This is a free format text. | ||
NEED_BY_DATE | TIMESTAMP | Date when the supply created by the work order will be used to fulfill a demand. | |||
STATUS_CHANGE_REASON | VARCHAR2 | 240 | The reason which is a free format capture of why the status is changed. The most current status change reason will be persisted in this column. | ||
OVERCOMPL_TOLERANCE_TYPE | VARCHAR2 | 30 | The tolerance type for over completions. Valid values exist in the lookup with lookup type = EGP_OVER_TOLTYPE. | ||
OVERCOMPL_TOLERANCE_VALUE | NUMBER | The percent or amount value that is allowed over the scheduled completion work order quantity. | |||
UNDERCOMPL_TOLERANCE_TYPE | VARCHAR2 | 30 | The tolerance type for under completions. Valid values exist in the lookup with lookup type = ORA_EGP_UNDER_COMP_TOL. | ||
UNDERCOMPL_TOLERANCE_VALUE | NUMBER | The percent or amount value that is allowed under the scheduled completion work order quantity. | |||
UNDER_COMPLETED_FLAG | VARCHAR2 | 1 | Flag to indicate that the work order is marked as under-completed. | ||
SUPPLY_TYPE | VARCHAR2 | 30 | The various supply types are "Assembly Pull", "Operation Pull", "Push", and "Phantom". Assembly Pull - Material will be backflushed at the completion of the assembly. Operation Pull - Material will be backflushed at the completion of the operation. Push - Material will have to manually issued. Phantom - For materials having lower level components, the components will be considered as inputs to this work order. Valid values exist in the lookup with lookup_type = EGP_WIP_SUP_TYPE + lookup_type = ORA_WIE_WO_SUPPLY_TYPE. | ||
COMPL_SUBINVENTORY_CODE | VARCHAR2 | 10 | The default completion subinventory for the primary product. | ||
COMPL_LOCATOR_ID | NUMBER | 18 | The default completion locator for the primary product, if the subinventory is locator controlled. | ||
COMPL_LOCATOR_SEGMENT1 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT2 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT3 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT4 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT5 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT6 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT7 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT8 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT9 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT10 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT11 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT12 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT13 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT14 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT15 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT16 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT17 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT18 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT19 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
COMPL_LOCATOR_SEGMENT20 | VARCHAR2 | 40 | Represents the completion locator flexfield segment. | ||
BACK_TO_BACK_FLAG | VARCHAR2 | 1 | Flag to indicate that the work order is created as a result of a back-to-back flow. | ||
CONTRACT_MFG_FLAG | VARCHAR2 | 1 | Flag to indicate that the work order is a contract manufacturing work order. | ||
ORCHESTRATION_CODE | VARCHAR2 | 30 | Attribute made available for integrating stakeholders to retain and persist a handle in the work orders schema to filter out events that make only sense to them. Stakeholders include SCO and Planning. | ||
INTERFACE_SOURCE_CODE | VARCHAR2 | 30 | Attribute made available for integrating stakeholders to retain and persist a handle in the work orders schema to filter out events that make only sense to them. Stakeholders include SCO and Planning. | ||
SCO_SUPPLY_ORDER_ID | NUMBER | 18 | When Supply Chain Orchestration (SCO) creates the Work Order, this column contains an order reference populated by the SCO process. For manually created CM orders, or when Planning creates the CM Order in Manufacturing directly, this reference is not populated. SCO then reads these SCO unaware CM work orders via an ESS program and creates them in the SCO repository. | ||
SOLD_TO_LEGAL_ENTITY_NAME | VARCHAR2 | 240 | The legal entity name of the enterprise that is procuring goods/services from the supplier. | ||
SOLD_TO_LEGAL_ENTITY_ID | NUMBER | 18 | The legal entity identifier of the enterprise that is procuring goods/services from the supplier. | ||
CM_PO_NUMBER | VARCHAR2 | 30 | Represents the contract manufacturing purchase order number. | ||
CM_PO_HEADER_ID | NUMBER | 18 | Represents the internal identifier of the contract manufacturer's purchase order. | ||
CM_PO_LINE_NUMBER | NUMBER | The user key to the contract manufacturing purchase order line number. | |||
CM_PO_LINE_ID | NUMBER | 18 | The reference to the contract manufacturer's PO line identifier. The PO line will have the item that is identified as a CM Service Item (also referred to as the CM FG Server in the examples) in the PO line. It is not the primary product on the work order. | ||
CM_PO_SHIPMENT_NUMBER | NUMBER | The user key to the contract manufacturing purchase order shipment number. | |||
CM_PO_LINE_LOC_ID | NUMBER | The reference to the contract manufacturer's PO schedule line reference. This will be populated only when the WO is created in the contract manufacturing organization. | |||
SOURCE_HEADER_REF | VARCHAR2 | 240 | Represents the source system's user-facing header reference identifier. | ||
SOURCE_HEADER_REF_ID | NUMBER | 18 | Represents the source system's internal header reference identifier. | ||
SOURCE_LINE_REF | VARCHAR2 | 240 | Represents the source system's user-facing line reference identifier. | ||
SOURCE_LINE_REF_ID | NUMBER | 18 | Represents the source system's internal line reference identifier. | ||
MNT_FORECAST_ID | NUMBER | 18 | Reference to the maintenance forecast that created the work order. Foreign key to MNT_FORECASTS.FORECAST_ID. | ||
PARTITION_NUMBER | NUMBER | The partition number for multi-threading. | |||
PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. | ||
PJC_PROJECT_ID | NUMBER | 18 | Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. Foreign key to PJF_PROJECTS_ALL_B.PROJECT_ID. | ||
PJC_PROJECT_NUMBER | VARCHAR2 | 25 | The number assigned to a project. | ||
PJC_TASK_ID | NUMBER | 18 | Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. Foreign key to PJF_PROJ_ELEMENTS_B.PROJ_ELEMENT_ID (however uses an alias of TASK_ID). | ||
PJC_TASK_NUMBER | VARCHAR2 | 100 | The identifying number for a task which is a subdivision of project work. | ||
PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. | ||
PJC_EXPENDITURE_TYPE_NAME | VARCHAR2 | 240 | A classification of cost that you assign to each expenditure item. Expenditure types are grouped into cost groups and revenue groups. | ||
PJC_EXPENDITURE_ITEM_DATE | DATE | Date on which a project-related transaction is incurred. | |||
PJC_ORGANIZATION_ID | NUMBER | 18 | Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. | ||
PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is available to be billed to customers. Valid values are Y or N. | ||
PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is eligible for capitalization. Valid values are Y or N. | ||
PJC_WORK_TYPE_ID | NUMBER | 18 | Identifier for project-related classification of the worked performed. | ||
PJC_WORK_TYPE | VARCHAR2 | 240 | User-defined name that uniquely identifies the work type. | ||
PJC_CONTRACT_ID | NUMBER | 18 | Identifier of contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
PJC_CONTRACT_NUMBER | VARCHAR2 | 120 | Number of the contract. Used to derive the value for PJC_CONTRACT_ID if the ID is not given. | ||
PJC_CONTRACT_LINE_ID | NUMBER | 18 | Tracks contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Specifies the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | ||
PJC_FUNDING_SOURCE_NUMBER | VARCHAR2 | 50 | Number of the project's funding source. The ID of the funding source is stored in PJC_RESERVED_ATTRIBUTE1. | ||
PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for future project-related functionality. | ||
PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable project information. | ||
PREASSIGN_LOT_FLAG | VARCHAR2 | 1 | Flag used to indicate that the lots for primary product and outputs can be pre-assigned in the work order. | ||
RESEQUENCE_FLAG | VARCHAR2 | 1 | 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. | ||
MNT_COMPLETE_TO_INV_FLAG | VARCHAR2 | 1 | Flag indicating that the asset(s) involved in the work order will be completing to inventory upon completion of work. | ||
MNT_INCLUDE_IN_PLANNING_FLAG | VARCHAR2 | 1 | Flag indicating that the assets that are to be completed to inventory can be used as a supply in planning for any outstanding demand. | ||
MNT_OUT_OF_SEQUENCE_FLAG | VARCHAR2 | 1 | Flag indicating whether operations within the work order can be soft completed in an out of sequence fashion. | ||
MNT_TRANSFORM_TO_ITEM_ID | NUMBER | 18 | The end item that this asset will transform to upon completion of the work. | ||
MNT_ALLOW_MULTIPLE_ASSETS_FLAG | VARCHAR2 | 1 | Flag indicating that multiple assets can be associated to this maintenance work order. | ||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | 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. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
LOAD_REQUEST_ID | NUMBER | 18 | This column is used when loading data from the csv file to the interface table using the central ESS program. This is the request id for the job that did the move from UCM to the interface table. | ||
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
WIE_WORK_ORDERS_INT_N01 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE, ACTION_CODE |
WIE_WORK_ORDERS_INT_N02 | Non Unique | Default | PARTITION_NUMBER, INTERFACE_STATUS_CODE, ACTION_CODE |
WIE_WORK_ORDERS_INT_N03 | Non Unique | Default | INTERFACE_BATCH_ID, WORK_ORDER_NUMBER, ACTION_CODE |
WIE_WORK_ORDERS_INT_N04 | Non Unique | Default | LAST_UPDATE_DATE, INTERFACE_STATUS_CODE |
WIE_WORK_ORDERS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |
WIE_WORK_ORDERS_INT_U02 | Unique | Default | INTERFACE_BATCH_CODE, HEADER_NUMBER |