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	32					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	4000					Full name
home_phone	VARCHAR2	100					Home phone
is_person	VARCHAR2	32					Type (company or individual)
isinactive	VARCHAR2	32					Partner is inactive
last_modified_date	TIMESTAMP						Last modified date (GMT)
loginaccess	VARCHAR2	32					Give access
mobile_phone	VARCHAR2	100					Mobile phone
name	VARCHAR2	83					Name
partner_extid	VARCHAR2	255					Partner external ID
partner_id	NUMBER		22	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		22	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