General informations

Name: RecordsetFilterCriteriaRule
Label: Recordset Filter Criteria Rule
Type: Standard Object
Deployed:

Fields (22)
Name Label Type Description
Id Recordset Filter Criteria Rule ID ID
IsDeleted Deleted CHECKBOX
RecordsetFilterCriteriaRuleNumber Recordset Filter Criteria Rule Number AUTO NUMBER
CreatedDate Created Date DATETIME
CreatedById Created By ID LOOKUP
LastModifiedDate Last Modified Date DATETIME
LastModifiedById Last Modified By ID LOOKUP
SystemModstamp System Modstamp DATETIME
LastViewedDate Last Viewed Date DATETIME
LastReferencedDate Last Referenced Date DATETIME
RecordsetFilterCriteriaId Recordset Filter Criteria ID MASTER-DETAIL
CriteriaField Criteria Field PICKLIST
Operator Operator PICKLIST
Value Value TEXT AREA (LONG)(256)
Type Recordset Filter Criteria Type PICKLIST
FirstOccurrence First Occurrence TEXT(255)
LastOccurrence Last Occurrence TEXT(255)
Frequency Frequency TEXT(255)
NextOccurrenceField Next Occurrence Field PICKLIST
Index Index AUTO NUMBER
UsageRateField Usage Rate Field PICKLIST
UsageRateUnit Usage Rate Unit PICKLIST
Fields Details (22)
Name Id
Label Recordset Filter Criteria Rule ID
Type ID
Required Yes
Name IsDeleted
Label Deleted
Type CHECKBOX
Required Yes
Default value false
Name RecordsetFilterCriteriaRuleNumber
Label Recordset Filter Criteria Rule Number
Type AUTO NUMBER
Required Yes
Name CreatedDate
Label Created Date
Type DATETIME
Required Yes
Name CreatedById
Label Created By ID
Type LOOKUP
Foreign key Yes
Required Yes
Name LastModifiedDate
Label Last Modified Date
Type DATETIME
Required Yes
Name LastModifiedById
Label Last Modified By ID
Type LOOKUP
Foreign key Yes
Required Yes
Name SystemModstamp
Label System Modstamp
Type DATETIME
Required Yes
Name LastViewedDate
Label Last Viewed Date
Type DATETIME
Name LastReferencedDate
Label Last Referenced Date
Type DATETIME
Name RecordsetFilterCriteriaId
Label Recordset Filter Criteria ID
Type MASTER-DETAIL
Foreign key Yes
Required Yes
Name CriteriaField
Label Criteria Field
Type PICKLIST
Required Yes
Picklist values Asset.AccountId ServiceAppointment.AccountId ServiceAppointment.ActualDuration ServiceAppointment.ActualEndTime ServiceAppointment.ActualStartTime ServiceAppointment.AdditionalInformation ServiceAppointment.IsAnonymousBooking ServiceAppointment.AppointmentCategoryId ServiceAppointment.FSL__Appointment_Grade__c ServiceAppointment.AppointmentMode ServiceAppointment.AppointmentNumber ServiceAppointment.AppointmentReasonId ServiceAppointment.AppointmentType ServiceAppointment.ArrivalWindowEndTime ServiceAppointment.ArrivalWindowStartTime Asset.Id Asset.Name Asset.AssetProvidedById Asset.AssetServicedById ServiceAppointment.AssociatedProduct ServiceAppointment.AttendeeLimit ServiceAppointment.FSL__Auto_Schedule__c ServiceAppointment.IsBundle ServiceAppointment.IsBundleMember ServiceAppointment.CancellationReason ServiceAppointment.CheckedInTime Asset.City ServiceAppointment.City ServiceAppointment.Comments Asset.IsCompetitorProduct Asset.ContactId ServiceAppointment.ContactId Asset.Country ServiceAppointment.Country Asset.CountryCode ServiceAppointment.CountryCode Asset.CreatedById ServiceAppointment.CreatedById Asset.CreatedDate ServiceAppointment.CreatedDate ServiceAppointment.DueDate ServiceAppointment.Duration ServiceAppointment.DurationInMinutes ServiceAppointment.DurationType ServiceAppointment.EarliestStartTime ServiceAppointment.Email ServiceAppointment.FSL__Emergency__c ServiceAppointment.EngagementChannelTypeId ServiceAppointment.FSL__GanttColor__c ServiceAppointment.FSL__Gantt_Display_Date__c ServiceAppointment.FSL__GanttLabel__c Asset.GeocodeAccuracy ServiceAppointment.GeocodeAccuracy ServiceAppointment.GroupAppointmentAccessType ServiceAppointment.FSL__InJeopardy__c ServiceAppointment.FSL__InJeopardyReason__c Asset.InstallDate Asset.IsInternal ServiceAppointment.FSL__InternalSLRGeolocation__Latitude__s ServiceAppointment.FSL__InternalSLRGeolocation__Longitude__s ServiceAppointment.FSL__IsFillInCandidate__c ServiceAppointment.FSL__IsMultiDay__c Asset.LastModifiedById ServiceAppointment.LastModifiedById Asset.LastModifiedDate ServiceAppointment.LastModifiedDate ServiceAppointment.FSL__Last_Updated_Epoch__c Asset.Latitude ServiceAppointment.Latitude Asset.Longitude ServiceAppointment.Longitude ServiceAppointment.IsManuallyBundled ServiceAppointment.FSL__MDS_Calculated_length__c ServiceAppointment.IsOffsiteAppointment Asset.OwnerId Asset.ParentId ServiceAppointment.Phone ServiceAppointment.FSL__Pinned__c Asset.PostalCode ServiceAppointment.FSL__Prevent_Geocoding_For_Chatter_Actions__c Asset.Price Asset.Product2Id Asset.PurchaseDate Asset.Quantity ServiceAppointment.RelatedBundleId ServiceAppointment.FSL__Related_Service__c Asset.RootAssetId ServiceAppointment.FSL__Same_Day__c ServiceAppointment.FSL__Same_Resource__c ServiceAppointment.FSL__Duration_In_Minutes__c ServiceAppointment.SchedEndTime ServiceAppointment.SchedStartTime ServiceAppointment.FSL__Schedule_Mode__c ServiceAppointment.FSL__Schedule_over_lower_priority_appointment__c ServiceAppointment.FSL__Scheduling_Policy_Used__c Asset.SerialNumber ServiceAppointment.Id ServiceAppointment.SourceSystem ServiceAppointment.SourceSystemIdentifier ServiceAppointment.SourceSystemResponse Asset.State ServiceAppointment.State Asset.StateCode ServiceAppointment.StateCode Asset.Status ServiceAppointment.Status ServiceAppointment.StatusCategory ServiceAppointment.StatusReason Asset.Street ServiceAppointment.Street ServiceAppointment.Subject ServiceAppointment.ServiceTerritoryId ServiceAppointment.FSL__Time_Dependency__c ServiceAppointment.FSL__UpdatedByOptimization__c Asset.UsageEndDate ServiceAppointment.FSL__Use_Async_Logic__c ServiceAppointment.FSL__Virtual_Service_For_Chatter_Action__c ServiceAppointment.WorkTypeId ServiceAppointment.PostalCode
Name Operator
Label Operator
Type PICKLIST
Required Yes
Picklist values Equals GreaterThan GreaterOrEqual LessThan LessOrEqual
Name Value
Label Value
Type TEXT AREA (LONG)(256)
Name Type
Label Recordset Filter Criteria Type
Type PICKLIST
Picklist values Criteria Usage UsageDuration UsageCounter
Name FirstOccurrence
Label First Occurrence
Type TEXT(255)
Help Text Set the start value. To determine if the rule is true, this value is compared to the Usage Field value.
Name LastOccurrence
Label Last Occurrence
Type TEXT(255)
Name Frequency
Label Frequency
Type TEXT(255)
Help Text Set the frequency of maintenance. For example if this field is “1000”, this will schedule at every 1000 increments. This can either be a positive value for an incrementing Usage Field, or a negative value for a decreasing Usage Field.
Name NextOccurrenceField
Label Next Occurrence Field
Type PICKLIST
Help Text This field’s value is compared to the Usage Field to determine if the rule is true.
Picklist values Asset.AccountId ServiceAppointment.AccountId ServiceAppointment.ActualDuration ServiceAppointment.ActualEndTime ServiceAppointment.ActualStartTime ServiceAppointment.AdditionalInformation ServiceAppointment.IsAnonymousBooking ServiceAppointment.AppointmentCategoryId ServiceAppointment.FSL__Appointment_Grade__c ServiceAppointment.AppointmentMode ServiceAppointment.AppointmentNumber ServiceAppointment.AppointmentReasonId ServiceAppointment.AppointmentType ServiceAppointment.ArrivalWindowEndTime ServiceAppointment.ArrivalWindowStartTime Asset.Id Asset.Name Asset.AssetProvidedById Asset.AssetServicedById ServiceAppointment.AssociatedProduct ServiceAppointment.AttendeeLimit ServiceAppointment.FSL__Auto_Schedule__c ServiceAppointment.IsBundle ServiceAppointment.IsBundleMember ServiceAppointment.CancellationReason ServiceAppointment.CheckedInTime Asset.City ServiceAppointment.City ServiceAppointment.Comments Asset.IsCompetitorProduct Asset.ContactId ServiceAppointment.ContactId Asset.Country ServiceAppointment.Country Asset.CountryCode ServiceAppointment.CountryCode Asset.CreatedById ServiceAppointment.CreatedById Asset.CreatedDate ServiceAppointment.CreatedDate ServiceAppointment.DueDate ServiceAppointment.Duration ServiceAppointment.DurationInMinutes ServiceAppointment.DurationType ServiceAppointment.EarliestStartTime ServiceAppointment.Email ServiceAppointment.FSL__Emergency__c ServiceAppointment.EngagementChannelTypeId ServiceAppointment.FSL__GanttColor__c ServiceAppointment.FSL__Gantt_Display_Date__c ServiceAppointment.FSL__GanttLabel__c Asset.GeocodeAccuracy ServiceAppointment.GeocodeAccuracy ServiceAppointment.GroupAppointmentAccessType ServiceAppointment.FSL__InJeopardy__c ServiceAppointment.FSL__InJeopardyReason__c Asset.InstallDate Asset.IsInternal ServiceAppointment.FSL__InternalSLRGeolocation__Latitude__s ServiceAppointment.FSL__InternalSLRGeolocation__Longitude__s ServiceAppointment.FSL__IsFillInCandidate__c ServiceAppointment.FSL__IsMultiDay__c Asset.LastModifiedById ServiceAppointment.LastModifiedById Asset.LastModifiedDate ServiceAppointment.LastModifiedDate ServiceAppointment.FSL__Last_Updated_Epoch__c Asset.Latitude ServiceAppointment.Latitude Asset.Longitude ServiceAppointment.Longitude ServiceAppointment.IsManuallyBundled ServiceAppointment.FSL__MDS_Calculated_length__c ServiceAppointment.IsOffsiteAppointment Asset.OwnerId Asset.ParentId ServiceAppointment.Phone ServiceAppointment.FSL__Pinned__c Asset.PostalCode ServiceAppointment.FSL__Prevent_Geocoding_For_Chatter_Actions__c Asset.Price Asset.Product2Id Asset.PurchaseDate Asset.Quantity ServiceAppointment.RelatedBundleId ServiceAppointment.FSL__Related_Service__c Asset.RootAssetId ServiceAppointment.FSL__Same_Day__c ServiceAppointment.FSL__Same_Resource__c ServiceAppointment.FSL__Duration_In_Minutes__c ServiceAppointment.SchedEndTime ServiceAppointment.SchedStartTime ServiceAppointment.FSL__Schedule_Mode__c ServiceAppointment.FSL__Schedule_over_lower_priority_appointment__c ServiceAppointment.FSL__Scheduling_Policy_Used__c Asset.SerialNumber ServiceAppointment.Id ServiceAppointment.SourceSystem ServiceAppointment.SourceSystemIdentifier ServiceAppointment.SourceSystemResponse Asset.State ServiceAppointment.State Asset.StateCode ServiceAppointment.StateCode Asset.Status ServiceAppointment.Status ServiceAppointment.StatusCategory ServiceAppointment.StatusReason Asset.Street ServiceAppointment.Street ServiceAppointment.Subject ServiceAppointment.ServiceTerritoryId ServiceAppointment.FSL__Time_Dependency__c ServiceAppointment.FSL__UpdatedByOptimization__c Asset.UsageEndDate ServiceAppointment.FSL__Use_Async_Logic__c ServiceAppointment.FSL__Virtual_Service_For_Chatter_Action__c ServiceAppointment.WorkTypeId ServiceAppointment.PostalCode
Name Index
Label Index
Type AUTO NUMBER
Help Text Index in the Recordset Filter Criteria Rule
Name UsageRateField
Label Usage Rate Field
Type PICKLIST
Help Text This field stores the daily usage rate of the asset. The unit for the usage rate must be per day.
Picklist values Asset.AccountId ServiceAppointment.AccountId ServiceAppointment.ActualDuration ServiceAppointment.ActualEndTime ServiceAppointment.ActualStartTime ServiceAppointment.AdditionalInformation ServiceAppointment.IsAnonymousBooking ServiceAppointment.AppointmentCategoryId ServiceAppointment.FSL__Appointment_Grade__c ServiceAppointment.AppointmentMode ServiceAppointment.AppointmentNumber ServiceAppointment.AppointmentReasonId ServiceAppointment.AppointmentType ServiceAppointment.ArrivalWindowEndTime ServiceAppointment.ArrivalWindowStartTime Asset.Id Asset.Name Asset.AssetProvidedById Asset.AssetServicedById ServiceAppointment.AssociatedProduct ServiceAppointment.AttendeeLimit ServiceAppointment.FSL__Auto_Schedule__c ServiceAppointment.IsBundle ServiceAppointment.IsBundleMember ServiceAppointment.CancellationReason ServiceAppointment.CheckedInTime Asset.City ServiceAppointment.City ServiceAppointment.Comments Asset.IsCompetitorProduct Asset.ContactId ServiceAppointment.ContactId Asset.Country ServiceAppointment.Country Asset.CountryCode ServiceAppointment.CountryCode Asset.CreatedById ServiceAppointment.CreatedById Asset.CreatedDate ServiceAppointment.CreatedDate ServiceAppointment.DueDate ServiceAppointment.Duration ServiceAppointment.DurationInMinutes ServiceAppointment.DurationType ServiceAppointment.EarliestStartTime ServiceAppointment.Email ServiceAppointment.FSL__Emergency__c ServiceAppointment.EngagementChannelTypeId ServiceAppointment.FSL__GanttColor__c ServiceAppointment.FSL__Gantt_Display_Date__c ServiceAppointment.FSL__GanttLabel__c Asset.GeocodeAccuracy ServiceAppointment.GeocodeAccuracy ServiceAppointment.GroupAppointmentAccessType ServiceAppointment.FSL__InJeopardy__c ServiceAppointment.FSL__InJeopardyReason__c Asset.InstallDate Asset.IsInternal ServiceAppointment.FSL__InternalSLRGeolocation__Latitude__s ServiceAppointment.FSL__InternalSLRGeolocation__Longitude__s ServiceAppointment.FSL__IsFillInCandidate__c ServiceAppointment.FSL__IsMultiDay__c Asset.LastModifiedById ServiceAppointment.LastModifiedById Asset.LastModifiedDate ServiceAppointment.LastModifiedDate ServiceAppointment.FSL__Last_Updated_Epoch__c Asset.Latitude ServiceAppointment.Latitude Asset.Longitude ServiceAppointment.Longitude ServiceAppointment.IsManuallyBundled ServiceAppointment.FSL__MDS_Calculated_length__c ServiceAppointment.IsOffsiteAppointment Asset.OwnerId Asset.ParentId ServiceAppointment.Phone ServiceAppointment.FSL__Pinned__c Asset.PostalCode ServiceAppointment.FSL__Prevent_Geocoding_For_Chatter_Actions__c Asset.Price Asset.Product2Id Asset.PurchaseDate Asset.Quantity ServiceAppointment.RelatedBundleId ServiceAppointment.FSL__Related_Service__c Asset.RootAssetId ServiceAppointment.FSL__Same_Day__c ServiceAppointment.FSL__Same_Resource__c ServiceAppointment.FSL__Duration_In_Minutes__c ServiceAppointment.SchedEndTime ServiceAppointment.SchedStartTime ServiceAppointment.FSL__Schedule_Mode__c ServiceAppointment.FSL__Schedule_over_lower_priority_appointment__c ServiceAppointment.FSL__Scheduling_Policy_Used__c Asset.SerialNumber ServiceAppointment.Id ServiceAppointment.SourceSystem ServiceAppointment.SourceSystemIdentifier ServiceAppointment.SourceSystemResponse Asset.State ServiceAppointment.State Asset.StateCode ServiceAppointment.StateCode Asset.Status ServiceAppointment.Status ServiceAppointment.StatusCategory ServiceAppointment.StatusReason Asset.Street ServiceAppointment.Street ServiceAppointment.Subject ServiceAppointment.ServiceTerritoryId ServiceAppointment.FSL__Time_Dependency__c ServiceAppointment.FSL__UpdatedByOptimization__c Asset.UsageEndDate ServiceAppointment.FSL__Use_Async_Logic__c ServiceAppointment.FSL__Virtual_Service_For_Chatter_Action__c ServiceAppointment.WorkTypeId ServiceAppointment.PostalCode
Name UsageRateUnit
Label Usage Rate Unit
Type PICKLIST
Help Text This enum value that define different options for Usage Rate Field.
Picklist values Day