DW_INV_FISCAL_SNAPSHOTS_D

This table stores the fiscal snapshots needed for Inventory Balance aging

Details

Module: Inventory Management

Key Columns

FISCAL_PERIOD_SET_NAME, SNAPSHOT_PERIOD_START_DATE_ID, SNAPSHOT_PERIOD_END_DATE_ID, FISCAL_PERIOD_TYPE

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, 2024, Oracle and/or its affiliates.