SalesTerritories
The specific geographical sales region. Sales representatives can be assigned specific territories for opportunity assignment.
Table-Specific Information
SELECT
The driver will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the driver.
SELECT * FROM SalesTerritories WHERE id = 12 SELECT * FROM SalesTerritories WHERE id > 15 SELECT * FROM SalesTerritories WHERE lookUpName LIKE '%test' SELECT * FROM SalesTerritories WHERE id IN (12,23,123) SELECT * FROM SalesTerritories WHERE lookUpName IS NOT NULL
INSERT
Insert can be executed by specifying the names column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO SalesTerritoriesNames#TEMP (languageId,labeltext) VALUES ('1','Community Ideas')
INSERT INTO SalesTerritories (names) VALUES ('salesTerritoriesNames#TEMP')
UPDATE
Update can be executed. The columns that are not read-only can be Updated.
For example:
UPDATE SalesTerritories SET displayorder = '2' WHERE name = 'United States'
DELETE
Delete can be executed by specifying id in the WHERE Clause.
For example:
DELETE FROM SalesTerritories WHERE id = '4'
Columns
| Name | Type | ReadOnly | Description |
| Comment | String | False |
The comments or notes associated with the sales territory. |
| CreatedTime | Datetime | True |
The date and time when the sales territory was created. This attribute is read-only. |
| Disabled | Bool | False |
Indicates whether a sales territory is disabled. The default value is false. |
| DisplayOrder | Int | False |
The display position of the sales territory relative to other members of the same group. |
| Id [KEY] | Long | True |
The unique identifier of the sales territory. |
| LookupName | String | True |
The name used to look up the sales territory. |
| Name | String | True |
The name of the sales territory in the language of the current interface. This attribute is read-only. |
| ParentId | Long | False |
Id of parent. The parent sales territory in the hierarchy. |
| ParentlookUpName | String | False |
LookUpName of parent. The parent sales territory in the hierarchy. |
| UpdatedTime | Datetime | True |
The date and time when the sales territory was last updated. This attribute is read-only. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| adminVisibleInterfaces | String |
The list of interfaces on which the category is available for administration use. |
| names | String |
The list of names, one for each supported language. |