JContPhone

Last updated
Save as PDF

JContPhone contains information about the phone numbers in a contact record.

This information includes the number itself, phone number type (such as Home or Business), and contact record to which each number belongs. This table represents the Phone Numbers block on the General tab of a contact record.

Object: JContPhone (J_CONT_PHONE)

Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments
Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments
number Before TeamConnect 3.3 SP2: phoneString	PHONE_STRING (VARCHAR2) (50)	Number	x			string (50)	The actual phone number.
owner-->	CONTACT_ID (NUMBER)		x	x	TContact	object	8 The contact to which the phone number belongs. --> Links to specific information for the contact record.
primaryKey	PRIMARY_KEY (NUMBER)		x			int	The unique ID of the phone number record.
type-->	TYPE_ID (NUMBER)	Type	x	x	LContPhone Type	object	8 The type of this phone number (such as Home or Business). --> Links to the table that contains all phone number types.
version	VERSION (NUMBER)		x			int	Indicates how many times the phone number was updated.

LContPhoneType

LContPhoneType contains information about the phone number types defined for contact phone numbers. This information includes the name of the phone type, tree position, and display order. This table represents the Phone Type system lookup table.

Object: LContPhoneType (L_CONT_PHONE_TYPE)

Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments
Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments
childList-->	n/a						Do not apply. These lookup items cannot have a hierarchical structure.
parent-->	PARENT_ID (NUMBER)
displayOrder	DISPLAY_ORDER (NUMBER)	Order	x			int	The order in which the table items will be listed in the GUI, lowest number first.
isActive	IS_ACTIVE					boolean
name	NAME (VARCHAR2) (50)	Item Name	x			string (50)	The name of the phone type.
primaryKey	PRIMARY_KEY (NUMBER)		x			int	The unique ID of the phone type list item.
treePosition	TREE_POSITION (VARCHAR20) (250)	Tree Position	x			string (250)	The unique four- character alphanumeric code that is created when the phone type is defined.
version	VERSION (NUMBER)		x			int	Indicates how many times the phone type list item was updated.