JContTerritory
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 |
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 |
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 |
8 The child territories for this territory. --> Links to definition information for all child territories of the current territory. |
|||
|
displayOrder |
DISPLAY_ |
Order |
x |
int |
The order in which the table items will be listed in the GUI, lowest number first. |
||
| isActive | IS_ACTIVE | boolean | |||||
|
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 |
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_ |
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. |