WIE_RESOURCE_TRANSACTIONS_INT
This is the interface table for work order resource transactions. Production progress updates, in terms of resource requirements, are interfaced from either third party systems or from contract manufacturers via this interface table.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
WIE_RSC_TRANSACTIONS_INT_PK |
INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | The unique identifier of a resource transaction 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 | 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. | |
| TXN_HEADER_NUMBER | VARCHAR2 | 18 | This is a user loaded key that uniquely identifies the transaction within the batch. This user key will be used as a handle to connect the child entities (i.e. the WIE_TRANSACTION_LOTS_INT and WIE_TRANSACTION_SERIALS_INT tables) to this parent transaction table. | ||
| ORGANIZATION_CODE | VARCHAR2 | 30 | The organization code that represents the manufacturing plant to which this resource transaction is performed. | ||
| ORGANIZATION_ID | NUMBER | 18 | The organization identifier that represents the manufacturing plant to which this resource transaction is performed. | ||
| WORK_CENTER_CODE | VARCHAR2 | 30 | Represents the user-key for the work center to which this resource is charged. | ||
| WORK_CENTER_ID | NUMBER | 18 | The identifier of the work center to which this resource is charged. | ||
| WORK_ORDER_NUMBER | VARCHAR2 | 120 | Represents the user-facing identifier of the work order. Resource transactions are always performed in the context of a work order. | ||
| WORK_ORDER_ID | NUMBER | 18 | Represents the internal identifier of the work order. Resource transactions are always performed in the context of a work order. | ||
| WO_OPERATION_SEQ_NUMBER | NUMBER | Represents the work order operation sequence from which this resource transaction is being performed. | |||
| WO_OPERATION_ID | NUMBER | 18 | The internal identifier of the operation from which the resource quantity is transacted. | ||
| WO_RESOURCE_SEQ_NUMBER | NUMBER | Represents the sequence number of the resource associated to this work order operation resource transaction. | |||
| WO_OPERATION_RESOURCE_ID | NUMBER | 18 | Represents the work order operation resource for the resource being transacted. | ||
| RESOURCE_CODE | VARCHAR2 | 30 | The user key for the resource against which the quantity is transacted. | ||
| RESOURCE_ID | NUMBER | 18 | The internal identifier of the resource against which the quantity is transacted. | ||
| RESOURCE_ACTIVITY_CODE | VARCHAR2 | 30 | Indicates the activity this production resource is performing at this operation. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_ACTIVITY. | ||
| 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. | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifies the type of the resource transaction. Valid values are listed in the lookup with lookup type = ORA_WIE_TRANSACTION_TYPES. | |
| TRANSACTION_DATE | TIMESTAMP | Yes | Date when the resource transaction is performed. | ||
| TRANSACTION_QUANTITY | NUMBER | Yes | Resource quantity that is being transacted. | ||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the resource quantity being transacted. | ||
| TRANSACTION_UNIT_OF_MEASURE | VARCHAR2 | 25 | Represents the unit of measure of the resource quantity being transacted. | ||
| SOURCE_SYSTEM_TYPE | VARCHAR2 | 30 | Indicates the type of source system (i.e. internal or external) from which data is being imported. Valid values exist in the lookup with lookup type = ORA_WIE_SOURCE_SYSTEM_TYPE. | ||
| SOURCE_SYSTEM_CODE | VARCHAR2 | 30 | A code used to indicate the source system from which data is being imported. Depending on the source system type, this value could represent an internal Fusion product code or the actual trading community (TCA) source system reference. | ||
| SOURCE_SYSTEM_ID | NUMBER | Represents the identifier of the source system. If the source system type = "INTERNAL" this value equates to the application id. If "EXTERNAL", then it is the source system as defined in the trading community (TCA) source systems table. | |||
| 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. | ||
| WO_OP_TXN_INTERFACE_ROW_ID | NUMBER | 18 | This is an internal column that is used to link backflush resource transaction interface records to an associated operation transaction interface record. | ||
| WO_OPERATION_TRANSACTION_ID | NUMBER | 18 | When the auto-transact flag is checked at the operation level, the operation completion that moves the primary product quantity out of the operation triggers the creation of resource transactions. In such cases, this column will contain the operation transaction id that triggered this resource transaction. | ||
| WO_RESOURCE_TRANSACTION_ID | NUMBER | 18 | To complete the interface cycle, the resource transaction processor updates this column with the id of the transaction in the history table after successfully processing the transaction. | ||
| 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. | ||
| REASON_FOR_REPAIR_CODE_ID | NUMBER | 18 | Represents the unique identifier of the reason for which this repair operation is performed. Foreign key to cse_condition_event_codes_b table. | ||
| REASON_FOR_REPAIR_CODE | VARCHAR2 | 30 | Represents the unique code that identifies the reason for which this repair operation is performed. Foreign key to cse_condition_event_codes_b table. | ||
| REPAIR_TXN_CODE_ID | NUMBER | 18 | Represents the unique identifier of the code to which this repair transaction is performed. Foreign key to cse_condition_event_codes_b table. | ||
| REPAIR_TXN_CODE | VARCHAR2 | 30 | Represents the unique code that identifies the code to which this repair transaction is performed. 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. | ||
| WORKER_ID | NUMBER | The partitioning number for multi-threading. Internal column. | |||
| 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. | ||
| 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_RSC_TRANSACTIONS_INT_N01 | Non Unique | Default | WORK_ORDER_ID |
| WIE_RSC_TRANSACTIONS_INT_N02 | Non Unique | Default | WORK_ORDER_NUMBER, ORGANIZATION_CODE |
| WIE_RSC_TRANSACTIONS_INT_N03 | Non Unique | Default | WORK_ORDER_NUMBER, ORGANIZATION_ID |
| WIE_RSC_TRANSACTIONS_INT_N04 | Non Unique | Default | WORKER_ID, INTERFACE_STATUS_CODE, TRANSACTION_TYPE_CODE |
| WIE_RSC_TRANSACTIONS_INT_N05 | Non Unique | Default | REQUEST_ID, INTERFACE_STATUS_CODE, TRANSACTION_TYPE_CODE |
| WIE_RSC_TRANSACTIONS_INT_N06 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE |
| WIE_RSC_TRANSACTIONS_INT_N07 | Non Unique | Default | INTERFACE_BATCH_CODE, INTERFACE_STATUS_CODE |
| WIE_RSC_TRANSACTIONS_INT_N08 | Non Unique | Default | LAST_UPDATE_DATE, INTERFACE_STATUS_CODE |
| WIE_RSC_TRANSACTIONS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |