Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.
TypeScript ai-agentsbill-of-materialserpinventory-managementleanmanufacturingmanufacturing-execution-systemmcp-servermesmrpopen-source-erppostgresqlproduction-planningqmsquality-management-systemreact-routerself-hostedsupabasetraceabilitytypescript
CREATE OR REPLACE FUNCTION util.document_sequence_number(p_value text, p_prefix text, p_suffix text, p_size integer)
RETURNS bigint
LANGUAGE plpgsql
IMMUTABLE
AS $function$
DECLARE
v_digits text;
BEGIN
-- The number get_next_sequence would have formatted as p_value, or NULL when
-- p_value is not in the sequence's format (a custom id such as "ACME-1").
v_digits := substring(p_value FROM util.document_sequence_pattern(p_prefix, p_suffix, p_size));
IF v_digits IS NULL OR length(v_digits) > 18 THEN
RETURN NULL;
END IF;
RETURN v_digits::bigint;
END;
$function$;