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

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