Other_names

The Entity Fields custom field is available for the Other Names table.

Columns

Name Type Length Precision Scale References In Description
account_number VARCHAR2 99 Account number
address VARCHAR2 999 Address
address1 VARCHAR2 150 Address line 1
address2 VARCHAR2 150 Address line 2
address3 VARCHAR2 150 Address line 3
altemail VARCHAR2 254 Alt email
altphone VARCHAR2 100 Alt phone
city VARCHAR2 50 City
comments VARCHAR2 4000 Comments
companyname VARCHAR2 83 Company name
country VARCHAR2 50 Country
create_date TIMESTAMP Create date (GMT)
date_last_modified TIMESTAMP Date last modified
email VARCHAR2 254 Email
fax VARCHAR2 100 Fax
full_name VARCHAR2 1800 Full name
home_phone VARCHAR2 100 Home phone
is_person VARCHAR2 3 Type (company or individual)
isinactive VARCHAR2 3 Other name is inactive
last_modified_date TIMESTAMP Last modified date (GMT)
loginaccess VARCHAR2 3 Login access
mobile_phone VARCHAR2 100 Mobile phone
name VARCHAR2 83 Name
other_name_extid VARCHAR2 255 Other name external ID
other_name_id NUMBER 39 0 Other name ID
parent_id NUMBER 39 0 Child of
phone VARCHAR2 100 Phone
state VARCHAR2 50 State
subsidiary NUMBER 39 0 Subsidiary
url VARCHAR2 100 URL
zipcode VARCHAR2 36 Zip code