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 This column is for Oracle Internal use only. 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