INV_BALANCE_TXNS_LOT_INT
This table is used for uploading lot 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 sync in both the systems. This table will be the interface to receive the lot number details and the quantities for these onhand messages.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
INV_BALANCE_TXNS_LOT_INT_PK |
TXN_LOT_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TXN_LOT_INTERFACE_ID | NUMBER | 18 | Yes | Transaction lot identifier for the lot record. | |
| TRANSACTION_INTERFACE_ID | NUMBER | 18 | Yes | Transaction identifier for the balance message. Foreign key that maps to parent table INV_BALANCE_TXNS. | |
| LOT_NUMBER | VARCHAR2 | 80 | Yes | This number identifies the lot number. | |
| PRIMARY_QUANTITY | NUMBER | Primary uom quantity for the lot record. | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Uom code for primary unit of measure. | ||
| PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | 25 | Primary unit of measure for the balance message. | ||
| SECONDARY_QUANTITY | NUMBER | Secondary uom quantity for the lot record. | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Uom code for secondary unit of measure. | ||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | 25 | Secondary unit of measure for the balance message. | ||
| LOT_EXPIRATION_DATE | DATE | The date which indicates when Lot expires. | |||
| VENDOR_ID | NUMBER | 18 | Vendor identifier for the lot record. | ||
| VENDOR_NAME | VARCHAR2 | 240 | Vendor name for the lot record. | ||
| SUPPLIER_LOT_NUMBER | VARCHAR2 | 150 | Supplier lot number for the lot record. | ||
| TERRITORY_CODE | VARCHAR2 | 2 | Territory code for the country of origin. | ||
| TERRITORY_SHORT_NAME | VARCHAR2 | 80 | Territory short name for the country of origin. | ||
| ORIGINATION_TYPE | VARCHAR2 | 30 | This is the type of origination. | ||
| ORIGINATION_DATE | DATE | Origination date of the Lot which indicates the manufatured or creation date | |||
| GRADE_CODE | VARCHAR2 | 150 | This indicates the lot grade which is an attribute used to differentate lots. | ||
| STATUS_ID | NUMBER | 18 | Material status identifier for the lot number. | ||
| STATUS_CODE | VARCHAR2 | 80 | Material status code for the lot number. | ||
| STATUS_NAME | VARCHAR2 | 240 | Material status name for the lot number. | ||
| AGE | NUMBER | The age of the lot or sublot in days after the creatiom date. | |||
| PLACE_OF_ORIGIN | VARCHAR2 | 150 | A value indicating the place the lot number originated. | ||
| EXPIRATION_ACTION_CODE | VARCHAR2 | 32 | Code indicating the expiration action. The action that has to be performed once the lot expiration date is reached. | ||
| EXPIRATION_ACTION_NAME | VARCHAR2 | 80 | Name indicating the expiration action. The action that has to be performed once the lot expiration date is reached. | ||
| EXPIRATION_ACTION_DATE | DATE | Date for the expiration action, post which the lot is considered as expired. | |||
| HOLD_DATE | DATE | This date defines till what time the lot is to be set on hold from being consumed. | |||
| PARENT_LOT_NUMBER | VARCHAR2 | 80 | This identifies the parent lot number for the current Lot 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_LOT_INTERFACE_NUM | VARCHAR2 | 30 | Alternate key to link the lot numbers belonging to a balance message. Used for SAAS processing. | ||
| INV_SERIAL_INTERFACE_NUM | VARCHAR2 | 30 | Alternate key to link the serial and lot number balance messages. Used for SAAS processing. | ||
| PRIMARY_ADJ_QUANTITY | NUMBER | Adjustment quantity in primary unit of measure for the lot record. | |||
| SECONDARY_ADJ_QUANTITY | NUMBER | Adjustment quantity in secondary unit of measure for the lot record. | |||
| PRIMARY_SYSTEM_QUANTITY | NUMBER | System quantity in primary unit of measure for the lot record. | |||
| SECONDARY_SYSTEM_QUANTITY | NUMBER | System quantity in secondary unit of measure for the lot record. | |||
| COMMENTS | VARCHAR2 | 240 | Notes pertaining to the Current Lot Record. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_BALANCE_TXNS_LOT_INT | inv_balance_txns_int | TRANSACTION_INTERFACE_ID |
| inv_balance_txns_serial_int | inv_balance_txns_lot_int | TXN_LOT_INTERFACE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_BALANCE_TXNS_LOT_INT_N1 | Non Unique | Default | TRANSACTION_INTERFACE_ID |
| INV_BALANCE_TXNS_LOT_INT_N2 | Non Unique | Default | LOAD_REQUEST_ID |
| INV_BALANCE_TXNS_LOT_INT_N3 | Non Unique | Default | INV_LOT_INTERFACE_NUM |
| INV_BALANCE_TXNS_LOT_INT_N4 | Non Unique | Default | INV_SERIAL_INTERFACE_NUM |
| INV_BALANCE_TXNS_LOT_INT_U1 | Unique | Default | TXN_LOT_INTERFACE_ID |
| INV_BALANCE_TXNS_LOT_INT_U2 | Unique | Default | LOT_NUMBER, TRANSACTION_INTERFACE_ID |