WIE_TRANSACTION_LOTS_INT
This table stores the work order material transaction lot information.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
WIE_TXN_LOTS_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 lots 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 lots that are transacted are captured in this 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 | Yes | Lot Number reference. Foreign key to INV_LOT_NUMBERS table. | |
| PARENT_LOT_NUMBER | VARCHAR2 | 80 | Used to capture the parent lot number in manufacturing and is then passed on to Inventory during material transaction processing. The value eventually resides in the PARENT_LOT_NUMBER column in INV_LOT_NUMBERS table. | ||
| TRANSACTION_QUANTITY | NUMBER | Yes | Lot quantity that is being transacted. | ||
| SECONDARY_TRANSACTION_QUANTITY | NUMBER | Represents the secondary quantity for a lot controlled material transaction if the item is dual UOM enabled. | |||
| LOT_EXPIRATION_DATE | DATE | The date on which the inventory in the lot expires. | |||
| LOT_ORIGINATION_TYPE | VARCHAR2 | 30 | The type of origination of the lot. Valid values exist in the lookup with lookup type = INV_LOT_ORIGINATION_TYPE. | ||
| LOT_ORIGINATION_DATE | DATE | Date when the lot is originated. | |||
| LOT_HOLD_DATE | DATE | The date on which the lot has been put on hold. | |||
| WO_LOT_TRANSACTION_ID | NUMBER | 18 | Internal Column: After successfully creating the interface row to the production table the LOT_TRANSACTION_ID value is persisted here. | ||
| SERIAL_TRANSACTION_TEMP_ID | NUMBER | 18 | This is an internal column. Do not expose it via xlsm. We are adding this for the purpose of convenience. This column in the inv transactions interface world links the serials and lots for items that are serial and lot controlled. | ||
| PARENT_SERIAL_NUMBER | VARCHAR2 | 80 | The serial number of the parent product. When components are transacted (issued) from a lot and quantities are split across lots, users can optionally specify which parent serial, these specific components from the lot goes to. For serialization enabled jobs, these can happen when auto transactions are triggered as and when assembly serials are completed at operations. | ||
| 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 | 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. | ||
| LOT_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Lot attributes descriptive flexfield structure defining column. | ||
| AGE | NUMBER | The age of the lot or sublot in days after the creation date. - Used By WMS Only | |||
| BEST_BY_DATE | DATE | The date on or before which the lot or sublot is best used. - Used By WMS Only | |||
| CHANGE_DATE | DATE | Last modified date (as in the BRD). - Used By WMS Only | |||
| COLOR | VARCHAR2 | 150 | Name of the color. - Used By WMS Only | ||
| CURL_WRINKLE_FOLD | VARCHAR2 | 150 | This attribute is used in the pulp and paper industry to identify potential problems when feeding the paper through machinery. - Used By WMS Only | ||
| DATE_CODE | VARCHAR2 | 150 | A code identifying the date of packaging or assembly. - Used By WMS Only | ||
| DESCRIPTION | VARCHAR2 | 256 | Description for the Lot Number. - Used By WMS Only | ||
| ITEM_SIZE | NUMBER | The size of a given product, determined by visual inspection. - Used By WMS Only | |||
| LENGTH_UOM | VARCHAR2 | 3 | Unit of measure for measuring length. - Used By WMS Only | ||
| PLACE_OF_ORIGIN | VARCHAR2 | 150 | Country of Origin. - Used By WMS Only | ||
| RECYCLED_CONTENT | NUMBER | The content, usually expressed as a percentage, of the product that is made up of recycled materials. - Used By WMS Only | |||
| RETEST_DATE | DATE | This is the retest date. Used By WMS Only | |||
| TERRITORY_CODE | VARCHAR2 | 30 | Territory code for country of origin. | ||
| THICKNESS_UOM | VARCHAR2 | 3 | Unit of measure to measure thickness. - Used By WMS Only | ||
| VENDOR_ID | NUMBER | 18 | Supplier identification (from po_vendors table). - Used by WMS Only | ||
| VOLUME_UOM | VARCHAR2 | 3 | When defining the volume attribute the ability to identify a volume unit of measure such as cubic inches or cubic centimeters should also be included. - Used By WMS Only | ||
| WIDTH_UOM | VARCHAR2 | 3 | Unit of measure to measure width dimension of the lot. - 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_LOTS_INT_N01 | Non Unique | Default | LOT_NUMBER, TXN_INTERFACE_ROW_ID | Obsolete |
| WIE_TXN_LOTS_INT_N02 | Non Unique | Default | TXN_HEADER_NUMBER | Obsolete |
| WIE_TXN_LOTS_INT_N03 | Non Unique | Default | TXN_HEADER_NUMBER, INTERFACE_STATUS_CODE | |
| WIE_TXN_LOTS_INT_N04 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_STATUS_CODE | |
| WIE_TXN_LOTS_INT_N05 | Non Unique | Default | INTERFACE_BATCH_CODE, INTERFACE_STATUS_CODE | |
| WIE_TXN_LOTS_INT_N06 | Non Unique | Default | TXN_INTERFACE_ROW_ID, LOT_NUMBER | |
| WIE_TXN_LOTS_INT_N07 | Non Unique | Default | TXN_INTERFACE_ROW_ID, INTERFACE_STATUS_CODE | |
| WIE_TXN_LOTS_INT_U01 | Unique | Default | INTERFACE_ROW_ID |