Name Description Type Additional information
RECORD_ID

integer

None.

INVESTOR_ID

integer

None.

INVESTOR_FIRST_NAME

string

None.

INVESTOR_LAST_NAME

string

None.

INVESTOR_LEGAL_NAME

string

None.

INVESTOR_TYPE

string

None.

US_TAX_CLASSIFICATION_ID

integer

None.

W9_Federal_Tax_Classification

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.

TIN_1

string

None.

TIN_2

string

None.

TIN_3

string

None.

W9_EXEMPT_PAYEE_CODE

string

None.

W9_EXEMPT_FATCA_CODE

string

None.

Tax_Residency_1

string

None.

TIN_COUNTRY_1_ID

integer

None.

Tax_Residency_2

string

None.

TIN_COUNTRY_2_ID

integer

None.

Tax_Residency_3

string

None.

TIN_COUNTRY_3_ID

integer

None.

US_TAX_CLASSIFICATION_NAME

string

None.

REGARDED_OWNERS

string

None.

W9_EXEMPT_PAYEE

string

None.

W9_EXEMPT_FATCA

string

None.

SINGLE_MEMBER_LLC_NAME

string

None.

FORM_TYPE_ID

integer

None.

CITIZENSHIP_COUNTRY_ID

integer

None.

CITIZENSHIP_COUNTRY_NAME

string

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_NAME

string

None.

ADDRESS_COUNTRY_NAME

string

None.

BIRTH_DATE

date

None.

BIRTH_CITY

string

None.

BIRTH_COUNTRY_ID

integer

None.

BIRTH_COUNTRY_NAME

string

None.

WITHHOLDING_RATE_INTEREST

string

None.

WITHHOLDING_RATE_DIVIDENDS

string

None.

WITHHOLDING_RATE_OTHER

string

None.

FORM_SIGNATURE_DATE

date

None.

FORM_EXPIRY_DT

date

None.

TREATY_COUNTRY_NAME

string

None.

US_ITIN

string

None.

INCORPORATION_COUNTRY_NAME

string

None.

CHAPTER_3_STATUS_CODE

string

None.

CHAPTER_4_STATUS_CODE

string

None.

US_EIN

string

None.

GIIN

string

None.

LOB_CODE

string

None.

REASON_FOR_NO_TIN

string

None.

LOCAL_TAX_STATUS

string

None.

DRE_BRANCH_RECEIVING_PAYMENT

string

None.

RECIPIENT_STATUS

string

None.

PAYEE_STATUS

string

None.

FATCA_REPORTABLE

string

None.

CRS_REPORTABLE

string

None.

FATCA_REPORTING_STATUS

string

None.

CRS_REPORTING_STATUS

string

None.

FATCA_REPORTABLE_ID

integer

None.

FATCA_REPORTABLE_NAME

string

None.

CRS_REPORTABLE_ID

integer

None.

CRS_REPORTABLE_NAME

string

None.

INVESTOR_TYPE_BO

string

None.

WITHHOLDING_QUALIFIED_HOLDER

string

None.