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.