# DW_NS_INVENTORY_FSN_ANALYSIS_LOCATION_CF

This fact contains necessary attributes and measures to perform location level Inventory FSN Analysis across span of accounting periods including base periods, quarters and years of default fiscal calendar. FSN Analysis is an inventory analysis technique that classifies the items based on their sales and consumption rate from inventory. Items are classified as (F) Fast moving, (S) Slow moving and (N) Non moving.

## Details

Module:

## Key Columns

item, location, accountingperiod, fiscalcalendar

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
fiscalcalendar | NUMBER | 38 | 0 | True |  | DW_NS_fiscalCalendar_D | id
accountingperiod | NUMBER | 38 | 0 | True |  | DW_NS_accountingPeriod_D | id
item | NUMBER | 38 | 0 | True |  | DW_NS_item_D | id
location | NUMBER | 38 | 0 | True |  | DW_NS_location_D | id
SOURCE_RECORD_ID | VARCHAR2 | 999 |  |  | This column is for Oracle Internal use only. |  |
fsn_startdate | DATE |  |  |  |  |  |
fsn_enddate | DATE |  |  |  |  |  |
is_baseperiod | VARCHAR2 | 16 |  |  |  |  |
is_quarter | VARCHAR2 | 16 |  |  |  |  |
is_year | VARCHAR2 | 16 |  |  |  |  |
subsidiary | NUMBER | 38 | 0 |  |  | DW_NS_subsidiary_D | id
currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
cogs_amount | NUMBER |  |  |  |  |  |
location_agg_cogs_amount | NUMBER |  |  |  |  |  |
cogs_percent | NUMBER |  |  |  |  |  |
cumulative_cogs_percent | NUMBER |  |  |  |  |  |
cogs_rank | NUMBER |  |  |  |  |  |
has_netsales | VARCHAR2 | 16 |  |  |  |  |

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