Assets
The product or service associated with an organization's customers.
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 Assets WHERE id = 12 SELECT * FROM Assets WHERE id > 15 SELECT * FROM Assets WHERE lookUpName LIKE '%test' SELECT * FROM Assets WHERE id IN (12, 23, 123) SELECT * FROM Assets WHERE lookUpName IS NOT NULL
INSERT
Insert can be executed by specifying the name, productid and serialNumber columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO Assets (name, productid, serialNumber) VALUES ('ABC', 12, 'SN00123')
UPDATE
Update can be executed by specifying the column in WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE Assets SET contacts = 'US of America' WHERE name = 'United States (US)'
DELETE
Delete can be executed by specifying id in the WHERE Clause.
For example:
DELETE FROM Assets WHERE id = '4'
Columns
| Name | Type | ReadOnly | Description |
| ContactId | Long | False |
Id of contact. The contact associated with the asset. |
| ContactlookUpName | String | False |
LookUpName of contact. The contact associated with the asset. |
| CreatedTime | Datetime | True |
The date and time when the asset was created. This attribute is read-only. |
| Description | String | False |
The description of the asset. |
| Id [KEY] | Long | True |
The unique identifier of the asset. |
| InstalledDate | Date | False |
The date when the asset was installed. |
| LookupName | String | True |
The name used to look up the asset. |
| Name | String | False |
The name of the asset used as the lookupName for the asset object. |
| OrganizationId | Long | False |
Id of organization. The organization associated with the asset. |
| OrganizationlookUpName | String | False |
LookUpName of organization. The organization associated with the asset. |
| ProductId | Long | False |
Id of product. The product associated with the asset. |
| ProductlookUpName | String | False |
LookUpName of product. The product associated with the asset. |
| PurchasedDate | Date | False |
The date when the asset was purchased. |
| RetiredDate | Date | False |
The date when the asset was retired. |
| SerialNumber | String | False |
The serial number of the asset. |
| UpdatedTime | Datetime | True |
The date and time when the asset was last updated. This attribute is read-only. |
| PricecurrencyId | Long | False |
Id of currency. The ID of the currency. |
| PricecurrencylookUpName | String | False |
LookUpName of currency. The ID of the currency. |
| PriceexchangeRateId | Long | False |
Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| PriceexchangeRatelookUpName | String | False |
LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| Pricevalue | String | False |
The value of the currency. |
| StatusWithTypestatusId | Long | False |
Id of status. The current status. |
| StatusWithTypestatuslookUpName | String | False |
LookUpName of status. The current status. |
| StatusWithTypestatusTypeId | Long | True |
Id of statusType. The associated status type. This attribute is read-only. |
| StatusWithTypestatusTypelookUpName | String | True |
LookUpName of statusType. The associated status type. 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 |
| sLAInstances | String |
The SLA instances associated with the asset. |