# configsetup

description: Picking document
lookupsql:
  SELECT DOCCONFIG.ID, DOCCONFIG.DESCRIPTION FROM DOCCONFIG JOIN ENTITYTYPE_DOCCONFIG ON ENTITYTYPE_DOCCONFIG.DOCCONFIG_ID = DOCCONFIG.ID AND ENTITYTYPE_DOCCONFIG.ENTITYTYPE_ID = 2004 AND ENTITYTYPE_DOCCONFIG.DELETED = 0 WHERE DOCCONFIG.MOVE_


description: Texto para a autorização de clientes
lookupsql:
  [COMPANY_NAME],"[Company Name]";[COMPANY_ADDRESS],"[Company Address]";[COMPANY_PHONE],"[Company Phone]";[COMPANY_MAIL],"[Company EMail]";[SYSTEM_DATE],"[Date]";[ENTITY_NAME],"[Entity Name]";[TAX_NUMBER],"[Tax Number]"


description: Local
lookupsql:
  select LOCAL.ID, LOCAL.DESCRIPTION from LOCAL where LOCAL.DELETED = 0 and <CODE>write(EmployeeRelation('LOCAL'))</CODE>


description: Requer entidade
lookupsql:
  SELECT ID, DESCRIPTION FROM ENTITY JOIN SUPPLIER ON ENTITY.ID = SUPPLIER.ENTITY_ID AND SUPPLIER.DELETED = 0 ORDER BY DESCRIPTION


description: Centro de distribuição
lookupsql:
  SELECT ID, DESCRIPTION FROM ENTITY JOIN WAREHOUSE ON ENTITY.ID = WAREHOUSE.ENTITY_ID AND WAREHOUSE.DELETED = 0 ORDER BY DESCRIPTION


