Partners

The Entity Fields custom field is available for the Partners 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
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	Subsidiaries	Subsidiary
tax_number	VARCHAR2	15					Tax identity number
url	VARCHAR2	100					URL
zipcode	VARCHAR2	36					Zip code

Primary key

PK Column Name
partner_id

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
Posting_account_activity_pe_partners_fk	partner_id	Posting_account_activity_pe	partner_id	1