The column
Label in the report is used to derive a letter to show in each pin. Only the first letter from the label is shown.
The map region has static id "mymap".
Query for map plugin:
select c003 as lat, c004 as lng, c002 as name, c001 as id,
c002 || ' (id=' || c001 || ')' as info ,
'' AS icon,
c006 as label
from apex_collections
where collection_name = 'MAP'