Show/Hide Toolbars

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

Commonly used in:

Rules

Temp/Wiz

number

Before TeamConnect 3.3 SP2: phoneString

PHONE_STRING

(VARCHAR2) (50)

Number

x

 

 

string (50)

The actual phone number.

 

x

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

LContPhoneType

object

8 The type of this phone number (such as Home or Business).

--> Links to the table that contains all phone number types.

x

x

version

VERSION

(NUMBER)

 

x

 

 

int

Indicates how many times the phone number was updated.