Name Description Type Additional information
BENEFICIAL_OWNER_ID

integer

None.

RECORD_ID

integer

None.

RECORD_CHANGED_BY

string

None.

RECORD_START_DT

date

None.

RECORD_END_DT

date

None.

CLIENT_ID

integer

None.

CLIENT_REFERENCE_ID

string

None.

CLIENT_REFERENCE_NAME

string

None.

BENEFICIAL_LEGAL_NAME

string

None.

PAYEE_STATUS

string

None.

CITIZENSHIP_COUNTRY_ID

integer

None.

CITIZENSHIP_COUNTRY_NAME

string

None.

BIRTH_COUNTRY_ID

integer

None.

BIRTH_CITY

string

None.

SINGLE_MEMBER_LLC_NAME

string

None.

EIN

string

None.

SSN

string

None.

TIN_COUNTRY_1_ID

integer

None.

TIN_1

string

None.

TIN_COUNTRY_2_ID

integer

None.

TIN_2

string

None.

REASON_FOR_NO_TIN

string

None.

TIN_COUNTRY_3_ID

integer

None.

TIN_3

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.

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.

US_TAX_CLASSIFICATION_ID

integer

None.

US_TAX_CLASSIFICATION_NAME

string

None.

LOCAL_TAX_CLASSIFICATION_ID

integer

None.

LOCAL_TAX_CLASSIFICATION_NAME

string

None.

IMY_STATUS_ID

integer

None.

W9_EXEMPT_CODE

string

None.

W9_FATCA_CODE

string

None.

FATCA_STATUS_ID

integer

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.

CHAPTER_4_STATUS_CODE

string

None.

GIIN

string

None.

TREATY_ARTICLE_ID

integer

None.

IMY_WITHHOLDING_STATEMENT

string

None.

SPECIFIED_FATCA

string

None.

REPORTABLE_PERSON_CRS

string

None.

CRS_FORM_STATUS

string

None.

CRS_STATUS_ID

integer

None.

CONTROLLING_PERSONS

string

None.

PMIE

string

None.

REASON_NO_GIIN

string

None.

NAME_SPONSORED_ENTITY

string

None.

GIIN_SPONSORED_ENTITY

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.

COMMENTS

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.

CRS_STATUS_NAME

string

None.

Birth_CountryName

string

None.

Mailing_CountryName

string

None.

Incorporation_CountryName

string

None.

IMY_STATUS_NAME

string

None.

ARTICLE_NAME

string

None.

StrBIRTH_DATE

string

None.

StrFORM_SIGNATURE_DATE

string

None.

LoggedInUserName

string

None.

FORM_EXPIRATION_DATE

date

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.

IMY_BEN_OWNERS_FORMS

string

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.

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.

Full_Mailing_Address

string

None.

Full_Address

string

None.

CP_ID

integer

None.

BeneficialType

string

None.

US_Tax_Form_Status

string

None.

US_Tax_Form_Provided

string

None.

StrFORM_EXPIRATION_DATE

string

None.

strBENEFICIAL_OWNER_ID

string

None.

strRECORD_ID

string

None.

SPECIAL_TAX_STATUS

string

None.

W9_Federal_Tax_Classification

string

None.

REGARDED_OWNERS

string

None.

INVESTOR_ID

integer

None.

PERCENTAGE

integer

None.

EntityBO

string

None.

EntityBOId

integer

None.

Text

string

None.

INVESTOR_LEGAL_NAME

string

None.

EntityName

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.

strRECORD_START_DT

string

None.

strRECORD_END_DT

string

None.

LAST_UPDATE_ON

string

None.

LAST_UPDATE_BY

string

None.

COUNTRY_INCORPORATION_NAME

string

None.

US_TAX_FORM_REQUIRED

string

None.

CRS_FORM_REQUIRED

string

None.

INVESTOR_TYPE

string

None.