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.

SSIS Components for Oracle Service Cloud