# DW_NS_INVENTORY_AGING_CF

Inventory aging analysis breaks down stock based on how long items have been held in inventory, usually using predefined time intervals (e.g., 0–30, 31–60, 61–90 days). It supports decision-making by identifying slow-moving inventory, helping reduce holding costs, optimize stock levels, and improve margins. This fact table captures inventory aging information for items across multiple locations.

## Details

Module:

## Key Columns

item, aging_asofdate, location, trandate

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
aging_asofdate | DATE |  |  | True |  |  |
item | NUMBER | 38 | 0 | True |  | DW_NS_item_D | id
location | NUMBER | 38 | 0 | True |  | DW_NS_location_D | id
trandate | TIMESTAMP |  |  | True |  |  |
SOURCE_RECORD_ID | VARCHAR2 | 999 |  |  | This column is for Oracle Internal use only. |  |
is_carryover_inventory | VARCHAR2 | 16 |  |  |  |  |
is_latest_aging | VARCHAR2 | 16 |  |  |  |  |
subsidiary | NUMBER | 38 | 0 |  |  | DW_NS_subsidiary_D | id
currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
units | NUMBER | 38 | 0 |  |  | DW_NS_unitsTypeUom_D | internalid
unitcost | NUMBER |  |  |  |  |  |
received_quantity | NUMBER |  |  |  |  |  |
aging_quantity | NUMBER |  |  |  |  |  |
aging_value | NUMBER |  |  |  |  |  |
aging_days | NUMBER |  |  |  |  |  |

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