DW_FISCAL_CONTEXT_G

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

Details

Module:

Key Columns

FISCAL_PERIOD_TYPE, FISCAL_PERIOD_SET_NAME, LEDGER_ID, ORGANIZATION_ID

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     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    

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