XLE_ENTITY_PROFILES
XLE_ENTITY_PROFILES contains the general information, which identifies a party with the classification of legal entity.
Details
-
Schema: FUSION
-
Object owner: XLE
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
XLE_ENTITY_PROFILES_PK |
LEGAL_ENTITY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Unique identifier of the legal entity. | ||
| PARTY_ID | NUMBER | 18 | Yes | Party identifier for the legal entity. | ||
| LEGAL_ENTITY_IDENTIFIER | VARCHAR2 | 30 | Yes | 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. | ||
| NAME | VARCHAR2 | 240 | Yes | Name of the legal entity that belongs to your own corporate structure (enterprise). | ||
| GEOGRAPHY_ID | NUMBER | 18 | Yes | Region or district assigned to a representative, agent, or the like, as for making sales. | ||
| TRANSACTING_ENTITY_FLAG | VARCHAR2 | 1 | Whether or not the legal entity is allowed to generate business transactions. Not currently used. | |||
| EFFECTIVE_FROM | DATE | Effective start date of the legal entity. | ||||
| EFFECTIVE_TO | DATE | Effective end date of the legal entity. | ||||
| LE_INFORMATION_CONTEXT | VARCHAR2 | 30 | Descriptive Flexfield: financial additional information descriptive flexfield segment context. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION1 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 1. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION2 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 2. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION3 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 3. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION4 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 4. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION5 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 5. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION6 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 6. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION7 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 7. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION8 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 8. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION9 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 9. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION10 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 10. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION11 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 11. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION12 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 12. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION13 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 13. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION14 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 14. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION15 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 15. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION16 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 16. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION17 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 17. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION18 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 18. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION19 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 19. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LE_INFORMATION20 | VARCHAR2 | 150 | Descriptive Flexfield: financial additional information descriptive flexfield segment 20. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Legal Entity (XLE_LE_ADD_INFO) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ACTIVITY_CODE | VARCHAR2 | 150 | Primary activity of the legal entity. This is an extension of the financial additional information descriptive flexfield columns from LE_INFORMATION1 to LE_INFORMATION_20. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| SUB_ACTIVITY_CODE | VARCHAR2 | 150 | Subordinate activity of the legal entity. This is an extension of the financial additional information descriptive flexfield columns from LE_INFORMATION1 to LE_INFORMATION_20. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| TYPE_OF_COMPANY | VARCHAR2 | 50 | Type of company. This is an extension of the financial additional information descriptive flexfield columns from LE_INFORMATION1 to LE_INFORMATION_20. | Legal Entity Context (XLE_LE_INFO_DEV) | ||
| PSU_FLAG | VARCHAR2 | 1 | Payroll Statutory Unit is a legal entity that is registered to report payroll tax and social insurance. In most cases, a Legal Employer is also a Payroll Statutory Unit, but a Payroll Statutory Unit can represent multiple Legal Employers. | |||
| LEGAL_EMPLOYER_FLAG | VARCHAR2 | 1 | Whether the legal entity can be an employer. Value values are Yes or No. | |||
| PARENT_PSU_ID | NUMBER | 18 | Parent payroll statutory unit identifier. | |||
| ENTERPRISE_ID | NUMBER | 18 | Enterprise or business group identifier. | |||
| LE_INFORMATION_NUMBER1 | NUMBER | Descriptive Flexfield: financial additional information descriptive flexfield segment | ||||
| LE_INFORMATION_NUMBER2 | NUMBER | Descriptive Flexfield: financial additional information descriptive flexfield segment | ||||
| LE_INFORMATION_NUMBER3 | NUMBER | Descriptive Flexfield: financial additional information descriptive flexfield segment | ||||
| LE_INFORMATION_NUMBER4 | NUMBER | Descriptive Flexfield: financial additional information descriptive flexfield segment | ||||
| LE_INFORMATION_NUMBER5 | NUMBER | Descriptive Flexfield: financial additional information descriptive flexfield segment | ||||
| LE_INFORMATION_DATE1 | DATE | Descriptive Flexfield: financial additional information descriptive flexfield segment | ||||
| LE_INFORMATION_DATE2 | DATE | Descriptive Flexfield: financial additional information descriptive flexfield segment | ||||
| LE_INFORMATION_DATE3 | DATE | Descriptive Flexfield: financial additional information descriptive flexfield segment | ||||
| LE_INFORMATION_DATE4 | DATE | Descriptive Flexfield: financial additional information descriptive flexfield segment | ||||
| LE_INFORMATION_DATE5 | DATE | Descriptive Flexfield: financial additional information descriptive flexfield segment |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| XLE_ENTITY_PROFILES | hz_parties | PARTY_ID |
| XLE_ENTITY_PROFILES | hz_geographies | GEOGRAPHY_ID |
| ap_checks_all | xle_entity_profiles | LEGAL_ENTITY_ID |
| fun_ic_cust_supp_map | xle_entity_profiles | LEGAL_ENTITY_ID |
| fun_trx_headers | xle_entity_profiles | TO_LE_ID |
| je_fr_das2_ven_summary_t | xle_entity_profiles | LEGAL_ENTITY_ID |
| ra_customer_trx_all | xle_entity_profiles | LEGAL_ENTITY_ID |
| jl_br_sped_extr_params | xle_entity_profiles | LEGAL_ENTITY_ID |
| ce_bank_accounts | xle_entity_profiles | ACCOUNT_OWNER_ORG_ID |
| fos_agreement_ptr_f | xle_entity_profiles | FROM_LE_ID |
| fos_agreement_ptr_f | xle_entity_profiles | TO_LE_ID |
| ra_batch_sources_all | xle_entity_profiles | LEGAL_ENTITY_ID |
| ar_trx_dist_line_balances_all | xle_entity_profiles | RECEIPT_LEGAL_ENTITY_ID |
| fun_bal_inter_accounts_addl | xle_entity_profiles | FROM_LE_ID |
| fun_bal_inter_accounts_addl | xle_entity_profiles | TO_LE_ID |
| ap_selected_invoices_all | xle_entity_profiles | LEGAL_ENTITY_ID |
| je_fr_das2_details_t | xle_entity_profiles | LEGAL_ENTITY_ID |
| je_fr_das2_etb_headers_t | xle_entity_profiles | LEGAL_ENTITY_ID |
| je_fr_das2_le_headers_t | xle_entity_profiles | LEGAL_ENTITY_ID |
| jl_br_sped_prcpnt_relations_f | xle_entity_profiles | LEGAL_ENTITY_ID |
| ar_interest_headers_all | xle_entity_profiles | LEGAL_ENTITY_ID |
| ar_interim_cash_receipts_all | xle_entity_profiles | LEGAL_ENTITY_ID |
| vrm_perf_obligations | xle_entity_profiles | LEGAL_ENTITY_ID |
| fun_bal_recon_result | xle_entity_profiles | FROM_LE_ID |
| fun_bal_recon_result | xle_entity_profiles | TO_LE_ID |
| okc_k_headers_all_b_h | xle_entity_profiles | LEGAL_ENTITY_ID |
| fun_trx_batches | xle_entity_profiles | FROM_LE_ID |
| ar_cash_receipts_all | xle_entity_profiles | LEGAL_ENTITY_ID |
| vrm_impl_perf_oblig_tlines | xle_entity_profiles | LEGAL_ENTITY_ID |
| fun_interco_organizations | xle_entity_profiles | LEGAL_ENTITY_ID |
| ra_interface_lines_all | xle_entity_profiles | LEGAL_ENTITY_ID |
| ap_invoices_all | xle_entity_profiles | LEGAL_ENTITY_ID |
| fun_bal_inter_rules | xle_entity_profiles | FROM_LE_ID |
| fun_bal_inter_rules | xle_entity_profiles | TO_LE_ID |
| fun_bal_intra_rules | xle_entity_profiles | LE_ID |
| xle_etb_profiles | xle_entity_profiles | LEGAL_ENTITY_ID |
| okc_k_headers_all_b | xle_entity_profiles | LEGAL_ENTITY_ID |
| ap_le_group | xle_entity_profiles | LEGAL_ENTITY_ID |
| je_fr_das2_le_etb_summ_t | xle_entity_profiles | LEGAL_ENTITY_ID |
| jl_br_sped_acct_configs_f | xle_entity_profiles | LEGAL_ENTITY_ID |
| ar_rec_trx_le_details_all | xle_entity_profiles | LEGAL_ENTITY_ID |
| iby_gen_docs_payable | xle_entity_profiles | LEGAL_ENTITY_ID |
| ar_late_charge_trx_t | xle_entity_profiles | LEGAL_ENTITY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XLE_ENTITY_PROFILES_N1 | Non Unique | Default | NAME |
| XLE_ENTITY_PROFILES_N2 | Non Unique | Default | LAST_UPDATE_DATE |
| XLE_ENTITY_PROFILES_N3 | Non Unique | Default | UPPER("LEGAL_ENTITY_IDENTIFIER") |
| XLE_ENTITY_PROFILES_N4 | Non Unique | Default | UPPER("NAME") |
| XLE_ENTITY_PROFILES_U1 | Unique | Default | LEGAL_ENTITY_ID |
| XLE_ENTITY_PROFILES_U2 | Unique | Default | PARTY_ID |
| XLE_ENTITY_PROFILES_U3 | Unique | Default | LEGAL_ENTITY_IDENTIFIER |