Territory table

The Territory table allows you to retrieve the territories defined for an organization. A territory designates a collection of customers, depots, drivers, and vehicles.

Note
This table supports Response integrations for Fleet accounts.

This topic contains the following sections:

Requirements
Territory column descriptions
Custom columns

Requirements

When you write templates that access this table, follow these requirements:

Specify the Symbolic Name for the table version to use:
Copy
```
TableID = Territory-1.0
```
Specify an Intent that this table supports:
- Create
- Retrieve
- Update
- CreateOrUpdate
- Delete
Input templates: In your [Output] section, be sure to map an input value to every table column that is flagged as being a primary key or required.
Retrieve templates: This table does not require the use of a fetcher. However, the following fetchers are available to optimize your query and are listed from most efficient to least:
1. Id (Equals/In)
  Copy
  [Filter] Id(ExtId) = Equals(Id1) # You can filter on literals or on variables from the [User] or [Calculated] sections.
  Copy
  [Filter] Id(ExtId) = In(["Id1","Id2","Id3"])

Territory column descriptions

This list includes each column's name, which you use in expressions to retrieve data, and data type, which defines how the data is retrieved.

Column	Data Type	Description
Id	Id	(primary key) The Id of the territory.
Name	Text	(Telogis key) The name of the territory.
TimeZone	Text	The timezone in which the territory is located.

Additional columns:

Column	Data Type	Description
CustomerId	Id	(read-only, all Fleet tables) The ID of the customer/owner.
CustomerFullName	Text	(read-only, all Fleet tables) The human-readable full name of the customer/owner.

Custom columns

Column	Data Type	Description
Custom.name	Text	Specifies a user-defined custom column name to store additional information in the table. If the column name contains non-alphanumeric characters, enclose the value in brackets, for example Custom.[Special column].