flag_rules: foreign_supplier

Definicie pravidiel pre cervene vlajky (red flags). Kazde pravidlo obsahuje SQL podmienku, ktora sa vyhodnocuje voci zmluvam. Nove pravidla je mozne pridat cez CLI alebo priamo do tabulky.

This data as json

id label description severity sql_condition needs_extraction enabled created_at
foreign_supplier Zahranicny dodavatel Dodavatel je registrovany v zahranici podla registra uctovnych zavierok (RUZ) info z.dodavatel_ico IS NOT NULL AND z.dodavatel_ico != '' AND z.dodavatel_ico IN (SELECT cin FROM ruz_entities WHERE region = 'Zahraničie' AND cin IS NOT NULL) 0 1 2026-03-07 20:38:29

Links from other tables