The Entity Fields custom field is available for the Other Names table.
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 | |||||
VARCHAR2 | 254 | ||||||
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 |