SSIS Components for Oracle Service Cloud

Build 24.0.9062

SalesTerritoriesNames

The language-specific strings used for localization of fields.

Table-Specific Information

SELECT

The 本製品 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 本製品.

SELECT * FROM SalesTerritoriesNames WHERE languageId = 12;
SELECT * FROM SalesTerritoriesNames WHERE languageId > 15;
SELECT * FROM SalesTerritoriesNames WHERE labeltext LIKE '%test';
SELECT * FROM SalesTerritoriesNames WHERE languageId IN (12, 23, 123);
SELECT * FROM SalesTerritoriesNames WHERE labeltext IS NOT NULL;

Columns

Name Type Description
SalesTerritoriesId Long The unique identifier of the sales territory.
LabelText String The language-specific label text. The value cannot be null or empty.
LanguageId Long Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName String LookUpName of language. The ID of the language. This is the key for the list entry.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062