AssetAction
Represents an action, such as installation or maintenance, performed on an asset.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier for the record. | |
| IsDeleted | Bool | Indicates whether the record has been moved to the Recycle Bin. | |
| AssetActionNumber | String | AssetAction identification number. | |
| CurrencyIsoCode | String | ISO code for the currency in which the revenue amount is expressed. | |
| CreatedById | String |
User.Id | ID of the user who created the record. |
| LastModifiedDate | Datetime | Date and time when the record was last modified. | |
| LastModifiedById | String |
User.Id | ID of the user who last modified the record. |
| AssetId | String |
Asset.Id | ID of the Asset associated with this record. |
| Type | String | Type of account or classification. | |
| CategoryEnum | String | Field containing CategoryEnum information. | |
| ActionDate | Datetime | Date associated with Action. | |
| ProductAmountChange | Decimal | Change in product amount resulting from this asset action. | |
| AdjustmentAmountChange | Decimal | Change in adjustment amount resulting from this asset action. | |
| EstimatedTaxChange | Decimal | Estimated change in tax amount resulting from this asset action. | |
| ActualTaxChange | Decimal | Actual change in tax amount resulting from this asset action. | |
| SubtotalChange | Decimal | Change in subtotal amount resulting from this asset action. | |
| QuantityChange | Double | Field containing QuantityChange information. | |
| MrrChange | Decimal | Field containing MrrChange information. | |
| Amount | Decimal | Estimated total sale amount. | |
| TotalInitialSaleAmount | Decimal | Field containing TotalInitialSaleAmount information. | |
| TotalRenewalsAmount | Decimal | Field containing TotalRenewalsAmount information. | |
| TotalUpsellsAmount | Decimal | Field containing TotalUpsellsAmount information. | |
| TotalDownsellsAmount | Decimal | Field containing TotalDownsellsAmount information. | |
| TotalCrossSellsAmount | Decimal | Field containing TotalCrossSellsAmount information. | |
| TotalCancellationsAmount | Decimal | Field containing TotalCancellationsAmount information. | |
| TotalTransfersAmount | Decimal | Field containing TotalTransfersAmount information. | |
| TotalTermsAndConditionsAmount | Decimal | Field containing TotalTermsAndConditionsAmount information. | |
| TotalOtherAmount | Decimal | Field containing TotalOtherAmount information. | |
| TotalSwapsAmount | Decimal | Total amount attributable to product swaps in this asset action. | |
| TotalUpgradesAmount | Decimal | Total amount attributable to upgrades in this asset action. | |
| TotalDowngradesAmount | Decimal | Total amount attributable to downgrades in this asset action. | |
| TotalAmount | Decimal | Total monetary amount of this asset action. | |
| TotalQuantity | Double | Field containing TotalQuantity information. | |
| TotalMrr | Decimal | Field containing TotalMrr information. | |
| Subtype | String | Subtype classification of the asset action. | |
| SystemModstamp | Datetime | Date and time when the record was last modified by a user or by an automated process. | |
| CreatedDate | Datetime | Date and time when the record was created. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| SOQL | String | 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 | 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 | 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. |