confirm_check_reconciliation

PostgREST stored procedure — POST /rest/v1/rpc/confirm_check_reconciliation.

These are SECURITY DEFINER functions granted only to the service role (execute is revoked from anon/authenticated). They bypass table RLS and enforce their own company_id and status checks internally, so call them server-side with the service-role key:

const { data, error } = await supabase.rpc('confirm_check_reconciliation', { p_actor, p_applications, p_check_id, p_company_id });

Arguments

Argument	Type	Required
p_actor	uuid	yes
p_applications	jsonb	yes
p_check_id	uuid	yes
p_company_id	uuid	yes

Generated from specs/supabase.json. The function's behaviour is defined by its SQL migration; this page documents its call signature only.