# DW_NS_INVENTORY_QUANTITY_CHANGE_F

This fact table contains the daily net quantity change for an item at specific location.

## Details

Module:

## Key Columns

inventoryidentifier, trandate

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
inventoryidentifier | VARCHAR2 | 64 |  | True | Inventory identifier is combination of item~location. |  |
trandate | TIMESTAMP |  |  | True | Posting or occurring date of this transaction. |  |
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
inventorylocation | NUMBER | 38 | 0 |  | Location that allows fulfillment. | DW_NS_location_D | id
subsidiary | NUMBER | 38 | 0 |  | Subsidiary identifier associated with this transaction. | DW_NS_subsidiary_D | id
quantity | NUMBER |  |  |  | Number or unit count of items used in the transaction. |  |

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