Histórico

Consistem¶

Índice

GEOvendas
Força de Vendas
Business to Business (B2B)
CRM

GEO - Representantes¶

select
        '1' as codEmpresa
        , codRepres as codRepres 
        , nome as nome
        , telefone || DECODE(celular,null,' ',' / '||celular) as telefone
        , email as email    
        , endereco as endereco
        , bairro as bairro
        , cep as CEP
        , csci->nome as Cidade
        , csci->estado as UF
        , csci->codIBGE as codIBGE
        , decode(situacao,1,0,2,1,3,1,4,0,0) as situacao
        , null as CodRepresAgrupador
        , celular as telefone2
        , null as telefone3
        , null as codigoAdministrador
        , cnpjcpf as cnpj
        , null as codAgrupadorEscritorio
        , null as flagAgrupadorMaster
        , null as percComissa
        , null as codigoPessoaFisica
        , null as nomePessoaFisica
        , null as senhaAPi
        , null as Origem
        , null as fantasia
        , null as empresaIntegracaoPedido
        , null as marcas
        , null as flagPermiteVendaPorFamilia
FROM    ibtech.ftre re
WHERE   codempresa in (1)
and exists (select top 1 r.codrepres from ibtech.ftcr r where r.codempresa = 1 and r.codrepres = re.codRepres and $length(r.ftcl->cnpjcpf)= 14)

GEO - Representante Gerente¶

Documentação: Representante Gerente

Adicionar SQL

GEO - Municípios do Representante¶

Documentação: Municípios do Representante

Adicionar SQL

GEO - Municípios do ERP¶

Documentação: Municípios do ERP

Adicionar SQL

GEO - Clientes e Prospects¶

Documentação: Clientes e Prospects

select 
        '1' codEmpresa
        , cidadecodIBGE as codIBGE
        , codCliente as codCliente
        , 1 as tipo /* 1 - Cliente, 2 - Prospect*/
        , rtrim(ltrim(Icf.Replace(nome,{fn CHAR(0)},' '))) as nome
        , decode(situacao,2,0,3,2,4,99,situacao) as situacao
        , codRepres as codRepres1
        , codRepres2 as codRepres2
        , codRepres3 as codRepres3
        , ibtech.ftcl_filtrarTelefone(telefone) as telefone
        , nvl(Icf.Replace(email,,{fn CHAR(0)},' '),Icf.Replace(emailNFE,,{fn CHAR(0)},' ')) as email
        , Icf.Replace(endrua,{fn CHAR(0)},' ') as endereco
        , Icf.Replace(endbairro,{fn CHAR(0)},' ') as bairro
        , cep as CEP
        , dataCadastro as dataCadastro
        , cnpjCpf as cnpjCpf
        , emailCobranca as emailCobranca
        , Icf.Replace(endbairro,{fn CHAR(0)},' ') as nomeDistritoBairro
        , ibtech.ftcl_filtrarTelefone(celular) as celular -- colocado por ivo essa storedprocedure para nõa gerar pendencia de alteração de cliente
        , inscricaoEstadual as inscricaoEstadual
        , endNumero as enderecoNumero
        , null as complemento
        , null as IndicePontualidade
        , ibtech.ftcl_filtrarTelefone(fax) as telefone2 -- colocado por ivo essa storedprocedure para nõa gerar pendencia de alteração de cliente
        , null as telefoneCobranca
        , ibtech.ccccli_pegarClienteAgrupador(codEmpresa,codCliente,1,0,1) as grupoCliente
        , ibtech.ccccli_pegarClienteAgrupador(codEmpresa,codCliente,1,0,1) as codClientePrincipal
        , null as situacaoEdt
        , ibtech.ccccli_pegarClienteAgrupador(codEmpresa,codCliente,3,0,1) as nomeGrupoCliente
        , null as flagInadimplente
        , null as cidade
        , null as uf
        , rtrim(ltrim(nvl(Icf.Replace(nomeFantasia,{fn CHAR(0)},' '),nome))) as nomeFantasia
        , null as ramoAtividade
        , null as dataPrimeiraCompra
        , null as dataUltimaCompra
        , null as maiorCompra
        , null as maiorAcumulado
        , codCliente as codClienteERP
        , null as codRamoAtividade
        , ftlc -> valor as limiteCredito
        , null as ultimoFaturamento
        , null as dataReativacao
        , null as codSitCreditoERP
        , null as descSitCreditoERP
        , IBTech.CCDC_temVencidosHoje(codEmpresa,codCliente) as motivoInativo
        , null as diasVencimentoTitulo
        , null as socios
        , null as cidadeGrupoCliente
        , null as classificacaoERP
        , null as instagram
        , null as facebook
        , null as marcasLiberadas
        , nvl(Icf.Replace(emailNFE,,{fn CHAR(0)},' '),Icf.Replace(email,,{fn CHAR(0)},' ')) as emailNfe
from    ibtech.ftcl
where   codempresa in (1)
and     +codcliente <> 0
and     $length(cnpjcpf)=14

GEO - Cliente Dos Representantes¶

Documentação: Cliente Dos Representantes

SELECT 
        '1' as Codempresa
        , codcliente as CodigoCliente
        , codRepres as CodigoRepres
        , '1' as FlagEPrincipal
FROM (
  SELECT f.codcliente as codcliente,codRepres as codRepres
  FROM ibtech.ftcl f
  WHERE codempresa = 1
  AND $length(f.cnpjcpf) <> 11
) a
GROUP BY  codcliente
        , codRepres