The Entity Fields custom field is available for the Partners 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
assigntasks VARCHAR2 3 Can be assigned tasks
city VARCHAR2 50 City
code VARCHAR2 200 Promotion code
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 Partner is inactive
last_modified_date TIMESTAMP Last modified date (GMT)
loginaccess VARCHAR2 3 Give access
mobile_phone VARCHAR2 100 Mobile phone
name VARCHAR2 83 Name
partner_extid VARCHAR2 255 Partner external ID
partner_id NUMBER 39 0 Partner ID
phone VARCHAR2 100 Phone
print_on_check_as VARCHAR2 83 Print on check as
shipping_address VARCHAR2 999 Shipping address
state VARCHAR2 50 State
subsidiary NUMBER 39 0 subsidiary_id
tax_number VARCHAR2 15 Tax identity number
url VARCHAR2 100 URL
zipcode VARCHAR2 36 Zip code

Primary key

PK Column Name

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
partners_subsidiaries_fk subsidiary Subsidiaries subsidiary_id 1

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Customers_partners_fk partner_id Customers partner_id 1
Opportunities_partners_fk partner_id Opportunities partner_id 1
Posting_account_activity_partners_fk partner_id Posting_account_activity partner_id 1