| Name | Description | Type | Additional information |
|---|---|---|---|
| CLIENT_REFERENCE_ID | string |
None. |
|
| LEGAL_ENTITY_NAME | string |
None. |
|
| DATE_INVESTMENT | date |
None. |
|
| Str_DATE_INVESTMENT | string |
None. |
|
| DATE_DISPOSAL | date |
None. |
|
| Str_DATE_DISPOSAL | string |
None. |
|
| Tax_Residency_Country_1_ID | integer |
None. |
|
| Tax_Residency_Country_1 | string |
None. |
|
| TIN_1 | string |
None. |
|
| Tax_Residency_Country_2_ID | integer |
None. |
|
| Tax_Residency_Country_2 | string |
None. |
|
| TIN_2 | string |
None. |
|
| FATCA_REPORTING_REQUIRED | string |
None. |
|
| CRS_REPORTING_REQUIRED | string |
None. |
|
| INSTRUMENT_TYPE | string |
None. |
|
| NEW_INSTRUMENT_TYPE | string |
None. |
|
| AMOUNT_HELD | string |
None. |
|
| NEW_AMOUNT_HELD | string |
None. |
|
| PERCENTAGE | decimal number |
None. |
|
| NEW_PERCENTAGE | decimal number |
None. |
|
| strPERCENTAGE | string |
None. |
|
| strNewPERCENTAGE | string |
None. |
|
| INVESTMENT_TYPE | string |
None. |
|
| INVESTMENT_TYPE_ID | integer |
None. |
|
| INVESTMENT_TYPE_NAME | string |
None. |
|
| NEW_INVESTMENT_TYPE | string |
None. |
|
| NEW_INVESTMENT_TYPE_NAME | string |
None. |
|
| RECORD_ID | integer |
None. |
|
| TOP_ENTITY_ID | integer |
None. |
|
| BOT_ENTITY_ID | integer |
None. |
|
| ENTITY_ID | integer |
None. |
|
| strENTITY_ID | string |
None. |
|
| MANAGEMENT_COUNTRY_NAME | string |
None. |
|
| FATCA_STATUS_NAME | string |
None. |
|
| CRS_STATUS_NAME | string |
None. |
|
| CURRENT_RECORD_ENTITY_NAME | string |
None. |
|
| FATCA_REPORTABLE | string |
None. |
|
| CRS_REPORTABLE | string |
None. |
|
| EntityRecordId | integer |
None. |
|
| strEntityRecordId | string |
None. |
|
| FATCA_SPECIFIED_PERSON_STATUS | string |
None. |
|
| CRS_SPECIFIED_PERSON_STATUS | string |
None. |
|
| US_TAX_CLASSIFICATION_ID | integer |
None. |
|
| LOCAL_TAX_CLASSIFICATION_ID | integer |
None. |
|
| TYPE | string |
None. |
|
| strUS_TAX_STATUS | string |
None. |
|
| strLOCAL_TAX_STATUS | string |
None. |
|
| INVESTMENT_CATEGORY | string |
None. |
|
| INVESTMENT_CATEGORY_ColorCode | string |
None. |
|
| InvestmentCategoryColorCode | string |
None. |
|
| InvestmentCategoryName | string |
None. |
|
| strRECORD_START_DT | string |
None. |
|
| strRECORD_END_DT | string |
None. |
|
| RELATIONSHIP_ID | integer |
None. |
|
| LIQUIDATION_DATE | date |
None. |
|
| Str_LIQUIDATION_DATE | string |
None. |
|
| CLIENT_REFERENCE_NAME | string |
None. |
|
| INVESTMENT_AMOUNT | string |
None. |
|
| NEW_INVESTMENT_AMOUNT | string |
None. |
|
| OtherConnectorInfo | string |
None. |
|
| NEW_OtherConnectorInfo | string |
None. |
|
| CONNECTOR_DISPLAY | string |
None. |
|
| NEW_CONNECTOR_DISPLAY | string |
None. |
|
| CONNECTOR_TYPE | string |
None. |
|
| NEW_CONNECTOR_TYPE | string |
None. |
|
| CONNECTOR_COLOUR | string |
None. |
|
| NEW_CONNECTOR_COLOUR | string |
None. |
|
| CONNECTOR_DISPLAY_DYNAMIC_FIELD | string |
None. |
|
| FORMATION_DATE | date |
None. |
|
| INTEREST_TYPE | string |
None. |
|
| DIVIDEND_TYPE | string |
None. |
|
| OTHER_INCOME_TYPE | string |
None. |
|
| WITHHOLDING_RATE_INTEREST | string |
None. |
|
| strWITHHOLDING_RATE_INTEREST | string |
None. |
|
| WITHHOLDING_RATE_DIVIDENDS | string |
None. |
|
| strWITHHOLDING_RATE_DIVIDENDS | string |
None. |
|
| WITHHOLDING_RATE_OTHER | string |
None. |
|
| strWITHHOLDING_RATE_OTHER | string |
None. |
|
| RECIPIENT_STATUS | string |
None. |
|
| INTEREST_CH3_BASIS_EXEMPTION | string |
None. |
|
| DIVIDEND_CH3_BASIS_EXEMPTION | string |
None. |
|
| OTHER_INCOME_CH3_BASIS_EXEMPTION | string |
None. |
|
| APPLICATION_DATE | date |
None. |
|
| NEW_APPLICATION_DATE | date |
None. |
|
| AMOUNT | string |
None. |
|
| FATCA_REQUIRED | string |
None. |
|
| CRS_REQUIRED | string |
None. |
|
| LOCAL_FATCA_NUMBER | string |
None. |
|
| LOCAL_CRS_NUMBER | string |
None. |
|
| AEOIPortalID | string |
None. |
|
| PGE_ENTITY_ID | integer |
None. |
|
| PGE_RECORD_ID | integer |
None. |
|
| PGE_GROUP_ENTITY_NAME | string |
None. |
|
| PGE_GROUP_ENTITY_LEGAL_NAME | string |
None. |
|
| PGE_LOCAL_FATCA_NUMBER | string |
None. |
|
| PGE_LOCAL_CRS_NUMBER | string |
None. |
|
| PGE_AEOIPortalID | string |
None. |
|
| PGE_CurrencyTypeId | integer |
None. |
|
| PGE_CurrencyTypeName | string |
None. |
|
| ADDRESS_CITY | string |
None. |
|
| ADDRESS_COUNTRY_NAME | string |
None. |
|
| FULL_ADDRESS | string |
None. |
|
| VAT_NUMBER | string |
None. |
|
| USCTAFinCENID | string |
None. |
|
| CurrencyTypeId | integer |
None. |