WIE_WORK_ORDER_DETAILS_INT
This is the interface table for the work order details. It is used to identify what it takes to make a product by allowing for definition of the work order operation details, work order operation materials and resources, as well as, product serials and lot information.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
WIE_WORK_ORDER_DETAILS_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 details 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_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_BATCH_CODE | VARCHAR2 | 30 | Yes | Represents the user identified code for the interface batch. | |
| 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 what action the system should perform on the detail entity. Valid values exist in the lookup with lookup type = ORA_WIE_WO_IMP_DETAIL_ACTION. | |
| LOAD_TYPE | VARCHAR2 | 30 | Yes | A code used to indicate the type of data this detail record contains. This indicates if the data being loaded represents the work order operation, work order operation material, work order operation resource, work order serials, etc. Valid values exist in the lookup with lookup type = ORA_WIE_WO_IMP_LOAD_TYPE. | |
| 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. | ||
| ORGANIZATION_ID | NUMBER | 18 | The organization identifier that represents the manufacturing plant to which this work order belongs. | ||
| WO_OPERATION_SEQ_NUMBER | NUMBER | Represents the user key in defining the order of operations within the work order. | |||
| STANDARD_OPERATION_CODE | VARCHAR2 | 30 | Reference to the standard operation code. If populated will be used to pull the standard definition for constructing the work order operation and its children. | ||
| STANDARD_OPERATION_ID | NUMBER | 18 | Reference to the standard operation identifier. If populated will be used to pull the standard definition for constructing the operation and its children. | ||
| OPERATION_NAME | VARCHAR2 | 120 | Name of the operation. It is a short description of the operation. | ||
| OPERATION_DESCRIPTION | VARCHAR2 | 240 | Description of the operation. It is a long description of the operation. | ||
| OPERATION_TYPE | VARCHAR2 | 30 | Specifies the type of the operation. Valid values are contained within the ORA_WIS_OPERATION_TYPE lookup. | ||
| WO_OPERATION_ID | NUMBER | 18 | The internal work order operation identifier. | ||
| WORK_CENTER_CODE | VARCHAR2 | 30 | The user key to the work center entity. | ||
| WORK_CENTER_ID | NUMBER | 18 | The internal identifier to the work center entity. | ||
| COUNT_POINT_OPERATION_FLAG | VARCHAR2 | 1 | Flag used to indicate if this is a count point operation. If an operation is a count point operation, then you have to manually complete it. Any operations in between the count points are automatically completed (i.e. backflushed, etc.). | ||
| AUTO_TRANSACT_FLAG | VARCHAR2 | 1 | Indicates whether both resources and materials are automatically charged based on the Supply Type or the Charge Type setups upon completion of the operation. | ||
| OPER_PLANNED_START_DATE | TIMESTAMP | Planned start date of this operation. | |||
| OPER_PLANNED_COMPL_DATE | TIMESTAMP | Planned completion date of this operation. | |||
| READY_QUANTITY | NUMBER | The quantity that is sitting in the inbound queue of each of the operation. This is an internal field and is not exposed in the XLSM template for import. | |||
| SHIPPING_DOCUMENTS_FLAG | VARCHAR2 | 1 | Flag used to determine whether shipping documents need to be generated for a supplier operation. Valid Values: 'Y' and 'N'. | ||
| OSP_ITEM_ID | NUMBER | 18 | Item that represents the value added service in a supplier operation. This is also commonly known as a partially finished assembly. | ||
| OSP_ITEM_NUMBER | VARCHAR2 | 300 | Item that represents the value added service in a supplier operation. This is also commonly known as a partially finished assembly. This is the user key for the supplier operation item. | ||
| SUPPLIER_ID | NUMBER | 18 | Represents the identifier of the suggested supplier for a supplier operation. | ||
| SUPPLIER_NAME | VARCHAR2 | 360 | Represents the name of the suggested supplier for a supplier operation. This is the user key for the supplier. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Represents the identifier of the suggested supplier site for a supplier operation. | ||
| SUPPLIER_SITE_CODE | VARCHAR2 | 15 | Represents the code of the suggested supplier site for a supplier operation. This is the user key for the supplier site. | ||
| LEAD_TIME_UOM | VARCHAR2 | 3 | Represents the unit of measure code for the fixed and/or variable lead time values on the supplier operation. | ||
| LEAD_TIME_UNIT_OF_MEASURE | VARCHAR2 | 25 | Represents the unit of measure for the fixed and/or variable lead time values on the supplier operation. | ||
| FIXED_LEAD_TIME | NUMBER | Represents the fixed lead time used to calculate the operation's start and end date for the supplier operation. | |||
| VARIABLE_LEAD_TIME | NUMBER | Represents the variable lead time used to calculate the operation's start and end date based on the operation quantity for the supplier operation. | |||
| ADDL_MTL_AT_MANUAL_ISSUE | VARCHAR2 | 30 | Indicates whether or not this operation allows additional materials to be added at manual issue. Valid values exist in the lookup with lookup type = ORA_WIS_ADDL_MANUAL_ISSUE_OPTS. | ||
| OP_COMPL_WITH_UNDER_ISSUE | VARCHAR2 | 30 | Indicates whether or not to allow operation completions with under issued material. Valid values exist in the lookup with lookup type = ORA_WIS_OP_COMPLETION_VAL_OPTS. | ||
| OP_COMPL_WITH_OPEN_EXCEPTIONS | VARCHAR2 | 30 | Indicates whether or not to allow operation completions with open exceptions. Valid values exist in the lookup with lookup type = ORA_WIS_OP_COMPLETION_VAL_OPTS. | ||
| MATERIAL_SEQ_NUMBER | NUMBER | A sequence number that represents the order of consumption of material at a given operation. | |||
| WO_OPERATION_MATERIAL_ID | NUMBER | 18 | The internal work order operation material identifier. System generated primary key. | ||
| MATERIAL_TYPE | VARCHAR2 | 30 | Type of material consumed by the operation. Valid values exist in the lookup with lookup type = ORA_WIS_WD_INPUT_MATERIAL. | ||
| MATERIAL_ITEM_NUMBER | VARCHAR2 | 300 | User key to the item to be specified as material in the work order operation material entity. | ||
| MATERIAL_ITEM_ID | NUMBER | 18 | Internal identifier to the item to be specified as material in the work order operation material entity. | ||
| MATERIAL_ITEM_REVISION | VARCHAR2 | 18 | Revision of the item when the item is revision controlled. | ||
| MATERIAL_QTY_PER_PRODUCT | NUMBER | The quantity per assembly of the component material. | |||
| MATERIAL_QUANTITY | NUMBER | Quantity of the material either consumed in the operation or produced from the operation. | |||
| MATERIAL_INVERSE_QUANTITY | NUMBER | The inverse of material quantity. | |||
| MATERIAL_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the specified material quantity. | ||
| MATERIAL_UNIT_OF_MEASURE | VARCHAR2 | 25 | Represents the unit of measure of the specified material quantity. | ||
| MATERIAL_BASIS_TYPE | VARCHAR2 | 30 | Indicates whether the material quantity is fixed (i.e. quantity per lot produced) or variable (i.e. quantity per item produced). Valid values exist in the lookup with lookup type = EGP_BOM_BASIS_TYPE. | ||
| MATERIAL_REQUIRED_DATE | TIMESTAMP | Date when the material is required in the operation. | |||
| MATERIAL_YIELD_FACTOR | NUMBER | Represents the yield factor of the component. | |||
| MATERIAL_INCL_IN_PLANNING | VARCHAR2 | 1 | Flag used to identify if the item should be included in planning. Valid Values: 'Y' and 'N'. | ||
| SUBSTITUTE_MATERIAL_ITEM_ID | NUMBER | 18 | Internal identifier to the substitute item. | ||
| SUBSTITUTE_QTY_PER_PRODUCT | NUMBER | Quantity per assembly of the substitute item. | |||
| 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. | ||
| SUPPLY_SUBINVENTORY | VARCHAR2 | 10 | The subinventory that supplies material to the operation. | ||
| SUPPLY_LOCATOR_ID | NUMBER | 18 | The locator within the supply subinventory that feed material in to the work order operations. | ||
| SUPPLY_LOCATOR_SEGMENT1 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT2 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT3 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT4 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT5 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT6 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT7 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT8 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT9 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT10 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT11 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT12 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT13 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT14 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT15 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT16 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT17 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT18 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT19 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| SUPPLY_LOCATOR_SEGMENT20 | VARCHAR2 | 40 | Supply Locator Segment which makes up the Locator key flex field. | ||
| RESOURCE_SEQ_NUMBER | NUMBER | This value is used to define the sequence in which resources work together in finishing the operation. For parallel work the same sequence number is used. | |||
| WO_OPERATION_RESOURCE_ID | NUMBER | 18 | This is the internal work order operation resource identifier. System generated primary key. | ||
| RESOURCE_CODE | VARCHAR2 | 30 | Represents the user key to the resource. | ||
| RESOURCE_ID | NUMBER | 18 | Represents the internal identifier to the resource which is a foreign key to the WIS_RESOURCES_B table. | ||
| RESOURCE_PRINCIPAL_FLAG | VARCHAR2 | 1 | When two or more resources are running in parallel (i.e. simultaneous resources which have the same sequence number), one and only one of them must be marked as the principal/primary resource. Planning will identify bottlenecks if the principal resource is not available when checking for capacity. | ||
| RESOURCE_USAGE_RATE | NUMBER | Represents the resource usage rate per unit of the primary product produced. | |||
| RESOURCE_REQUIRED_USAGE | NUMBER | Represents the total required usage for the resource based on the basis type, usage rate, and work order quantity. It is the usage per assembly unit (variable basis) or the usage per work order (fixed basis). For example, assuming usage rate = 1 hour and work order quantity = 10: If Basis = Variable, then required usage = 1 * 10 = 10 hours If Basis = Fixed, then required usage = 1 hour | |||
| RESOURCE_INVERSE_REQD_USAGE | NUMBER | The inverse of the required usage. | |||
| RESOURCE_BASIS_TYPE | VARCHAR2 | 30 | Indicates whether the resource quantity is fixed (i.e. usage per lot produced) or variable (i.e. usage per item produced). Valid values exist in the lookup with lookup type = EGP_BOM_BASIS_TYPE. | ||
| CHARGE_TYPE | VARCHAR2 | 30 | Indicates whether resource transactions are automatically generated and at what stage. Valid values exist in the lookup with lookup type = ORA_WIS_CHARGE_TYPE. | ||
| RESOURCE_ASSIGNED_UNITS | NUMBER | Number of resource units assigned to perform the operation. | |||
| RESOURCE_PLANNED_START_DATE | TIMESTAMP | Date when the resource is planned to start within the operation to which it is assigned. | |||
| RESOURCE_PLANNED_COMPL_DATE | TIMESTAMP | Date when the resource is planned to complete within the operation to which it is assigned. | |||
| RESOURCE_ACTIVITY_CODE | VARCHAR2 | 30 | Indicates the activity this production resource is going to perform at this operation. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_ACTIVITY. | ||
| RESOURCE_SCHEDULED_FLAG | VARCHAR2 | 30 | Flag used to indicate if this resource is scheduled or not. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_SCHEDULE. | ||
| WD_OP_ALT_RESOURCE_ID | NUMBER | 18 | Foreign key to WIS_WD_OP_ALT_RESOURCES.WD_OP_ALT_RESOURCE_ID. | ||
| WO_OP_MATERIAL_SERIAL_ID | NUMBER | 18 | Represents the unique identifier of the operation material serial. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | Serial Number that is attached to the primary product in the case of serialized manufacturing. | ||
| SERIAL_NUMBER_NEW | VARCHAR2 | 80 | This column is currently not being used. | ||
| WO_OP_MATERIAL_LOT_ID | NUMBER | 18 | Represents the unique identifier of the operation material lot. | ||
| PARENT_LOT_NUMBER | VARCHAR2 | 80 | Used to capture the parent lot number in manufacturing and is then passed on to Inventory.The value eventually resides in the PARENT_LOT_NUMBER column in INV_LOT_NUMBERS table. | ||
| LOT_NUMBER | VARCHAR2 | 80 | Lot Number reference. Foreign key to INV_LOT_NUMBERS table. | ||
| LOT_ASSOCIATED_QUANTITY | NUMBER | Represents the quantity associated to the particular lot number. | |||
| LOT_EXPIRATION_DATE | DATE | The date on which the inventory in the lot expires. | |||
| ASSET_ID | NUMBER | 18 | Represents the unique identifier of the asset on a maintenance work order. | ||
| ASSET_NUMBER | VARCHAR2 | 80 | Represents the user-key that uniquely identifies the asset on a maintenance work order. | ||
| WARRANTY_REPAIR_FLAG | VARCHAR2 | 1 | Flag to indicate that the work performed in this work order is covered by a supplier warranty. | ||
| MATCH_TO_TXN_CODE_FLAG | VARCHAR2 | 1 | Flag to indicate that the transactions performed in this work order must be coded with predefined transaction codes. | ||
| REASON_FOR_REPAIR_CODE_ID | NUMBER | 18 | Represents the unique identifier of the specific reason for repair for which the work order is created. Foreign key to cse_condition_event_codes_b table. | ||
| REASON_FOR_REPAIR_CODE | VARCHAR2 | 30 | Represents the user-key identifier of the specific reason for repair for which the work order is created. Foreign key to cse_condition_event_codes_b table. | ||
| REPAIR_TXN_CODE_ID | NUMBER | 18 | Represents the unique identifier of the reason to which this repair transaction is applicable. Foreign key to cse_condition_event_codes_b table. | ||
| REPAIR_TXN_CODE | VARCHAR2 | 30 | Represents the unique code that identifies of the reason to which this repair transaction is applicable. Foreign key to cse_condition_event_codes_b table. | ||
| WORK_ACCOMPLISHED_CODE_ID | NUMBER | 18 | Represents the unique identifier of the accomplishment code recorded at resource transaction. Foreign key to cse_condition_event_codes_b table. | ||
| WORK_ACCOMPLISHED_CODE | VARCHAR2 | 30 | Represents the unique code that identifies the accomplishment code recorded at resource transaction. Foreign key to cse_condition_event_codes_b table. | ||
| WO_OP_RESOURCE_INSTANCE_ID | NUMBER | 18 | Represents the unique identifier of the work order operation resource instance. | ||
| LABOR_INSTANCE_CODE | VARCHAR2 | 30 | A code used to identify the labor resource instance. This code uniquely identifies the labor resource instance within a manufacturing plant. | ||
| LABOR_INSTANCE_ID | NUMBER | 18 | Represents the foreign key to the labor resource instance record. | ||
| EQUIPMENT_INSTANCE_CODE | VARCHAR2 | 80 | A code used to identify the equipment resource instance. This code uniquely identifies the equipment resource instance within a manufacturing plant. | ||
| EQUIPMENT_INSTANCE_ID | NUMBER | 18 | Represents the foreign key to the equipment resource instance record. | ||
| RESOURCE_TYPE | VARCHAR2 | 30 | Indicates the type of this resource. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_TYPE. | ||
| WO_OPERATION_OUTPUT_ID | NUMBER | 18 | Represents the unique identifier of a work order operation output. | ||
| OUTPUT_SEQ_NUMBER | NUMBER | Indicates the sequence of this output line within this operation. | |||
| OUTPUT_TYPE | VARCHAR2 | 30 | Type of output produced by the operation. Valid values exist in the lookup with lookup type = ORA_WIS_WD_OUTPUT_MATERIAL. | ||
| COMPLETION_TYPE | VARCHAR2 | 30 | Indicates the completion type code. Valid values exist in the lookup with lookup type = ORA_WIS_OUTPUT_COMPL_TYPE. | ||
| PRIMARY_FLAG | VARCHAR2 | 1 | Indicates whether this is the primary output for the work order. Valid values are Y or N. | ||
| COST_ALLOCATION_PERCENTAGE | NUMBER | Indicates the cost percentage share of this output across all outputs. This column will be null for manually entered costs. | |||
| COMPL_SUBINVENTORY_CODE | VARCHAR2 | 10 | Indicates the subinventory into which this output line is produced. | ||
| COMPL_LOCATOR_ID | NUMBER | 18 | Indicates the locator into which this output line is produced. | ||
| 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. | ||
| RESEQUENCE_FLAG | VARCHAR2 | 1 | Flag used to indicate if the operation can be re-sequenced while executing the operation. Valid values are Y or N. | ||
| PROFILE_ID | NUMBER | 18 | Foreign key reference to HCM model profiles. | ||
| PROFILE_CODE | VARCHAR2 | 30 | The unique code which identifies the HCM model profile. | ||
| EQP_QUAL_PROFILE_ID | NUMBER | 18 | Foreign key reference to equipment qualification profiles. | ||
| EQP_QUAL_PROFILE_CODE | VARCHAR2 | 30 | The unique code which identifies the equipment qualification profile. | ||
| PARTITION_NUMBER | NUMBER | The partitioning number for multi-threading. | |||
| 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_WO_DETAILS_INT_N01 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE, LOAD_TYPE, ACTION_CODE |
| WIE_WO_DETAILS_INT_N02 | Non Unique | Default | INTERFACE_BATCH_ID, HEADER_NUMBER, INTERFACE_STATUS_CODE |
| WIE_WO_DETAILS_INT_N03 | Non Unique | Default | INTERFACE_BATCH_CODE |
| WIE_WO_DETAILS_INT_N04 | Non Unique | Default | PARTITION_NUMBER, INTERFACE_STATUS_CODE, LOAD_TYPE, ACTION_CODE |
| WIE_WO_DETAILS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |