This table contains information about legal entities.
Module:
LEGAL_ENTITY_ID
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, 2023, Oracle and/or its affiliates.