This table stores the fiscal snapshots needed for Inventory Balance aging
Module: Inventory Management
FISCAL_PERIOD_SET_NAME, SNAPSHOT_PERIOD_START_DATE_ID, SNAPSHOT_PERIOD_END_DATE_ID, FISCAL_PERIOD_TYPE
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.