Filters
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) |