# DW_INV_FISCAL_SNAPSHOTS_D

This table stores the fiscal snapshots needed for Inventory Balance aging

## Details

Module: Inventory Management

## Key Columns

FISCAL_PERIOD_TYPE, FISCAL_PERIOD_SET_NAME, SNAPSHOT_PERIOD_END_DATE_ID, SNAPSHOT_PERIOD_START_DATE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SNAPSHOT_PERIOD_END_DATE_ID | NUMBER | 38 | 0 | True | Snapshot Date (Fiscal Calendar Period End Date) (YYYYMMDD) | DW_FISCAL_DAY_D | FISCAL_PERIOD_END_DATE_ID
SNAPSHOT_PERIOD_START_DATE_ID | NUMBER | 38 | 0 | True | Snapshot Date (Fiscal Calendar Period End Date) (YYYYMMDD) | DW_FISCAL_DAY_D | FISCAL_PERIOD_END_DATE_ID
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  | True | Fiscal calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  | True | Fiscal period type. | DW_FISCAL_PERIOD_D | FISCAL_PERIOD_TYPE
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System |  |
FISCAL_PERIOD_START_DATE | TIMESTAMP |  |  |  | Fiscal Period Start Date | DW_FISCAL_PERIOD_D | FISCAL_PERIOD_START_DATE
FISCAL_PERIOD_END_DATE | TIMESTAMP |  |  |  | Fiscal Period End Date | DW_FISCAL_PERIOD_D | FISCAL_PERIOD_END_DATE
PERIOD_SEQUENCE | NUMBER | 38 | 0 |  | Period number to identiy latest and oldest period. |  |

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