DW_LEGAL_ENTITY_LEDGER_REL_D

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

Details

Module:

Key Columns

LEDGER_ID, LEGAL_ENTITY_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     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, 2022, Oracle and/or its affiliates.