Show/Hide Toolbars

JContRelation contains information about a contact record's relations with other contacts. This information includes the contact on the left and right sides of the relationship and the type of relationship between the two contacts (such as "Attorney for" or "Employee of"). This table represents the Relations block on the Relations tab of a contact record.

Object: JContRelation (J_CONT_RELATION)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

contact-->

Before TeamConnect 3.3 SP2: leftContact-->

LEFT_CONTACT_ID

(NUMBER)

Contact (left-side)

x

x

TContact

object

8 The contact that is on the left side of the relationship.

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

Note: The distinction between right and left contact in TeamConnect 3.4 is determined by a 3.4-specific attribute named relationDirection.

 

x

primaryKey

PRIMARY_KEY

(NUMBER)

 

x

 

 

int

The unique ID of the relation record.

 

 

contact-->

Before TeamConnect 3.3 SP2: rightContact-->

RIGHT_CONTACT_ID

(NUMBER)

Contact (right-side)

x

x

TContact

object

8 The contact that is on the right side of the relationship.

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

Note: The distinction between right and left contact in TeamConnect 3.4 is determined by a 3.4-specific attribute named relationDirection.

 

x

relationType

Before TeamConnect 3.3 SP2: typeID

TYPE_ID

(NUMBER)

Relation

x

x

LContRelationTypee

object

8 The type of the relationship.

--> Links to definition information for the relation type.

x

x

version

VERSION

(NUMBER)

 

x

 

 

int

Indicates how many times the relation record was updated.