INV_BALANCE_TXNS_SERIAL_INT
This table is used for uploading serial number details for balance messages. The usage scenario is typically a 3PL scenarion when the execution system is not the fusion system. In that case the 3PL system would periodically send their onhand quantities to synch in both the systems. This table will be the interface to receive the serial number details for the onhand messages.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
INV_BAL_TXNS_SERIAL_INT_PK |
SERIAL_TXN_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SERIAL_TXN_INTERFACE_ID | NUMBER | 18 | Yes | Transaction serial identifier for the serial record. | |
| TXN_LOT_INTERFACE_ID | NUMBER | 18 | Transaction lot identifier for the lot record. This is a foreign key which maps to TXN_LOT_INTERFACE_ID in INV_BALANCE_TXNS_LOT. This identifier is specifically used for lot serial controlled items. | ||
| TRANSACTION_INTERFACE_ID | NUMBER | 18 | Yes | Transaction identifier for the serial record. This is a foreign key which maps to TRANSACTION_INTERFACE_ID in INV_BALANCE_TXNS. | |
| FROM_SERIAL_NUMBER | VARCHAR2 | 80 | Yes | The starting serial number for a serial range. | |
| TO_SERIAL_NUMBER | VARCHAR2 | 80 | Yes | The ending serial number for a serial range. | |
| FROM_VENDOR_SERIAL_NUMBER | VARCHAR2 | 80 | The starting vendor serial number for a vendor serial range. | ||
| TO_VENDOR_SERIAL_NUMBER | VARCHAR2 | 80 | The ending vendor serial number for a vendor serial range. | ||
| TERRITORY_CODE | VARCHAR2 | 2 | Territory code for the country of origin. | ||
| ORIGINATION_DATE | DATE | Creation date of the serial number such as a manufacture date. | |||
| STATUS_ID | NUMBER | 18 | Material status identifier for the serial number. | ||
| STATUS_NAME | VARCHAR2 | 240 | Material status name for the serial number. | ||
| STATUS_CODE | VARCHAR2 | 80 | Material status code for the serial number. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | 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_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_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. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. | |
| 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. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Used for Enterprise Service Scheduler. Indicates the Request identifier for the interface job that created the row. | ||
| INV_SERIAL_INTERFACE_NUM | VARCHAR2 | 30 | Alternate key to link the serial records corresponding to a balance message. Used for SAAS processing. | ||
| TERRITORY_SHORT_NAME | VARCHAR2 | 80 | Territory short name for the country of origin. | ||
| SERIAL_ADJ_STATUS | VARCHAR2 | 30 | Serial Numbers Adjustment Status. | ||
| DISC_SUBINVENTORY | VARCHAR2 | 10 | This is name of the Discrepant Subinventory Name. | ||
| DISC_LOCATOR_ID | NUMBER | 18 | This is Identifier of the Discrepant Locator. | ||
| DISC_PROJECT_ID | NUMBER | 18 | This is Identifier of the Discrepant Project Name. | ||
| DISC_TASK_ID | NUMBER | 18 | This is Identifier of the Discrepant Task Name. | ||
| DISC_COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | This is code of the Discrepant Country of origin. | ||
| COMMENTS | VARCHAR2 | 240 | Notes pertaining to the Current Serial Record. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_BALANCE_TXNS_SERIAL_INT | inv_balance_txns_lot_int | TXN_LOT_INTERFACE_ID |
| INV_BALANCE_TXNS_SERIAL_INT | inv_balance_txns_int | TRANSACTION_INTERFACE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_BALANCE_TXNS_SERIAL_INT_N1 | Non Unique | Default | TRANSACTION_INTERFACE_ID |
| INV_BALANCE_TXNS_SERIAL_INT_N2 | Non Unique | Default | TXN_LOT_INTERFACE_ID |
| INV_BALANCE_TXNS_SERIAL_INT_N3 | Non Unique | Default | LOAD_REQUEST_ID |
| INV_BALANCE_TXNS_SERIAL_INT_N4 | Non Unique | Default | INV_SERIAL_INTERFACE_NUM |
| INV_BALANCE_TXNS_SERIAL_INT_U1 | Unique | Default | SERIAL_TXN_INTERFACE_ID |