INV_SERIAL_NUMBERS
INV_SERIAL_NUMBERS stores the definition of all seriallot numbers in inventory. Since the primary key consists of SERIAL_NUMBER, CURRENT_ORGANIZATION_ID, and INVENTORY_ITEM_ID, a serial number could exist in more than one organization or for different items depending on the setup.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_SERIAL_NUMBERS_PK |
CURRENT_ORGANIZATION_ID, SERIAL_NUMBER, INVENTORY_ITEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the inventory item. | Active | ||
| UNIQUE_DEVICE_IDENTIFIER | VARCHAR2 | 150 | The unique device identifier (UDI) is a unique numeric or alphanumeric code for a medical device. | ||||
| SERIAL_NUMBER | VARCHAR2 | 80 | Yes | This stores the item unit number. | Active | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | |||
| INITIALIZATION_DATE | DATE | Yes | This is the unit initialization date. | Active | |||
| COMPLETION_DATE | DATE | This is the unit completion date. | Active | ||||
| SHIP_DATE | DATE | This is the ship date of this unit. | Active | ||||
| CURRENT_STATUS | VARCHAR2 | 30 | Indicates the current status of this serial number. | Active | |||
| REVISION | VARCHAR2 | 18 | Revision of item if under revision control. | Active | |||
| LOT_NUMBER | VARCHAR2 | 80 | This number identifies an inventory lot. | Active | |||
| FIXED_ASSET_TAG | VARCHAR2 | 10 | This is the unit fixed asset tab number. | Active | |||
| RESERVED_ORDER_ID | NUMBER | 18 | Scheduled sales order reservation | Active | |||
| PARENT_ITEM_ID | NUMBER | 18 | This identifies the parent item. | Active | |||
| PARENT_SERIAL_NUMBER | VARCHAR2 | 80 | This is the component parent serial number. | Active | |||
| ORIGINAL_WIP_ENTITY_ID | NUMBER | 18 | This identifies the original WIP entity. | Active | |||
| ORIGINAL_UNIT_VENDOR_ID | NUMBER | 18 | This identifies the original unit supplier. | Active | |||
| VENDOR_SERIAL_NUMBER | VARCHAR2 | 80 | This is the supplier unit number. | Active | |||
| VENDOR_LOT_NUMBER | VARCHAR2 | 30 | This is the supplier lot number. | Active | |||
| LAST_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Last transaction source type identifier | Active | |||
| LAST_TRANSACTION_ID | NUMBER | 18 | This identifies the last inventory transaction. | Active | |||
| LAST_RECEIPT_ISSUE_TYPE | NUMBER | This is the last transaction type (receipt or issue). | Active | ||||
| LAST_TXN_SOURCE_NAME | VARCHAR2 | 30 | Name of the last transaction source. | Active | |||
| LAST_TXN_SOURCE_ID | NUMBER | 18 | Last transaction source identifier | Active | |||
| DESCRIPTIVE_TEXT | VARCHAR2 | 240 | This is the descriptive text for the serial number. | Active | |||
| CURRENT_SUBINVENTORY_CODE | VARCHAR2 | 10 | Indicates the current subinventory. | Active | |||
| CURRENT_LOCATOR_ID | NUMBER | 18 | Identifies the current location. | Active | |||
| CURRENT_ORGANIZATION_ID | NUMBER | 18 | Yes | Organization where the serial number is currently stored | Active | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | Active | ||
| GROUP_MARK_ID | NUMBER | 18 | Group identifier (used by Oracle Inventory for ensuring that serial numbers used by one user's session do not become available incorrectly to another user) | Active | |||
| LINE_MARK_ID | NUMBER | 18 | Used by Oracle Inventory for ensuring that serial numbers used by one user's session do not become available incorrectly to another user. The column is used by Oracle Inventory's serialnumber marking and unmarking routines | Active | |||
| LOT_LINE_MARK_ID | NUMBER | 18 | Identifier used in serial number marking and unmarking routines | Active | |||
| END_ITEM_UNIT_NUMBER | VARCHAR2 | 30 | This column is the model unit number. | Active | |||
| GEN_OBJECT_ID | NUMBER | 18 | Yes | This identifies the genealogy object. | Active | ||
| SERIAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive flexfield structure defining column - Usedby WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| TERRITORY_CODE | VARCHAR2 | 30 | Territory code for Country of Origin-- Usedby WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| ORIGINATION_DATE | DATE | Creation Date of the serial number such as manufacture date. - Used by WMS only | Active | ||||
| C_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| C_ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | ||
| D_ATTRIBUTE1 | DATE | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| D_ATTRIBUTE2 | DATE | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| D_ATTRIBUTE3 | DATE | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| D_ATTRIBUTE4 | DATE | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| D_ATTRIBUTE5 | DATE | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| D_ATTRIBUTE6 | DATE | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| D_ATTRIBUTE7 | DATE | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| D_ATTRIBUTE8 | DATE | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| D_ATTRIBUTE9 | DATE | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| D_ATTRIBUTE10 | DATE | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| N_ATTRIBUTE1 | NUMBER | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| N_ATTRIBUTE2 | NUMBER | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| N_ATTRIBUTE3 | NUMBER | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| N_ATTRIBUTE4 | NUMBER | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| N_ATTRIBUTE5 | NUMBER | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| N_ATTRIBUTE6 | NUMBER | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| N_ATTRIBUTE7 | NUMBER | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| N_ATTRIBUTE8 | NUMBER | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| N_ATTRIBUTE9 | NUMBER | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| N_ATTRIBUTE10 | NUMBER | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| T_ATTRIBUTE1 | TIMESTAMP | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | ||||
| T_ATTRIBUTE2 | TIMESTAMP | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | ||||
| T_ATTRIBUTE3 | TIMESTAMP | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | ||||
| T_ATTRIBUTE4 | TIMESTAMP | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | ||||
| T_ATTRIBUTE5 | TIMESTAMP | Descriptive flexfield segment- Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | ||||
| STATUS_ID | NUMBER | 18 | Status identifier - Used by WMS only | Active | |||
| TIME_SINCE_NEW | NUMBER | Time since new for MRO industry - Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| CYCLES_SINCE_NEW | NUMBER | Cycles since new for MRO industry - Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| TIME_SINCE_OVERHAUL | NUMBER | Time Since overhaul for MRO industry - Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| CYCLES_SINCE_OVERHAUL | NUMBER | Cycles since overhaul for MRO industry - Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| TIME_SINCE_REPAIR | NUMBER | Time Since repair for MRO industry - Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| CYCLES_SINCE_REPAIR | NUMBER | Cycles Since repair for MRO industry - Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| TIME_SINCE_VISIT | NUMBER | Time since Visit for MRO industry - Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| CYCLES_SINCE_VISIT | NUMBER | Cycles Since Visit for MRO industry - Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| TIME_SINCE_MARK | NUMBER | Time since Mark for MRO industry - Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| CYCLES_SINCE_MARK | NUMBER | Cycles Since Mark for MRO industry - Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| NUMBER_OF_REPAIRS | NUMBER | Number of repairs for MRO industry - Used by WMS only | Serial Attributes (INV_SERIAL_ATTRIBUTES) | Active | |||
| LPN_ID | NUMBER | 18 | License Plate Number Identifier of the item - Used by WMS only | Active | |||
| INSPECTION_STATUS | NUMBER | Status after Inspection of the Serial Number - Usedby WMS only | Active | ||||
| PREVIOUS_STATUS | NUMBER | Previous Status - Usedby WMS only | Active | ||||
| LPN_TXN_ERROR_FLAG | VARCHAR2 | 1 | Error flag for LPN Transaction -- Usedby WMS only | Active | |||
| WIP_ACCOUNTING_CLASS_CODE | VARCHAR2 | 10 | WIP Accounting class code -- Used by EAM | Active | |||
| MAINTAINABLE_FLAG | VARCHAR2 | 1 | Maintainable flag -- Used by EAM | Active | |||
| OWNING_DEPARTMENT_ID | NUMBER | 18 | Owning Department Identifier - Used by EAM only | Active | |||
| NETWORK_ASSET_FLAG | VARCHAR2 | 1 | Network asset flag -- Used by EAM | Active | |||
| FA_ASSET_ID | NUMBER | 18 | FA Asset Identifier - Used by EAM only | Active | |||
| PN_LOCATION_ID | NUMBER | 18 | PN Location Identifier - Used by EAM only | Active | |||
| EAM_LOCATION_ID | NUMBER | 18 | EAM Location Identifier - Used by EAM only | Active | |||
| ASSET_CRITICALITY_CODE | VARCHAR2 | 30 | Asset criticality code -- Used by EAM | Active | |||
| CATEGORY_ID | NUMBER | 18 | Category Identifier - Used by EAM only | Active | |||
| PROD_ORGANIZATION_ID | NUMBER | 18 | Prod Organization Identifier - Used by EAM only | Active | |||
| EQUIPMENT_ITEM_ID | NUMBER | 18 | Equipment Item Identifier - Used by EAM only | Active | |||
| EQP_SERIAL_NUMBER | VARCHAR2 | 80 | Equipment serial number -- Used by EAM | Active | |||
| ORGANIZATION_TYPE | NUMBER | Organization Type. The values are based on MTL_TP_TYPES lookup. | Active | ||||
| OWNING_ORGANIZATION_ID | NUMBER | 18 | This identifies the owning organization or entity. | Active | |||
| OWNING_TP_TYPE | NUMBER | Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. | Active | ||||
| PLANNING_ORGANIZATION_ID | NUMBER | 18 | Planning organization identifier | Active | |||
| PLANNING_TP_TYPE | NUMBER | Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup. | Active | ||||
| ONHAND_QUANTITIES_ID | NUMBER | 18 | Stores reference to the row in MTL_ONHAND_QUANTITIES which was created when the serial number came into stores. | Active | |||
| WIP_ENTITY_ID | NUMBER | 18 | Stores reference to WIP Entity Identifier in WIP_ENTITIES table | Active | |||
| OPERATION_SEQ_NUM | NUMBER | 18 | Stores reference to WIP Operation Sequence Number | Active | |||
| INTRAOPERATION_STEP_TYPE | NUMBER | Stores Reference to Lookup Code for Intraoperational Step in mfg_lookups | Active | ||||
| EAM_INSTANTIATION_FLAG | VARCHAR2 | 1 | Flag to indicate if EAM-rebuild serial number instantiation setups are complete. Setup includes copying parent item information like pm definition, meter, activity association into rebuild serial. | Active | |||
| EAM_LINEAR_LOCATION_ID | NUMBER | 18 | This identifies the linear location. | Active | |||
| AVAILABILITY_TYPE | NUMBER | This code indicates the type of availability. | Active | ||||
| INVENTORY_ATP_CODE | NUMBER | Code indicates inventory available to promise. | Active | ||||
| RESERVABLE_TYPE | NUMBER | Indicates hard reservation eligibility. | Active | ||||
| RESERVATION_ID | NUMBER | 18 | Conatins the reservation id of the corresponding reservation record for which the serial number is reserved | Active | |||
| DEPENDENT_ASSET_FLAG | VARCHAR2 | 1 | Flag indicates dependent asset. | Active | |||
| PARENT_LOT_NUMBER | VARCHAR2 | 30 | This is the parent lot number. Used by WMS only. | Active | |||
| OPERATIONAL_LOG_FLAG | VARCHAR2 | 1 | This flag controls operational log. | Active | |||
| OPERATIONAL_STATUS_FLAG | NUMBER | This flag indicates the operational status. | Active | ||||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | Active | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | Active | |||
| 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. | Active | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | |||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | |||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | |||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | |||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Serial numbers (INV_SERIAL_NUMBERS) | ||||
| INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes | ||||
| PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions | ||||
| TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions | ||||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions | ||||
| INV_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||||
| INV_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||||
| INV_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| LAST_RCV_TRANSACTION_ID | NUMBER | 18 | This column stores the unique identifier of the last receiving transaction performed for the serial against an expense or manufacturing destination order. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_SERIAL_NUMBERS | inv_org_parameters | CURRENT_ORGANIZATION_ID |
| INV_SERIAL_NUMBERS | inv_lot_numbers | INVENTORY_ITEM_ID, CURRENT_ORGANIZATION_ID, LOT_NUMBER |
| INV_SERIAL_NUMBERS | poz_suppliers | ORIGINAL_UNIT_VENDOR_ID |
| INV_SERIAL_NUMBERS | inv_material_statuses_b | STATUS_ID |
| INV_SERIAL_NUMBERS | inv_item_locations | CURRENT_LOCATOR_ID |
| INV_SERIAL_NUMBERS | inv_secondary_inventories | CURRENT_SUBINVENTORY_CODE, CURRENT_ORGANIZATION_ID |
| INV_SERIAL_NUMBERS | egp_item_org_associations | INVENTORY_ITEM_ID, CURRENT_ORGANIZATION_ID |
| INV_SERIAL_NUMBERS | inv_serial_numbers | CURRENT_ORGANIZATION_ID, PARENT_SERIAL_NUMBER, PARENT_ITEM_ID |
| INV_SERIAL_NUMBERS | inv_txn_source_types_b | LAST_TXN_SOURCE_TYPE_ID |
| INV_SERIAL_NUMBERS | inv_material_txns | LAST_TRANSACTION_ID |
| inv_lpn_interface | inv_serial_numbers | ORGANIZATION_ID, SERIAL_NUMBER, INVENTORY_ITEM_ID |
| inv_serial_numbers | inv_serial_numbers | CURRENT_ORGANIZATION_ID, PARENT_SERIAL_NUMBER, PARENT_ITEM_ID |
| inv_license_plate_numbers | inv_serial_numbers | ORGANIZATION_ID, SERIAL_NUMBER, INVENTORY_ITEM_ID |
| inv_material_status_history | inv_serial_numbers | ORGANIZATION_ID, INVENTORY_ITEM_ID, SERIAL_NUMBER |
| inv_txn_request_lines | inv_serial_numbers | ORGANIZATION_ID, SERIAL_NUMBER_START, INVENTORY_ITEM_ID |
| inv_txn_request_lines | inv_serial_numbers | ORGANIZATION_ID, SERIAL_NUMBER_END, INVENTORY_ITEM_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_SERIAL_NUMBERS_N1 | Non Unique | FUSION_TS_TX_IDX | CURRENT_ORGANIZATION_ID, CURRENT_SUBINVENTORY_CODE, CURRENT_LOCATOR_ID |
| INV_SERIAL_NUMBERS_N11 | Non Unique | FUSION_TS_TX_IDX | INVENTORY_ITEM_ID, CURRENT_ORGANIZATION_ID, RESERVATION_ID |
| INV_SERIAL_NUMBERS_N13 | Non Unique | FUSION_TS_TX_IDX | RESERVATION_ID |
| INV_SERIAL_NUMBERS_N2 | Non Unique | FUSION_TS_TX_IDX | INVENTORY_ITEM_ID, CURRENT_STATUS, CURRENT_ORGANIZATION_ID, CURRENT_LOCATOR_ID |
| INV_SERIAL_NUMBERS_N3 | Non Unique | FUSION_TS_TX_IDX | ORIGINAL_UNIT_VENDOR_ID, VENDOR_SERIAL_NUMBER |
| INV_SERIAL_NUMBERS_N4 | Non Unique | FUSION_TS_TX_IDX | UPPER("SERIAL_NUMBER") |
| INV_SERIAL_NUMBERS_N5 | Non Unique | FUSION_TS_TX_IDX | GROUP_MARK_ID, LINE_MARK_ID, LOT_LINE_MARK_ID |
| INV_SERIAL_NUMBERS_N6 | Non Unique | FUSION_TS_TX_IDX | CURRENT_STATUS, CURRENT_ORGANIZATION_ID, INVENTORY_ITEM_ID, CURRENT_SUBINVENTORY_CODE |
| INV_SERIAL_NUMBERS_N7 | Non Unique | FUSION_TS_TX_IDX | STATUS_ID |
| INV_SERIAL_NUMBERS_U1 | Unique | FUSION_TS_TX_IDX | CURRENT_ORGANIZATION_ID, SERIAL_NUMBER, INVENTORY_ITEM_ID |
| INV_SERIAL_NUMBERS_U2 | Unique | FUSION_TS_TX_IDX | INVENTORY_ITEM_ID, SERIAL_NUMBER |