SalesProducts
The items or services sold by an organization.
Table-Specific Information
SELECT
The add-in 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 add-in.
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
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 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. |