# DW_LEGAL_ENTITY_LEDGER_REL_D

This table contains information about relationship between ledger and legal entities.

## Details

Module:

## Key Columns

LEGAL_ENTITY_ID, LEDGER_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
LEGAL_ENTITY_ID | NUMBER | 38 | 0 | True | Legal entity identifier. |  |
LEDGER_ID | NUMBER | 38 | 0 | True | Unique ledger identifier. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source record identifier,combination of LEGAL_ENTITY_ID and LEDGER_ID |  |
CHART_OF_ACCOUNTS_ID | NUMBER | 38 | 0 |  | Key flexfield structure identifier. |  |
LEGAL_ENTITY_NAME | VARCHAR2 | 256 |  |  | Legal entity name. |  |
LEGAL_ENTITY_IDENTIFIER | VARCHAR2 | 32 |  |  | Unique number used to identify a legal entity; either manually set by the user or composed of the country of registration and the registration number of the identifying jurisdiction if automatically generated. This is only relevant for third party legal entity. |  |
EFFECTIVE_FROM | DATE |  |  |  | Effective start date for legal entity. |  |
EFFECTIVE_TO | DATE |  |  |  | Effective end date for legal entity. |  |
PAYROLL_STATUTORY_UNIT_FLAG | VARCHAR2 | 16 |  |  | Indicates a legal entity PSU. |  |
TRANSACTING_ENTITY_FLAG | VARCHAR2 | 16 |  |  | Indicates a transacting legal entity. |  |
LEDGER_NAME | VARCHAR2 | 32 |  |  | User entered unique ledger name. |  |
LEDGER_SHORT_NAME | VARCHAR2 | 32 |  |  | User entered unique ledger short name. |  |
LEDGER_DESCRIPTION | VARCHAR2 | 256 |  |  | Description of the ledger definition. |  |
LEDGER_CATEGORY_CODE | VARCHAR2 | 32 |  |  | Type of ledger. Valid values are PRIMARY, SECONDARY and ALC. |  |
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Functional currency of the ledger. |  |
LE_LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | indicates the user who last updated the row. |  |
LE_LAST_UPDATE_LOGIN | VARCHAR2 | 64 |  |  | indicates the session login associated to the user who last updated the row. |  |
LE_LAST_UPDATE_DATE | TIMESTAMP |  |  |  | indicates the date and time of the last update of the row. |  |
LE_CREATION_DATE | TIMESTAMP |  |  |  | indicates the date and time of the creation of the row. |  |

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