prepare_payroll_draft

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

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('prepare_payroll_draft', { p_company_id, p_payments, p_period_end, p_period_start, p_prepared_by, p_total_centavos });

Arguments

Argument	Type	Required
`p_company_id`	`uuid`	yes
`p_payments`	`jsonb`	yes
`p_period_end`	`date`	yes
`p_period_start`	`date`	yes
`p_prepared_by`	`uuid`	yes
`p_total_centavos`	`bigint`	yes

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

Arguments​

Arguments