DW_LEGAL_ENTITY_D

This table contains information about legal entities.

Details

Module:

Key Columns

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.    
SOURCE_RECORD_ID NUMBER 38 0   Source record identifier for legal entity.    
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.    
ADDRESS_ELEMENT_ATTRIBUTE1 VARCHAR2 256     Location address element attribute 1.    
ADDRESS_ELEMENT_ATTRIBUTE2 VARCHAR2 256     Location address element attribute 2.    
CITY VARCHAR2 64     Legal entity location city.    
POSTAL_CODE VARCHAR2 64     Legal entity location postal code.    
COUNTY VARCHAR2 64     Legal entity location county.    
STATE VARCHAR2 64     Legal entity location state.    
COUNTRY_CODE VARCHAR2 16     Legal entity location country.    
REGISTERED_NAME VARCHAR2 256     Legal entity registration name.    
REGISTRATION_NUMBER VARCHAR2 32     Legal entity registration number.    

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