teste.php

select 
      DOCHEADER.ID,
      DOCHEADER.DOC_PREFIX,
      DOCHEADER.DOC_NUMBER,
      DOCHEADER.ACCUMULATOR as acumulador,
      DOCHEADER.CLOCK_DATE data_FP,
      DOCHEADER.ENTITY_ID as client_id,
      ENTITY.DESCRIPTION as cliente,
      EMPLOYEE.INTERNAL_NAME as funcionario,
      LOCAL.DESCRIPTION as local,
      DOCHEADER.OBS as obs
      from DOCHEADER
      JOIN ENTITY on ENTITY.ID = DOCHEADER.ENTITY_ID
      JOIN LOCAL on LOCAL.ID = DOCHEADER.LOCAL_ID
      JOIN EMPLOYEE on EMPLOYEE.ENTITY_ID = DOCHEADER.employee_id
      Where DOCHEADER.DELETED=0 and local = 'Delivery'
      ORDER by data_FP