This view will have the FISCAL_DAY_D data after applying the filter ADJUSTMENT_PERIOD_FLAG IN ('N','~NOVALUE~')
Module:
FISCAL_DAY_DATE_ID, FISCAL_PERIOD_TYPE, FISCAL_PERIOD_NAME, FISCAL_PERIOD_SET_NAME
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
FISCAL_PERIOD_NAME | VARCHAR2 | 64 | True | Accounting period name. | |||
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | True | Accounting calendar name. #1 | |||
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | True | Accounting period type. | |||
FISCAL_DAY_DATE_ID | NUMBER | 38 | 0 | True | Fiscal day in YYYYMMDD format. | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Source record identifier. Value is derived from a combination of accounting calendar name, accounting period type, accounting period nameand fiscal day in YYYYMMDD format. | ||||
FISCAL_PERIOD_SORT_KEY | VARCHAR2 | 256 | Enables sorting by fiscal calendar and fiscal period. | ||||
FISCAL_DAY_DATE | DATE | Date of the fiscal day. | |||||
FISCAL_DAY_CODE | VARCHAR2 | 64 | Name of the fiscal day. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=DAYS_OF_WEEK. | ||||
ADJUSTMENT_PERIOD_FLAG | VARCHAR2 | 16 | Indicates an adjustment period for the fiscal year. | ||||
FISCAL_PERIOD_NUMBER | NUMBER | 38 | 0 | Accounting period number. | |||
FISCAL_PERIOD_START_DATE | DATE | Start date of the fiscal period. | |||||
FISCAL_PERIOD_START_DATE_ID | NUMBER | 38 | 0 | First day of fiscal day in YYYYMMDD format. | |||
FISCAL_PERIOD_END_DATE | DATE | End date of the fiscal period. | |||||
FISCAL_PERIOD_END_DATE_ID | NUMBER | 38 | 0 | Last day of fiscal period in YYYYMMDD format. | |||
FISCAL_QUARTER_NUMBER | NUMBER | 38 | 0 | Fiscal quarter. Possible values are 1, 2, 3, and 4. | |||
FISCAL_QUARTER_CODE | VARCHAR2 | 16 | Fiscal quarter . For example, 1999Q2. | ||||
FISCAL_QUARTER_START_DATE | DATE | Start date of the fiscal quarter. | |||||
FISCAL_QUARTER_START_DATE_ID | NUMBER | 38 | 0 | First day of fiscal quarter in YYYYMMDD format. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
FISCAL_QUARTER_END_DATE | DATE | End date of the fiscal quarter. | |||||
FISCAL_QUARTER_END_DATE_ID | NUMBER | 38 | 0 | Last day of fiscal quarter in YYYYMMDD format. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT | |
FISCAL_HALF_NUMBER | NUMBER | 38 | 0 | Fiscal half year. Possible values are 1 and 2. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE | |
FISCAL_YEAR_NUMBER | NUMBER | 38 | 0 | Fiscal Year in YYYY format. | DW_COST_CENTER_D | COST_CENTER_SEGMENT | |
FISCAL_YEAR_START_DATE | DATE | Start date of the fiscal year. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE | |||
FISCAL_YEAR_START_DATE_ID | NUMBER | 38 | 0 | First day of fiscal year in YYYYMMDD format. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT | |
FISCAL_YEAR_END_DATE | DATE | End date of the fiscal year. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE | |||
FISCAL_YEAR_END_DATE_ID | NUMBER | 38 | 0 | Last day of fiscal year in YYYYMMDD format. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | |
FISCAL_YEAR_TOTAL_WEEKS | NUMBER | 38 | 0 | Number of weeks in this fiscal year. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | |
FISCAL_YEAR_TOTAL_DAYS | NUMBER | 38 | 0 | Number of days in this fiscal year. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | |
FISCAL_DAY_OF_YEAR | NUMBER | 38 | 0 | Day number in the fiscal year. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | |
FISCAL_DAY_OF_QUARTER | NUMBER | 38 | 0 | Day number in the fiscal quarter. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | |
FISCAL_DAY_OF_PERIOD | NUMBER | 38 | 0 | Day number in the fiscal period. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | |
FIRST_DAY_FISCAL_PERIOD_FLAG | VARCHAR2 | 16 | Indicates that this day is the first day of fiscal period. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
FIRST_DAY_FISCAL_QUARTER_FLAG | VARCHAR2 | 16 | Indicates that this day is the first day of fiscal quarter. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
FIRST_DAY_FISCAL_YEAR_FLAG | VARCHAR2 | 16 | Indicates that this day is the first day of fiscal year. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
LAST_DAY_FISCAL_PERIOD_FLAG | VARCHAR2 | 16 | Indicates that this day is the last day of fiscal period. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
LAST_DAY_FISCAL_QUARTER_FLAG | VARCHAR2 | 16 | Indicates that this day is the last day of fiscal quarter. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
LAST_DAY_FISCAL_YEAR_FLAG | VARCHAR2 | 16 | Indicates that this day is the last day of fiscal year. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
FISCAL_WEEK_NUMBER | NUMBER | 38 | 0 | Week number in the fiscal year. Possible values are 1, 2, and so on. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | |
FISCAL_WEEK_START_DATE | DATE | Start date of the fiscal week. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | |||
FISCAL_WEEK_START_DATE_ID | NUMBER | 38 | 0 | First day of fiscal week in YYYYMMDD format. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | |
FISCAL_WEEK_END_DATE | DATE | End date of the fiscal week. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | |||
FISCAL_WEEK_END_DATE_ID | NUMBER | 38 | 0 | Last day of fiscal week in YYYYMMDD format. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | |
FIRST_DAY_FISCAL_WEEK_FLAG | VARCHAR2 | 16 | Indicates that this day is the first day of fiscal week. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
LAST_DAY_FISCAL_WEEK_FLAG | VARCHAR2 | 16 | Indicates that this day is the last day of fiscal week. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
FISCAL_DAY_OF_WEEK | NUMBER | 38 | 0 | Day number in the fiscal week. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | |
CURRENT_FISCAL_DAY_CODE | VARCHAR2 | 16 | Indicates the current fiscal day. Possible value is Current. | ||||
CURRENT_FISCAL_WEEK_CODE | VARCHAR2 | 16 | Indicates that this day belongs to current fiscal week. Possible value is Current. | ||||
CURRENT_FISCAL_PERIOD_CODE | VARCHAR2 | 16 | Indicates that this day belongs to current fiscal period. Possible value is Current. | ||||
CURRENT_FISCAL_QUARTER_CODE | VARCHAR2 | 16 | Indicates that this day belongs to current fiscal quarter. Possible value is Current. | ||||
CURRENT_FISCAL_YEAR_CODE | VARCHAR2 | 16 | Indicates that this day belongs to current fiscal year. Possible value is Current. | ||||
FISCAL_TRAILING_PERIOD_NUMBER | NUMBER | 38 | 0 | Indicates the trailing fiscal period number | |||
FISCAL_TRAILING_QUARTER_NUMBER | NUMBER | 38 | 0 | Indicates the trailing fiscal quarter number | |||
FISCAL_TRAILING_YEAR_NUMBER | NUMBER | 38 | 0 | Indicates the trailing fiscal year number | |||
NUMBER_PER_FISCAL_YEAR | NUMBER | 38 | 0 | Number of periods per fiscal year. | |||
FISCAL_YEAR_NUMBER_1 | NUMBER | 38 | 0 | Fiscal Year Number 1 | |||
CALENDAR_TYPE_CODE | VARCHAR2 | 32 | Type of Calendar. Valid values are Accounting or Budgetary Control. | ||||
ACCOUNTING_CAL_FLAG | VARCHAR2 | 16 | Accounting Calendar Flag |
Copyright © 2019, 2023, Oracle and/or its affiliates.