Vendedores: vw_salesman

vw_salesman expone el catálogo de vendedores consolidando:

• identidad base desde vw_party (nombres, tax_id y contacto),

• datos comerciales del rol vendedor (salesman_code, comisiones),

• zona geográfica asignada (tabla zone).

Casos de uso - Queries de ejemplo (para probar)

1) Listado general de vendedores

SELECT party_id, salesman_code, legalname, zone_name, primary_phone
FROM public.vw_salesman
ORDER BY legalname;

Vendedores por zona

SELECT zone_name, COUNT(*) AS qty
FROM public.vw_salesman
GROUP BY zone_name
ORDER BY qty DESC;

Clientes por vendedor (usando vw_client)

SELECT
  c.salesman_id,
  c.salesman_name,
  COUNT(*) AS client_qty
FROM public.vw_client c
WHERE c.salesman_id IS NOT NULL
GROUP BY c.salesman_id, c.salesman_name
ORDER BY client_qty DESC;