SalesProducts

The items or services sold by an organization.

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 SalesProducts WHERE id = 12
SELECT * FROM SalesProducts WHERE id > 15
SELECT * FROM SalesProducts WHERE lookUpName LIKE '%test'
SELECT * FROM SalesProducts WHERE id IN (12, 23, 123)
SELECT * FROM SalesProducts WHERE lookUpName IS NOT NULL

INSERT

Insert can be executed by specifying the acceptCount,respondCount and 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 SalesProductsNames#TEMP (languageId, labeltext) VALUES ('1', 'Smartly Maestro')
INSERT INTO SalesProducts (acceptCount, respondCount, names) VALUES ('0', '0', salesProductsNames#TEMP)

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE SalesProducts SET partNumber = 'SV100D' WHERE folderlookupName = 'Smartly Maestro'

DELETE

Following is an example of how to Delete a record in this table. For example:

DELETE FROM SalesProducts WHERE folderLookupName = 'Spaces B2B'

Columns


Name	Type	ReadOnly	Description
AcceptCount	Int	False	The number of times an offer for the sales product was accepted through offer advisor.
CreatedTime	Datetime	True	The date and time when the sales product was created. This attribute is read-only.
DisplayOrder	Int	False	The display position of the sales product within the folder list in the product catalog.
ExcludeFromOfferAdvisor	Bool	False	Indicates whether the product is excluded from the offer advisor. This attribute does not have a default value.
Id [KEY]	Long	True	The unique identifier of the sales product.
LookupName	String	True	The name used to look up the sales product.
Name	String	True	The name of the product in the language of the current interface. This attribute is read-only.
PartNumber	String	False	The text string which identifies the product. For example, stock keeping unit (SKU) or model number.
RespondCount	Int	False	The number of times the product was offered through the offer advisor.
ServiceProductId	Long	False	Id of serviceProduct. The service product.
ServiceProductlookUpName	String	False	LookUpName of serviceProduct. The service product.
UpdatedTime	Datetime	True	The date and time when the sales product was last updated. This attribute is read-only.
Attributesdisabled	Bool	False	Indicates whether the product is temporarily disabled and will not be displayed. The default value is false.
AttributeshasSerialNumber	Bool	False	Indicates whether the product has a serial number. The default value is false.
AttributesisSalesProduct	Bool	False	Indicates whether the product is a sales product. The default value is true.
AttributesisServiceProduct	Bool	False	Indicates whether the product is a service product. The default value is false.
Folderid	Long	False	ID value
FolderlookupName	String	False	Name used to lookup this object

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
adminVisibleInterfaces	String	The list of interfaces on which the sales product is visible.
descriptions	String	The list of descriptions, one for each supported language.
names	String	The list of names, one for each supported language.
schedules	String	The list of associated price schedules.

ODBC Driver for Oracle Service Cloud