| Name | Description | Type | Additional information |
|---|---|---|---|
| RECORD_ID | integer |
None. |
|
| RECORD_CHANGED_BY | string |
None. |
|
| RECORD_START_DT | date |
None. |
|
| RECORD_END_DT | date |
None. |
|
| CLIENT_ID | integer |
None. |
|
| INVESTOR_ID | integer |
None. |
|
| CLIENT_REFERENCE_ID | string |
None. |
|
| CLIENT_REFERENCE_NAME | string |
None. |
|
| INVESTOR_TYPE | string |
None. |
|
| INVESTOR_LEGAL_NAME | string |
None. |
|
| ENTITY_INVESTOR_NAME | string |
None. |
|
| INVESTOR_FIRST_NAME | string |
None. |
|
| INVESTOR_LAST_NAME | string |
None. |
|
| SINGLE_MEMBER_LLC_NAME | string |
None. |
|
| REGARDED_OWNERS | string |
None. |
|
| REGARDED_OWNER_TIN | string |
None. |
|
| CITIZENSHIP_COUNTRY_ID | integer |
None. |
|
| CITIZENSHIP_COUNTRY_NAME | string |
None. |
|
| INCORPORATION_COUNTRY_ID | integer |
None. |
|
| INCORPORATION_COUNTRY_NAME | string |
None. |
|
| BIRTH_DATE | date |
None. |
|
| StrBIRTH_DATE | string |
None. |
|
| BIRTH_CITY | string |
None. |
|
| BIRTH_STATE | string |
None. |
|
| BIRTH_COUNTRY_ID | integer |
None. |
|
| BIRTH_COUNTRY_NAME | string |
None. |
|
| SSN | string |
None. |
|
| TIN_COUNTRY_1_ID | integer |
None. |
|
| TIN_COUNTRY_2_ID | integer |
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. |
|
| ELECTRONIC_K1_CONSENT | string |
None. |
|
| TYPE_OF_FORM | integer |
None. |
|
| FORM_VALID | string |
None. |
|
| FORM_SIGNATURE_DATE | date |
None. |
|
| FORM_W8_OWNER_NAME | string |
None. |
|
| INTERMEDIARY_NAME | string |
None. |
|
| COUNTRY_INCORPORATION_ID | integer |
None. |
|
| COUNTRY_INCORPORATION_NAME | string |
None. |
|
| IMY_STATUS_ID | integer |
None. |
|
| W9_EXEMPT_CODE | string |
None. |
|
| W9_FATCA_CODE | string |
None. |
|
| FATCA_STATUS_ID | integer |
None. |
|
| TREATY_ARTICLE_ID | integer |
None. |
|
| REPORTABLE_PERSON_CRS | string |
None. |
|
| CRS_FORM_STATUS | string |
None. |
|
| CONTROLLING_PERSONS | string |
None. |
|
| PMIE | string |
None. |
|
| REASON_NO_GIIN | string |
None. |
|
| NAME_SPONSORED_ENTITY | string |
None. |
|
| GIIN_SPONSORED_ENTITY | string |
None. |
|
| COMMENTS | string |
None. |
|
| INVESTMENT_ENTITY_TYPE | string |
None. |
|
| INVEST_INTO_NON_US_ENTITY | string |
None. |
|
| INVESTMENT_ACQUISITION_DATE | string |
None. |
|
| INVESTMENT_DISPOSAL_DATE | string |
None. |
|
| TIN_COUNTRY_1_Name | string |
None. |
|
| TIN_COUNTRY_2_Name | string |
None. |
|
| TIN_COUNTRY_3_Name | string |
None. |
|
| ADDRESS_COUNTRY_Name | string |
None. |
|
| FORM_TYPE_NAME | string |
None. |
|
| FATCA_STATUS_NAME | string |
None. |
|
| INVESTOR_Full_NAME | string |
None. |
|
| Birth_CountryName | string |
None. |
|
| Mailing_CountryName | string |
None. |
|
| Incorporation_CountryName | string |
None. |
|
| IMY_STATUS_NAME | string |
None. |
|
| ARTICLE_NAME | string |
None. |
|
| StrFORM_SIGNATURE_DATE | string |
None. |
|
| LoggedInUserName | string |
None. |
|
| FORM_EXPIRATION_DATE | date |
None. |
|
| FATCA_SPECIFIED_PERSON_STATUS | string |
None. |
|
| CRS_SPECIFIED_PERSON_STATUS | string |
None. |
|
| bSPECIFIED_FATCA | boolean |
None. |
|
| bREPORTABLE_PERSON_CRS | boolean |
None. |
|
| bFATCA_REPORTABLE | boolean |
None. |
|
| bCRS_REPORTABLE | boolean |
None. |
|
| bELECTRONIC_K1_CONSENT | boolean |
None. |
|
| bPMIE | boolean |
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. |
|
| strLOCAL_TAX_STATUS | string |
None. |
|
| Full_Mailing_Address | string |
None. |
|
| Full_Address | string |
None. |
|
| CP_ID | integer |
None. |
|
| InvestorType | string |
None. |
|
| US_Tax_Form_Status | string |
None. |
|
| US_Tax_Form_Provided | string |
None. |
|
| StrFORM_EXPIRATION_DATE | string |
None. |
|
| strINVESTOR_ID | string |
None. |
|
| strRECORD_ID | string |
None. |
|
| SPECIAL_TAX_STATUS | string |
None. |
|
| strRECORD_START_DT | string |
None. |
|
| strRECORD_END_DT | string |
None. |
|
| Last_Update_On | string |
None. |
|
| Last_Update_By | string |
None. |
|
| SCHEDULE_K1_REQUIRED | string |
None. |
|
| CONTACT_NAME | string |
None. |
|
| CONTACT_PHONE | string |
None. |
|
| CONTACT_EMAIL | string |
None. |
|
| US_TAX_CLASSIFICATION_ID | integer |
None. |
|
| US_TAX_CLASSIFICATION_NAME | string |
None. |
|
| DISREGARDED_ENTITY_TIN | string |
None. |
|
| LOCAL_TAX_CLASSIFICATION_ID | integer |
None. |
|
| LOCAL_TAX_CLASSIFICATION_NAME | string |
None. |
|
| SPECIFIED_FATCA | string |
None. |
|
| PAYEE_STATUS | string |
None. |
|
| EIN | string |
None. |
|
| TIN_1 | string |
None. |
|
| TIN_2 | string |
None. |
|
| REASON_FOR_NO_TIN | string |
None. |
|
| TIN_COUNTRY_3_ID | integer |
None. |
|
| TIN_3 | string |
None. |
|
| STATE_OF_TAX_RESIDENCE_ID | integer |
None. |
|
| STATE_OF_TAX_RESIDENCE_NAME | string |
None. |
|
| CHAPTER_4_STATUS_CODE | string |
None. |
|
| GIIN | string |
None. |
|
| W9_EXEMPT_PAYEE | string |
None. |
|
| W9_EXEMPT_PAYEE_CODE | string |
None. |
|
| W9_EXEMPT_FATCA | string |
None. |
|
| W9_EXEMPT_FATCA_CODE | string |
None. |
|
| CHAPTER_3_STATUS_CODE | string |
None. |
|
| bIMY_WITHHOLDING_STATEMENT | boolean |
None. |
|
| US_OWNERS | string |
None. |
|
| US_TREATY_ELIGIBLE | string |
None. |
|
| TREATY_COUNTRY_ID | integer |
None. |
|
| TREATY_COUNTRY_Name | string |
None. |
|
| LOB_CODE | string |
None. |
|
| WITHHOLDING_RATE_INTEREST | string |
None. |
|
| WITHHOLDING_RATE_DIVIDENDS | string |
None. |
|
| WITHHOLDING_RATE_RENTS | string |
None. |
|
| WITHHOLDING_RATE_ROYALTIES | string |
None. |
|
| WITHHOLDING_RATE_OTHER | string |
None. |
|
| W9_Federal_Tax_Classification | string |
None. |
|
| INTEREST_TYPE | string |
None. |
|
| DIVIDEND_TYPE | string |
None. |
|
| OTHER_INCOME_TYPE | string |
None. |
|
| INTEREST_CH3_BASIS_EXEMPTION | string |
None. |
|
| DIVIDEND_CH3_BASIS_EXEMPTION | string |
None. |
|
| OTHER_INCOME_CH3_BASIS_EXEMPTION | string |
None. |
|
| CH4_BASIS_EXEMPTION | string |
None. |
|
| IMY_WITHHOLDING_STATEMENT | string |
None. |
|
| IMY_BEN_OWNERS_FORMS | string |
None. |
|
| DRE_BRANCH_RECEIVING_PAYMENT | string |
None. |
|
| WITHHOLDING_QUALIFIED_HOLDER | string |
None. |
|
| US_ITIN | string |
None. |
|
| US_TAX_FORM_REQUIRED | string |
None. |
|
| US_FORM_STATUS | string |
None. |
|
| CRS_FORM_REQUIRED | string |
None. |
|
| CRS_TAX_FORM_STATUS | string |
None. |
|
| FATCA_CLASSIFICATION | string |
None. |
|
| FATCA_CLASSIFICATION_ID | integer |
None. |
|
| FATCA_CLASSIFICATION_NAME | string |
None. |
|
| CRS_CLASSIFICATION_ID | integer |
None. |
|
| CRS_CLASSIFICATION_NAME | string |
None. |
|
| CRS_STATUS_ID | integer |
None. |
|
| CRS_STATUS_NAME | string |
None. |
|
| FATCA_REPORTABLE | string |
None. |
|
| FATCA_REPORTABLE_ID | integer |
None. |
|
| FATCA_REPORTABLE_NAME | string |
None. |
|
| CRS_REPORTABLE | string |
None. |
|
| CRS_REPORTABLE_ID | integer |
None. |
|
| CRS_REPORTABLE_NAME | string |
None. |
|
| HTML_NOTE | string |
None. |