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.