SalesTerritories

The specific geographical sales region. Sales representatives can be assigned specific territories for opportunity assignment.

Table-Specific Information

SELECT

The component 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 component.

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.

SSIS Components for Oracle Service Cloud