Constant Field Values

Contents

br.com.*

  • br.com.intersys.systextil.function.creditopedido.ProcessadorDeSituacaoAnalise
    Modifier and Type
    Constant Field
    Value
    public static final int
    1
    public static final int
    1
  • br.com.intersys.systextil.function.creditopedido.SituacaoAnalise
    Modifier and Type
    Constant Field
    Value
    protected final int
    1

systextil.dao.*

  • systextil.dao.AssinaturaBloqueio
    Modifier and Type
    Constant Field
    Value
    public static final int
    1
  • systextil.dao.AtributosDeTingimento
    Modifier and Type
    Constant Field
    Value
    public static final String
    "select * from basi_450 "
  • systextil.dao.CadastrosGenericos
    Modifier and Type
    Constant Field
    Value
    public static final String
    "select 1 from hdoc_001 "
  • systextil.dao.Calendario
    Modifier and Type
    Constant Field
    Value
    public static final String
    "<"
    public static final String
    "<="
    public static final String
    "dia_util"
    public static final String
    "dia_util_finan"
    public static final String
    "="
    public static final String
    ">"
    public static final String
    ">="
  • systextil.dao.CentroDeCustoMaquina
    Modifier and Type
    Constant Field
    Value
    public static final int
    0
  • systextil.dao.CGProdutoGlobal
    Modifier and Type
    Constant Field
    Value
    public static final String
    "select 1 from hdoc_001 "
  • systextil.dao.CodigoContabil
    Modifier and Type
    Constant Field
    Value
    public static final int
    11
    public static final int
    3
    public static final int
    1
    public static final int
    6
    public static final int
    8
    public static final int
    10
  • systextil.dao.CondicaoDePagamento
    Modifier and Type
    Constant Field
    Value
    public static final int
    2
  • systextil.dao.ContaCorrente
    Modifier and Type
    Constant Field
    Value
    public static final String
    "C"
    public static final String
    "D"
  • systextil.dao.CoresPadronagens
    Modifier and Type
    Constant Field
    Value
    public static final int
    2
    public static final int
    1
    public static final int
    2
    public static final int
    2
  • systextil.dao.Deposito
    Modifier and Type
    Constant Field
    Value
    public static final int
    1
  • Modifier and Type
    Constant Field
    Value
    public static final int
    1
  • systextil.dao.DivisaoProducao
    Modifier and Type
    Constant Field
    Value
    public static final String
    "select 1 from basi_180 "
    public static final String
    "select basi_180.* from basi_180 "
  • systextil.dao.Duplicata
    Modifier and Type
    Constant Field
    Value
    public static final String
    "SELECT codigo_empresa, cli_dup_cgc_cli9, cli_dup_cgc_cli4, cli_dup_cgc_cli2, tipo_titulo, num_duplicata, seq_duplicatas, data_venc_duplic, valor_duplicata, situacao_duplic, cod_canc_duplic, data_canc_duplic, perc_juro_duplic, perc_desc_duplic, portador_duplic, serie_nota_fisc, num_nota_fiscal, numero_bordero, quantidade, tecido_peca, percentual_comis, valor_comis, base_calc_comis, pedido_venda, nr_titulo_banco, cod_rep_cliente, posicao_duplic, port_anterior, vencto_anterior, duplic_emitida, nr_solicitacao, data_emissao, numero_titulo, data_transf_tit, numero_sequencia, valor_remessa, cod_historico, compl_historico, cod_local, previsao, moeda_titulo, valor_moeda, data_prorrogacao, conta_corrente, numero_remessa, perc_comis_crec, duplic_impressa, cod_transacao, codigo_contabil, tit_renegociado, seq_end_cobranca, num_contabil, comissao_lancada, referente_nf, tipo_tit_origem, num_dup_origem, seq_dup_origem, cli9resptit, cli4resptit, cli2resptit, origem_pedido, cgc9_endosso, cgc4_endosso, cgc2_endosso, controle_cheque, tipo_comissao, codigo_administr, comissao_administr, perc_comis_crec_adm, tit_baixar, posicao_ant, mensagem_boleto, atraso_pela_renegociacao, data_ult_movim_pagto, data_ult_movim_credito, saldo_duplicata, cod_forma_pagto, nr_cupom, nr_mtv_prorrogacao, nr_remessa_inadimplencia, nr_solicitacao_inadimplencia, situacao_inadimplencia, valor_desp_cobr, cond_pagto_vendor, executa_trigger, valor_desconto_aux, valor_juros_aux, valor_saldo_aux, nr_identificacao, cod_carteira, motivo_bxa_serasa_pefin, cd_centro_custo, nr_adiantamento, flag_alteracao_boleto, tipopix, chavepix, bolepix, nr_identificacao_fnd, observacao from fatu_070 "
  • systextil.dao.Embalagens
    Modifier and Type
    Constant Field
    Value
    public static final String
    "select fatu_100.* from fatu_100 "
  • systextil.dao.EstoqueMovimentacao
    Modifier and Type
    Constant Field
    Value
    public static final String
    "E"
    public static final String
    "S"
  • systextil.dao.HistoricoContabil
    Modifier and Type
    Constant Field
    Value
    public static final int
    1
    public static final int
    2
    public static final int
    2
    public static final int
    0
    public static final int
    1
  • systextil.dao.IntePedidoVenda
    Modifier and Type
    Constant Field
    Value
    public static final String
    "select ana_comercial_concessao_desc, ana_comercial_prazo, ana_comercial_comissao, ana_comercial_obs, cod_funcionario, valor_frete_pedido, numero_controle, tipo_registro, obs1, obs2, obs3, obs4, obs5, obs6, obs7, sit_importacao, loja, data_importacao, cod_repre, codigo_empresa, data_emis_venda, data_digit_venda, perc_comis_venda, perc_desc_duplic, seq_end_entrega, seq_end_cobranca, cod_via_transp, trans_pv_forne9, trans_pv_forne4, trans_pv_forne2, cod_banco, data_arquivo, frete_venda, numero_semana, novo_pedido_venda, desconto_item1, desconto_item2, desconto_item3, tipo_comissao, classificacao_pedido, codigo_deposito, obs1_nf, obs2_nf, obs3_nf, obs4_nf, obs5_nf, obs1_prod, obs2_prod, obs3_prod, obs4_prod, obs5_prod, tipo_pedido, tipo_prod_pedido, exigencia_requisito_ambiental, especificar_requisito, origem_pedido, executa_trigger, criterio_pedido, administrador, pedido_cotacao, id_pedido_forca_vendas, criterio_qualidade, desconto_extra, prazo_extra, cond_pgto_extra, cod_local, cod_catalogo, aceita_antecipacao, permite_parcial, cod_preposto, codigo_registro, pedido_venda, tecido_peca, data_entrega, cliente9, cliente4, cliente2, pedido_cliente, colecao_tabela, mes_tabela, sequencia_tabela, codigo_moeda, cond_pgto_venda, desconto1, desconto2, desconto3, trans_re_forne9, trans_re_forne4, trans_re_forne2, nat_oper, nat_est_oper, obs_lista_conteudo_1, obs_lista_conteudo_2, obs_lista_conteudo_3, perc_comissao_fatu_repres, perc_comissao_fatu_adm, pedido_origem, nome_preposto, data_base_fatur, pronta_entrega, servico_postagem, observacao, nr_autorizacao_opera, cod_forma_pagto from inte_100 "
  • systextil.dao.LancamentoContabil
    Modifier and Type
    Constant Field
    Value
    public static final String
    "C"
    public static final String
    "D"
  • systextil.dao.Mensagem
    Modifier and Type
    Constant Field
    Value
    public static final String
    "S"
    public static final String
    "N"
  • systextil.dao.NaturezaDeOperacao
    Modifier and Type
    Constant Field
    Value
    public static final int
    0
  • systextil.dao.NotaFiscal
    Modifier and Type
    Constant Field
    Value
    public static final String
    "E"
    public static final String
    "S"
  • Modifier and Type
    Constant Field
    Value
    public static final String
    "select 1 from obrf_015 where capa_ent_nrdoc=? and capa_ent_serie=? and capa_ent_forcli9=? and capa_ent_forcli4=? and capa_ent_forcli2=? "
    public static final String
    "select * from obrf_015 where capa_ent_nrdoc=? and capa_ent_serie=? and capa_ent_forcli9=? and capa_ent_forcli4=? and capa_ent_forcli2=? "
  • systextil.dao.NotaFiscalDeSaida
    Modifier and Type
    Constant Field
    Value
    public static final int
    1
    public static final int
    3
    public static final int
    2
    public static final int
    0
    public static final int
    6
    public static final int
    2
    public static final int
    1
    public static final int
    4
    public static final int
    3
    public static final int
    5
  • systextil.dao.NotaFiscalDeSaidaItem
    Modifier and Type
    Constant Field
    Value
    public static final String
    "FATU_060"
  • systextil.dao.NotaFiscalSerie
    Modifier and Type
    Constant Field
    Value
    public static final int
    0
    public static final int
    1
    public static final int
    1
  • systextil.dao.ObservacoesRolo
    Modifier and Type
    Constant Field
    Value
    public static final String
    "select 1 from pcpt_022 "
    public static final String
    "select pcpt_022.* from pcpt_022 "
    public static final String
    "where pcpt_022.codigo_rolo = ? and pcpt_022.usuario = ? and pcpt_022.data = ? and pcpt_022.hora = ?"
  • systextil.dao.OrcamentoItem
    Modifier and Type
    Constant Field
    Value
    public static final String
    "T"
    public static final String
    "V"
  • Modifier and Type
    Constant Field
    Value
    public static final int
    0
    public static final String
    ""
  • systextil.dao.OrdemDeCorte
    Modifier and Type
    Constant Field
    Value
    public static final String
    "select 1 from pcpc_020 "
    public static final String
    "select pcpc_020.* from pcpc_020 "
  • Modifier and Type
    Constant Field
    Value
    public static final int
    1
    public static final int
    3
    public static final int
    2
  • systextil.dao.ParametrosDeEmpresa
    Modifier and Type
    Constant Field
    Value
    protected static final String
    "FATU_500"
    protected static final String
    "FATU_501"
    protected static final String
    "FATU_502"
    protected static final String
    "FATU_503"
    protected static final String
    "FATU_504"
  • systextil.dao.ParametrosGenericos
    Modifier and Type
    Constant Field
    Value
    public static final String
    "select 1 from hdoc_001"
    public static final String
    "select hdoc_001.* from hdoc_001 "
    public static final String
    "where hdoc_001.tipo=? and hdoc_001.codigo=? and hdoc_001.codigo2=?"
  • systextil.dao.PeriodoProducao
    Modifier and Type
    Constant Field
    Value
    public static final int
    0
    public static final int
    1
    public static final int
    2
    public static final int
    3
    public static final int
    1
  • systextil.dao.PermissaoUsuario
    Modifier and Type
    Constant Field
    Value
    public static final String
    "S"
  • systextil.dao.ProdutoComponente
    Modifier and Type
    Constant Field
    Value
    public static final int
    1
    public static final int
    2
  • Modifier and Type
    Constant Field
    Value
    public static final int
    2
    public static final int
    3
    public static final int
    1
    public static final int
    1
    public static final int
    0
    public static final int
    2
  • Modifier and Type
    Constant Field
    Value
    public static final String
    "CC"
    public static final String
    "CI"
    public static final String
    "CP"
  • Modifier and Type
    Constant Field
    Value
    public static final String
    "select ESTQ_040.CDITEM_NIVEL99, ESTQ_040.CDITEM_GRUPO, ESTQ_040.CDITEM_SUBGRUPO, ESTQ_040.CDITEM_ITEM, ESTQ_040.DEPOSITO, ESTQ_040.LOTE_ACOMP, ESTQ_040.QTDE_ESTOQUE_ATU from ESTQ_040 inner join BASI_030 ON (BASI_030.NIVEL_ESTRUTURA = ESTQ_040.CDITEM_NIVEL99 and BASI_030.REFERENCIA = CDITEM_GRUPO) inner join BASI_205 ON (BASI_205.TIPO_VOLUME = 0 and BASI_205.LOCAL_DEPOSITO = ? and ESTQ_040.DEPOSITO = BASI_205.CODIGO_DEPOSITO) and ESTQ_040.CDITEM_NIVEL99 = ? and (ESTQ_040.DEPOSITO = ? ) and (ESTQ_040.CDITEM_GRUPO = ? or ? = \'XXXXXX\') and (ESTQ_040.CDITEM_SUBGRUPO = ? or ? = \'XXXX\') and (ESTQ_040.CDITEM_ITEM = ? or ? = \'XXXXXXX\') order by DBMS_RANDOM.VALUE() "
    public static final String
    "select ESTQ_040.CDITEM_NIVEL99, ESTQ_040.CDITEM_GRUPO, ESTQ_040.CDITEM_SUBGRUPO, ESTQ_040.CDITEM_ITEM, ESTQ_040.DEPOSITO, ESTQ_040.LOTE_ACOMP, 0 AS QTDE_ESTOQUE_ATU from ESTQ_040 inner join BASI_030 ON (BASI_030.NIVEL_ESTRUTURA = ESTQ_040.CDITEM_NIVEL99 and BASI_030.REFERENCIA = CDITEM_GRUPO) inner join BASI_205 ON (BASI_205.TIPO_VOLUME = 0 and BASI_205.LOCAL_DEPOSITO = ? and ESTQ_040.DEPOSITO = BASI_205.CODIGO_DEPOSITO) and ESTQ_040.CDITEM_NIVEL99 = ? and (ESTQ_040.CDITEM_GRUPO = ? or ? = \'XXXXXX\') and (ESTQ_040.CDITEM_SUBGRUPO = ? or ? = \'XXXX\') and (ESTQ_040.CDITEM_ITEM = ? or ? = \'XXXXXXX\') order by DBMS_RANDOM.VALUE() "
    public static final String
    " select estq_049.nivel, estq_049.grupo, estq_049.subgrupo, estq_049.item from estq_049 where estq_049.data_imagem >= to_char(sysdate -?) and estq_049.data_imagem <> to_char(sysdate) and estq_049.cod_deposito = ? and estq_049.nivel = ? group by estq_049.nivel, estq_049.grupo, estq_049.subgrupo, estq_049.item "
    public static final String
    "select ESTQ_040.CDITEM_NIVEL99, ESTQ_040.CDITEM_GRUPO, ESTQ_040.CDITEM_SUBGRUPO, ESTQ_040.CDITEM_ITEM, ESTQ_040.DEPOSITO, ESTQ_040.LOTE_ACOMP, ESTQ_040.QTDE_ESTOQUE_ATU, BASI_030.CONTA_ESTOQUE || \' - \' || BASI_150.DESCR_CT_ESTOQUE CONTA_ESTOQUE from ESTQ_040 inner join BASI_030 ON (BASI_030.NIVEL_ESTRUTURA = ESTQ_040.CDITEM_NIVEL99 and BASI_030.REFERENCIA = CDITEM_GRUPO) inner join BASI_150 ON (BASI_150.CONTA_ESTOQUE = BASI_030.CONTA_ESTOQUE) inner join BASI_205 ON (BASI_205.TIPO_VOLUME = 0 and BASI_205.LOCAL_DEPOSITO = ? and ESTQ_040.DEPOSITO = BASI_205.CODIGO_DEPOSITO) and (BASI_030.CONTA_ESTOQUE in (%s)) and ESTQ_040.CDITEM_NIVEL99 = ? and (ESTQ_040.DEPOSITO = ? or ? = 0) %s order by DBMS_RANDOM.VALUE()"
    public static final String
    "select ESTQ_040.CDITEM_NIVEL99, ESTQ_040.CDITEM_GRUPO, ESTQ_040.CDITEM_SUBGRUPO, ESTQ_040.CDITEM_ITEM, ESTQ_040.DEPOSITO, ESTQ_040.LOTE_ACOMP, ESTQ_040.QTDE_ESTOQUE_ATU from ESTQ_040 inner join BASI_030 ON (BASI_030.NIVEL_ESTRUTURA = ESTQ_040.CDITEM_NIVEL99 and BASI_030.REFERENCIA = CDITEM_GRUPO) inner join BASI_205 ON (BASI_205.TIPO_VOLUME = 0 and BASI_205.LOCAL_DEPOSITO = ? and ESTQ_040.DEPOSITO = BASI_205.CODIGO_DEPOSITO) and ESTQ_040.CDITEM_NIVEL99 = ? and (ESTQ_040.DEPOSITO = ? or ? = 0) %s order by DBMS_RANDOM.VALUE()"
    public static final String
    "select ESTQ_040.CDITEM_NIVEL99, ESTQ_040.CDITEM_GRUPO, ESTQ_040.CDITEM_SUBGRUPO, ESTQ_040.CDITEM_ITEM, ESTQ_040.DEPOSITO, ESTQ_040.LOTE_ACOMP, ESTQ_040.QTDE_ESTOQUE_ATU, BASI_030.UNIDADE_MEDIDA from ESTQ_040 inner join BASI_030 ON (BASI_030.NIVEL_ESTRUTURA = ESTQ_040.CDITEM_NIVEL99 and BASI_030.REFERENCIA = CDITEM_GRUPO) inner join BASI_205 ON (BASI_205.TIPO_VOLUME = 0 and BASI_205.LOCAL_DEPOSITO = ? and ESTQ_040.DEPOSITO = BASI_205.CODIGO_DEPOSITO) and (BASI_030.UNIDADE_MEDIDA in (?)) and ESTQ_040.CDITEM_NIVEL99 = ? and (ESTQ_040.DEPOSITO = ? or ? = 0) %s order by DBMS_RANDOM.VALUE() "
    public static final String
    " select count(*) QTDE_REFERENCIAS from rcnb_060 where rcnb_060.tipo_registro = ? and rcnb_060.subgru_estrutura = ? and rcnb_060.nr_solicitacao = ? "
    public static final String
    " select RCNB_060.GRUPO_ESTRUTURA_STR, RCNB_060.SUBGRU_ESTRUTURA_STR, RCNB_060.DESCRICAO from rcnb_060 where rcnb_060.tipo_registro = ? and rcnb_060.subgru_estrutura = ? and rcnb_060.nr_solicitacao = ? "
  • systextil.dao.RegistroDeParadas
    Modifier and Type
    Constant Field
    Value
    public static final String
    "select * from efic_090 where data_parada <= ? and maquina_maq_sub_grupo_mq = ? and maquina_maq_sub_sbgr_maq = ? and maquina_nr_maq = ? and parada_cd_area = ? and parada_cd_parad = ? and turno = ? and equipe = ? and hora_inicio = ? and operador_parada = ?"
    public static final String
    "select * from efic_090 where data_parada \t<= ? and maquina_maq_sub_grupo_mq = ? and maquina_maq_sub_sbgr_maq = ? and maquina_nr_maq \t= ? and parada_cd_area \t= ? and parada_cd_parad \t= ? and turno \t= ? and equipe \t= ? and operador_parada = ?"
  • systextil.dao.RoloDeTecido
    Modifier and Type
    Constant Field
    Value
    public static final int
    2
    public static final int
    1
    public static final int
    0
    public static final int
    4
    public static final int
    2
    public static final int
    4
  • Modifier and Type
    Constant Field
    Value
    public static final String
    "select 1 from rcnb_850 "
    public static final String
    "select rcnb_850.* from rcnb_850 "
    public static final String
    "where rcnb_850.codigo_empresa = ? and rcnb_850.mes = ? and rcnb_850.ano = ? and rcnb_850.nivel_estrutura = ? and rcnb_850.grupo_estrutura = ? and rcnb_850.subgru_estrutura = ? and rcnb_850.item_estrutura = ?and rcnb_850.nr_versao = ? "
  • Modifier and Type
    Constant Field
    Value
    public static final String
    "select 1 from rcnb_851 "
    public static final String
    "select rcnb_851.* from rcnb_851 "
    public static final String
    "where rcnb_851.codigo_empresa = ? and rcnb_851.mes = ? and rcnb_851.ano = ? and rcnb_851.nivel_estrutura = ? and rcnb_851.grupo_estrutura = ? and rcnb_851.subgru_estrutura = ? and rcnb_851.item_estrutura = ? and rcnb_851.seq_estrutura = ? and and rcnb_851.nivel_explosao = ? and rcnb_851.nivel_componente = ? and rcnb_851.grupo_componente = ? and rcnb_851.subgru_componente = ? and rcnb_851.item_componente = ? and rcnb_851.nr_versao = ?"
  • systextil.dao.SolicitacaoProcesso
    Modifier and Type
    Constant Field
    Value
    public static final int
    2
  • Modifier and Type
    Constant Field
    Value
    public static final int
    1
    public static final int
    2
  • systextil.dao.Tamanho
    Modifier and Type
    Constant Field
    Value
    public static final int
    1
    public static final int
    2
  • systextil.dao.ValoresClasseDeValor
    Modifier and Type
    Constant Field
    Value
    public static final String
    "select 1 from rcnb_800 "
    public static final String
    "select rcnb_800.* from rcnb_800 "
    public static final String
    "where rcnb_800.mes_classe = ? and rcnb_800.ano_classe = ? and rcnb_800.seq_classe = ? and rcnb_800.classe_valor = ?"
  • systextil.dao.Volume
    Modifier and Type
    Constant Field
    Value
    public static final int
    3
    public static final int
    8