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 |
Commonly used in: |
|
Rules |
Temp/Wiz |
||||||||
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 (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 |
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. |
|
|