API Name: Filter__c

Filters containing SOQL WHERE clauses that allow the customization of certain processes in bill.ON e.g. the Invoice Run.

Label API Name Type Description
Name Name Text(255)
Child Relation ChildRelation__c Text(255) The name of child object. Used to query child records (subscription builder only).
Condition Condition__c TextArea The condition describing the logic of this filter in the format of a SOQL WHERE clause, e.g. "StartDate__c <= 2013-12-11". If left empty, matches all records of the specified type.
Filter Group FilterGroup__c Text(255) Allows to restrict the filter selection by a common group. A common way to group filters is the use of the business entity. This option is UI only.
Parent Relationships ParentRelationships__c Text(255) Describes parent relationships for target as JSON. For example: {"AccountId": "Account"}. Each key is the API field name on the target SObject. The value of a key ist the SObject type.
Sequence Sequence__c Number(18, 0) The position of this filter in Filter picklists.
Subchild Relation SubchildRelation__c Text(255) The name of the subchild object. Used to query subchild records for price tier information (subscription builder only).
Target Target__c Text(255) The API name of the sObject that is targeted by this filter.
Transactional Suffix TransactionalSuffix__c Text(5) The suffix for control fields used when converting records multiple times for different invoice recipients with the transaction builder (use case: Continuous) or the generic invoice run (use case: Generic).
Use Case UseCase__c Text(255) The filter use case: "SubscriptionBuilder", "New", "Reorder", "Upgrade" (subscription builder), "Continuous"/"Continuous Daily" (transaction builder), "Generic" (generic invoice run), "AccountStatement" (account statement run), empty (regular invoice run)