# DW_NS_InventoryBalance_F

This fact stores the quantity information for all items across locations at bin, lot/serial & status level.

## Details

Module:

## Key Columns

inventorynumber, binnumber, inventorystatus, location, item

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
item | NUMBER | 38 | 0 | True | Identifier of the item. | DW_NS_item_D | id
location | NUMBER | 38 | 0 | True | Location Identifier. | DW_NS_location_D | id
binnumber | NUMBER | 38 | 0 | True | Identifier of the bin associated with the item in a location. | DW_NS_bin_D | id
inventorynumber | NUMBER | 38 | 0 | True | The Serial/Lot number from which the picking will be performed. | DW_NS_inventoryNumber_D | id
inventorystatus | NUMBER | 38 | 0 | True | Identifier of the inventory Status associated with the item in a transaction. | DW_NS_inventoryStatus_D | id
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Composite key that consists of all PK values of the transaction. This consists combination of columns that defines the granularity of the table and identifies a row uniquely. |  |
base_unit | NUMBER | 38 | 0 |  | Identifier of the base units of measure used to measure the quantity. | DW_NS_unitsTypeUom_D | internalid
subsidiary | NUMBER | 38 | 0 |  | Subsidiary identifier associated with this transaction. | DW_NS_subsidiary_D | id
createddate | TIMESTAMP |  |  |  | Transaction creation date. |  |
lastmodifieddate | TIMESTAMP |  |  |  | Last Modification Date. |  |
quantityavailable | NUMBER |  |  |  | Available Quantity, Indicates the number of items available for ordering. |  |
quantityonhand | NUMBER |  |  |  | Item quantity on hand. |  |
quantitypicked | NUMBER |  |  |  | Quantity of items that have been picked and are waiting to be shipped. The number that you need to be fulfilling to complete sales/production. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.