Database - Investor Information (investor_entity)

Deprecated!

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the entity

custom_id

varchar(255)

Custom investor id

customer_type

char(100)

Investor type

customer.type.*

status

varchar(255)

Status code of the entity

first_name

varchar(50)

investor first name

last_name

varchar(50)

investor last name

middle_name

varchar(50)

investor middle name

birth_date

varbinary(255)

investor birthdate

gender

char(100)

investor gender

customer.gender.*

generation_code

char(100)

investor generation code

customer.generationCode.*

email

varchar(255)

investor email

ssn

varbinary(255)

investor ssn

driver_license

varchar(50)

investor driver license

company_name

varchar(255)

Company name of investor.

contact_name

varchar(255)

investor contact name

customer_id_type

char(100)

investor id type

customer.idType.*

customer_id

varbinary(255)

ID for the customer

credit_limit

decimal(10,2)

investor credit limit

access_username

varchar(255)

investor website access username

access_password

varchar(255)

investor website access password

primary_address_id

int(11)

investor primary address id

mail_address_id

int(11)

investor mail address id

has_avatar

tinyint(4)

whether or not has an avatar

1 - yes, 0 - no

ofac_match

tinyint(4)

Whether or not match OFAC records

1 - yes, 0 - no

ofac_tested

tinyint(4)

Whether or not was OFAC tested

1 - yes, 0 - no

created

timestamp

Timestamp of when the entity was created

lastUpdated

timestamp

Timestamp of when the entity was last updated

active

tinyint(4)

Whether or not the entity is active

1 - yes, 0 - no

deleted

tinyint(4)

Whether or not the entity was deleted

1 - yes, 0 - no


How did we do?


Powered by HelpDocs (opens in a new tab)