Skip to main content
Mitratech Success Center

JContTerritory

JContTerritory contains information about the territories in a contact record.

This information includes the territory type (such as Northwest or Southeast), and contact record to which each territory belongs. This table represents the Territories block on the Territories tab of a contact record.

Object: JContTerritory (J_CONT_TERRITORY)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

owner-->

CONTACT_ID (NUMBER)

 

x

x

TContact

object

8 The contact to which the territory belongs.

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

primaryKey

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of the territory record.

territoryItem-->

Before TeamConnect 3.3

SP2: type -->

TYPE_ID (NUMBER)

Territory

x

x

LContTerritoryType

object

8 The type of the territory record.

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

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the territory record was updated.

LContTerritoryType

LContTerritoryType contains information about the territory types defined for contact records. This information includes the name of the territory type, tree position, and display order. This table represents the Territory Type system lookup table.

Object: LContTerritoryType (L_CONT_TERRITORY_TYPE)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

childList-->

n/a

 

x

x

LContTerritoryType

 

8 The child territories for this territory.

--> Links to definition information for all child territories of the current territory.

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

parent -->

PARENT_ID (NUMBER)

Show items in node

x

x

LContTerritoryType

object

8 The parent item of the current item.

--> Links to definition information for the parent item.

primaryKey

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of the territory type list item.

treePosition

TREE_
POSITION (VARCHAR2) (250)

Tree Position

x

   

string (250)

The unique four- character alphanumeric code that is created when the territory type is defined.

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the territory type list item was updated.

  • Was this article helpful?