Skip to main content
Mitratech Success Center

JContEmail

JContEmail contains information about the email addresses in a contact record.

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

Object: JContEmail (J_CONT_EMAIL)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

address

Before TeamConnect 3.3

SP2: emailString

EMAIL_STRING (VARCHAR20) (250)

Email

x

   

string (250)

The actual email address.

owner-->

CONTACT_ID (NUMBER)

 

x

x

TContact

object

8 The contact to which the email address belongs.

--> Links to specific information for the contact record.

primaryKey

PRIMARY_KEY (NUMBER)

 

x

 

   

int

The unique ID of the email address record.

type-->

TYPE_ID (NUMBER)

Type

x

 

x

LContEmail
Type

object

8 The type of the email address.

--> Links to definition information for the email address type.

version

VERSION (NUMBER)

 

x

 

   

int

Indicates how many times the email address was updated.

LContEmailType

LContEmailType contains information about the email types defined for contact email addresses. This information includes the name of the email type, tree position, and display order. This table represents the Email Type system lookup table.

Object: LContEmailType (L_CONT_EMAIL_TYPE)

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)

         

display Order

DISPLAY_ORDER (NUMBER)

Order

x

   

int

The order in which the table items will be listed in the GUI, lowest number first.

name

NAME (VARCHAR2) (50)

Item Name

x

 

   

string (50)

The name of the email type.

primaryKey

PRIMARY_KEY (NUMBER)

 

x

 

   

int

The unique ID of the email type list item.

treePosition

TREE_POSITION (VARCHAR20) (250)

Tree Position

x

   

string (250)

The unique four- character alphanumeric code that is created when the email type is defined.

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the email type list item was updated.

  • Was this article helpful?