Skip to main content
Mitratech Success Center

JContPhone

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

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

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.

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.

  • Was this article helpful?