INV_BALANCE_TXNS_INT
This table is used for uploading 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 these onhand messages.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
INV_BALANCE_TXNS_INT_PK |
TRANSACTION_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_INTERFACE_ID | NUMBER | 18 | Yes | Transaction identifier for the balance message. | |
| DOCUMENT_NUMBER | NUMBER | 18 | Document number for the balance message. Used for identifying a set of balance messages. | ||
| MESSAGE_CREATION_DATE | DATE | Message creation date for the balance message. | |||
| SOURCE_SYSTEM_ID | NUMBER | 18 | Source system identifier for the balance message. Used to identify the system from which the balance messages has originated. | ||
| SOURCE_SYSTEM_NAME | VARCHAR2 | 80 | Source system name for the balance message. Used to identify the system from which the balance messages has originated. | ||
| SOURCE_SYSTEM_CODE | VARCHAR2 | 30 | Source system code for the balance message. Used to identify the system from which the balance messages has originated. | ||
| ORGANIZATION_ID | NUMBER | 18 | Organization identifier for the balance message. | ||
| ORGANIZATION_NAME | VARCHAR2 | 240 | Organization name for the balance message. | ||
| ORGANIZATION_CODE | VARCHAR2 | 18 | Organization code for the balance message. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item identifier for the balance message. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Inventory item name for the balance message. | ||
| REVISION | VARCHAR2 | 18 | Item revision for the balance message. | ||
| SUBINVENTORY | VARCHAR2 | 10 | Subinventory for the balance message. | ||
| LOCATOR_ID | NUMBER | 18 | Locator identifier for the balance message. | ||
| LOCATOR_NAME | VARCHAR2 | 255 | Locator name for the balance message. | ||
| PRIMARY_UOM_QUANTITY | NUMBER | Primary uom quantity for the balance message. | |||
| 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_UOM_QUANTITY | NUMBER | Secondary uom quantity for the balance message. | |||
| 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. | ||
| OWNING_TRADING_PARTNER_TYPE | VARCHAR2 | 30 | Owning type for the balance message. | ||
| OWNING_ORGANIZATION_ID | NUMBER | 18 | Owning organization identifier for the balance message. | ||
| OWNING_ORGANIZATION_CODE | VARCHAR2 | 240 | Owning organization code for the balance message. | ||
| OWNING_ORGANIZATION_NAME | VARCHAR2 | 240 | Owning organization name for the balance message. | ||
| PRC_BU_NAME | VARCHAR2 | 240 | Procuring business unit for the balance message in case of consigned quantity. | ||
| VENDOR_NAME | VARCHAR2 | 240 | Vendor name for the balance message in case of consigned quantities. | ||
| VENDOR_NUMBER | VARCHAR2 | 30 | Vendor number for the balance message in case of consigned quantity. | ||
| CONSIGNMENT_AGREEMENT_NUM | VARCHAR2 | 30 | Consignment agreement number for the consigned material. | ||
| ACCOUNT_ALIAS_ID | NUMBER | 18 | Account alias identifier for the balance message. | ||
| ACCOUNT_ALIAS_NAME | VARCHAR2 | 255 | Account alias name for the balance message. | ||
| AGING_ONSET_DATE | DATE | Aging onset date for the balance message. | |||
| 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. | ||
| PROCESSING_STATUS | VARCHAR2 | 30 | Processing status of the balance record | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Load request identifier. Used for SAAS Processing | ||
| INV_LOT_SERIAL_NUM | VARCHAR2 | 30 | Lot serial interface number. Used for sequencing in SAAS Processing | ||
| ERROR_MESSAGE_CODE | VARCHAR2 | 50 | Error message code which indicates reason for the failure of the balance message. | ||
| ERROR_MESSAGE_TEXT | VARCHAR2 | 240 | Error message text which indicates reason for the failure of the balance message. | ||
| PRIMARY_ADJ_QUANTITY | NUMBER | Adjustment quantity for the balance message in the primary unit of measure. | |||
| SECONDARY_ADJ_QUANTITY | NUMBER | Quantity for the balance message in secondary unit of measure. | |||
| PRIMARY_SYSTEM_QUANTITY | NUMBER | System quantity for the balance message in primary unit of measure . | |||
| SECONDARY_SYSTEM_QUANTITY | NUMBER | System quantity for the balance message in secondary unit of measure. | |||
| TXN_INTERFACE_GROUP_ID | NUMBER | 18 | Transaction interface group identifier for the balance message. | ||
| TRANSACTION_SOURCE_CODE | VARCHAR2 | 30 | Transaction source code for the balance message. | ||
| ITEM_LOT_CONTROL_CODE | VARCHAR2 | 30 | Inventory Item Lot Control Code. | ||
| ITEM_SERIAL_CONTROL_CODE | VARCHAR2 | 30 | Inventory Item Serial Number control code. | ||
| ITEM_REVISION_QTY_CONTROL_CODE | VARCHAR2 | 30 | Inventory Item Revision quantity control code. | ||
| ITEM_UNIT_COST | NUMBER | This is cost per unit of this item. | |||
| CURRENCY | VARCHAR2 | 15 | Currency Code of the Item Cost. | ||
| COMMENTS | VARCHAR2 | 240 | Notes pertaining to the Current Balance Record. | ||
| ADJUSTMENT_PROCESSED_DATE | TIMESTAMP | Date and Time Of Balance Adjustment Processed | |||
| PRIMARY_POS_ADJ_QUANTITY | NUMBER | Positive Adjustment quantity for the balance message in the primary unit of measure. | |||
| PRIMARY_NEG_ADJ_QUANTITY | NUMBER | Negative Adjustment quantity for the balance message in the primary unit of measure. | |||
| SECONDARY_POS_ADJ_QUANTITY | NUMBER | Positive Adjustment Quantity for the balance message in secondary unit of measure. | |||
| SECONDARY_NEG_ADJ_QUANTITY | NUMBER | Negative Adjustment Quantity for the balance message in secondary unit of measure. | |||
| 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. | ||
| INV_PROJECT | VARCHAR2 | 25 | Name of the project used to stripe Inventory transactions. | ||
| TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions. | ||
| INV_TASK | VARCHAR2 | 100 | Name 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. | ||
| COUNTRY_OF_ORIGIN_NAME | VARCHAR2 | 80 | Name 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| inv_balance_txns_serial_int | inv_balance_txns_int | TRANSACTION_INTERFACE_ID |
| inv_balance_txns_lot_int | inv_balance_txns_int | TRANSACTION_INTERFACE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_BALANCE_TXNS_INT_N1 | Non Unique | Default | TXN_INTERFACE_GROUP_ID |
| INV_BALANCE_TXNS_INT_N2 | Non Unique | Default | PROCESSING_STATUS, LOAD_REQUEST_ID |
| INV_BALANCE_TXNS_INT_N3 | Non Unique | Default | INV_LOT_SERIAL_NUM |
| INV_BALANCE_TXNS_INT_U1 | Unique | Default | TRANSACTION_INTERFACE_ID |