DW_GL_LEDGER_RELATIONSHIPS_D

This table contains the relationships between ledgers. Each relationship between a primary ledger and a secondary ledger or between a ledger and its reporting currency is stored in one or more rows in this table.

Details

Module:

Key Columns

RELATIONSHIP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RELATIONSHIP_ID NUMBER 38 0 True Ledger relationship identifier.    
SOURCE_RECORD_ID VARCHAR2 64     Source record identifier.    
SOURCE_LEDGER_ID NUMBER 38 0   Ledger identifier where reporting currency conversions are based from transactions, journals, or balances.    
TARGET_LEDGER_ID VARCHAR2 16     Destination ledger identifier for conversion of transactions, journals, or balances.    
SOURCE_CURRENCY_CODE VARCHAR 16     Source ledger currency code    
SOURCE_LEDGER_NAME VARCHAR 32     Source ledger name    
SOURCE_LEDGER_SHORT_NAME VARCHAR 32     Source ledger short name    
SOURCE_LEDGER_CATEGORY_CODE VARCHAR 32     Source ledger category code    
TARGET_CURRENCY_CODE VARCHAR 16     Target ledger functional currency.    
TARGET_LEDGER_NAME VARCHAR 32     User entered target ledger name.    
TARGET_LEDGER_SHORT_NAME VARCHAR 32     User entered target ledger short name.    
TARGET_LEDGER_CATEGORY_CODE VARCHAR 32     Target ledger category code. Valid values are PRIMARY, SECONDARY and ALC.    
RELATIONSHIP_TYPE_CODE VARCHAR 32     Relationship level between source and target ledger.    
RELATIONSHIP_ENABLED_FLAG VARCHAR 16     Whether or not ledger relationship is enabled.    
GL_RELATIONSHIP_STATUS_CODE VARCHAR 32     Ledger relationship status code.    
SOURCE_CHART_OF_ACCOUNTS_ID NUMBER 38 0   Source ledger chart of accounts identifier    
TARGET_CHART_OF_ACCOUNTS_ID NUMBER 38 0   Target ledger chart of accounts identifier    
PRIMARY_LEDGER_ID NUMBER 38 0   Ledger identifier of the primary ledger as defined in the accounting configuration.    
APPLICATION_ID NUMBER 38 0   Application defining column (backward compatible only).    
ORG_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row.    
TRGT_LEDGER_ID NUMBER 38 0   Destination ledger identifier for conversion of transactions, journals, or balances.in Number data type