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 |
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 |
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. |
|
|