| Name | Description | Type | Additional information |
|---|---|---|---|
| CLIENT_REFERENCE_ID | string |
None. |
|
| ENTITY_INVESTOR_NAME | string |
None. |
|
| Str_DATE_INVESTMENT | string |
None. |
|
| Str_DATE_DISPOSAL | string |
None. |
|
| TIN_3 | 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. |
|
| INVESTMENT_AMOUNT | string |
None. |
|
| NEW_INVESTMENT_AMOUNT | 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. |
|
| INSTRUMENT_TYPE | string |
None. |
|
| NEW_INSTRUMENT_TYPE | string |
None. |
|
| AMOUNT_HELD | string |
None. |
|
| NEW_AMOUNT_HELD | string |
None. |
|
| SCHEDULE_K1_REQUIRED | string |
None. |
|
| ELECTRONIC_K1_CONSENT | string |
None. |
|
| FATCA_REPORTING_REQUIRED | string |
None. |
|
| CRS_REPORTING_REQUIRED | string |
None. |
|
| RECORD_ID | integer |
None. |
|
| BOT_ENTITY_ID | integer |
None. |
|
| INVESTOR_ID | integer |
None. |
|
| strINVESTOR_ID | string |
None. |
|
| DATE_INVESTMENT | date |
None. |
|
| DATE_DISPOSAL | date |
None. |
|
| FATCA_REPORTABLE | string |
None. |
|
| CRS_REPORTABLE | string |
None. |
|
| INVESTOR_TYPE | string |
None. |
|
| INVESTOR_FIRST_NAME | string |
None. |
|
| INVESTOR_LAST_NAME | string |
None. |
|
| TIN_COUNTRY_1_NAME | string |
None. |
|
| InvestorRecordId | integer |
None. |
|
| FATCA_SPECIFIED_PERSON_STATUS | string |
None. |
|
| CRS_SPECIFIED_PERSON_STATUS | string |
None. |
|
| RELATIONSHIP_ID | integer |
None. |
|
| strRELATIONSHIP_ID | string |
None. |
|
| US_TAX_CLASSIFICATION_ID | integer |
None. |
|
| LOCAL_TAX_CLASSIFICATION_ID | integer |
None. |
|
| strUS_TAX_STATUS | string |
None. |
|
| strRECORD_START_DT | string |
None. |
|
| strRECORD_END_DT | string |
None. |
|
| SINGLE_MEMBER_LLC_NAME | string |
None. |
|
| strLOCAL_TAX_STATUS | 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. |
|
| 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. |
|
| 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. |
|
| BIRTH_DATE | date |
None. |
|
| Str_BIRTH_DATE | string |
None. |
|
| BIRTH_COUNTRY_ID | integer |
None. |
|
| CLASS_INSTRUMENT_ID | integer |
None. |
|
| BIRTH_CITY | string |
None. |
|
| BIRTH_COUNTRY_NAME | string |
None. |