DW_FA_GL_JE_SOURCES_G

Contains recon supported journal sources

Details

Module: General Ledger

Key Columns

APPLICATION_ID, FUNCTIONAL_AREA_CODE, JOURNAL_SOURCE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
APPLICATION_ID NUMBER 38 0 True Application Identifier
FUNCTIONAL_AREA_CODE VARCHAR2 256 True Indicates whether module is supported in FAW or not
JOURNAL_SOURCE VARCHAR2 32 True Journal source. Journal entry is assigned a source name to indicate how it was created. Values are from the table DW_JOURNAL_SOURCE_LKP_TL with CODE_TYPE=GL_JOURNAL_SOURCE. DW_JOURNAL_SOURCE_LKP_TL JOURNAL_SOURCE_LKP_CODE
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Unique record identifier
FAH_APPLICATION VARCHAR2 32 Indicates if the application or Journal source is FAH application or not.