ADO.NET Provider for Oracle Service Cloud

Build 24.0.9062

Assets

The product or service associated with an organization's customers.

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 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

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

Name Type Description
sLAInstances String

The SLA instances associated with the asset.

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