DW_INV_ONHAND_QUANTITIES_SUMMARY_CF
This table stores consolidated onhand quantity information at unique stock keeping unit and location.
Details
Module: Inventory Management
Key Columns
ONHAND_SUMMARY_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ONHAND_SUMMARY_ID | NUMBER | 38 | 0 | True | Sequence Column for the rows | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. System | ||||
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Reference to the unique identifier for the inventory item #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
| ORGANIZATION_ID | NUMBER | 38 | 0 | This identifies the inventory organization | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| PRIMARY_UOM_CODE | VARCHAR2 | 16 | Primary unit of measure of the item | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| PRIMARY_ONHAND_QUANTITY | NUMBER | This is the quantity in the Primary Unit of Measure | |||||
| SUBINVENTORY_CODE | VARCHAR2 | 16 | Reference to the unique identifier for the subinventory #2 | DW_INV_SUBINVENTORY_D | SECONDARY_INVENTORY_NAME | ||
| RESERVABLE_TYPE | NUMBER | 38 | 0 | Indicates hard reservation eligibility in a Subinventory. | |||
| REVISION | VARCHAR2 | 32 | Revision of item if under revision control. | ||||
| LOCATOR_ID | NUMBER | 38 | 0 | This identifies the item locator. | DW_INV_LOCATOR_D | INVENTORY_LOCATION_ID | |
| LOT_NUMBER | VARCHAR2 | 128 | This number identifies an inventory lot. | ||||
| SECONDARY_UOM_CODE | VARCHAR2 | 16 | Secondary unit of measure that may have been used to do the material transaction | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| SECONDARY_ONHAND_QUANTITY | NUMBER | This is the secondary transaction quantity. | |||||
| OWNING_TYPE | VARCHAR2 | 32 | 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. | DW_INV_OWNING_TYPE_LKP_TL | INV_OWNING_TYPE_CODE | ||
| OWNING_ENTITY_ID | NUMBER | 38 | 0 | The owning type will determine the type of value used; for example, this will identify the supplier site for consignment from supplier. | |||
| OWNING_ORGANIZATION_ID | NUMBER | 38 | 0 | This identifies the owning organization or entity. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| OWNING_SUPPLIER_SITE_ID | NUMBER | 38 | 0 | This identifies the owning supplier site identifier | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID | |
| OWNING_PARTY_ID | NUMBER | 38 | 0 | This identifies the owning party | DW_PARTY_D | PARTY_ID | |
| PROJECT_ID | NUMBER | 38 | 0 | Identifier of the project used to stripe Inventory transactions | DW_PROJECT_D | PROJECT_ID | |
| TASK_ID | NUMBER | 38 | 0 | Identifier of the task used to stripe Inventory transactions | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID | |
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 16 | Code for the country of manufacture used to stripe Inventory transactions | DW_INSERT_COUNTRY_LKP_TL | INSERT_COUNTRY_LKP_CODE | ||
| SUBINVENTORY_LOCATION_ID | NUMBER | 38 | 0 | This identifies the location of the subinventory | DW_WORKER_LOCATION_D | LOCATION_ID | |
| BUSINESS_UNIT_ID | NUMBER | 38 | 0 | This identifies the business unit | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| INVENTORY_ORG_PROFIT_CENTER_BU_ID | NUMBER | 38 | 0 | Profit Center Business Unit Id of the Inventory Organization. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| LOT_EXPIRATION_DATE | DATE | Date at which lot will expire | DW_DAY_D | CALENDAR_DATE | |||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Name of the accounting calendar. #3 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. Examples are Weekly, Monthly, Quarterly. #3 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
| PRIMARY_LEDGER_ID | NUMBER | 38 | 0 | Business unit primary ledger identifier. | DW_LEDGER_D | LEDGER_ID | |
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Business unit legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
| CREATION_DATE | DATE | Indicates the date of the creation of the row | DW_DAY_D | CALENDAR_DATE | |||
| CREATION_TIMESTAMP | TIMESTAMP | Indicates the date and time of the creation of the row | |||||
| LAST_UPDATE_TIMESTAMP | TIMESTAMP | Indicates the date and time of the last update of the row. |
Notes
#1 In these cases in addition to the inventory item id column, ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D #2 In these cases in addition to the subinventory code column, ORGANIZATION_ID column should also be used for join with DW_INV_SUBINVENTORY_D #3 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on CREATION_DATE column