# DW_NS_INVENTORY_SNAPSHOT_F

This fact contains daily end of the day on-hand inventory quantity information for a item at specific location.

## Details

Module:

## Key Columns

SNAPSHOT_DATE, ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ID | VARCHAR2 | 256 |  | True | Transaction Identifier. |  |
SNAPSHOT_DATE | DATE |  |  | True | Specific date on which values of attributes and metrics of this snapshot is based. |  |
SOURCE_RECORD_ID | VARCHAR2 | 999 |  |  | 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. |  |
item | NUMBER | 38 | 0 |  | Identifier of the item. | DW_NS_item_D | id
location | NUMBER | 38 | 0 |  | Location Identifier. | DW_NS_location_D | id
subsidiary | NUMBER | 38 | 0 |  | Subsidiary identifier associated with this transaction. |  |
quantityonhand | NUMBER |  |  |  | Item quantity on hand. |  |
onhandvalue | NUMBER |  |  |  | Inventory on hand value. |  |
currency | NUMBER | 38 | 0 |  | Transaction currency identifier. | DW_NS_currency_D | id

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