# 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 |  | This column is for Oracle Internal use only. 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, 2025, Oracle and/or its affiliates.