DW_FISCAL_CONTEXT_G

This table contains information about the relationship between organization or ledger with a fiscal calendar.

Details

Module:

Key Columns

ORGANIZATION_ID, LEDGER_ID, FISCAL_PERIOD_TYPE, FISCAL_PERIOD_SET_NAME

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ORGANIZATION_ID NUMBER 38 0 True Organization identifier.
LEDGER_ID NUMBER 38 0 True Ledger identifier.
FISCAL_PERIOD_SET_NAME VARCHAR2 16 True Accounting calendar name.
FISCAL_PERIOD_TYPE VARCHAR2 16 True Accounting period type.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of organization identifier, accounting calendar name, accounting period type, ledger identifier.
LEDGER_NAME VARCHAR2 128 Ledger name