INV_ONHAND_QUANTITIES_SUMMARY
INV_ONHAND_QUANTITIES_SUMMARY is a summary table that stores consolidated onhand quantity information at unique stock keeping unit and location. Every create/update/delete on INV_ONHAND_QUANTITIES_DETAIL table will update the INV_ONHAND_QUANTITIES_SUMMARY , based on the nature of the change. If the action is insert into INV_ONHAND_QUANTITIES_DETAIL, then INV_ONHAND_QUANTITIES_SUMMARY record is accordingly updated with the quantity if the record equivalent to the unique stock keeping unit already existed. If the record does not exist in the summary table then a new record is created.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_ONHAND_SUMMARY_PK |
ONHAND_SUMMARY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ONHAND_SUMMARY_ID | NUMBER | 18 | Yes | Primary key that identifies an Onhand Summary record. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Attribute indicating the unique identifier of the item. | |
| ITEM_NUMBER | VARCHAR2 | 300 | Yes | Any part, material, product or service that is unique as compared with other items by nature of its attributes in product data hub. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | This identifies the inventory organization. | |
| ORGANIZATION_CODE | VARCHAR2 | 18 | Yes | This identifies the inventory organization code. | |
| 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. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Yes | The principal unit of measure in which the quantity of an item is managed. | |
| SECONDARY_UOM_QUANTITY | NUMBER | This is the converted transaction quantity in units of the Secondary Unit of Measure. | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Attribute indicating the Secondary unit of measure through which the item can be transacted. | ||
| STOCKING_UOM_CODE | VARCHAR2 | 3 | Identifies the Stocking Quantity Unit of Measure. | ||
| STOCKING_UOM_QUANTITY | NUMBER | This is the converted transaction quantity in units of the Stocking Unit of Measure. | |||
| QUANTITY | NUMBER | Yes | This is the quantity in the Primary Unit of Measure. | ||
| LOT_CONTROL_CODE | NUMBER | Identifies the Lot control of an item. | |||
| SERIAL_NUMBER_CONTROL_CODE | NUMBER | Identifies the Serial control of an item. | |||
| REVISION_QTY_CONTROL_CODE | NUMBER | Identifies the Revision control of an item. | |||
| REVISION | VARCHAR2 | 18 | Revision of item if under revision control. | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Yes | This is name of the subinventory. | |
| LOT_NUMBER | VARCHAR2 | 80 | This number identifies an inventory lot. | ||
| LOT_GRADE | VARCHAR2 | 150 | Identifies the Grade of the inventory lot. | ||
| LOCATOR_ID | NUMBER | 18 | This identifies the Item Locator. | ||
| LOCATOR_NAME | VARCHAR2 | 2000 | Concatenated segments from the Inventory Locator KFF. | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions. | ||
| PROJECT_NUMBER | VARCHAR2 | 25 | This identifies the inventory project. | ||
| TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions. | ||
| TASK_NUMBER | VARCHAR2 | 100 | This identifies the inventory task. | ||
| OWNING_TYPE | VARCHAR2 | 30 | The owning type identifies the type of the entity who owns this quantity, in the context of consignment; the lookup type INV_OWNING_TYPES has the valid values. The record is consigned only if OWNING_TYPE is populated. | ||
| OWNING_TYPE_NAME | VARCHAR2 | 240 | The owning type identifies the type of the entity who owns this quantity, in the context of consignment; the lookup type INV_OWNING_TYPES has the valid values. The record is consigned only if OWNING_TYPE is populated. | ||
| OWNING_ENTITY_ID | NUMBER | 18 | The owning type will determine the type of value used; for example, this will identify the supplier site for consignment from supplier. | ||
| OWNING_ENTITY_NAME | VARCHAR2 | 240 | The owning type will determine the type of value used; for example, this will identify the supplier site for consignment from supplier. | ||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Identifies the Business Unit of an the organization. | |
| ONHAND_SUMMARY_KEY | VARCHAR2 | 1000 | Yes | Primary key that identifies an onhand record. The key is a combination of attributes that make up a unique SKU. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_ONHAND_SUMMARY_N1 | Non Unique | FUSION_TS_TX_DATA | INVENTORY_ITEM_ID, ORGANIZATION_ID |
| INV_ONHAND_SUMMARY_N2 | Non Unique | FUSION_TS_TX_DATA | ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID |
| INV_ONHAND_SUMMARY_N3 | Non Unique | FUSION_TS_TX_DATA | ORGANIZATION_ID, INVENTORY_ITEM_ID, LOT_NUMBER |
| INV_ONHAND_SUMMARY_N4 | Non Unique | FUSION_TS_TX_DATA | LOT_NUMBER, ORGANIZATION_ID |
| INV_ONHAND_SUMMARY_N5 | Non Unique | FUSION_TS_TX_DATA | ITEM_NUMBER, ORGANIZATION_ID |
| INV_ONHAND_SUMMARY_U1 | Unique | FUSION_TS_TX_DATA | ONHAND_SUMMARY_ID |
| INV_ONHAND_SUMMARY_U2 | Unique | FUSION_TS_TX_DATA | ONHAND_SUMMARY_KEY |