| Name | Description | Type | Additional information |
|---|---|---|---|
| RECORD_ID | integer |
None. |
|
| RECORD_CHANGED_BY | string |
None. |
|
| RECORD_START_DT | date |
None. |
|
| RECORD_END_DT | date |
None. |
|
| ENTITY_ID | integer |
None. |
|
| CLIENT_ID | integer |
None. |
|
| CLIENT_REFERENCE_ID | string |
None. |
|
| CLIENT_REFERENCE_NAME | string |
None. |
|
| LEGAL_ENTITY_NAME | string |
None. |
|
| INVESTMENT_CATEGORY | string |
None. |
|
| INCORPORATION_COUNTRY_NAME | string |
None. |
|
| FORMATION_DATE | date |
None. |
|
| STATUS_ID | integer |
None. |
|
| OperatingStatusId | integer |
None. |
|
| OperatingStatusName | string |
None. |
|
| ENTITY_STATUS_NAME | string |
None. |
|
| LIQUIDATION_DATE | date |
None. |
|
| LOCAL_REGISTRATION_NUMBER | string |
None. |
|
| USCTAFinCENID | string |
None. |
|
| ADDRESS_NUMBER_STREET | string |
None. |
|
| ADDRESS_LINE_TWO | string |
None. |
|
| ADDRESS_CITY | string |
None. |
|
| ADDRESS_STATE | string |
None. |
|
| ADDRESS_POST_CODE | string |
None. |
|
| ADDRESS_COUNTRY_ID | integer |
None. |
|
| MAILING_NUMBER_STREET | string |
None. |
|
| MAILING_LINE_TWO | string |
None. |
|
| MAILING_CITY | string |
None. |
|
| MAILING_STATE | string |
None. |
|
| MAILING_POST_CODE | string |
None. |
|
| MAILING_COUNTRY_ID | integer |
None. |
|
| LocalTaxAdvisoryId | integer |
None. |
|
| LocalTaxAdvisoryName | string |
None. |
|
| LocalTaxComplianceId | integer |
None. |
|
| LocalTaxComplianceName | string |
None. |
|
| USTaxAdvisoryId | integer |
None. |
|
| USTaxAdvisoryName | string |
None. |
|
| USTaxComplianceId | integer |
None. |
|
| USTaxComplianceName | string |
None. |
|
| LOCAL_TAX_CLASSIFICATION_ID | integer |
None. |
|
| US_TAX_CLASSIFICATION_ID | integer |
None. |
|
| SPECIAL_TAX_STATUS | string |
None. |
|
| TIN_COUNTRY_1_ID | integer |
None. |
|
| TIN_1 | string |
None. |
|
| US_EIN | string |
None. |
|
| TIN_COUNTRY_2_ID | integer |
None. |
|
| TIN_2 | string |
None. |
|
| REASON_FOR_NO_TIN | string |
None. |
|
| STATE_OF_TAX_RESIDENCE_NAME | string |
None. |
|
| VAT_NUMBER | string |
None. |
|
| REGARDED_OWNERS | string |
None. |
|
| REGARDED_OWNER_TIN | string |
None. |
|
| RECIPIENT_STATUS | string |
None. |
|
| CTB_ELECTION_DATE | date |
None. |
|
| SCHEDULE_K1_REQUIRED | string |
None. |
|
| W9_Federal_Tax_Classification | string |
None. |
|
| W9_EXEMPT_PAYEE_CODE | string |
None. |
|
| W9_EXEMPT_FATCA_CODE | string |
None. |
|
| W9_EXEMPT_PAYEE | string |
None. |
|
| W9_EXEMPT_FATCA | string |
None. |
|
| CHAPTER_3_STATUS_CODE | string |
None. |
|
| CHAPTER_4_STATUS_CODE | string |
None. |
|
| US_TREATY_ELIGIBLE | string |
None. |
|
| TREATY_COUNTRY_ID | integer |
None. |
|
| LOB_CODE | string |
None. |
|
| INTEREST_TYPE | string |
None. |
|
| WITHHOLDING_RATE_INTEREST | string |
None. |
|
| INTEREST_CH3_BASIS_EXEMPTION | string |
None. |
|
| DIVIDEND_TYPE | string |
None. |
|
| WITHHOLDING_RATE_DIVIDENDS | string |
None. |
|
| DIVIDEND_CH3_BASIS_EXEMPTION | string |
None. |
|
| OTHER_INCOME_TYPE | string |
None. |
|
| WITHHOLDING_RATE_OTHER | string |
None. |
|
| OTHER_INCOME_CH3_BASIS_EXEMPTION | string |
None. |
|
| CH4_BASIS_EXEMPTION | string |
None. |
|
| FATCA_CLASSIFICATION | string |
None. |
|
| FATCA_CLASSIFICATION_ID | integer |
None. |
|
| FATCA_CLASSIFICATION_NAME | string |
None. |
|
| CRS_CLASSIFICATION | integer |
None. |
|
| CRS_CLASSIFICATION_ID | integer |
None. |
|
| CRS_CLASSIFICATION_NAME | string |
None. |
|
| FATCA_REPORTING_STATUS | string |
None. |
|
| FATCA_REPORTABLE_ID | integer |
None. |
|
| FATCA_REPORTABLE_NAME | string |
None. |
|
| CRS_REPORTING_STATUS | string |
None. |
|
| CRS_REPORTABLE_ID | integer |
None. |
|
| CRS_REPORTABLE_NAME | string |
None. |
|
| GIIN | string |
None. |
|
| LOCAL_FATCA_NUMBER | string |
None. |
|
| LOCAL_CRS_NUMBER | string |
None. |
|
| AEOIPortalID | string |
None. |
|
| FATCA_CRS_AdvisoryId | integer |
None. |
|
| FATCA_CRS_AdvisoryName | string |
None. |
|
| FATCA_CRS_ComplianceId | integer |
None. |
|
| FATCA_CRS_ComplianceName | string |
None. |
|
| BUSINESS_LINE_ID | integer |
None. |
|
| FUND_DEAL_ID | integer |
None. |
|
| INCORPORATION_COUNTRY_ID | integer |
None. |
|
| COMPANY_NUMBER | string |
None. |
|
| COMPANY_REGISTER_NAME | string |
None. |
|
| MANAGEMENT_COUNTRY_ID | integer |
None. |
|
| REPORTING_REGISTRATION_DATE | date |
None. |
|
| REPORTING_DEREGISTRATION_DATE | date |
None. |
|
| EXEMPT_FATCA_REPORTING_W9 | string |
None. |
|
| EXEMPT_PAYEE_WITHHOLDING_W9 | string |
None. |
|
| CHECK_THE_BOX_DATE | date |
None. |
|
| TEN_PERCENT_US_OWNER | string |
None. |
|
| TWENTYFIVE_PERCENT_US_OWNER | string |
None. |
|
| bTEN_PERCENT_US_OWNER | boolean |
None. |
|
| bTWENTYFIVE_PERCENT_US_OWNER | boolean |
None. |
|
| TREATY_COUNTRY_NAME | string |
None. |
|
| WITHHOLDING_RATE_RENTS | string |
None. |
|
| WITHHOLDING_RATE_ROYALTIES | string |
None. |
|
| PRINCIPAL_ACTIVITY_ID | integer |
None. |
|
| FINANCIAL_COUNTERPARTY_NAMES | string |
None. |
|
| FORM_TO_COUNTERPARTY_ID | integer |
None. |
|
| FORM_SIGNATURE_DATE | date |
None. |
|
| US_BUSINESS | string |
None. |
|
| bUS_BUSINESS | boolean |
None. |
|
| FORM_TYPE_ID | integer |
None. |
|
| FORM_NAME | string |
None. |
|
| FORM_TYPE_NAME | string |
None. |
|
| FORM_EXPIRATION_DATE | date |
None. |
|
| FORM_RECIPIENT | string |
None. |
|
| CHAPTER_4_STATUS | string |
None. |
|
| LOCAL_ID | string |
None. |
|
| FATCA_REQUIRED | string |
None. |
|
| CRS_REQUIRED | string |
None. |
|
| bFATCA_REQUIRED | boolean |
None. |
|
| bCRS_REQUIRED | boolean |
None. |
|
| FATCA_REPORTING_TYPE | string |
None. |
|
| CRS_REPORTING_TYPE | string |
None. |
|
| COMMENTS | string |
None. |
|
| INVESTMENT_ENTITY_TYPE | string |
None. |
|
| INTERNAL_GROUP | string |
None. |
|
| INTEREST_HOLDERS | string |
None. |
|
| FATCA_REGISTRATION_STATUS | string |
None. |
|
| CRS_REGISTRATION_STATUS | string |
None. |
|
| US_TAX_STATUS | string |
None. |
|
| W8_FATCA_STATUS | string |
None. |
|
| W9_EXEMPT_STATUS | string |
None. |
|
| FORM_8832_STATUS | string |
None. |
|
| US_OWNERS | string |
None. |
|
| FATCA_CRS_CLASSIFICATION | string |
None. |
|
| HOLD_ACCT_NON_US_ENTITY | string |
None. |
|
| FATCA_SPECIFIED_PERSON_STATUS | string |
None. |
|
| CRS_SPECIFIED_PERSON_STATUS | string |
None. |
|
| GIIN_STATUS | string |
None. |
|
| CONTROLLING_PERSONS | string |
None. |
|
| INVESTOR_NOTIFICATION_STATUS | string |
None. |
|
| TIN_COUNTRY_1_NAME | string |
None. |
|
| TIN_COUNTRY_2_NAME | string |
None. |
|
| ADDRESS_COUNTRY_NAME | string |
None. |
|
| US_TAX_CLASSIFICATION_NAME | string |
None. |
|
| FATCA_STATUS_NAME | string |
None. |
|
| CRS_STATUS_NAME | string |
None. |
|
| MANAGEMENT_COUNTRY_NAME | string |
None. |
|
| BUSINESS_LINE_NAME | string |
None. |
|
| FUND_NAME | string |
None. |
|
| DEAL_NAME | string |
None. |
|
| MAILING_COUNTRY_NAME | string |
None. |
|
| LOCAL_TAX_CLASSIFICATION_NAME | string |
None. |
|
| PRINCIPAL_ACTIVITY_NAME | string |
None. |
|
| CreatedBy | integer |
None. |
|
| STATUS_NAME | string |
None. |
|
| FUND_DEAL_NAME | string |
None. |
|
| Str_FORMATION_DATE | string |
None. |
|
| Str_LIQUIDATION_DATE | string |
None. |
|
| operationType | string |
None. |
|
| TAX_RESIDENCY_1 | integer |
None. |
|
| TAX_RESIDENCY_2 | integer |
None. |
|
| TAX_RESIDENCY_3 | integer |
None. |
|
| Tax_Residency_Country_1 | string |
None. |
|
| Tax_Residency_Country_2 | string |
None. |
|
| Tax_Residency_Country_3 | string |
None. |
|
| StrCTB_ELECTION_DATE | string |
None. |
|
| StrUS_FORM_EXPIRATION_DATE | string |
None. |
|
| strENTITY_ID | string |
None. |
|
| strRECORD_ID | string |
None. |
|
| strRECORD_START_DT | string |
None. |
|
| strRECORD_END_DT | string |
None. |
|
| FUND_DEAL_COUNT | integer |
None. |
|
| LAST_UPDATE_ON | string |
None. |
|
| LAST_UPDATE_BY | string |
None. |
|
| K1_REPORTING_REQUIRED | string |
None. |
|
| STATE_OF_TAX_RESIDENCE_ID | integer |
None. |
|
| HTML_NOTE | string |
None. |
|
| UpdateDateOfDispose | integer |
None. |
|
| UpdateInvestmentDate | integer |
None. |
|
| INVESTMENT_CATEGORY_ID | integer |
None. |
|
| INVESTMENT_CATEGORY_NAME | string |
None. |
|
| INVESTMENT_CATEGORY_ColorCode | string |
None. |
|
| InvestmentCategoryColorCode | string |
None. |
|
| InvestmentCategoryName | string |
None. |
|
| GroupEntityName | string |
None. |
|
| CurrencyTypeId | integer |
None. |
|
| CurrencyTypeName | string |
None. |