JContInetAddress

Last updated
Save as PDF

JContInetAddress contains information about the internet addresses in a contact record.

This information includes the address itself, internet address type (such as Personal or Business), and contact record to which each address belongs. This table represents the Internet Addresses block on the General tab of a contact record.

Object: JContInetAddress (J_CONT_INET_ADDRESS)

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
url Before TeamConnect 3.3 SP2: inetAddressString	INET_ADDRESS_STRING (VARCHAR2) (250)	Address	x			string (250)	The actual internet address.
owner-->	CONTACT_ID (NUMBER)		x	x	TContact	object	8 The contact to which the internet address belongs. --> Links to specific information for the contact record.
primaryKey	PRIMARY_KEY (NUMBER)		x			int	The unique ID of the internet address record.
type-->	TYPE_ID (NUMBER)	Type	x	x	LContInet AddressType	object	8 The type of the internet address. --> Links to definition information for the internet address type.
version	VERSION (NUMBER)		x			int	Indicates how many times the internet address was updated.

LContInetAddressType

LContInetAddressType contains information about the internet address types defined for contact internet addresses. This information includes the name of the internet address type, tree position, and display order. This table represents the Internet Address Type system lookup table.

Object: LContInetAddressType (L_CONT_INET_ADDRESS_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 internet address type.
primaryKey	PRIMARY_KEY (NUMBER)		x			int	The unique ID of the internet address type list item.
treePosition	TREE_ POSITION (VARCHAR2) (250)	Tree Position	x			string (250)	The unique four-character alphanumeric code that is created when the internet address type is defined.
version	VERSION (NUMBER)		x			int	Indicates how many times the internet address type list item was updated.