WIE_TRANSACTION_SERIALS_INT
This table stores the work order material transaction serials information.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
WIE_TXN_SERIALS_INT_PK |
INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | The unique identifier of a transaction serials 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 | 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. | |
| 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. | ||
| TXN_INTERFACE_ROW_ID | NUMBER | 18 | Represents the foreign key to the WIE_MATERIAL_TRANSACTIONS_INT interface table. This is a direct child of the material transaction and the multiple serials that are transacted are captured in this table. | ||
| LOT_INTERFACE_ROW_ID | NUMBER | 18 | When the item is lot and serial controlled, the Serials that are transacted in the lots are connected by a foreign key reference to the WIE_TRANSACTION_LOTS_INT table. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | The primary product identifier defined on the work order. This is an internal column and is de-normalized. | ||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number. This column is populated for lot and serial controlled items. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | Yes | Serial Number reference. Foreign key to INV_SERIAL_NUMBERS table | |
| SERIAL_NUMBER_TO | VARCHAR2 | 80 | Serial Number reference. Foreign key to INV_SERIAL_NUMBERS table. | ||
| PARENT_SERIAL_NUMBER | VARCHAR2 | 80 | The serial number of the parent product. When component serials are transacted (issued), users can optionally specify which parent serial these specific component serial goes in to. For serialization enabled jobs, these can happen when auto transactions are triggerd as assembly serials are completed at operations. | ||
| WO_SERIAL_TRANSACTION_ID | NUMBER | 18 | Internal Column: After successfully creating the interface row to the production table the SERIAL_TRANSACTION_ID value is persisted here. | ||
| PARTITION_NUMBER | NUMBER | The partition number for multi-threading. | |||
| DISCRIMINATOR | VARCHAR2 | 30 | Discriminator value for achieving entity level polymorphism. | ||
| 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 | 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. | |||
| SERIAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive flexfield structure defining column. - Used by WMS Only | ||
| CYCLES_SINCE_MARK | NUMBER | Cycles since mark for MRO industry. - Used by WMS Only | |||
| CYCLES_SINCE_NEW | NUMBER | Cycles since new for MRO industry. - Used by WMS Only | |||
| CYCLES_SINCE_OVERHAUL | NUMBER | Cycles since overhaul for MRO industry. - Used by WMS Only | |||
| CYCLES_SINCE_REPAIR | NUMBER | Cycles since repair for MRO industry. - Used by WMS Only | |||
| CYCLES_SINCE_VISIT | NUMBER | Cycles since visit for MRO industry. - Used by WMS Only | |||
| NUMBER_OF_REPAIRS | NUMBER | Number of repairs for MRO industry. - Used by WMS Only | |||
| TERRITORY_CODE | VARCHAR2 | 30 | Territory code for country of origin. | ||
| TIME_SINCE_MARK | NUMBER | Time since mark for MRO industry. - Used by WMS Only | |||
| TIME_SINCE_NEW | NUMBER | Time since new for MRO industry. - Used by WMS Only | |||
| TIME_SINCE_OVERHAUL | NUMBER | Time since overhaul for MRO industry. - Used by WMS Only | |||
| TIME_SINCE_REPAIR | NUMBER | Time since repair for MRO industry. - Used by WMS Only | |||
| TIME_SINCE_VISIT | NUMBER | Time since visit for MRO industry. - Used by WMS Only | |||
| C_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| C_ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive flexfield segment - Used By WMS Only | ||
| N_ATTRIBUTE1 | NUMBER | Descriptive flexfield segment - Used By WMS Only | |||
| N_ATTRIBUTE2 | NUMBER | Descriptive flexfield segment - Used By WMS Only | |||
| N_ATTRIBUTE3 | NUMBER | Descriptive flexfield segment - Used By WMS Only | |||
| N_ATTRIBUTE4 | NUMBER | Descriptive flexfield segment - Used By WMS Only | |||
| N_ATTRIBUTE5 | NUMBER | Descriptive flexfield segment - Used By WMS Only | |||
| N_ATTRIBUTE6 | NUMBER | Descriptive flexfield segment - Used By WMS Only | |||
| N_ATTRIBUTE7 | NUMBER | Descriptive flexfield segment - Used By WMS Only | |||
| N_ATTRIBUTE8 | NUMBER | Descriptive flexfield segment - Used By WMS Only | |||
| N_ATTRIBUTE9 | NUMBER | Descriptive flexfield segment - Used By WMS Only | |||
| N_ATTRIBUTE10 | NUMBER | Descriptive flexfield segment - Used By WMS Only | |||
| D_ATTRIBUTE1 | DATE | Descriptive flexfield segment - Used By WMS Only | |||
| D_ATTRIBUTE2 | DATE | Descriptive flexfield segment - Used By WMS Only | |||
| D_ATTRIBUTE3 | DATE | Descriptive flexfield segment - Used By WMS Only | |||
| D_ATTRIBUTE4 | DATE | Descriptive flexfield segment - Used By WMS Only | |||
| D_ATTRIBUTE5 | DATE | Descriptive flexfield segment - Used By WMS Only | |||
| D_ATTRIBUTE6 | DATE | Descriptive flexfield segment - Used By WMS Only | |||
| D_ATTRIBUTE7 | DATE | Descriptive flexfield segment - Used By WMS Only | |||
| D_ATTRIBUTE8 | DATE | Descriptive flexfield segment - Used By WMS Only | |||
| D_ATTRIBUTE9 | DATE | Descriptive flexfield segment - Used By WMS Only | |||
| D_ATTRIBUTE10 | DATE | Descriptive flexfield segment - Used By WMS Only | |||
| T_ATTRIBUTE1 | TIMESTAMP | Descriptive flexfield segment - Used By WMS Only | |||
| T_ATTRIBUTE2 | TIMESTAMP | Descriptive flexfield segment - Used By WMS Only | |||
| T_ATTRIBUTE3 | TIMESTAMP | Descriptive flexfield segment - Used By WMS Only | |||
| T_ATTRIBUTE4 | TIMESTAMP | Descriptive flexfield segment - Used By WMS Only | |||
| T_ATTRIBUTE5 | TIMESTAMP | Descriptive flexfield segment - Used By WMS Only |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| WIE_TXN_SERIALS_INT_N01 | Non Unique | Default | TXN_INTERFACE_ROW_ID | Obsolete |
| WIE_TXN_SERIALS_INT_N02 | Non Unique | Default | TXN_HEADER_NUMBER | Obsolete |
| WIE_TXN_SERIALS_INT_N03 | Non Unique | Default | TXN_HEADER_NUMBER, INTERFACE_STATUS_CODE | |
| WIE_TXN_SERIALS_INT_N04 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE | |
| WIE_TXN_SERIALS_INT_N05 | Non Unique | Default | INTERFACE_BATCH_CODE, INTERFACE_STATUS_CODE | |
| WIE_TXN_SERIALS_INT_N06 | Non Unique | Default | TXN_INTERFACE_ROW_ID, SERIAL_NUMBER | |
| WIE_TXN_SERIALS_INT_N07 | Non Unique | Default | TXN_INTERFACE_ROW_ID, INTERFACE_STATUS_CODE | |
| WIE_TXN_SERIALS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |