DW_NS_INVENTORY_FSN_ANALYSIS_SUBSIDIARY_CF
This fact contains necessary attributes and measures to perform subsidiary 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, accountingperiod, fiscalcalendar, subsidiary
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 | |
| subsidiary | NUMBER | 38 | 0 | True | DW_NS_subsidiary_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 | |||||
| currency | NUMBER | 38 | 0 | DW_NS_currency_D | id | ||
| cogs_amount | NUMBER | ||||||
| subsidiary_agg_cogs_amount | NUMBER | ||||||
| cogs_percent | NUMBER | ||||||
| cumulative_cogs_percent | NUMBER | ||||||
| cogs_rank | NUMBER | ||||||
| has_netsales | VARCHAR2 | 16 |