Problem with huge queries [CORE3713] #4061
Comments
Modified by: Marco Castro (mcastro)description: Queries that brings too many fields don't be processed. The following Linq query brings data from 4 tables: var x = CONTA_CORRENTE.Include("Operacoes").Include("NOTAS_SAIDA").Include("NOTAS_SAIDA.ITENS_NOTA_SAIDA"); The FireBird message from the provider is: Dynamic SQL Error If I run the same query in SQL Manager 2005, the message is: Dynamic SQL Error. If I reduce the number of selected fields, the query works. If I take off a complex condition the query also runs. In other words, when I reduce the query it works. The generated query by the prodiver is this: SELECT => Queries that brings too many fields don't be processed. The following Linq query brings data from 4 tables: var x = CONTA_CORRENTE.Include("Operacoes").Include("NOTAS_SAIDA").Include("NOTAS_SAIDA.ITENS_NOTA_SAIDA"). The FireBird message from the provider is: Dynamic SQL Error If I run the same query in SQL Manager 2005, the message is: Dynamic SQL Error. If I reduce the number of selected fields, the query works. If I take off a complex condition the query also runs. In other words, when I reduce the query it works. The generated query by the prodiver is this: SELECT |
|
Commented by: Marco Castro (mcastro) I noticed that the CODIGO_INVERSO_WMS that makes a many to many relatiob may the couse of the problem. Taking if off the Entity map que query start to work. I need to compare an OPERACOES's field and this other table entered in the query with no necessity. This generated code was not need: FROM "OPERACOES" AS "Extent27" LEFT OUTER JOIN "CODIGO_INVERSO_WMS" wasn't necessary. |
|
Commented by: @dyemanov The length of the SQL statement is limited by 64KB. This is the API limitation existing in all Firebird versions and it's not going to disappear immediately. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: No test => Deferred Test Details: Very interesting example (for test) but where DDL of these tables ? |
Submitted by: Marco Castro (mcastro)
Duplicates CORE1117
Queries that brings too many fields don't be processed. The following Linq query brings data from 4 tables:
var x = CONTA_CORRENTE.Include("Operacoes").Include("NOTAS_SAIDA").Include("NOTAS_SAIDA.ITENS_NOTA_SAIDA").
Where(w => w.DATA_EMISSAO >= _from && w.DATA_EMISSAO <= _to
&& (w.OPERACOES.SAI_EM_RELATORIOS == 1 || ae.Contains((int)w.OPERACOES.ALTERA_ESTOQUE))
&& w.NOTA_SAIDA != null
&& w.NOTAS_SAIDA.STATUS == 0
&& w.NOTAS_SAIDA.CANCELADA == 0
&& (w.OPERACOES.ENTRA_OU_SAI == 5 || w.OPERACOES.ENTRA_OU_SAI == 11)
&& SAI_EM_RELATORIOS.Select(d => d.TIPO_NOTA).Contains(w.NOTAS_SAIDA.TIPO_NOTA)).
The FireBird message from the provider is:
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 309, column 12
If I run the same query in SQL Manager 2005, the message is:
Dynamic SQL Error.
SQL error code = -104.
Unexpected end of command - line 552, column 2366.
If I reduce the number of selected fields, the query works. If I take off a complex condition the query also runs. In other words, when I reduce the query it works.
The generated query by the prodiver is this:
SELECT
"Project2"."CODOPERACAO2" AS "CODOPERACAO",
"Project2"."CODOPERACAO1" AS "CODOPERACAO1",
"Project2"."CODOPERACAO4" AS "CODOPERACAO2",
"Project2"."CODOPERACAO3" AS "CODOPERACAO3",
"Project2"."CODOPERACAO6" AS "CODOPERACAO4",
"Project2"."CODOPERACAO5" AS "CODOPERACAO5",
"Project2"."CODOPERACAO8" AS "CODOPERACAO6",
"Project2"."CODOPERACAO7" AS "CODOPERACAO7",
"Project2"."CODOPERACAO10" AS "CODOPERACAO8",
"Project2"."CODOPERACAO9" AS "CODOPERACAO9",
"Project2"."CODOPERACAO12" AS "CODOPERACAO10",
"Project2"."CODOPERACAO11" AS "CODOPERACAO11",
"Project2"."CODOPERACAO14" AS "CODOPERACAO12",
"Project2"."CODOPERACAO13" AS "CODOPERACAO13",
"Project2"."CODOPERACAO16" AS "CODOPERACAO14",
"Project2"."CODOPERACAO15" AS "CODOPERACAO15",
"Project2"."NOTASAIDA1" AS "NOTASAIDA",
"Project2"."CODOPERACAO18" AS "CODOPERACAO16",
"Project2"."CODOPERACAO17" AS "CODOPERACAO17",
"Project2"."CODOPERACAO20" AS "CODOPERACAO18",
"Project2"."CODOPERACAO19" AS "CODOPERACAO19",
"Project2"."CODOPERACAO22" AS "CODOPERACAO20",
"Project2"."CODOPERACAO24" AS "CODOPERACAO21",
"Project2"."CODOPERACAO23" AS "CODOPERACAO22",
"Project2"."LANCAMENTO" AS "LANCAMENTO",
"Project2"."FILIAL" AS "FILIAL",
"Project2"."CLIENTE" AS "CLIENTE",
"Project2"."TIPO_DOCUMENTO" AS "TIPO_DOCUMENTO",
"Project2"."NUMERO_DOCUMENTO" AS "NUMERO_DOCUMENTO",
"Project2"."USUARIO" AS "USUARIO",
"Project2"."DATA_LANCAMENTO" AS "DATA_LANCAMENTO",
"Project2"."DATA_EMISSAO" AS "DATA_EMISSAO",
"Project2"."VALOR" AS "VALOR",
"Project2"."VALOR_PAGO" AS "VALOR_PAGO",
"Project2"."TRANSACAO" AS "TRANSACAO",
"Project2"."DUPLICATA" AS "DUPLICATA",
"Project2"."XREF" AS "XREF",
"Project2"."SERIE_SUB" AS "SERIE_SUB",
"Project2"."CODOPERACAO" AS "CODOPERACAO23",
"Project2"."CODIGO_OF" AS "CODIGO_OF",
"Project2"."NOTASAIDA" AS "NOTASAIDA1",
"Project2"."NOTA_ENTRADA" AS "NOTA_ENTRADA",
"Project2"."TIPO_NOTA" AS "TIPO_NOTA",
"Project2"."TIPO" AS "TIPO",
"Project2"."DESCONTO" AS "DESCONTO",
"Project2"."NOSSO_NUMERO" AS "NOSSO_NUMERO",
"Project2"."DATA_BOLETA" AS "DATA_BOLETA",
"Project2"."HISTORICO" AS "HISTORICO",
"Project2"."DATA_SAIDA" AS "DATA_SAIDA",
"Project2"."BASE_ICMS" AS "BASE_ICMS",
"Project2"."VALOR_ICMS" AS "VALOR_ICMS",
"Project2"."BASE_ICMS_SUBST" AS "BASE_ICMS_SUBST",
"Project2"."VALOR_ICMS_SUBST" AS "VALOR_ICMS_SUBST",
"Project2"."ALIQUOTA_ICMS" AS "ALIQUOTA_ICMS",
"Project2"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO",
"Project2"."VALOR_IPI" AS "VALOR_IPI",
"Project2"."PIS" AS "PIS",
"Project2"."COFINS" AS "COFINS",
"Project2"."CSLL" AS "CSLL",
"Project2"."VALOR_PIS" AS "VALOR_PIS",
"Project2"."VALOR_COFINS" AS "VALOR_COFINS",
"Project2"."VALOR_CSLL" AS "VALOR_CSLL",
"Project2"."CODIGO_OF2" AS "CODIGO_OF2",
"Project2"."CODIGO_OF3" AS "CODIGO_OF3",
"Project2"."FRETE" AS "FRETE",
"Project2"."REPARTE" AS "REPARTE",
"Project2"."CONTA_BANCARIA" AS "CONTA_BANCARIA",
"Project2"."VALOR_IRRF" AS "VALOR_IRRF",
"Project2"."VALOR_ISS" AS "VALOR_ISS",
"Project2"."VALOR_LIQUIDO" AS "VALOR_LIQUIDO",
"Project2"."VALOR_INSS" AS "VALOR_INSS",
"Project2"."CREDITA_ICMS" AS "CREDITA_ICMS",
"Project2"."AREA" AS "AREA",
"Project2"."COD_CONT_IRRF" AS "COD_CONT_IRRF",
"Project2"."NOTIMEUPDATE" AS "NOTIMEUPDATE",
"Project2"."IPTE" AS "IPTE",
"Project2"."DATA_ENVIO_BANCO" AS "DATA_ENVIO_BANCO",
"Project2"."CODIGO_ERRO" AS "CODIGO_ERRO",
"Project2"."HORA_GRAVACAO" AS "HORA_GRAVACAO",
"Project2"."CALCULOVENCIMENTO" AS "CALCULOVENCIMENTO",
"Project2"."VENDEDOR" AS "VENDEDOR",
"Project2"."VALOR_SEGURO" AS "VALOR_SEGURO",
"Project2"."VALOR_DESP_ACESSORIAS" AS "VALOR_DESP_ACESSORIAS",
"Project2"."DESPESAS_ADUANEIRAS" AS "DESPESAS_ADUANEIRAS",
"Project2"."VALOR_IOF" AS "VALOR_IOF",
"Project2"."CODIGO_MODELO" AS "CODIGO_MODELO",
"Project2"."CHAVE_NFE_CTE" AS "CHAVE_NFE_CTE",
"Project2"."CST_CTR" AS "CST_CTR",
"Project2"."ESPELHO_DE" AS "ESPELHO_DE",
"Project2"."CODOPERACAO21" AS "CODOPERACAO24",
"Project2"."TOPICO" AS "TOPICO",
"Project2"."DESCSISTEMA" AS "DESCSISTEMA",
"Project2"."ENTRAOUSAI" AS "ENTRAOUSAI",
"Project2"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO",
"Project2"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS",
"Project2"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO",
"Project2"."CALCULODA" AS "CALCULODA",
"Project2"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS",
"Project2"."ICMS" AS "ICMS",
"Project2"."CARTAOCREDITO" AS "CARTAOCREDITO",
"Project2"."TARIFA" AS "TARIFA",
"Project2"."NOMECARTAO" AS "NOMECARTAO",
"Project2"."DIASRECEBER" AS "DIASRECEBER",
"Project2"."CONDIGNACO" AS "CONDIGNACO",
"Project2"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA",
"Project2"."CONTA" AS "CONTA",
"Project2"."PARCELAS" AS "PARCELAS",
"Project2"."ATIVO" AS "ATIVO",
"Project2"."CATEGORIA" AS "CATEGORIA",
"Project2"."ALTERAESTOQUE" AS "ALTERAESTOQUE",
"Project2"."ISS" AS "ISS",
"Project2"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO",
"Project2"."FINANCEIRO" AS "FINANCEIRO",
"Project2"."GERA_DUPLICATA" AS "GERA_DUPLICATA",
"Project2"."CANCELADO" AS "CANCELADO",
"Project2"."COF_ESTADO" AS "COF_ESTADO",
"Project2"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO",
"Project2"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA",
"Project2"."ULTIMA_ATUALIZACAO1" AS "ULTIMA_ATUALIZACAO1",
"Project2"."COF2_ESTADO" AS "COF2_ESTADO",
"Project2"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO",
"Project2"."COF3_ESTADO" AS "COF3_ESTADO",
"Project2"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO",
"Project2"."TIPO_VALOR" AS "TIPO_VALOR",
"Project2"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO",
"Project2"."CONTA_BANCARIA1" AS "CONTA_BANCARIA1",
"Project2"."OBSERVACAO" AS "OBSERVACAO",
"Project2"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO",
"Project2"."FECHAR" AS "FECHAR",
"Project2"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO",
"Project2"."ENVIAR_EDI" AS "ENVIAR_EDI",
"Project2"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL",
"Project2"."NOTIMEUPDATE1" AS "NOTIMEUPDATE1",
"Project2"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO",
"Project2"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA",
"Project2"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL",
"Project2"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA",
"Project2"."CREDITO_DEBITO" AS "CREDITO_DEBITO",
"Project2"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV",
"Project2"."TABELA_PRECO" AS "TABELA_PRECO",
"Project2"."COF4_ESTADO" AS "COF4_ESTADO",
"Project2"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO",
"Project2"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS",
"Project2"."LICITACAO" AS "LICITACAO",
"Project2"."CODOPOSTO" AS "CODOPOSTO",
"Project2"."NOTASAIDA2" AS "NOTASAIDA2",
"Project2"."TRANSPORTADORA" AS "TRANSPORTADORA",
"Project2"."CLIENTE1" AS "CLIENTE1",
"Project2"."DUPLICATA1" AS "DUPLICATA1",
"Project2"."FILIAL1" AS "FILIAL1",
"Project2"."USUARIO1" AS "USUARIO1",
"Project2"."SERIE" AS "SERIE",
"Project2"."TIPO_NOTA1" AS "TIPO_NOTA1",
"Project2"."NUMERO" AS "NUMERO",
"Project2"."CANCELADA" AS "CANCELADA",
"Project2"."DATAEMISSAO" AS "DATAEMISSAO",
"Project2"."TRANSPORTE" AS "TRANSPORTE",
"Project2"."QUANTIDADE" AS "QUANTIDADE",
"Project2"."ESPECIE" AS "ESPECIE",
"Project2"."PESO" AS "PESO",
"Project2"."DESPESAS" AS "DESPESAS",
"Project2"."TOTAL" AS "TOTAL",
"Project2"."DESCONTO1" AS "DESCONTO1",
"Project2"."DATAACERTO" AS "DATAACERTO",
"Project2"."RESPONSAVEL" AS "RESPONSAVEL",
"Project2"."PEDIDO" AS "PEDIDO",
"Project2"."ULTIMO_ACESSO" AS "ULTIMO_ACESSO",
"Project2"."PEDIDO_INTERNO" AS "PEDIDO_INTERNO",
"Project2"."DATA_ENVIO" AS "DATA_ENVIO",
"Project2"."OBSERVACOES" AS "OBSERVACOES",
"Project2"."DATA_CANCELAMENTO" AS "DATA_CANCELAMENTO",
"Project2"."USUARIO_CANCELOU" AS "USUARIO_CANCELOU",
"Project2"."CODOPERACAO25" AS "CODOPERACAO25",
"Project2"."IMPRESSAO" AS "IMPRESSAO",
"Project2"."FRETE1" AS "FRETE1",
"Project2"."TIPO_CONVERTIDO" AS "TIPO_CONVERTIDO",
"Project2"."CODIGO_CONVERTIDO" AS "CODIGO_CONVERTIDO",
"Project2"."TIPO1" AS "TIPO1",
"Project2"."STATUSFRETE" AS "STATUSFRETE",
"Project2"."IRPJ" AS "IRPJ",
"Project2"."VENDEDOR1" AS "VENDEDOR1",
"Project2"."STATUS" AS "STATUS",
"Project2"."GERAR_ENCOMENDA" AS "GERAR_ENCOMENDA",
"Project2"."USUARIO_STATUS" AS "USUARIO_STATUS",
"Project2"."DATA_STATUS" AS "DATA_STATUS",
"Project2"."CAIXA" AS "CAIXA",
"Project2"."ISS_FONTE" AS "ISS_FONTE",
"Project2"."ULTIMA_ATUALIZACAO2" AS "ULTIMA_ATUALIZACAO2",
"Project2"."ESPELHO_FECHADO" AS "ESPELHO_FECHADO",
"Project2"."OBSERVACOES_2" AS "OBSERVACOES_2",
"Project2"."BOX" AS "BOX",
"Project2"."DOCUMENTO_COLECAO" AS "DOCUMENTO_COLECAO",
"Project2"."CONF_ITENS_USUARIO" AS "CONF_ITENS_USUARIO",
"Project2"."CONF_ITENS_DATA" AS "CONF_ITENS_DATA",
"Project2"."CONF_ITENS_TENTATIVAS" AS "CONF_ITENS_TENTATIVAS",
"Project2"."ESTADO_CORRENTE" AS "ESTADO_CORRENTE",
"Project2"."CONTADOR_FISCAL" AS "CONTADOR_FISCAL",
"Project2"."NOTIMEUPDATE2" AS "NOTIMEUPDATE2",
"Project2"."PLACA_VEICULO" AS "PLACA_VEICULO",
"Project2"."IMPRIMIR_ORDEM_LANCAMENTO" AS "IMPRIMIR_ORDEM_LANCAMENTO",
"Project2"."ROMANEIO_GERADO" AS "ROMANEIO_GERADO",
"Project2"."PROCESSO_INICIO" AS "PROCESSO_INICIO",
"Project2"."PROCESSO_GRAVA" AS "PROCESSO_GRAVA",
"Project2"."PROCESSO_TERMINO" AS "PROCESSO_TERMINO",
"Project2"."MOTIVO_CANCELAMENTO" AS "MOTIVO_CANCELAMENTO",
"Project2"."UF_PLACA_VEICULO" AS "UF_PLACA_VEICULO",
"Project2"."NUMERO_CONHECIMENTO" AS "NUMERO_CONHECIMENTO",
"Project2"."FRETE_NEGOCIADO" AS "FRETE_NEGOCIADO",
"Project2"."APROVACAO_FRETE" AS "APROVACAO_FRETE",
"Project2"."DATA_APROVACAO_FRETE" AS "DATA_APROVACAO_FRETE",
"Project2"."CIDADE_EXPORTACAO" AS "CIDADE_EXPORTACAO",
"Project2"."VOLUME" AS "VOLUME",
"Project2"."NFCOMPLEMENTADA" AS "NFCOMPLEMENTADA",
"Project2"."WMS_DOCUMENTO" AS "WMS_DOCUMENTO",
"Project2"."FAIXA_SIMPLES_NACIONAL" AS "FAIXA_SIMPLES_NACIONAL",
"Project2"."DEVOLUCAO_AVARIA" AS "DEVOLUCAO_AVARIA",
"Project2"."ASSINANTE_CANHOTO" AS "ASSINANTE_CANHOTO",
"Project2"."CI_ASSINANTE_CANHOTO" AS "CI_ASSINANTE_CANHOTO",
"Project2"."DATA_ENTREGA_CLIENTE" AS "DATA_ENTREGA_CLIENTE",
"Project2"."ENTREGADOR" AS "ENTREGADOR",
"Project2"."TELEFONE_ENTREGADOR" AS "TELEFONE_ENTREGADOR",
"Project2"."QTDE_VOLUMES" AS "QTDE_VOLUMES",
"Project2"."DATA_SAIDA_ENTREGADOR" AS "DATA_SAIDA_ENTREGADOR",
"Project2"."DATA_PREVISTA_ENTREGA" AS "DATA_PREVISTA_ENTREGA",
"Project2"."CONFERENTE_CANHOTO" AS "CONFERENTE_CANHOTO",
"Project2"."C1" AS "C1",
"Project2"."NOTASAIDA3" AS "NOTASAIDA3",
"Project2"."LIVRO" AS "LIVRO",
"Project2"."DESCONTO2" AS "DESCONTO2",
"Project2"."PRECOUNITARIO" AS "PRECOUNITARIO",
"Project2"."QUANTIDADE1" AS "QUANTIDADE1",
"Project2"."PRECOMEDIO" AS "PRECOMEDIO",
"Project2"."ATUALIZA_ESTOQUE" AS "ATUALIZA_ESTOQUE",
"Project2"."ISS1" AS "ISS1",
"Project2"."ALIQUOTA_ICMS1" AS "ALIQUOTA_ICMS1",
"Project2"."REDUCAO_ALIQUOTA_ICMS" AS "REDUCAO_ALIQUOTA_ICMS",
"Project2"."PROCESSADO" AS "PROCESSADO",
"Project2"."VALOR_BASE_ICMS" AS "VALOR_BASE_ICMS",
"Project2"."CODIGO_OF1" AS "CODIGO_OF1",
"Project2"."ESTADO" AS "ESTADO",
"Project2"."GERAR_ENCOMENDA1" AS "GERAR_ENCOMENDA1",
"Project2"."DATA_PEDIDO" AS "DATA_PEDIDO",
"Project2"."NOTIMEUPDATE3" AS "NOTIMEUPDATE3",
"Project2"."QUANTIDADE_BAIXADA" AS "QUANTIDADE_BAIXADA",
"Project2"."ALIQUOTA_IPI" AS "ALIQUOTA_IPI",
"Project2"."VALOR_IPI1" AS "VALOR_IPI1",
"Project2"."CONTADOR_USUARIO" AS "CONTADOR_USUARIO",
"Project2"."PRECO_HISTORICO" AS "PRECO_HISTORICO",
"Project2"."VALOR_TOTAL" AS "VALOR_TOTAL",
"Project2"."UNIDADE" AS "UNIDADE",
"Project2"."VALOR_ICMS_COMPLEMENTAR" AS "VALOR_ICMS_COMPLEMENTAR",
"Project2"."I_CST_PIS" AS "I_CST_PIS",
"Project2"."I_CST_COFINS" AS "I_CST_COFINS",
"Project2"."I_CST_CSLL" AS "I_CST_CSLL",
"Project2"."I_CST_ICMS" AS "I_CST_ICMS",
"Project2"."I_ALIQUOTA_PIS" AS "I_ALIQUOTA_PIS",
"Project2"."I_ALIQUOTA_COFINS" AS "I_ALIQUOTA_COFINS",
"Project2"."I_ALIQUOTA_CSLL" AS "I_ALIQUOTA_CSLL",
"Project2"."I_CST_ICMS_SN" AS "I_CST_ICMS_SN",
"Project2"."CAMPANHA" AS "CAMPANHA",
"Project2"."CP_TIPOCLIENTE" AS "CP_TIPOCLIENTE",
"Project2"."CP_TIPOLIVRO" AS "CP_TIPOLIVRO",
"Project2"."CP_EDITORA" AS "CP_EDITORA"
FROM ( SELECT
"Filter2"."LANCAMENTO" AS "LANCAMENTO",
"Filter2"."FILIAL1" AS "FILIAL",
"Filter2"."CLIENTE1" AS "CLIENTE",
"Filter2"."TIPO_DOCUMENTO" AS "TIPO_DOCUMENTO",
"Filter2"."NUMERO_DOCUMENTO" AS "NUMERO_DOCUMENTO",
"Filter2"."USUARIO1" AS "USUARIO",
"Filter2"."DATA_LANCAMENTO" AS "DATA_LANCAMENTO",
"Filter2"."DATA_EMISSAO" AS "DATA_EMISSAO",
"Filter2"."VALOR" AS "VALOR",
"Filter2"."VALOR_PAGO" AS "VALOR_PAGO",
"Filter2"."TRANSACAO" AS "TRANSACAO",
"Filter2"."DUPLICATA1" AS "DUPLICATA",
"Filter2"."XREF" AS "XREF",
"Filter2"."SERIE_SUB" AS "SERIE_SUB",
"Filter2"."CODOPERACAO1" AS "CODOPERACAO",
"Filter2"."CODIGO_OF" AS "CODIGO_OF",
"Filter2"."NOTASAIDA1" AS "NOTASAIDA",
"Filter2"."NOTA_ENTRADA" AS "NOTA_ENTRADA",
"Filter2"."TIPO_NOTA1" AS "TIPO_NOTA",
"Filter2"."TIPO1" AS "TIPO",
"Filter2"."DESCONTO1" AS "DESCONTO",
"Filter2"."NOSSO_NUMERO" AS "NOSSO_NUMERO",
"Filter2"."DATA_BOLETA" AS "DATA_BOLETA",
"Filter2"."HISTORICO" AS "HISTORICO",
"Filter2"."DATA_SAIDA" AS "DATA_SAIDA",
"Filter2"."BASE_ICMS" AS "BASE_ICMS",
"Filter2"."VALOR_ICMS" AS "VALOR_ICMS",
"Filter2"."BASE_ICMS_SUBST" AS "BASE_ICMS_SUBST",
"Filter2"."VALOR_ICMS_SUBST" AS "VALOR_ICMS_SUBST",
"Filter2"."ALIQUOTA_ICMS" AS "ALIQUOTA_ICMS",
"Filter2"."ULTIMA_ATUALIZACAO1" AS "ULTIMA_ATUALIZACAO",
"Filter2"."VALOR_IPI" AS "VALOR_IPI",
"Filter2"."PIS" AS "PIS",
"Filter2"."COFINS" AS "COFINS",
"Filter2"."CSLL" AS "CSLL",
"Filter2"."VALOR_PIS" AS "VALOR_PIS",
"Filter2"."VALOR_COFINS" AS "VALOR_COFINS",
"Filter2"."VALOR_CSLL" AS "VALOR_CSLL",
"Filter2"."CODIGO_OF2" AS "CODIGO_OF2",
"Filter2"."CODIGO_OF3" AS "CODIGO_OF3",
"Filter2"."FRETE1" AS "FRETE",
"Filter2"."REPARTE" AS "REPARTE",
"Filter2"."CONTA_BANCARIA1" AS "CONTA_BANCARIA",
"Filter2"."VALOR_IRRF" AS "VALOR_IRRF",
"Filter2"."VALOR_ISS" AS "VALOR_ISS",
"Filter2"."VALOR_LIQUIDO" AS "VALOR_LIQUIDO",
"Filter2"."VALOR_INSS" AS "VALOR_INSS",
"Filter2"."CREDITA_ICMS" AS "CREDITA_ICMS",
"Filter2"."AREA" AS "AREA",
"Filter2"."COD_CONT_IRRF" AS "COD_CONT_IRRF",
"Filter2"."NOTIMEUPDATE1" AS "NOTIMEUPDATE",
"Filter2"."IPTE" AS "IPTE",
"Filter2"."DATA_ENVIO_BANCO" AS "DATA_ENVIO_BANCO",
"Filter2"."CODIGO_ERRO" AS "CODIGO_ERRO",
"Filter2"."HORA_GRAVACAO" AS "HORA_GRAVACAO",
"Filter2"."CALCULOVENCIMENTO" AS "CALCULOVENCIMENTO",
"Filter2"."VENDEDOR1" AS "VENDEDOR",
"Filter2"."VALOR_SEGURO" AS "VALOR_SEGURO",
"Filter2"."VALOR_DESP_ACESSORIAS" AS "VALOR_DESP_ACESSORIAS",
"Filter2"."DESPESAS_ADUANEIRAS" AS "DESPESAS_ADUANEIRAS",
"Filter2"."VALOR_IOF" AS "VALOR_IOF",
"Filter2"."CODIGO_MODELO" AS "CODIGO_MODELO",
"Filter2"."CHAVE_NFE_CTE" AS "CHAVE_NFE_CTE",
"Filter2"."CST_CTR" AS "CST_CTR",
"Filter2"."ESPELHO_DE" AS "ESPELHO_DE",
"Filter2"."CODOPERACAO2" AS "CODOPERACAO1",
"Filter2"."CODOPERACAO3" AS "CODOPERACAO2",
"Filter2"."CODOPERACAO4" AS "CODOPERACAO3",
"Filter2"."CODOPERACAO5" AS "CODOPERACAO4",
"Filter2"."CODOPERACAO6" AS "CODOPERACAO5",
"Filter2"."CODOPERACAO7" AS "CODOPERACAO6",
"Filter2"."CODOPERACAO8" AS "CODOPERACAO7",
"Filter2"."CODOPERACAO9" AS "CODOPERACAO8",
"Filter2"."CODOPERACAO10" AS "CODOPERACAO9",
"Filter2"."CODOPERACAO11" AS "CODOPERACAO10",
"Filter2"."CODOPERACAO12" AS "CODOPERACAO11",
"Filter2"."CODOPERACAO13" AS "CODOPERACAO12",
"Filter2"."CODOPERACAO14" AS "CODOPERACAO13",
"Filter2"."CODOPERACAO15" AS "CODOPERACAO14",
"Filter2"."CODOPERACAO16" AS "CODOPERACAO15",
"Filter2"."CODOPERACAO17" AS "CODOPERACAO16",
"Filter2"."NOTASAIDA2" AS "NOTASAIDA1",
"Join19"."CODOPERACAO18" AS "CODOPERACAO17",
"Join19"."CODOPERACAO19" AS "CODOPERACAO18",
"Join21"."CODOPERACAO20" AS "CODOPERACAO19",
"Join21"."CODOPERACAO21" AS "CODOPERACAO20",
"Join23"."CODOPERACAO22" AS "CODOPERACAO21",
"Join23"."TOPICO" AS "TOPICO",
"Join23"."DESCSISTEMA" AS "DESCSISTEMA",
"Join23"."ENTRAOUSAI" AS "ENTRAOUSAI",
"Join23"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO",
"Join23"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS",
"Join23"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO",
"Join23"."CALCULODA" AS "CALCULODA",
"Join23"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS",
"Join23"."ICMS" AS "ICMS",
"Join23"."CARTAOCREDITO" AS "CARTAOCREDITO",
"Join23"."TARIFA" AS "TARIFA",
"Join23"."NOMECARTAO" AS "NOMECARTAO",
"Join23"."DIASRECEBER" AS "DIASRECEBER",
"Join23"."CONDIGNACO" AS "CONDIGNACO",
"Join23"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA",
"Join23"."CONTA" AS "CONTA",
"Join23"."PARCELAS" AS "PARCELAS",
"Join23"."ATIVO" AS "ATIVO",
"Join23"."CATEGORIA" AS "CATEGORIA",
"Join23"."ALTERAESTOQUE" AS "ALTERAESTOQUE",
"Join23"."ISS" AS "ISS",
"Join23"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO",
"Join23"."FINANCEIRO" AS "FINANCEIRO",
"Join23"."GERA_DUPLICATA" AS "GERA_DUPLICATA",
"Join23"."CANCELADO" AS "CANCELADO",
"Join23"."COF_ESTADO" AS "COF_ESTADO",
"Join23"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO",
"Join23"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA",
"Join23"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO1",
"Join23"."COF2_ESTADO" AS "COF2_ESTADO",
"Join23"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO",
"Join23"."COF3_ESTADO" AS "COF3_ESTADO",
"Join23"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO",
"Join23"."TIPO_VALOR" AS "TIPO_VALOR",
"Join23"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO",
"Join23"."CONTA_BANCARIA" AS "CONTA_BANCARIA1",
"Join23"."OBSERVACAO" AS "OBSERVACAO",
"Join23"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO",
"Join23"."FECHAR" AS "FECHAR",
"Join23"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO",
"Join23"."ENVIAR_EDI" AS "ENVIAR_EDI",
"Join23"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL",
"Join23"."NOTIMEUPDATE" AS "NOTIMEUPDATE1",
"Join23"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO",
"Join23"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA",
"Join23"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL",
"Join23"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA",
"Join23"."CREDITO_DEBITO" AS "CREDITO_DEBITO",
"Join23"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV",
"Join23"."TABELA_PRECO" AS "TABELA_PRECO",
"Join23"."COF4_ESTADO" AS "COF4_ESTADO",
"Join23"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO",
"Join23"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS",
"Join23"."LICITACAO" AS "LICITACAO",
"Join23"."CODOPERACAO23" AS "CODOPERACAO22",
"Join25"."CODOPERACAO24" AS "CODOPERACAO23",
"Join25"."CODOPERACAO25" AS "CODOPERACAO24",
"Join25"."CODOPOSTO" AS "CODOPOSTO",
"Extent29"."NOTASAIDA" AS "NOTASAIDA2",
"Extent29"."TRANSPORTADORA" AS "TRANSPORTADORA",
"Extent29"."CLIENTE" AS "CLIENTE1",
"Extent29"."DUPLICATA" AS "DUPLICATA1",
"Extent29"."FILIAL" AS "FILIAL1",
"Extent29"."USUARIO" AS "USUARIO1",
"Extent29"."SERIE" AS "SERIE",
"Extent29"."TIPO_NOTA" AS "TIPO_NOTA1",
"Extent29"."NUMERO" AS "NUMERO",
"Extent29"."CANCELADA" AS "CANCELADA",
"Extent29"."DATAEMISSAO" AS "DATAEMISSAO",
"Extent29"."TRANSPORTE" AS "TRANSPORTE",
"Extent29"."QUANTIDADE" AS "QUANTIDADE",
"Extent29"."ESPECIE" AS "ESPECIE",
"Extent29"."PESO" AS "PESO",
"Extent29"."DESPESAS" AS "DESPESAS",
"Extent29"."TOTAL" AS "TOTAL",
"Extent29"."DESCONTO" AS "DESCONTO1",
"Extent29"."DATAACERTO" AS "DATAACERTO",
"Extent29"."RESPONSAVEL" AS "RESPONSAVEL",
"Extent29"."PEDIDO" AS "PEDIDO",
"Extent29"."ULTIMO_ACESSO" AS "ULTIMO_ACESSO",
"Extent29"."PEDIDO_INTERNO" AS "PEDIDO_INTERNO",
"Extent29"."DATA_ENVIO" AS "DATA_ENVIO",
"Extent29"."OBSERVACOES" AS "OBSERVACOES",
"Extent29"."DATA_CANCELAMENTO" AS "DATA_CANCELAMENTO",
"Extent29"."USUARIO_CANCELOU" AS "USUARIO_CANCELOU",
"Extent29"."CODOPERACAO" AS "CODOPERACAO25",
"Extent29"."IMPRESSAO" AS "IMPRESSAO",
"Extent29"."FRETE" AS "FRETE1",
"Extent29"."TIPO_CONVERTIDO" AS "TIPO_CONVERTIDO",
"Extent29"."CODIGO_CONVERTIDO" AS "CODIGO_CONVERTIDO",
"Extent29"."TIPO" AS "TIPO1",
"Extent29"."STATUSFRETE" AS "STATUSFRETE",
"Extent29"."IRPJ" AS "IRPJ",
"Extent29"."VENDEDOR" AS "VENDEDOR1",
"Extent29"."STATUS" AS "STATUS",
"Extent29"."GERAR_ENCOMENDA" AS "GERAR_ENCOMENDA",
"Extent29"."USUARIO_STATUS" AS "USUARIO_STATUS",
"Extent29"."DATA_STATUS" AS "DATA_STATUS",
"Extent29"."CAIXA" AS "CAIXA",
"Extent29"."ISS_FONTE" AS "ISS_FONTE",
"Extent29"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO2",
"Extent29"."ESPELHO_FECHADO" AS "ESPELHO_FECHADO",
"Extent29"."OBSERVACOES_2" AS "OBSERVACOES_2",
"Extent29"."BOX" AS "BOX",
"Extent29"."DOCUMENTO_COLECAO" AS "DOCUMENTO_COLECAO",
"Extent29"."CONF_ITENS_USUARIO" AS "CONF_ITENS_USUARIO",
"Extent29"."CONF_ITENS_DATA" AS "CONF_ITENS_DATA",
"Extent29"."CONF_ITENS_TENTATIVAS" AS "CONF_ITENS_TENTATIVAS",
"Extent29"."ESTADO_CORRENTE" AS "ESTADO_CORRENTE",
"Extent29"."CONTADOR_FISCAL" AS "CONTADOR_FISCAL",
"Extent29"."NOTIMEUPDATE" AS "NOTIMEUPDATE2",
"Extent29"."PLACA_VEICULO" AS "PLACA_VEICULO",
"Extent29"."IMPRIMIR_ORDEM_LANCAMENTO" AS "IMPRIMIR_ORDEM_LANCAMENTO",
"Extent29"."ROMANEIO_GERADO" AS "ROMANEIO_GERADO",
"Extent29"."PROCESSO_INICIO" AS "PROCESSO_INICIO",
"Extent29"."PROCESSO_GRAVA" AS "PROCESSO_GRAVA",
"Extent29"."PROCESSO_TERMINO" AS "PROCESSO_TERMINO",
"Extent29"."MOTIVO_CANCELAMENTO" AS "MOTIVO_CANCELAMENTO",
"Extent29"."UF_PLACA_VEICULO" AS "UF_PLACA_VEICULO",
"Extent29"."NUMERO_CONHECIMENTO" AS "NUMERO_CONHECIMENTO",
"Extent29"."FRETE_NEGOCIADO" AS "FRETE_NEGOCIADO",
"Extent29"."APROVACAO_FRETE" AS "APROVACAO_FRETE",
"Extent29"."DATA_APROVACAO_FRETE" AS "DATA_APROVACAO_FRETE",
"Extent29"."CIDADE_EXPORTACAO" AS "CIDADE_EXPORTACAO",
"Extent29"."VOLUME" AS "VOLUME",
"Extent29"."NFCOMPLEMENTADA" AS "NFCOMPLEMENTADA",
"Extent29"."WMS_DOCUMENTO" AS "WMS_DOCUMENTO",
"Extent29"."FAIXA_SIMPLES_NACIONAL" AS "FAIXA_SIMPLES_NACIONAL",
"Extent29"."DEVOLUCAO_AVARIA" AS "DEVOLUCAO_AVARIA",
"Extent29"."ASSINANTE_CANHOTO" AS "ASSINANTE_CANHOTO",
"Extent29"."CI_ASSINANTE_CANHOTO" AS "CI_ASSINANTE_CANHOTO",
"Extent29"."DATA_ENTREGA_CLIENTE" AS "DATA_ENTREGA_CLIENTE",
"Extent29"."ENTREGADOR" AS "ENTREGADOR",
"Extent29"."TELEFONE_ENTREGADOR" AS "TELEFONE_ENTREGADOR",
"Extent29"."QTDE_VOLUMES" AS "QTDE_VOLUMES",
"Extent29"."DATA_SAIDA_ENTREGADOR" AS "DATA_SAIDA_ENTREGADOR",
"Extent29"."DATA_PREVISTA_ENTREGA" AS "DATA_PREVISTA_ENTREGA",
"Extent29"."CONFERENTE_CANHOTO" AS "CONFERENTE_CANHOTO",
"Extent30"."NOTASAIDA" AS "NOTASAIDA3",
"Extent30"."LIVRO" AS "LIVRO",
"Extent30"."DESCONTO" AS "DESCONTO2",
"Extent30"."PRECOUNITARIO" AS "PRECOUNITARIO",
"Extent30"."QUANTIDADE" AS "QUANTIDADE1",
"Extent30"."PRECOMEDIO" AS "PRECOMEDIO",
"Extent30"."ATUALIZA_ESTOQUE" AS "ATUALIZA_ESTOQUE",
"Extent30"."ISS" AS "ISS1",
"Extent30"."ALIQUOTA_ICMS" AS "ALIQUOTA_ICMS1",
"Extent30"."REDUCAO_ALIQUOTA_ICMS" AS "REDUCAO_ALIQUOTA_ICMS",
"Extent30"."PROCESSADO" AS "PROCESSADO",
"Extent30"."VALOR_BASE_ICMS" AS "VALOR_BASE_ICMS",
"Extent30"."CODIGO_OF" AS "CODIGO_OF1",
"Extent30"."ESTADO" AS "ESTADO",
"Extent30"."GERAR_ENCOMENDA" AS "GERAR_ENCOMENDA1",
"Extent30"."DATA_PEDIDO" AS "DATA_PEDIDO",
"Extent30"."NOTIMEUPDATE" AS "NOTIMEUPDATE3",
"Extent30"."QUANTIDADE_BAIXADA" AS "QUANTIDADE_BAIXADA",
"Extent30"."ALIQUOTA_IPI" AS "ALIQUOTA_IPI",
"Extent30"."VALOR_IPI" AS "VALOR_IPI1",
"Extent30"."CONTADOR_USUARIO" AS "CONTADOR_USUARIO",
"Extent30"."PRECO_HISTORICO" AS "PRECO_HISTORICO",
"Extent30"."VALOR_TOTAL" AS "VALOR_TOTAL",
"Extent30"."UNIDADE" AS "UNIDADE",
"Extent30"."VALOR_ICMS_COMPLEMENTAR" AS "VALOR_ICMS_COMPLEMENTAR",
"Extent30"."I_CST_PIS" AS "I_CST_PIS",
"Extent30"."I_CST_COFINS" AS "I_CST_COFINS",
"Extent30"."I_CST_CSLL" AS "I_CST_CSLL",
"Extent30"."I_CST_ICMS" AS "I_CST_ICMS",
"Extent30"."I_ALIQUOTA_PIS" AS "I_ALIQUOTA_PIS",
"Extent30"."I_ALIQUOTA_COFINS" AS "I_ALIQUOTA_COFINS",
"Extent30"."I_ALIQUOTA_CSLL" AS "I_ALIQUOTA_CSLL",
"Extent30"."I_CST_ICMS_SN" AS "I_CST_ICMS_SN",
"Extent30"."CAMPANHA" AS "CAMPANHA",
"Extent30"."CP_TIPOCLIENTE" AS "CP_TIPOCLIENTE",
"Extent30"."CP_TIPOLIVRO" AS "CP_TIPOLIVRO",
"Extent30"."CP_EDITORA" AS "CP_EDITORA",
CASE WHEN ("Extent30"."NOTASAIDA" IS NULL) THEN NULL ELSE 1 END AS "C1"
FROM (SELECT "Extent1"."LANCAMENTO" AS "LANCAMENTO", "Extent1"."FILIAL" AS "FILIAL1", "Extent1"."CLIENTE" AS "CLIENTE1", "Extent1"."TIPO_DOCUMENTO" AS "TIPO_DOCUMENTO", "Extent1"."NUMERO_DOCUMENTO" AS "NUMERO_DOCUMENTO", "Extent1"."USUARIO" AS "USUARIO1", "Extent1"."DATA_LANCAMENTO" AS "DATA_LANCAMENTO", "Extent1"."DATA_EMISSAO" AS "DATA_EMISSAO", "Extent1"."VALOR" AS "VALOR", "Extent1"."VALOR_PAGO" AS "VALOR_PAGO", "Extent1"."TRANSACAO" AS "TRANSACAO", "Extent1"."DUPLICATA" AS "DUPLICATA1", "Extent1"."XREF" AS "XREF", "Extent1"."SERIE_SUB" AS "SERIE_SUB", "Extent1"."CODOPERACAO" AS "CODOPERACAO1", "Extent1"."CODIGO_OF" AS "CODIGO_OF", "Extent1"."NOTASAIDA" AS "NOTASAIDA1", "Extent1"."NOTA_ENTRADA" AS "NOTA_ENTRADA", "Extent1"."TIPO_NOTA" AS "TIPO_NOTA1", "Extent1"."TIPO" AS "TIPO1", "Extent1"."DESCONTO" AS "DESCONTO1", "Extent1"."NOSSO_NUMERO" AS "NOSSO_NUMERO", "Extent1"."DATA_BOLETA" AS "DATA_BOLETA", "Extent1"."HISTORICO" AS "HISTORICO", "Extent1"."DATA_SAIDA" AS "DATA_SAIDA", "Extent1"."BASE_ICMS" AS "BASE_ICMS", "Extent1"."VALOR_ICMS" AS "VALOR_ICMS", "Extent1"."BASE_ICMS_SUBST" AS "BASE_ICMS_SUBST", "Extent1"."VALOR_ICMS_SUBST" AS "VALOR_ICMS_SUBST", "Extent1"."ALIQUOTA_ICMS" AS "ALIQUOTA_ICMS", "Extent1"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO1", "Extent1"."VALOR_IPI" AS "VALOR_IPI", "Extent1"."PIS" AS "PIS", "Extent1"."COFINS" AS "COFINS", "Extent1"."CSLL" AS "CSLL", "Extent1"."VALOR_PIS" AS "VALOR_PIS", "Extent1"."VALOR_COFINS" AS "VALOR_COFINS", "Extent1"."VALOR_CSLL" AS "VALOR_CSLL", "Extent1"."CODIGO_OF2" AS "CODIGO_OF2", "Extent1"."CODIGO_OF3" AS "CODIGO_OF3", "Extent1"."FRETE" AS "FRETE1", "Extent1"."REPARTE" AS "REPARTE", "Extent1"."CONTA_BANCARIA" AS "CONTA_BANCARIA1", "Extent1"."VALOR_IRRF" AS "VALOR_IRRF", "Extent1"."VALOR_ISS" AS "VALOR_ISS", "Extent1"."VALOR_LIQUIDO" AS "VALOR_LIQUIDO", "Extent1"."VALOR_INSS" AS "VALOR_INSS", "Extent1"."CREDITA_ICMS" AS "CREDITA_ICMS", "Extent1"."AREA" AS "AREA", "Extent1"."COD_CONT_IRRF" AS "COD_CONT_IRRF", "Extent1"."NOTIMEUPDATE" AS "NOTIMEUPDATE1", "Extent1"."IPTE" AS "IPTE", "Extent1"."DATA_ENVIO_BANCO" AS "DATA_ENVIO_BANCO", "Extent1"."CODIGO_ERRO" AS "CODIGO_ERRO", "Extent1"."HORA_GRAVACAO" AS "HORA_GRAVACAO", "Extent1"."CALCULOVENCIMENTO" AS "CALCULOVENCIMENTO", "Extent1"."VENDEDOR" AS "VENDEDOR1", "Extent1"."VALOR_SEGURO" AS "VALOR_SEGURO", "Extent1"."VALOR_DESP_ACESSORIAS" AS "VALOR_DESP_ACESSORIAS", "Extent1"."DESPESAS_ADUANEIRAS" AS "DESPESAS_ADUANEIRAS", "Extent1"."VALOR_IOF" AS "VALOR_IOF", "Extent1"."CODIGO_MODELO" AS "CODIGO_MODELO", "Extent1"."CHAVE_NFE_CTE" AS "CHAVE_NFE_CTE", "Extent1"."CST_CTR" AS "CST_CTR", "Extent1"."ESPELHO_DE" AS "ESPELHO_DE", "Join1"."CODOPERACAO2", "Join1"."TOPICO1", "Join1"."DESCSISTEMA1", "Join1"."ENTRAOUSAI1", "Join1"."FORMAPAGAMENTO1", "Join1"."SAIEMRELATORIOS1", "Join1"."COMPRAVENDADEVOLUCAO1", "Join1"."CALCULODA1", "Join1"."DIREITOSAUTORAIS1", "Join1"."ICMS1", "Join1"."CARTAOCREDITO1", "Join1"."TARIFA1", "Join1"."NOMECARTAO1", "Join1"."DIASRECEBER1", "Join1"."CONDIGNACO1", "Join1"."TIPO_DE_NOTA1", "Join1"."CONTA1", "Join1"."PARCELAS1", "Join1"."ATIVO1", "Join1"."CATEGORIA1", "Join1"."ALTERAESTOQUE1", "Join1"."ISS1", "Join1"."CONDICAO_PAGAMENTO1", "Join1"."FINANCEIRO1", "Join1"."GERA_DUPLICATA1", "Join1"."CANCELADO1", "Join1"."COF_ESTADO1", "Join1"."COF_OUTRO_ESTADO1", "Join1"."DESCRICAO_EXTRA1", "Join1"."ULTIMA_ATUALIZACAO2", "Join1"."COF2_ESTADO1", "Join1"."COF2_OUTRO_ESTADO1", "Join1"."COF3_ESTADO1", "Join1"."COF3_OUTRO_ESTADO1", "Join1"."TIPO_VALOR1", "Join1"."CLIENTE_REMOTO1", "Join1"."CONTA_BANCARIA2", "Join1"."OBSERVACAO1", "Join1"."TIPO_DE_CUSTO1", "Join1"."FECHAR1", "Join1"."CONSIDERAR_DA_RESUMIDO1", "Join1"."ENVIAR_EDI1", "Join1"."HISTORICO_CONTABIL1", "Join1"."NOTIMEUPDATE2", "Join1"."HISTORICO_CONTABIL_QUITACAO1", "Join1"."CONTRA_PARTIDA1", "Join1"."HISTORICO_FISCAL1", "Join1"."CALCULO_VENCIMENTO_VISTA1", "Join1"."CREDITO_DEBITO1", "Join1"."ENVIAR_ESTOQUE_PDV1", "Join1"."TABELA_PRECO1", "Join1"."COF4_ESTADO1", "Join1"."COF4_OUTRO_ESTADO1", "Join1"."CODIGO_OPERACAO_WMS1", "Join1"."LICITACAO1", "Join1"."CODOPERACAO3", "Join1"."CODOPOSTO1", "Join3"."CODOPERACAO4", "Join3"."TOPICO2", "Join3"."DESCSISTEMA2", "Join3"."ENTRAOUSAI2", "Join3"."FORMAPAGAMENTO2", "Join3"."SAIEMRELATORIOS2", "Join3"."COMPRAVENDADEVOLUCAO2", "Join3"."CALCULODA2", "Join3"."DIREITOSAUTORAIS2", "Join3"."ICMS2", "Join3"."CARTAOCREDITO2", "Join3"."TARIFA2", "Join3"."NOMECARTAO2", "Join3"."DIASRECEBER2", "Join3"."CONDIGNACO2", "Join3"."TIPO_DE_NOTA2", "Join3"."CONTA2", "Join3"."PARCELAS2", "Join3"."ATIVO2", "Join3"."CATEGORIA2", "Join3"."ALTERAESTOQUE2", "Join3"."ISS2", "Join3"."CONDICAO_PAGAMENTO2", "Join3"."FINANCEIRO2", "Join3"."GERA_DUPLICATA2", "Join3"."CANCELADO2", "Join3"."COF_ESTADO2", "Join3"."COF_OUTRO_ESTADO2", "Join3"."DESCRICAO_EXTRA2", "Join3"."ULTIMA_ATUALIZACAO3", "Join3"."COF2_ESTADO2", "Join3"."COF2_OUTRO_ESTADO2", "Join3"."COF3_ESTADO2", "Join3"."COF3_OUTRO_ESTADO2", "Join3"."TIPO_VALOR2", "Join3"."CLIENTE_REMOTO2", "Join3"."CONTA_BANCARIA3", "Join3"."OBSERVACAO2", "Join3"."TIPO_DE_CUSTO2", "Join3"."FECHAR2", "Join3"."CONSIDERAR_DA_RESUMIDO2", "Join3"."ENVIAR_EDI2", "Join3"."HISTORICO_CONTABIL2", "Join3"."NOTIMEUPDATE3", "Join3"."HISTORICO_CONTABIL_QUITACAO2", "Join3"."CONTRA_PARTIDA2", "Join3"."HISTORICO_FISCAL2", "Join3"."CALCULO_VENCIMENTO_VISTA2", "Join3"."CREDITO_DEBITO2", "Join3"."ENVIAR_ESTOQUE_PDV2", "Join3"."TABELA_PRECO2", "Join3"."COF4_ESTADO2", "Join3"."COF4_OUTRO_ESTADO2", "Join3"."CODIGO_OPERACAO_WMS2", "Join3"."LICITACAO2", "Join3"."CODOPERACAO5", "Join3"."CODOPOSTO2", "Join5"."CODOPERACAO6", "Join5"."TOPICO3", "Join5"."DESCSISTEMA3", "Join5"."ENTRAOUSAI3", "Join5"."FORMAPAGAMENTO3", "Join5"."SAIEMRELATORIOS3", "Join5"."COMPRAVENDADEVOLUCAO3", "Join5"."CALCULODA3", "Join5"."DIREITOSAUTORAIS3", "Join5"."ICMS3", "Join5"."CARTAOCREDITO3", "Join5"."TARIFA3", "Join5"."NOMECARTAO3", "Join5"."DIASRECEBER3", "Join5"."CONDIGNACO3", "Join5"."TIPO_DE_NOTA3", "Join5"."CONTA3", "Join5"."PARCELAS3", "Join5"."ATIVO3", "Join5"."CATEGORIA3", "Join5"."ALTERAESTOQUE3", "Join5"."ISS3", "Join5"."CONDICAO_PAGAMENTO3", "Join5"."FINANCEIRO3", "Join5"."GERA_DUPLICATA3", "Join5"."CANCELADO3", "Join5"."COF_ESTADO3", "Join5"."COF_OUTRO_ESTADO3", "Join5"."DESCRICAO_EXTRA3", "Join5"."ULTIMA_ATUALIZACAO4", "Join5"."COF2_ESTADO3", "Join5"."COF2_OUTRO_ESTADO3", "Join5"."COF3_ESTADO3", "Join5"."COF3_OUTRO_ESTADO3", "Join5"."TIPO_VALOR3", "Join5"."CLIENTE_REMOTO3", "Join5"."CONTA_BANCARIA4", "Join5"."OBSERVACAO3", "Join5"."TIPO_DE_CUSTO3", "Join5"."FECHAR3", "Join5"."CONSIDERAR_DA_RESUMIDO3", "Join5"."ENVIAR_EDI3", "Join5"."HISTORICO_CONTABIL3", "Join5"."NOTIMEUPDATE4", "Join5"."HISTORICO_CONTABIL_QUITACAO3", "Join5"."CONTRA_PARTIDA3", "Join5"."HISTORICO_FISCAL3", "Join5"."CALCULO_VENCIMENTO_VISTA3", "Join5"."CREDITO_DEBITO3", "Join5"."ENVIAR_ESTOQUE_PDV3", "Join5"."TABELA_PRECO3", "Join5"."COF4_ESTADO3", "Join5"."COF4_OUTRO_ESTADO3", "Join5"."CODIGO_OPERACAO_WMS3", "Join5"."LICITACAO3", "Join5"."CODOPERACAO7", "Join5"."CODOPOSTO3", "Join7"."CODOPERACAO8", "Join7"."TOPICO4", "Join7"."DESCSISTEMA4", "Join7"."ENTRAOUSAI4", "Join7"."FORMAPAGAMENTO4", "Join7"."SAIEMRELATORIOS4", "Join7"."COMPRAVENDADEVOLUCAO4", "Join7"."CALCULODA4", "Join7"."DIREITOSAUTORAIS4", "Join7"."ICMS4", "Join7"."CARTAOCREDITO4", "Join7"."TARIFA4", "Join7"."NOMECARTAO4", "Join7"."DIASRECEBER4", "Join7"."CONDIGNACO4", "Join7"."TIPO_DE_NOTA4", "Join7"."CONTA4", "Join7"."PARCELAS4", "Join7"."ATIVO4", "Join7"."CATEGORIA4", "Join7"."ALTERAESTOQUE4", "Join7"."ISS4", "Join7"."CONDICAO_PAGAMENTO4", "Join7"."FINANCEIRO4", "Join7"."GERA_DUPLICATA4", "Join7"."CANCELADO4", "Join7"."COF_ESTADO4", "Join7"."COF_OUTRO_ESTADO4", "Join7"."DESCRICAO_EXTRA4", "Join7"."ULTIMA_ATUALIZACAO5", "Join7"."COF2_ESTADO4", "Join7"."COF2_OUTRO_ESTADO4", "Join7"."COF3_ESTADO4", "Join7"."COF3_OUTRO_ESTADO4", "Join7"."TIPO_VALOR4", "Join7"."CLIENTE_REMOTO4", "Join7"."CONTA_BANCARIA5", "Join7"."OBSERVACAO4", "Join7"."TIPO_DE_CUSTO4", "Join7"."FECHAR4", "Join7"."CONSIDERAR_DA_RESUMIDO4", "Join7"."ENVIAR_EDI4", "Join7"."HISTORICO_CONTABIL4", "Join7"."NOTIMEUPDATE5", "Join7"."HISTORICO_CONTABIL_QUITACAO4", "Join7"."CONTRA_PARTIDA4", "Join7"."HISTORICO_FISCAL4", "Join7"."CALCULO_VENCIMENTO_VISTA4", "Join7"."CREDITO_DEBITO4", "Join7"."ENVIAR_ESTOQUE_PDV4", "Join7"."TABELA_PRECO4", "Join7"."COF4_ESTADO4", "Join7"."COF4_OUTRO_ESTADO4", "Join7"."CODIGO_OPERACAO_WMS4", "Join7"."LICITACAO4", "Join7"."CODOPERACAO9", "Join7"."CODOPOSTO4", "Join9"."CODOPERACAO10", "Join9"."TOPICO5", "Join9"."DESCSISTEMA5", "Join9"."ENTRAOUSAI5", "Join9"."FORMAPAGAMENTO5", "Join9"."SAIEMRELATORIOS5", "Join9"."COMPRAVENDADEVOLUCAO5", "Join9"."CALCULODA5", "Join9"."DIREITOSAUTORAIS5", "Join9"."ICMS5", "Join9"."CARTAOCREDITO5", "Join9"."TARIFA5", "Join9"."NOMECARTAO5", "Join9"."DIASRECEBER5", "Join9"."CONDIGNACO5", "Join9"."TIPO_DE_NOTA5", "Join9"."CONTA5", "Join9"."PARCELAS5", "Join9"."ATIVO5", "Join9"."CATEGORIA5", "Join9"."ALTERAESTOQUE5", "Join9"."ISS5", "Join9"."CONDICAO_PAGAMENTO5", "Join9"."FINANCEIRO5", "Join9"."GERA_DUPLICATA5", "Join9"."CANCELADO5", "Join9"."COF_ESTADO5", "Join9"."COF_OUTRO_ESTADO5", "Join9"."DESCRICAO_EXTRA5", "Join9"."ULTIMA_ATUALIZACAO6", "Join9"."COF2_ESTADO5", "Join9"."COF2_OUTRO_ESTADO5", "Join9"."COF3_ESTADO5", "Join9"."COF3_OUTRO_ESTADO5", "Join9"."TIPO_VALOR5", "Join9"."CLIENTE_REMOTO5", "Join9"."CONTA_BANCARIA6", "Join9"."OBSERVACAO5", "Join9"."TIPO_DE_CUSTO5", "Join9"."FECHAR5", "Join9"."CONSIDERAR_DA_RESUMIDO5", "Join9"."ENVIAR_EDI5", "Join9"."HISTORICO_CONTABIL5", "Join9"."NOTIMEUPDATE6", "Join9"."HISTORICO_CONTABIL_QUITACAO5", "Join9"."CONTRA_PARTIDA5", "Join9"."HISTORICO_FISCAL5", "Join9"."CALCULO_VENCIMENTO_VISTA5", "Join9"."CREDITO_DEBITO5", "Join9"."ENVIAR_ESTOQUE_PDV5", "Join9"."TABELA_PRECO5", "Join9"."COF4_ESTADO5", "Join9"."COF4_OUTRO_ESTADO5", "Join9"."CODIGO_OPERACAO_WMS5", "Join9"."LICITACAO5", "Join9"."CODOPERACAO11", "Join9"."CODOPOSTO5", "Join11"."CODOPERACAO12", "Join11"."TOPICO6", "Join11"."DESCSISTEMA6", "Join11"."ENTRAOUSAI6", "Join11"."FORMAPAGAMENTO6", "Join11"."SAIEMRELATORIOS6", "Join11"."COMPRAVENDADEVOLUCAO6", "Join11"."CALCULODA6", "Join11"."DIREITOSAUTORAIS6", "Join11"."ICMS6", "Join11"."CARTAOCREDITO6", "Join11"."TARIFA6", "Join11"."NOMECARTAO6", "Join11"."DIASRECEBER6", "Join11"."CONDIGNACO6", "Join11"."TIPO_DE_NOTA6", "Join11"."CONTA6", "Join11"."PARCELAS6", "Join11"."ATIVO6", "Join11"."CATEGORIA6", "Join11"."ALTERAESTOQUE6", "Join11"."ISS6", "Join11"."CONDICAO_PAGAMENTO6", "Join11"."FINANCEIRO6", "Join11"."GERA_DUPLICATA6", "Join11"."CANCELADO6", "Join11"."COF_ESTADO6", "Join11"."COF_OUTRO_ESTADO6", "Join11"."DESCRICAO_EXTRA6", "Join11"."ULTIMA_ATUALIZACAO7", "Join11"."COF2_ESTADO6", "Join11"."COF2_OUTRO_ESTADO6", "Join11"."COF3_ESTADO6", "Join11"."COF3_OUTRO_ESTADO6", "Join11"."TIPO_VALOR6", "Join11"."CLIENTE_REMOTO6", "Join11"."CONTA_BANCARIA7", "Join11"."OBSERVACAO6", "Join11"."TIPO_DE_CUSTO6", "Join11"."FECHAR6", "Join11"."CONSIDERAR_DA_RESUMIDO6", "Join11"."ENVIAR_EDI6", "Join11"."HISTORICO_CONTABIL6", "Join11"."NOTIMEUPDATE7", "Join11"."HISTORICO_CONTABIL_QUITACAO6", "Join11"."CONTRA_PARTIDA6", "Join11"."HISTORICO_FISCAL6", "Join11"."CALCULO_VENCIMENTO_VISTA6", "Join11"."CREDITO_DEBITO6", "Join11"."ENVIAR_ESTOQUE_PDV6", "Join11"."TABELA_PRECO6", "Join11"."COF4_ESTADO6", "Join11"."COF4_OUTRO_ESTADO6", "Join11"."CODIGO_OPERACAO_WMS6", "Join11"."LICITACAO6", "Join11"."CODOPERACAO13", "Join11"."CODOPOSTO6", "Join13"."CODOPERACAO14", "Join13"."TOPICO7", "Join13"."DESCSISTEMA7", "Join13"."ENTRAOUSAI7", "Join13"."FORMAPAGAMENTO7", "Join13"."SAIEMRELATORIOS7", "Join13"."COMPRAVENDADEVOLUCAO7", "Join13"."CALCULODA7", "Join13"."DIREITOSAUTORAIS7", "Join13"."ICMS7", "Join13"."CARTAOCREDITO7", "Join13"."TARIFA7", "Join13"."NOMECARTAO7", "Join13"."DIASRECEBER7", "Join13"."CONDIGNACO7", "Join13"."TIPO_DE_NOTA7", "Join13"."CONTA7", "Join13"."PARCELAS7", "Join13"."ATIVO7", "Join13"."CATEGORIA7", "Join13"."ALTERAESTOQUE7", "Join13"."ISS7", "Join13"."CONDICAO_PAGAMENTO7", "Join13"."FINANCEIRO7", "Join13"."GERA_DUPLICATA7", "Join13"."CANCELADO7", "Join13"."COF_ESTADO7", "Join13"."COF_OUTRO_ESTADO7", "Join13"."DESCRICAO_EXTRA7", "Join13"."ULTIMA_ATUALIZACAO8", "Join13"."COF2_ESTADO7", "Join13"."COF2_OUTRO_ESTADO7", "Join13"."COF3_ESTADO7", "Join13"."COF3_OUTRO_ESTADO7", "Join13"."TIPO_VALOR7", "Join13"."CLIENTE_REMOTO7", "Join13"."CONTA_BANCARIA8", "Join13"."OBSERVACAO7", "Join13"."TIPO_DE_CUSTO7", "Join13"."FECHAR7", "Join13"."CONSIDERAR_DA_RESUMIDO7", "Join13"."ENVIAR_EDI7", "Join13"."HISTORICO_CONTABIL7", "Join13"."NOTIMEUPDATE8", "Join13"."HISTORICO_CONTABIL_QUITACAO7", "Join13"."CONTRA_PARTIDA7", "Join13"."HISTORICO_FISCAL7", "Join13"."CALCULO_VENCIMENTO_VISTA7", "Join13"."CREDITO_DEBITO7", "Join13"."ENVIAR_ESTOQUE_PDV7", "Join13"."TABELA_PRECO7", "Join13"."COF4_ESTADO7", "Join13"."COF4_OUTRO_ESTADO7", "Join13"."CODIGO_OPERACAO_WMS7", "Join13"."LICITACAO7", "Join13"."CODOPERACAO15", "Join13"."CODOPOSTO7", "Join15"."CODOPERACAO16", "Join15"."TOPICO8", "Join15"."DESCSISTEMA8", "Join15"."ENTRAOUSAI8", "Join15"."FORMAPAGAMENTO8", "Join15"."SAIEMRELATORIOS8", "Join15"."COMPRAVENDADEVOLUCAO8", "Join15"."CALCULODA8", "Join15"."DIREITOSAUTORAIS8", "Join15"."ICMS8", "Join15"."CARTAOCREDITO8", "Join15"."TARIFA8", "Join15"."NOMECARTAO8", "Join15"."DIASRECEBER8", "Join15"."CONDIGNACO8", "Join15"."TIPO_DE_NOTA8", "Join15"."CONTA8", "Join15"."PARCELAS8", "Join15"."ATIVO8", "Join15"."CATEGORIA8", "Join15"."ALTERAESTOQUE8", "Join15"."ISS8", "Join15"."CONDICAO_PAGAMENTO8", "Join15"."FINANCEIRO8", "Join15"."GERA_DUPLICATA8", "Join15"."CANCELADO8", "Join15"."COF_ESTADO8", "Join15"."COF_OUTRO_ESTADO8", "Join15"."DESCRICAO_EXTRA8", "Join15"."ULTIMA_ATUALIZACAO9", "Join15"."COF2_ESTADO8", "Join15"."COF2_OUTRO_ESTADO8", "Join15"."COF3_ESTADO8", "Join15"."COF3_OUTRO_ESTADO8", "Join15"."TIPO_VALOR8", "Join15"."CLIENTE_REMOTO8", "Join15"."CONTA_BANCARIA9", "Join15"."OBSERVACAO8", "Join15"."TIPO_DE_CUSTO8", "Join15"."FECHAR8", "Join15"."CONSIDERAR_DA_RESUMIDO8", "Join15"."ENVIAR_EDI8", "Join15"."HISTORICO_CONTABIL8", "Join15"."NOTIMEUPDATE9", "Join15"."HISTORICO_CONTABIL_QUITACAO8", "Join15"."CONTRA_PARTIDA8", "Join15"."HISTORICO_FISCAL8", "Join15"."CALCULO_VENCIMENTO_VISTA8", "Join15"."CREDITO_DEBITO8", "Join15"."ENVIAR_ESTOQUE_PDV8", "Join15"."TABELA_PRECO8", "Join15"."COF4_ESTADO8", "Join15"."COF4_OUTRO_ESTADO8", "Join15"."CODIGO_OPERACAO_WMS8", "Join15"."LICITACAO8", "Join15"."CODOPERACAO17", "Join15"."CODOPOSTO8", "Extent18"."NOTASAIDA" AS "NOTASAIDA2", "Extent18"."TRANSPORTADORA" AS "TRANSPORTADORA", "Extent18"."CLIENTE" AS "CLIENTE2", "Extent18"."DUPLICATA" AS "DUPLICATA2", "Extent18"."FILIAL" AS "FILIAL2", "Extent18"."USUARIO" AS "USUARIO2", "Extent18"."SERIE" AS "SERIE", "Extent18"."TIPO_NOTA" AS "TIPO_NOTA2", "Extent18"."NUMERO" AS "NUMERO", "Extent18"."CANCELADA" AS "CANCELADA", "Extent18"."DATAEMISSAO" AS "DATAEMISSAO", "Extent18"."TRANSPORTE" AS "TRANSPORTE", "Extent18"."QUANTIDADE" AS "QUANTIDADE", "Extent18"."ESPECIE" AS "ESPECIE", "Extent18"."PESO" AS "PESO", "Extent18"."DESPESAS" AS "DESPESAS", "Extent18"."TOTAL" AS "TOTAL", "Extent18"."DESCONTO" AS "DESCONTO2", "Extent18"."DATAACERTO" AS "DATAACERTO", "Extent18"."RESPONSAVEL" AS "RESPONSAVEL", "Extent18"."PEDIDO" AS "PEDIDO", "Extent18"."ULTIMO_ACESSO" AS "ULTIMO_ACESSO", "Extent18"."PEDIDO_INTERNO" AS "PEDIDO_INTERNO", "Extent18"."DATA_ENVIO" AS "DATA_ENVIO", "Extent18"."OBSERVACOES" AS "OBSERVACOES", "Extent18"."DATA_CANCELAMENTO" AS "DATA_CANCELAMENTO", "Extent18"."USUARIO_CANCELOU" AS "USUARIO_CANCELOU", "Extent18"."CODOPERACAO" AS "CODOPERACAO26", "Extent18"."IMPRESSAO" AS "IMPRESSAO", "Extent18"."FRETE" AS "FRETE2", "Extent18"."TIPO_CONVERTIDO" AS "TIPO_CONVERTIDO", "Extent18"."CODIGO_CONVERTIDO" AS "CODIGO_CONVERTIDO", "Extent18"."TIPO" AS "TIPO2", "Extent18"."STATUSFRETE" AS "STATUSFRETE", "Extent18"."IRPJ" AS "IRPJ", "Extent18"."VENDEDOR" AS "VENDEDOR2", "Extent18"."STATUS" AS "STATUS", "Extent18"."GERAR_ENCOMENDA" AS "GERAR_ENCOMENDA", "Extent18"."USUARIO_STATUS" AS "USUARIO_STATUS", "Extent18"."DATA_STATUS" AS "DATA_STATUS", "Extent18"."CAIXA" AS "CAIXA", "Extent18"."ISS_FONTE" AS "ISS_FONTE", "Extent18"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO10", "Extent18"."ESPELHO_FECHADO" AS "ESPELHO_FECHADO", "Extent18"."OBSERVACOES_2" AS "OBSERVACOES_2", "Extent18"."BOX" AS "BOX", "Extent18"."DOCUMENTO_COLECAO" AS "DOCUMENTO_COLECAO", "Extent18"."CONF_ITENS_USUARIO" AS "CONF_ITENS_USUARIO", "Extent18"."CONF_ITENS_DATA" AS "CONF_ITENS_DATA", "Extent18"."CONF_ITENS_TENTATIVAS" AS "CONF_ITENS_TENTATIVAS", "Extent18"."ESTADO_CORRENTE" AS "ESTADO_CORRENTE", "Extent18"."CONTADOR_FISCAL" AS "CONTADOR_FISCAL", "Extent18"."NOTIMEUPDATE" AS "NOTIMEUPDATE10", "Extent18"."PLACA_VEICULO" AS "PLACA_VEICULO", "Extent18"."IMPRIMIR_ORDEM_LANCAMENTO" AS "IMPRIMIR_ORDEM_LANCAMENTO", "Extent18"."ROMANEIO_GERADO" AS "ROMANEIO_GERADO", "Extent18"."PROCESSO_INICIO" AS "PROCESSO_INICIO", "Extent18"."PROCESSO_GRAVA" AS "PROCESSO_GRAVA", "Extent18"."PROCESSO_TERMINO" AS "PROCESSO_TERMINO", "Extent18"."MOTIVO_CANCELAMENTO" AS "MOTIVO_CANCELAMENTO", "Extent18"."UF_PLACA_VEICULO" AS "UF_PLACA_VEICULO", "Extent18"."NUMERO_CONHECIMENTO" AS "NUMERO_CONHECIMENTO", "Extent18"."FRETE_NEGOCIADO" AS "FRETE_NEGOCIADO", "Extent18"."APROVACAO_FRETE" AS "APROVACAO_FRETE", "Extent18"."DATA_APROVACAO_FRETE" AS "DATA_APROVACAO_FRETE", "Extent18"."CIDADE_EXPORTACAO" AS "CIDADE_EXPORTACAO", "Extent18"."VOLUME" AS "VOLUME", "Extent18"."NFCOMPLEMENTADA" AS "NFCOMPLEMENTADA", "Extent18"."WMS_DOCUMENTO" AS "WMS_DOCUMENTO", "Extent18"."FAIXA_SIMPLES_NACIONAL" AS "FAIXA_SIMPLES_NACIONAL", "Extent18"."DEVOLUCAO_AVARIA" AS "DEVOLUCAO_AVARIA", "Extent18"."ASSINANTE_CANHOTO" AS "ASSINANTE_CANHOTO", "Extent18"."CI_ASSINANTE_CANHOTO" AS "CI_ASSINANTE_CANHOTO", "Extent18"."DATA_ENTREGA_CLIENTE" AS "DATA_ENTREGA_CLIENTE", "Extent18"."ENTREGADOR" AS "ENTREGADOR", "Extent18"."TELEFONE_ENTREGADOR" AS "TELEFONE_ENTREGADOR", "Extent18"."QTDE_VOLUMES" AS "QTDE_VOLUMES", "Extent18"."DATA_SAIDA_ENTREGADOR" AS "DATA_SAIDA_ENTREGADOR", "Extent18"."DATA_PREVISTA_ENTREGA" AS "DATA_PREVISTA_ENTREGA", "Extent18"."CONFERENTE_CANHOTO" AS "CONFERENTE_CANHOTO"
FROM "CONTA_CORRENTE" AS "Extent1"
LEFT OUTER JOIN (SELECT "Extent2"."CODOPERACAO" AS "CODOPERACAO2", "Extent2"."TOPICO" AS "TOPICO1", "Extent2"."DESCSISTEMA" AS "DESCSISTEMA1", "Extent2"."ENTRAOUSAI" AS "ENTRAOUSAI1", "Extent2"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO1", "Extent2"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS1", "Extent2"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO1", "Extent2"."CALCULODA" AS "CALCULODA1", "Extent2"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS1", "Extent2"."ICMS" AS "ICMS1", "Extent2"."CARTAOCREDITO" AS "CARTAOCREDITO1", "Extent2"."TARIFA" AS "TARIFA1", "Extent2"."NOMECARTAO" AS "NOMECARTAO1", "Extent2"."DIASRECEBER" AS "DIASRECEBER1", "Extent2"."CONDIGNACO" AS "CONDIGNACO1", "Extent2"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA1", "Extent2"."CONTA" AS "CONTA1", "Extent2"."PARCELAS" AS "PARCELAS1", "Extent2"."ATIVO" AS "ATIVO1", "Extent2"."CATEGORIA" AS "CATEGORIA1", "Extent2"."ALTERAESTOQUE" AS "ALTERAESTOQUE1", "Extent2"."ISS" AS "ISS1", "Extent2"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO1", "Extent2"."FINANCEIRO" AS "FINANCEIRO1", "Extent2"."GERA_DUPLICATA" AS "GERA_DUPLICATA1", "Extent2"."CANCELADO" AS "CANCELADO1", "Extent2"."COF_ESTADO" AS "COF_ESTADO1", "Extent2"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO1", "Extent2"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA1", "Extent2"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO2", "Extent2"."COF2_ESTADO" AS "COF2_ESTADO1", "Extent2"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO1", "Extent2"."COF3_ESTADO" AS "COF3_ESTADO1", "Extent2"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO1", "Extent2"."TIPO_VALOR" AS "TIPO_VALOR1", "Extent2"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO1", "Extent2"."CONTA_BANCARIA" AS "CONTA_BANCARIA2", "Extent2"."OBSERVACAO" AS "OBSERVACAO1", "Extent2"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO1", "Extent2"."FECHAR" AS "FECHAR1", "Extent2"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO1", "Extent2"."ENVIAR_EDI" AS "ENVIAR_EDI1", "Extent2"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL1", "Extent2"."NOTIMEUPDATE" AS "NOTIMEUPDATE2", "Extent2"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO1", "Extent2"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA1", "Extent2"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL1", "Extent2"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA1", "Extent2"."CREDITO_DEBITO" AS "CREDITO_DEBITO1", "Extent2"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV1", "Extent2"."TABELA_PRECO" AS "TABELA_PRECO1", "Extent2"."COF4_ESTADO" AS "COF4_ESTADO1", "Extent2"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO1", "Extent2"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS1", "Extent2"."LICITACAO" AS "LICITACAO1", "Extent3"."CODOPERACAO" AS "CODOPERACAO3", "Extent3"."CODOPOSTO" AS "CODOPOSTO1"
FROM "OPERACOES" AS "Extent2"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent3" ON "Extent2"."CODOPERACAO" = "Extent3"."CODOPERACAO" ) AS "Join1" ON "Extent1"."CODOPERACAO" = "Join1"."CODOPERACAO2"
LEFT OUTER JOIN (SELECT "Extent4"."CODOPERACAO" AS "CODOPERACAO4", "Extent4"."TOPICO" AS "TOPICO2", "Extent4"."DESCSISTEMA" AS "DESCSISTEMA2", "Extent4"."ENTRAOUSAI" AS "ENTRAOUSAI2", "Extent4"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO2", "Extent4"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS2", "Extent4"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO2", "Extent4"."CALCULODA" AS "CALCULODA2", "Extent4"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS2", "Extent4"."ICMS" AS "ICMS2", "Extent4"."CARTAOCREDITO" AS "CARTAOCREDITO2", "Extent4"."TARIFA" AS "TARIFA2", "Extent4"."NOMECARTAO" AS "NOMECARTAO2", "Extent4"."DIASRECEBER" AS "DIASRECEBER2", "Extent4"."CONDIGNACO" AS "CONDIGNACO2", "Extent4"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA2", "Extent4"."CONTA" AS "CONTA2", "Extent4"."PARCELAS" AS "PARCELAS2", "Extent4"."ATIVO" AS "ATIVO2", "Extent4"."CATEGORIA" AS "CATEGORIA2", "Extent4"."ALTERAESTOQUE" AS "ALTERAESTOQUE2", "Extent4"."ISS" AS "ISS2", "Extent4"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO2", "Extent4"."FINANCEIRO" AS "FINANCEIRO2", "Extent4"."GERA_DUPLICATA" AS "GERA_DUPLICATA2", "Extent4"."CANCELADO" AS "CANCELADO2", "Extent4"."COF_ESTADO" AS "COF_ESTADO2", "Extent4"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO2", "Extent4"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA2", "Extent4"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO3", "Extent4"."COF2_ESTADO" AS "COF2_ESTADO2", "Extent4"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO2", "Extent4"."COF3_ESTADO" AS "COF3_ESTADO2", "Extent4"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO2", "Extent4"."TIPO_VALOR" AS "TIPO_VALOR2", "Extent4"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO2", "Extent4"."CONTA_BANCARIA" AS "CONTA_BANCARIA3", "Extent4"."OBSERVACAO" AS "OBSERVACAO2", "Extent4"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO2", "Extent4"."FECHAR" AS "FECHAR2", "Extent4"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO2", "Extent4"."ENVIAR_EDI" AS "ENVIAR_EDI2", "Extent4"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL2", "Extent4"."NOTIMEUPDATE" AS "NOTIMEUPDATE3", "Extent4"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO2", "Extent4"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA2", "Extent4"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL2", "Extent4"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA2", "Extent4"."CREDITO_DEBITO" AS "CREDITO_DEBITO2", "Extent4"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV2", "Extent4"."TABELA_PRECO" AS "TABELA_PRECO2", "Extent4"."COF4_ESTADO" AS "COF4_ESTADO2", "Extent4"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO2", "Extent4"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS2", "Extent4"."LICITACAO" AS "LICITACAO2", "Extent5"."CODOPERACAO" AS "CODOPERACAO5", "Extent5"."CODOPOSTO" AS "CODOPOSTO2"
FROM "OPERACOES" AS "Extent4"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent5" ON "Extent4"."CODOPERACAO" = "Extent5"."CODOPERACAO" ) AS "Join3" ON "Extent1"."CODOPERACAO" = "Join3"."CODOPERACAO4"
LEFT OUTER JOIN (SELECT "Extent6"."CODOPERACAO" AS "CODOPERACAO6", "Extent6"."TOPICO" AS "TOPICO3", "Extent6"."DESCSISTEMA" AS "DESCSISTEMA3", "Extent6"."ENTRAOUSAI" AS "ENTRAOUSAI3", "Extent6"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO3", "Extent6"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS3", "Extent6"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO3", "Extent6"."CALCULODA" AS "CALCULODA3", "Extent6"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS3", "Extent6"."ICMS" AS "ICMS3", "Extent6"."CARTAOCREDITO" AS "CARTAOCREDITO3", "Extent6"."TARIFA" AS "TARIFA3", "Extent6"."NOMECARTAO" AS "NOMECARTAO3", "Extent6"."DIASRECEBER" AS "DIASRECEBER3", "Extent6"."CONDIGNACO" AS "CONDIGNACO3", "Extent6"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA3", "Extent6"."CONTA" AS "CONTA3", "Extent6"."PARCELAS" AS "PARCELAS3", "Extent6"."ATIVO" AS "ATIVO3", "Extent6"."CATEGORIA" AS "CATEGORIA3", "Extent6"."ALTERAESTOQUE" AS "ALTERAESTOQUE3", "Extent6"."ISS" AS "ISS3", "Extent6"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO3", "Extent6"."FINANCEIRO" AS "FINANCEIRO3", "Extent6"."GERA_DUPLICATA" AS "GERA_DUPLICATA3", "Extent6"."CANCELADO" AS "CANCELADO3", "Extent6"."COF_ESTADO" AS "COF_ESTADO3", "Extent6"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO3", "Extent6"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA3", "Extent6"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO4", "Extent6"."COF2_ESTADO" AS "COF2_ESTADO3", "Extent6"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO3", "Extent6"."COF3_ESTADO" AS "COF3_ESTADO3", "Extent6"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO3", "Extent6"."TIPO_VALOR" AS "TIPO_VALOR3", "Extent6"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO3", "Extent6"."CONTA_BANCARIA" AS "CONTA_BANCARIA4", "Extent6"."OBSERVACAO" AS "OBSERVACAO3", "Extent6"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO3", "Extent6"."FECHAR" AS "FECHAR3", "Extent6"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO3", "Extent6"."ENVIAR_EDI" AS "ENVIAR_EDI3", "Extent6"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL3", "Extent6"."NOTIMEUPDATE" AS "NOTIMEUPDATE4", "Extent6"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO3", "Extent6"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA3", "Extent6"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL3", "Extent6"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA3", "Extent6"."CREDITO_DEBITO" AS "CREDITO_DEBITO3", "Extent6"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV3", "Extent6"."TABELA_PRECO" AS "TABELA_PRECO3", "Extent6"."COF4_ESTADO" AS "COF4_ESTADO3", "Extent6"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO3", "Extent6"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS3", "Extent6"."LICITACAO" AS "LICITACAO3", "Extent7"."CODOPERACAO" AS "CODOPERACAO7", "Extent7"."CODOPOSTO" AS "CODOPOSTO3"
FROM "OPERACOES" AS "Extent6"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent7" ON "Extent6"."CODOPERACAO" = "Extent7"."CODOPERACAO" ) AS "Join5" ON "Extent1"."CODOPERACAO" = "Join5"."CODOPERACAO6"
LEFT OUTER JOIN (SELECT "Extent8"."CODOPERACAO" AS "CODOPERACAO8", "Extent8"."TOPICO" AS "TOPICO4", "Extent8"."DESCSISTEMA" AS "DESCSISTEMA4", "Extent8"."ENTRAOUSAI" AS "ENTRAOUSAI4", "Extent8"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO4", "Extent8"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS4", "Extent8"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO4", "Extent8"."CALCULODA" AS "CALCULODA4", "Extent8"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS4", "Extent8"."ICMS" AS "ICMS4", "Extent8"."CARTAOCREDITO" AS "CARTAOCREDITO4", "Extent8"."TARIFA" AS "TARIFA4", "Extent8"."NOMECARTAO" AS "NOMECARTAO4", "Extent8"."DIASRECEBER" AS "DIASRECEBER4", "Extent8"."CONDIGNACO" AS "CONDIGNACO4", "Extent8"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA4", "Extent8"."CONTA" AS "CONTA4", "Extent8"."PARCELAS" AS "PARCELAS4", "Extent8"."ATIVO" AS "ATIVO4", "Extent8"."CATEGORIA" AS "CATEGORIA4", "Extent8"."ALTERAESTOQUE" AS "ALTERAESTOQUE4", "Extent8"."ISS" AS "ISS4", "Extent8"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO4", "Extent8"."FINANCEIRO" AS "FINANCEIRO4", "Extent8"."GERA_DUPLICATA" AS "GERA_DUPLICATA4", "Extent8"."CANCELADO" AS "CANCELADO4", "Extent8"."COF_ESTADO" AS "COF_ESTADO4", "Extent8"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO4", "Extent8"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA4", "Extent8"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO5", "Extent8"."COF2_ESTADO" AS "COF2_ESTADO4", "Extent8"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO4", "Extent8"."COF3_ESTADO" AS "COF3_ESTADO4", "Extent8"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO4", "Extent8"."TIPO_VALOR" AS "TIPO_VALOR4", "Extent8"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO4", "Extent8"."CONTA_BANCARIA" AS "CONTA_BANCARIA5", "Extent8"."OBSERVACAO" AS "OBSERVACAO4", "Extent8"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO4", "Extent8"."FECHAR" AS "FECHAR4", "Extent8"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO4", "Extent8"."ENVIAR_EDI" AS "ENVIAR_EDI4", "Extent8"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL4", "Extent8"."NOTIMEUPDATE" AS "NOTIMEUPDATE5", "Extent8"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO4", "Extent8"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA4", "Extent8"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL4", "Extent8"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA4", "Extent8"."CREDITO_DEBITO" AS "CREDITO_DEBITO4", "Extent8"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV4", "Extent8"."TABELA_PRECO" AS "TABELA_PRECO4", "Extent8"."COF4_ESTADO" AS "COF4_ESTADO4", "Extent8"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO4", "Extent8"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS4", "Extent8"."LICITACAO" AS "LICITACAO4", "Extent9"."CODOPERACAO" AS "CODOPERACAO9", "Extent9"."CODOPOSTO" AS "CODOPOSTO4"
FROM "OPERACOES" AS "Extent8"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent9" ON "Extent8"."CODOPERACAO" = "Extent9"."CODOPERACAO" ) AS "Join7" ON "Extent1"."CODOPERACAO" = "Join7"."CODOPERACAO8"
LEFT OUTER JOIN (SELECT "Extent10"."CODOPERACAO" AS "CODOPERACAO10", "Extent10"."TOPICO" AS "TOPICO5", "Extent10"."DESCSISTEMA" AS "DESCSISTEMA5", "Extent10"."ENTRAOUSAI" AS "ENTRAOUSAI5", "Extent10"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO5", "Extent10"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS5", "Extent10"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO5", "Extent10"."CALCULODA" AS "CALCULODA5", "Extent10"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS5", "Extent10"."ICMS" AS "ICMS5", "Extent10"."CARTAOCREDITO" AS "CARTAOCREDITO5", "Extent10"."TARIFA" AS "TARIFA5", "Extent10"."NOMECARTAO" AS "NOMECARTAO5", "Extent10"."DIASRECEBER" AS "DIASRECEBER5", "Extent10"."CONDIGNACO" AS "CONDIGNACO5", "Extent10"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA5", "Extent10"."CONTA" AS "CONTA5", "Extent10"."PARCELAS" AS "PARCELAS5", "Extent10"."ATIVO" AS "ATIVO5", "Extent10"."CATEGORIA" AS "CATEGORIA5", "Extent10"."ALTERAESTOQUE" AS "ALTERAESTOQUE5", "Extent10"."ISS" AS "ISS5", "Extent10"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO5", "Extent10"."FINANCEIRO" AS "FINANCEIRO5", "Extent10"."GERA_DUPLICATA" AS "GERA_DUPLICATA5", "Extent10"."CANCELADO" AS "CANCELADO5", "Extent10"."COF_ESTADO" AS "COF_ESTADO5", "Extent10"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO5", "Extent10"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA5", "Extent10"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO6", "Extent10"."COF2_ESTADO" AS "COF2_ESTADO5", "Extent10"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO5", "Extent10"."COF3_ESTADO" AS "COF3_ESTADO5", "Extent10"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO5", "Extent10"."TIPO_VALOR" AS "TIPO_VALOR5", "Extent10"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO5", "Extent10"."CONTA_BANCARIA" AS "CONTA_BANCARIA6", "Extent10"."OBSERVACAO" AS "OBSERVACAO5", "Extent10"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO5", "Extent10"."FECHAR" AS "FECHAR5", "Extent10"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO5", "Extent10"."ENVIAR_EDI" AS "ENVIAR_EDI5", "Extent10"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL5", "Extent10"."NOTIMEUPDATE" AS "NOTIMEUPDATE6", "Extent10"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO5", "Extent10"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA5", "Extent10"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL5", "Extent10"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA5", "Extent10"."CREDITO_DEBITO" AS "CREDITO_DEBITO5", "Extent10"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV5", "Extent10"."TABELA_PRECO" AS "TABELA_PRECO5", "Extent10"."COF4_ESTADO" AS "COF4_ESTADO5", "Extent10"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO5", "Extent10"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS5", "Extent10"."LICITACAO" AS "LICITACAO5", "Extent11"."CODOPERACAO" AS "CODOPERACAO11", "Extent11"."CODOPOSTO" AS "CODOPOSTO5"
FROM "OPERACOES" AS "Extent10"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent11" ON "Extent10"."CODOPERACAO" = "Extent11"."CODOPERACAO" ) AS "Join9" ON "Extent1"."CODOPERACAO" = "Join9"."CODOPERACAO10"
LEFT OUTER JOIN (SELECT "Extent12"."CODOPERACAO" AS "CODOPERACAO12", "Extent12"."TOPICO" AS "TOPICO6", "Extent12"."DESCSISTEMA" AS "DESCSISTEMA6", "Extent12"."ENTRAOUSAI" AS "ENTRAOUSAI6", "Extent12"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO6", "Extent12"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS6", "Extent12"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO6", "Extent12"."CALCULODA" AS "CALCULODA6", "Extent12"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS6", "Extent12"."ICMS" AS "ICMS6", "Extent12"."CARTAOCREDITO" AS "CARTAOCREDITO6", "Extent12"."TARIFA" AS "TARIFA6", "Extent12"."NOMECARTAO" AS "NOMECARTAO6", "Extent12"."DIASRECEBER" AS "DIASRECEBER6", "Extent12"."CONDIGNACO" AS "CONDIGNACO6", "Extent12"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA6", "Extent12"."CONTA" AS "CONTA6", "Extent12"."PARCELAS" AS "PARCELAS6", "Extent12"."ATIVO" AS "ATIVO6", "Extent12"."CATEGORIA" AS "CATEGORIA6", "Extent12"."ALTERAESTOQUE" AS "ALTERAESTOQUE6", "Extent12"."ISS" AS "ISS6", "Extent12"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO6", "Extent12"."FINANCEIRO" AS "FINANCEIRO6", "Extent12"."GERA_DUPLICATA" AS "GERA_DUPLICATA6", "Extent12"."CANCELADO" AS "CANCELADO6", "Extent12"."COF_ESTADO" AS "COF_ESTADO6", "Extent12"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO6", "Extent12"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA6", "Extent12"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO7", "Extent12"."COF2_ESTADO" AS "COF2_ESTADO6", "Extent12"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO6", "Extent12"."COF3_ESTADO" AS "COF3_ESTADO6", "Extent12"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO6", "Extent12"."TIPO_VALOR" AS "TIPO_VALOR6", "Extent12"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO6", "Extent12"."CONTA_BANCARIA" AS "CONTA_BANCARIA7", "Extent12"."OBSERVACAO" AS "OBSERVACAO6", "Extent12"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO6", "Extent12"."FECHAR" AS "FECHAR6", "Extent12"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO6", "Extent12"."ENVIAR_EDI" AS "ENVIAR_EDI6", "Extent12"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL6", "Extent12"."NOTIMEUPDATE" AS "NOTIMEUPDATE7", "Extent12"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO6", "Extent12"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA6", "Extent12"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL6", "Extent12"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA6", "Extent12"."CREDITO_DEBITO" AS "CREDITO_DEBITO6", "Extent12"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV6", "Extent12"."TABELA_PRECO" AS "TABELA_PRECO6", "Extent12"."COF4_ESTADO" AS "COF4_ESTADO6", "Extent12"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO6", "Extent12"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS6", "Extent12"."LICITACAO" AS "LICITACAO6", "Extent13"."CODOPERACAO" AS "CODOPERACAO13", "Extent13"."CODOPOSTO" AS "CODOPOSTO6"
FROM "OPERACOES" AS "Extent12"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent13" ON "Extent12"."CODOPERACAO" = "Extent13"."CODOPERACAO" ) AS "Join11" ON "Extent1"."CODOPERACAO" = "Join11"."CODOPERACAO12"
LEFT OUTER JOIN (SELECT "Extent14"."CODOPERACAO" AS "CODOPERACAO14", "Extent14"."TOPICO" AS "TOPICO7", "Extent14"."DESCSISTEMA" AS "DESCSISTEMA7", "Extent14"."ENTRAOUSAI" AS "ENTRAOUSAI7", "Extent14"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO7", "Extent14"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS7", "Extent14"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO7", "Extent14"."CALCULODA" AS "CALCULODA7", "Extent14"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS7", "Extent14"."ICMS" AS "ICMS7", "Extent14"."CARTAOCREDITO" AS "CARTAOCREDITO7", "Extent14"."TARIFA" AS "TARIFA7", "Extent14"."NOMECARTAO" AS "NOMECARTAO7", "Extent14"."DIASRECEBER" AS "DIASRECEBER7", "Extent14"."CONDIGNACO" AS "CONDIGNACO7", "Extent14"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA7", "Extent14"."CONTA" AS "CONTA7", "Extent14"."PARCELAS" AS "PARCELAS7", "Extent14"."ATIVO" AS "ATIVO7", "Extent14"."CATEGORIA" AS "CATEGORIA7", "Extent14"."ALTERAESTOQUE" AS "ALTERAESTOQUE7", "Extent14"."ISS" AS "ISS7", "Extent14"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO7", "Extent14"."FINANCEIRO" AS "FINANCEIRO7", "Extent14"."GERA_DUPLICATA" AS "GERA_DUPLICATA7", "Extent14"."CANCELADO" AS "CANCELADO7", "Extent14"."COF_ESTADO" AS "COF_ESTADO7", "Extent14"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO7", "Extent14"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA7", "Extent14"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO8", "Extent14"."COF2_ESTADO" AS "COF2_ESTADO7", "Extent14"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO7", "Extent14"."COF3_ESTADO" AS "COF3_ESTADO7", "Extent14"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO7", "Extent14"."TIPO_VALOR" AS "TIPO_VALOR7", "Extent14"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO7", "Extent14"."CONTA_BANCARIA" AS "CONTA_BANCARIA8", "Extent14"."OBSERVACAO" AS "OBSERVACAO7", "Extent14"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO7", "Extent14"."FECHAR" AS "FECHAR7", "Extent14"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO7", "Extent14"."ENVIAR_EDI" AS "ENVIAR_EDI7", "Extent14"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL7", "Extent14"."NOTIMEUPDATE" AS "NOTIMEUPDATE8", "Extent14"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO7", "Extent14"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA7", "Extent14"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL7", "Extent14"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA7", "Extent14"."CREDITO_DEBITO" AS "CREDITO_DEBITO7", "Extent14"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV7", "Extent14"."TABELA_PRECO" AS "TABELA_PRECO7", "Extent14"."COF4_ESTADO" AS "COF4_ESTADO7", "Extent14"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO7", "Extent14"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS7", "Extent14"."LICITACAO" AS "LICITACAO7", "Extent15"."CODOPERACAO" AS "CODOPERACAO15", "Extent15"."CODOPOSTO" AS "CODOPOSTO7"
FROM "OPERACOES" AS "Extent14"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent15" ON "Extent14"."CODOPERACAO" = "Extent15"."CODOPERACAO" ) AS "Join13" ON "Extent1"."CODOPERACAO" = "Join13"."CODOPERACAO14"
LEFT OUTER JOIN (SELECT "Extent16"."CODOPERACAO" AS "CODOPERACAO16", "Extent16"."TOPICO" AS "TOPICO8", "Extent16"."DESCSISTEMA" AS "DESCSISTEMA8", "Extent16"."ENTRAOUSAI" AS "ENTRAOUSAI8", "Extent16"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO8", "Extent16"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS8", "Extent16"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO8", "Extent16"."CALCULODA" AS "CALCULODA8", "Extent16"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS8", "Extent16"."ICMS" AS "ICMS8", "Extent16"."CARTAOCREDITO" AS "CARTAOCREDITO8", "Extent16"."TARIFA" AS "TARIFA8", "Extent16"."NOMECARTAO" AS "NOMECARTAO8", "Extent16"."DIASRECEBER" AS "DIASRECEBER8", "Extent16"."CONDIGNACO" AS "CONDIGNACO8", "Extent16"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA8", "Extent16"."CONTA" AS "CONTA8", "Extent16"."PARCELAS" AS "PARCELAS8", "Extent16"."ATIVO" AS "ATIVO8", "Extent16"."CATEGORIA" AS "CATEGORIA8", "Extent16"."ALTERAESTOQUE" AS "ALTERAESTOQUE8", "Extent16"."ISS" AS "ISS8", "Extent16"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO8", "Extent16"."FINANCEIRO" AS "FINANCEIRO8", "Extent16"."GERA_DUPLICATA" AS "GERA_DUPLICATA8", "Extent16"."CANCELADO" AS "CANCELADO8", "Extent16"."COF_ESTADO" AS "COF_ESTADO8", "Extent16"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO8", "Extent16"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA8", "Extent16"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO9", "Extent16"."COF2_ESTADO" AS "COF2_ESTADO8", "Extent16"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO8", "Extent16"."COF3_ESTADO" AS "COF3_ESTADO8", "Extent16"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO8", "Extent16"."TIPO_VALOR" AS "TIPO_VALOR8", "Extent16"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO8", "Extent16"."CONTA_BANCARIA" AS "CONTA_BANCARIA9", "Extent16"."OBSERVACAO" AS "OBSERVACAO8", "Extent16"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO8", "Extent16"."FECHAR" AS "FECHAR8", "Extent16"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO8", "Extent16"."ENVIAR_EDI" AS "ENVIAR_EDI8", "Extent16"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL8", "Extent16"."NOTIMEUPDATE" AS "NOTIMEUPDATE9", "Extent16"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO8", "Extent16"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA8", "Extent16"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL8", "Extent16"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA8", "Extent16"."CREDITO_DEBITO" AS "CREDITO_DEBITO8", "Extent16"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV8", "Extent16"."TABELA_PRECO" AS "TABELA_PRECO8", "Extent16"."COF4_ESTADO" AS "COF4_ESTADO8", "Extent16"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO8", "Extent16"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS8", "Extent16"."LICITACAO" AS "LICITACAO8", "Extent17"."CODOPERACAO" AS "CODOPERACAO17", "Extent17"."CODOPOSTO" AS "CODOPOSTO8"
FROM "OPERACOES" AS "Extent16"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent17" ON "Extent16"."CODOPERACAO" = "Extent17"."CODOPERACAO" ) AS "Join15" ON "Extent1"."CODOPERACAO" = "Join15"."CODOPERACAO16"
INNER JOIN "NOTASSAIDA" AS "Extent18" ON "Extent1"."NOTASAIDA" = "Extent18"."NOTASAIDA"
WHERE (((("Extent1"."NOTASAIDA" IS NOT NULL) AND ( EXISTS (SELECT
1 AS "C1"
FROM "SAI_EM_RELATORIOS" AS "Extent19"
INNER JOIN "NOTASSAIDA" AS "Extent20" ON "Extent19"."TIPO_NOTA" = "Extent20"."TIPO_NOTA"
WHERE "Extent1"."NOTASAIDA" = "Extent20"."NOTASAIDA"
))) AND ((1 = "Join1"."SAIEMRELATORIOS1") OR ((((48 = "Join3"."ALTERAESTOQUE2") OR (42 = "Join5"."ALTERAESTOQUE3")) OR ((38 = "Join7"."ALTERAESTOQUE4") OR (16 = "Join9"."ALTERAESTOQUE5"))) OR (((24 = "Join11"."ALTERAESTOQUE6") OR (23 = "Join13"."ALTERAESTOQUE7")) OR (33 = "Join15"."ALTERAESTOQUE8"))))) AND (0 = "Extent18"."STATUS")) AND (0 = "Extent18"."CANCELADA") ) AS "Filter2"
LEFT OUTER JOIN (SELECT "Extent21"."CODOPERACAO" AS "CODOPERACAO18", "Extent21"."TOPICO" AS "TOPICO", "Extent21"."DESCSISTEMA" AS "DESCSISTEMA", "Extent21"."ENTRAOUSAI" AS "ENTRAOUSAI", "Extent21"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO", "Extent21"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS", "Extent21"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO", "Extent21"."CALCULODA" AS "CALCULODA", "Extent21"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS", "Extent21"."ICMS" AS "ICMS", "Extent21"."CARTAOCREDITO" AS "CARTAOCREDITO", "Extent21"."TARIFA" AS "TARIFA", "Extent21"."NOMECARTAO" AS "NOMECARTAO", "Extent21"."DIASRECEBER" AS "DIASRECEBER", "Extent21"."CONDIGNACO" AS "CONDIGNACO", "Extent21"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA", "Extent21"."CONTA" AS "CONTA", "Extent21"."PARCELAS" AS "PARCELAS", "Extent21"."ATIVO" AS "ATIVO", "Extent21"."CATEGORIA" AS "CATEGORIA", "Extent21"."ALTERAESTOQUE" AS "ALTERAESTOQUE", "Extent21"."ISS" AS "ISS", "Extent21"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO", "Extent21"."FINANCEIRO" AS "FINANCEIRO", "Extent21"."GERA_DUPLICATA" AS "GERA_DUPLICATA", "Extent21"."CANCELADO" AS "CANCELADO", "Extent21"."COF_ESTADO" AS "COF_ESTADO", "Extent21"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO", "Extent21"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA", "Extent21"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO", "Extent21"."COF2_ESTADO" AS "COF2_ESTADO", "Extent21"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO", "Extent21"."COF3_ESTADO" AS "COF3_ESTADO", "Extent21"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO", "Extent21"."TIPO_VALOR" AS "TIPO_VALOR", "Extent21"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO", "Extent21"."CONTA_BANCARIA" AS "CONTA_BANCARIA", "Extent21"."OBSERVACAO" AS "OBSERVACAO", "Extent21"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO", "Extent21"."FECHAR" AS "FECHAR", "Extent21"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO", "Extent21"."ENVIAR_EDI" AS "ENVIAR_EDI", "Extent21"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL", "Extent21"."NOTIMEUPDATE" AS "NOTIMEUPDATE", "Extent21"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO", "Extent21"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA", "Extent21"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL", "Extent21"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA", "Extent21"."CREDITO_DEBITO" AS "CREDITO_DEBITO", "Extent21"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV", "Extent21"."TABELA_PRECO" AS "TABELA_PRECO", "Extent21"."COF4_ESTADO" AS "COF4_ESTADO", "Extent21"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO", "Extent21"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS", "Extent21"."LICITACAO" AS "LICITACAO", "Extent22"."CODOPERACAO" AS "CODOPERACAO19", "Extent22"."CODOPOSTO" AS "CODOPOSTO"
FROM "OPERACOES" AS "Extent21"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent22" ON "Extent21"."CODOPERACAO" = "Extent22"."CODOPERACAO" ) AS "Join19" ON "Filter2"."CODOPERACAO1" = "Join19"."CODOPERACAO18"
LEFT OUTER JOIN (SELECT "Extent23"."CODOPERACAO" AS "CODOPERACAO20", "Extent23"."TOPICO" AS "TOPICO", "Extent23"."DESCSISTEMA" AS "DESCSISTEMA", "Extent23"."ENTRAOUSAI" AS "ENTRAOUSAI", "Extent23"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO", "Extent23"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS", "Extent23"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO", "Extent23"."CALCULODA" AS "CALCULODA", "Extent23"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS", "Extent23"."ICMS" AS "ICMS", "Extent23"."CARTAOCREDITO" AS "CARTAOCREDITO", "Extent23"."TARIFA" AS "TARIFA", "Extent23"."NOMECARTAO" AS "NOMECARTAO", "Extent23"."DIASRECEBER" AS "DIASRECEBER", "Extent23"."CONDIGNACO" AS "CONDIGNACO", "Extent23"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA", "Extent23"."CONTA" AS "CONTA", "Extent23"."PARCELAS" AS "PARCELAS", "Extent23"."ATIVO" AS "ATIVO", "Extent23"."CATEGORIA" AS "CATEGORIA", "Extent23"."ALTERAESTOQUE" AS "ALTERAESTOQUE", "Extent23"."ISS" AS "ISS", "Extent23"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO", "Extent23"."FINANCEIRO" AS "FINANCEIRO", "Extent23"."GERA_DUPLICATA" AS "GERA_DUPLICATA", "Extent23"."CANCELADO" AS "CANCELADO", "Extent23"."COF_ESTADO" AS "COF_ESTADO", "Extent23"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO", "Extent23"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA", "Extent23"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO", "Extent23"."COF2_ESTADO" AS "COF2_ESTADO", "Extent23"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO", "Extent23"."COF3_ESTADO" AS "COF3_ESTADO", "Extent23"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO", "Extent23"."TIPO_VALOR" AS "TIPO_VALOR", "Extent23"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO", "Extent23"."CONTA_BANCARIA" AS "CONTA_BANCARIA", "Extent23"."OBSERVACAO" AS "OBSERVACAO", "Extent23"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO", "Extent23"."FECHAR" AS "FECHAR", "Extent23"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO", "Extent23"."ENVIAR_EDI" AS "ENVIAR_EDI", "Extent23"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL", "Extent23"."NOTIMEUPDATE" AS "NOTIMEUPDATE", "Extent23"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO", "Extent23"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA", "Extent23"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL", "Extent23"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA", "Extent23"."CREDITO_DEBITO" AS "CREDITO_DEBITO", "Extent23"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV", "Extent23"."TABELA_PRECO" AS "TABELA_PRECO", "Extent23"."COF4_ESTADO" AS "COF4_ESTADO", "Extent23"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO", "Extent23"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS", "Extent23"."LICITACAO" AS "LICITACAO", "Extent24"."CODOPERACAO" AS "CODOPERACAO21", "Extent24"."CODOPOSTO" AS "CODOPOSTO"
FROM "OPERACOES" AS "Extent23"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent24" ON "Extent23"."CODOPERACAO" = "Extent24"."CODOPERACAO" ) AS "Join21" ON "Filter2"."CODOPERACAO1" = "Join21"."CODOPERACAO20"
LEFT OUTER JOIN (SELECT "Extent25"."CODOPERACAO" AS "CODOPERACAO22", "Extent25"."TOPICO" AS "TOPICO", "Extent25"."DESCSISTEMA" AS "DESCSISTEMA", "Extent25"."ENTRAOUSAI" AS "ENTRAOUSAI", "Extent25"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO", "Extent25"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS", "Extent25"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO", "Extent25"."CALCULODA" AS "CALCULODA", "Extent25"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS", "Extent25"."ICMS" AS "ICMS", "Extent25"."CARTAOCREDITO" AS "CARTAOCREDITO", "Extent25"."TARIFA" AS "TARIFA", "Extent25"."NOMECARTAO" AS "NOMECARTAO", "Extent25"."DIASRECEBER" AS "DIASRECEBER", "Extent25"."CONDIGNACO" AS "CONDIGNACO", "Extent25"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA", "Extent25"."CONTA" AS "CONTA", "Extent25"."PARCELAS" AS "PARCELAS", "Extent25"."ATIVO" AS "ATIVO", "Extent25"."CATEGORIA" AS "CATEGORIA", "Extent25"."ALTERAESTOQUE" AS "ALTERAESTOQUE", "Extent25"."ISS" AS "ISS", "Extent25"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO", "Extent25"."FINANCEIRO" AS "FINANCEIRO", "Extent25"."GERA_DUPLICATA" AS "GERA_DUPLICATA", "Extent25"."CANCELADO" AS "CANCELADO", "Extent25"."COF_ESTADO" AS "COF_ESTADO", "Extent25"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO", "Extent25"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA", "Extent25"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO", "Extent25"."COF2_ESTADO" AS "COF2_ESTADO", "Extent25"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO", "Extent25"."COF3_ESTADO" AS "COF3_ESTADO", "Extent25"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO", "Extent25"."TIPO_VALOR" AS "TIPO_VALOR", "Extent25"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO", "Extent25"."CONTA_BANCARIA" AS "CONTA_BANCARIA", "Extent25"."OBSERVACAO" AS "OBSERVACAO", "Extent25"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO", "Extent25"."FECHAR" AS "FECHAR", "Extent25"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO", "Extent25"."ENVIAR_EDI" AS "ENVIAR_EDI", "Extent25"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL", "Extent25"."NOTIMEUPDATE" AS "NOTIMEUPDATE", "Extent25"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO", "Extent25"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA", "Extent25"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL", "Extent25"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA", "Extent25"."CREDITO_DEBITO" AS "CREDITO_DEBITO", "Extent25"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV", "Extent25"."TABELA_PRECO" AS "TABELA_PRECO", "Extent25"."COF4_ESTADO" AS "COF4_ESTADO", "Extent25"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO", "Extent25"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS", "Extent25"."LICITACAO" AS "LICITACAO", "Extent26"."CODOPERACAO" AS "CODOPERACAO23", "Extent26"."CODOPOSTO" AS "CODOPOSTO"
FROM "OPERACOES" AS "Extent25"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent26" ON "Extent25"."CODOPERACAO" = "Extent26"."CODOPERACAO" ) AS "Join23" ON "Filter2"."CODOPERACAO1" = "Join23"."CODOPERACAO22"
LEFT OUTER JOIN (SELECT "Extent27"."CODOPERACAO" AS "CODOPERACAO24", "Extent27"."TOPICO" AS "TOPICO", "Extent27"."DESCSISTEMA" AS "DESCSISTEMA", "Extent27"."ENTRAOUSAI" AS "ENTRAOUSAI", "Extent27"."FORMAPAGAMENTO" AS "FORMAPAGAMENTO", "Extent27"."SAIEMRELATORIOS" AS "SAIEMRELATORIOS", "Extent27"."COMPRAVENDADEVOLUCAO" AS "COMPRAVENDADEVOLUCAO", "Extent27"."CALCULODA" AS "CALCULODA", "Extent27"."DIREITOSAUTORAIS" AS "DIREITOSAUTORAIS", "Extent27"."ICMS" AS "ICMS", "Extent27"."CARTAOCREDITO" AS "CARTAOCREDITO", "Extent27"."TARIFA" AS "TARIFA", "Extent27"."NOMECARTAO" AS "NOMECARTAO", "Extent27"."DIASRECEBER" AS "DIASRECEBER", "Extent27"."CONDIGNACO" AS "CONDIGNACO", "Extent27"."TIPO_DE_NOTA" AS "TIPO_DE_NOTA", "Extent27"."CONTA" AS "CONTA", "Extent27"."PARCELAS" AS "PARCELAS", "Extent27"."ATIVO" AS "ATIVO", "Extent27"."CATEGORIA" AS "CATEGORIA", "Extent27"."ALTERAESTOQUE" AS "ALTERAESTOQUE", "Extent27"."ISS" AS "ISS", "Extent27"."CONDICAO_PAGAMENTO" AS "CONDICAO_PAGAMENTO", "Extent27"."FINANCEIRO" AS "FINANCEIRO", "Extent27"."GERA_DUPLICATA" AS "GERA_DUPLICATA", "Extent27"."CANCELADO" AS "CANCELADO", "Extent27"."COF_ESTADO" AS "COF_ESTADO", "Extent27"."COF_OUTRO_ESTADO" AS "COF_OUTRO_ESTADO", "Extent27"."DESCRICAO_EXTRA" AS "DESCRICAO_EXTRA", "Extent27"."ULTIMA_ATUALIZACAO" AS "ULTIMA_ATUALIZACAO", "Extent27"."COF2_ESTADO" AS "COF2_ESTADO", "Extent27"."COF2_OUTRO_ESTADO" AS "COF2_OUTRO_ESTADO", "Extent27"."COF3_ESTADO" AS "COF3_ESTADO", "Extent27"."COF3_OUTRO_ESTADO" AS "COF3_OUTRO_ESTADO", "Extent27"."TIPO_VALOR" AS "TIPO_VALOR", "Extent27"."CLIENTE_REMOTO" AS "CLIENTE_REMOTO", "Extent27"."CONTA_BANCARIA" AS "CONTA_BANCARIA", "Extent27"."OBSERVACAO" AS "OBSERVACAO", "Extent27"."TIPO_DE_CUSTO" AS "TIPO_DE_CUSTO", "Extent27"."FECHAR" AS "FECHAR", "Extent27"."CONSIDERAR_DA_RESUMIDO" AS "CONSIDERAR_DA_RESUMIDO", "Extent27"."ENVIAR_EDI" AS "ENVIAR_EDI", "Extent27"."HISTORICO_CONTABIL" AS "HISTORICO_CONTABIL", "Extent27"."NOTIMEUPDATE" AS "NOTIMEUPDATE", "Extent27"."HISTORICO_CONTABIL_QUITACAO" AS "HISTORICO_CONTABIL_QUITACAO", "Extent27"."CONTRA_PARTIDA" AS "CONTRA_PARTIDA", "Extent27"."HISTORICO_FISCAL" AS "HISTORICO_FISCAL", "Extent27"."CALCULO_VENCIMENTO_VISTA" AS "CALCULO_VENCIMENTO_VISTA", "Extent27"."CREDITO_DEBITO" AS "CREDITO_DEBITO", "Extent27"."ENVIAR_ESTOQUE_PDV" AS "ENVIAR_ESTOQUE_PDV", "Extent27"."TABELA_PRECO" AS "TABELA_PRECO", "Extent27"."COF4_ESTADO" AS "COF4_ESTADO", "Extent27"."COF4_OUTRO_ESTADO" AS "COF4_OUTRO_ESTADO", "Extent27"."CODIGO_OPERACAO_WMS" AS "CODIGO_OPERACAO_WMS", "Extent27"."LICITACAO" AS "LICITACAO", "Extent28"."CODOPERACAO" AS "CODOPERACAO25", "Extent28"."CODOPOSTO" AS "CODOPOSTO"
FROM "OPERACOES" AS "Extent27"
LEFT OUTER JOIN "CODIGO_INVERSO_WMS" AS "Extent28" ON "Extent27"."CODOPERACAO" = "Extent28"."CODOPERACAO" ) AS "Join25" ON "Filter2"."CODOPERACAO1" = "Join25"."CODOPERACAO24"
LEFT OUTER JOIN "NOTASSAIDA" AS "Extent29" ON "Filter2"."NOTASAIDA1" = "Extent29"."NOTASAIDA"
LEFT OUTER JOIN "ITENSNOTA" AS "Extent30" ON "Filter2"."NOTASAIDA1" = "Extent30"."NOTASAIDA"
WHERE ((5 = "Join19"."ENTRAOUSAI") OR (11 = "Join21"."ENTRAOUSAI")) AND (("Filter2"."DATA_EMISSAO" >= @p__linq__0) AND ("Filter2"."DATA_EMISSAO" <= @p__linq__1))
) AS "Project2"
ORDER BY "Project2"."CODOPERACAO2" ASC, "Project2"."CODOPERACAO1" ASC, "Project2"."CODOPERACAO4" ASC, "Project2"."CODOPERACAO3" ASC, "Project2"."CODOPERACAO6" ASC, "Project2"."CODOPERACAO5" ASC, "Project2"."CODOPERACAO8" ASC, "Project2"."CODOPERACAO7" ASC, "Project2"."CODOPERACAO10" ASC, "Project2"."CODOPERACAO9" ASC, "Project2"."CODOPERACAO12" ASC, "Project2"."CODOPERACAO11" ASC, "Project2"."CODOPERACAO14" ASC, "Project2"."CODOPERACAO13" ASC, "Project2"."CODOPERACAO16" ASC, "Project2"."CODOPERACAO15" ASC, "Project2"."NOTASAIDA1" ASC, "Project2"."CODOPERACAO18" ASC, "Project2"."CODOPERACAO17" ASC, "Project2"."CODOPERACAO20" ASC, "Project2"."CODOPERACAO19" ASC, "Project2"."CODOPERACAO22" ASC, "Project2"."CODOPERACAO24" ASC, "Project2"."CODOPERACAO23" ASC, "Project2"."LANCAMENTO" ASC, "Project2"."CODOPERACAO21" ASC, "Project2"."NOTASAIDA2" ASC, "Project2"."C1" ASC
====== Test Details ======
Very interesting example (for test) but where DDL of these tables ?
The text was updated successfully, but these errors were encountered: