Rules & Calculation Formulas · Calculation functionsOperational Master Data RepositoriesRules & Calculation Formulas
Effective-dated selection
FN-12- Category
- Selection
Exactly one record must match the criteria and be in effect on the day. None, or more than one, stops every calculation that depends on it: there is no fallback value.
SELECT the one record WHERE criteria match AND valid from ≤ date ≤ valid to
Example: VAT code for EG, standard, on 2026-10-15 → EG-VAT-STD (14%)
Used by rules
—