SSIS Components for Salesforce

Build 25.0.9434

Asset

Manages customer-owned products, including warranty and support details, for asset tracking.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the asset record.

ContactId String False

Contact.Id

ID of the contact associated with the asset, typically the end user or owner.

AccountId String False

Account.Id

ID of the account that owns or manages the asset.

ParentId String False

Asset.Id

ID of the parent object in the hierarchy.

RootAssetId String True

Asset.Id

ID of the RootAsset associated with this record.

Product2Id String False

Product2.Id

ID of the product associated with this asset, linking it to a product catalog entry.

ProductCode String True

Field containing ProductCode information.

IsCompetitorProduct Bool False

Indicates whether the asset is a competitor's product rather than your own.

CreatedDate Datetime True

Timestamp when the asset record was created.

CreatedById String True

User.Id

ID of the user who created the asset record.

LastModifiedById String True

User.Id

ID of the user who last updated the asset record.

IsDeleted Bool True

Indicates whether the asset has been deleted.

CurrencyIsoCode String False

ISO code for the currency in which the revenue amount is expressed.

Name String False

Name of the asset, often a reference or product model identifier.

SerialNumber String False

Manufacturer's serial number for the physical asset.

InstallDate Date False

Date when the asset was installed or became operational.

PurchaseDate Date False

Date when the asset was purchased by the customer or account.

UsageEndDate Date False

Expected or actual date when the asset is no longer in use.

LifecycleStartDate Datetime True

Date associated with LifecycleStart.

LifecycleEndDate Datetime True

Date associated with LifecycleEnd.

Status String False

Current lifecycle status of the asset, such as Active, Inactive, or Returned.

Price Decimal False

Monetary value or cost of the asset at the time of sale or installation.

Quantity Double False

Number of units represented by the asset record.

Description String False

Additional details or notes about the asset.

OwnerId String False

User.Id

ID of the user who owns the record.

AssetProvidedById String False

Account.Id

ID of the AssetProvidedBy associated with this record.

AssetServicedById String False

Account.Id

ID of the AssetServicedBy associated with this record.

IsInternal Bool False

Indicates whether the record has the Internal characteristic.

AssetLevel Int True

Field containing AssetLevel information.

StockKeepingUnit String True

Field containing StockKeepingUnit information.

HasLifecycleManagement Bool True

Indicates whether the record has LifecycleManagement.

CurrentMrr Decimal True

Field containing CurrentMrr information.

CurrentLifecycleEndDate Datetime True

Date associated with CurrentLifecycleEnd.

CurrentQuantity Double True

Field containing CurrentQuantity information.

CurrentAmount Decimal True

Field containing CurrentAmount information.

TotalLifecycleAmount Decimal True

Field containing TotalLifecycleAmount information.

Street String False

Street address.

City String False

City portion of the address.

State String False

State or province portion of the address.

PostalCode String False

Postal code portion of the address.

Country String False

Country portion of the address.

Latitude Double False

Used with Longitude to specify the precise geolocation of an address.

Longitude Double False

Used with Latitude to specify the precise geolocation of an address.

GeocodeAccuracy String False

Accuracy level of the geocode for the address.

LastViewedDate Datetime True

Date and time when the record was last viewed in the user interface.

LastReferencedDate Datetime True

Date and time when the record was last referenced.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

SystemModstamp Datetime True

System-generated timestamp indicating the last update to any field in the record.

LastModifiedDate Datetime True

Timestamp when the asset record was last modified.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434