Package systextil.dao
Class NotaFiscalDeSaidaItem
java.lang.Object
systextil.dao.NotaFiscalItem
systextil.dao.NotaFiscalDeSaidaItem
Representa a tabela
FATU_060
-
Field Summary
FieldsModifier and TypeFieldDescriptionfinal int
final int
final br.com.intersys.systextil.connection.Amount
final NotaFiscalDeSaida
final int
final int
final int
final int
final int
final int
final int
final int
final Date
final int
final br.com.intersys.systextil.connection.Amount
final int
final int
final int
final int
final int
final String
final int
final int
final int
final String
final int
final int
final Cnpj
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final double
final double
final int
final double
final Double
final br.com.intersys.systextil.connection.Amount
final int
final int
final int
final int
final int
final int
final String
final String
static final String
final double
final String
final double
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
final br.com.intersys.systextil.connection.Amount
Fields inherited from class systextil.dao.NotaFiscalItem
base_icms, base_ipi, base_pis_cofins, capa, centro_custo, classif_contabil, classific_fiscal, codigo_contabil, codigo_deposito, codigo_transacao, cvf_cofins, cvf_icms, cvf_ipi, cvf_pis, data_canc_nfisc, descricao_item, estrutura, executa_trigger, flag_devolucao, flag_guia_remissao, formulario_num, formulario_ori, formulario_seq, formulario_ser, lote, natoper_est, natoper_num, nome_programa, num_nota_orig, numero, obs_livro1, obs_livro2, pedido_num, pedido_seq, perc_cofins, perc_icms, perc_ipi, perc_iva_1, perc_iva_2, perc_pis, procedencia, quantidade, rateio_descontos_ipi, rateio_despesa, rateio_despesas_ipi, seq_nota_orig, sequencia, serie, serie_nota_orig, transacao_canc_nfisc, unidade_medida, usuario_cardex, valor_cofins, valor_icms, valor_ipi, valor_iva_1, valor_iva_2, valor_pis, valor_unitario
-
Method Summary
Modifier and TypeMethodDescriptionstatic int
atualizarEncargosSubstituicaoTributaria
(br.com.intersys.systextil.connection.AppConnection conn, BigDecimal percentualReducaoICMS, BigDecimal valorIcmsOperacao, BigDecimal valorIcmsDif, BigDecimal valorIcms, NotaFiscalDeSaida nf, Integer sequenciaDoItem) Atualiza os encargos de ICMS cobrado integralmente com substituição tributária (Quando o CST for 51).static void
delete
(br.com.intersys.systextil.connection.AppConnection conn, int codigo_empresa, int num_nota, String serie) static boolean
existeItem
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capaNota, CodProduto item) static boolean
existeItemPatrimonial
(br.com.intersys.systextil.connection.AppConnection conn, int numNotaFiscal, String serieNotaFiscal, int seqItemNFisc) static boolean
exists
(br.com.intersys.systextil.connection.AppConnection conn, int codigoEmpresa, int numeroNota, String serie, String nivel) static NotaFiscalDeSaidaItem
get
(br.com.intersys.systextil.connection.AppConnection conn, int codigo_empresa, int numero_nota, String serie, int seq_item) static NotaFiscalDeSaidaItem
get
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota, int seq_item) static NotaFiscalDeSaidaItem
get
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa, CodProduto p) static NotaFiscalDeSaidaItem
getDepositoDifZero
(br.com.intersys.systextil.connection.AppConnection conn, int codigoEmpresa, int numeroNota, String serie) static List
<Fatu060Dto> getItensParalancamentosContabeis
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida nf) GRAVA OS LANCAMENTOS CONTABEISstatic Date
getMaxdataEmissao
(br.com.intersys.systextil.connection.AppConnection conn, int pedidovenda) static String
getNivelEstrutura
(br.com.intersys.systextil.connection.AppConnection conn, int codigoEmpresa, int numeroNota, String serie) double
getQtdeDevolvida
(br.com.intersys.systextil.connection.AppConnection conn) static Integer
getQtdeProdutosPorPedido
(br.com.intersys.systextil.connection.AppConnection conn, int codigo_empresa, int pedido) static double
getTotalFaturadoByNotaFiscal
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida notaFiscalDeSaida) static br.com.intersys.systextil.connection.Amount
getTotalValorContabil
(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis) static br.com.intersys.systextil.connection.Amount
getTotalValorFaturado
(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis) static void
insertItem
(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, int nr_solicitacao, Date data_emissao, int natopeno_nat_oper, String natopeno_est_oper, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, String descricao_item, String classific_fiscal, int seq_item_pedido, String unidade_medida, int procedencia, int classif_contabil, int codigo_contabil, double qtde_item_fatur, double valor_unitario, br.com.intersys.systextil.connection.Amount valor_faturado, br.com.intersys.systextil.connection.Amount desconto_item, int deposito, int lote_acomp, int transacao, double peso_liquido, int cvf_ipi, br.com.intersys.systextil.connection.Amount base_ipi, br.com.intersys.systextil.connection.Amount perc_ipi, br.com.intersys.systextil.connection.Amount valor_ipi, br.com.intersys.systextil.connection.Amount perc_icms, int cvf_icms, int deposito_transf, int num_nota_orig, String serie_nota_orig, int seq_nota_orig, int cgc9_origem, int cgc4_origem, int cgc2_origem, br.com.intersys.systextil.connection.Amount valor_negociacao, double perc_mao_obra, double qtde_fatu_empe, int motivo_devolucao, br.com.intersys.systextil.connection.Amount base_icms, br.com.intersys.systextil.connection.Amount valor_icms, String usuario_cardex, String nome_programa, int centro_custo, int pedido_venda, br.com.intersys.systextil.connection.Amount valor_iss, int sequencia_mao_obra, String obs_livro1, String obs_livro2, String um_faturamento_um, double um_faturamento_qtde, double um_faturamento_valor_unit, int cvf_pis, int cvf_cofins, br.com.intersys.systextil.connection.Amount valor_pis, br.com.intersys.systextil.connection.Amount valor_cofins, br.com.intersys.systextil.connection.Amount basi_pis_cofins, int cvf_ipi_saida, br.com.intersys.systextil.connection.Amount perc_pis, br.com.intersys.systextil.connection.Amount perc_cofins, int cod_csosn) static void
insertItem
(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, int nr_solicitacao, Date data_emissao, int natopeno_nat_oper, String natopeno_est_oper, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, String descricao_item, String classific_fiscal, int seq_item_pedido, String unidade_medida, int procedencia, int classif_contabil, int codigo_contabil, double qtde_item_fatur, double valor_unitario, br.com.intersys.systextil.connection.Amount valor_faturado, br.com.intersys.systextil.connection.Amount desconto_item, int deposito, int lote_acomp, int transacao, double peso_liquido, int cvf_ipi, br.com.intersys.systextil.connection.Amount base_ipi, br.com.intersys.systextil.connection.Amount perc_ipi, br.com.intersys.systextil.connection.Amount valor_ipi, br.com.intersys.systextil.connection.Amount perc_icms, int cvf_icms, int deposito_transf, int num_nota_orig, String serie_nota_orig, int seq_nota_orig, int cgc9_origem, int cgc4_origem, int cgc2_origem, br.com.intersys.systextil.connection.Amount valor_negociacao, double perc_mao_obra, double qtde_fatu_empe, int motivo_devolucao, br.com.intersys.systextil.connection.Amount base_icms, br.com.intersys.systextil.connection.Amount valor_icms, String usuario_cardex, String nome_programa, int centro_custo, int pedido_venda, br.com.intersys.systextil.connection.Amount valor_iss, int sequencia_mao_obra, String obs_livro1, String obs_livro2, String um_faturamento_um, double um_faturamento_qtde, double um_faturamento_valor_unit, int cvf_pis, int cvf_cofins, br.com.intersys.systextil.connection.Amount valor_pis, br.com.intersys.systextil.connection.Amount valor_cofins, br.com.intersys.systextil.connection.Amount basi_pis_cofins, int cvf_ipi_saida, br.com.intersys.systextil.connection.Amount perc_pis, br.com.intersys.systextil.connection.Amount perc_cofins, int cod_csosn, int num_ordem_serv, int seq_item_ordem) static void
insertItem
(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, int nr_solicitacao, Date data_emissao, int natopeno_nat_oper, String natopeno_est_oper, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, String descricao_item, String classific_fiscal, int seq_item_pedido, String unidade_medida, int procedencia, int classif_contabil, int codigo_contabil, double qtde_item_fatur, double valor_unitario, br.com.intersys.systextil.connection.Amount valor_faturado, br.com.intersys.systextil.connection.Amount desconto_item, int deposito, int lote_acomp, int transacao, double peso_liquido, int cvf_ipi, br.com.intersys.systextil.connection.Amount base_ipi, br.com.intersys.systextil.connection.Amount perc_ipi, br.com.intersys.systextil.connection.Amount valor_ipi, br.com.intersys.systextil.connection.Amount perc_icms, int cvf_icms, int deposito_transf, int num_nota_orig, String serie_nota_orig, int seq_nota_orig, int cgc9_origem, int cgc4_origem, int cgc2_origem, br.com.intersys.systextil.connection.Amount valor_negociacao, double perc_mao_obra, double qtde_fatu_empe, int motivo_devolucao, br.com.intersys.systextil.connection.Amount base_icms, br.com.intersys.systextil.connection.Amount valor_icms, String usuario_cardex, String nome_programa, int centro_custo, int pedido_venda, br.com.intersys.systextil.connection.Amount valor_iss, int sequencia_mao_obra, String obs_livro1, String obs_livro2, String um_faturamento_um, double um_faturamento_qtde, double um_faturamento_valor_unit, int cvf_pis, int cvf_cofins, br.com.intersys.systextil.connection.Amount valor_pis, br.com.intersys.systextil.connection.Amount valor_cofins, br.com.intersys.systextil.connection.Amount basi_pis_cofins, int cvf_ipi_saida, br.com.intersys.systextil.connection.Amount perc_pis, br.com.intersys.systextil.connection.Amount perc_cofins, int cod_csosn, int num_nota_relacionada, String serie_nota_relacionada) static void
insertItem
(br.com.intersys.systextil.connection.AppConnection conn, Fatu060Dto fatu060) static void
insertItemDeIntegracao
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalIntegracaoItem item) static void
insertItemDeLoja
(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, int seq_item_pedido, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, int lote_acomp, int deposito, int transacao, Date data_emissao, double qtde_item_fatur, double valor_unitario, br.com.intersys.systextil.connection.Amount valor_faturado, br.com.intersys.systextil.connection.Amount valor_contabil, br.com.intersys.systextil.connection.Amount desconto_item, int natopeno_nat_oper, String natopeno_est_oper, br.com.intersys.systextil.connection.Amount base_ipi, br.com.intersys.systextil.connection.Amount perc_ipi, br.com.intersys.systextil.connection.Amount valor_ipi, int cvf_ipi, br.com.intersys.systextil.connection.Amount base_icms, br.com.intersys.systextil.connection.Amount perc_icms, br.com.intersys.systextil.connection.Amount valor_icms, int cvf_icms, br.com.intersys.systextil.connection.Amount valor_icms_difer, double peso_liquido, String descricao_item, String classific_fiscal, int classif_contabil, int centro_custo, String unidade_medida, br.com.intersys.systextil.connection.Amount rateio_despesa, int procedencia, int codigo_contabil, String obs_livro1, String obs_livro2, br.com.intersys.systextil.connection.Amount rateio_desc_propaganda, br.com.intersys.systextil.connection.Amount base_icms_difer, br.com.intersys.systextil.connection.Amount rateio_despesas_ipi, br.com.intersys.systextil.connection.Amount rateio_descontos_ipi, int pedido_venda, br.com.intersys.systextil.connection.Amount valor_iss, br.com.intersys.systextil.connection.Amount valor_pis, br.com.intersys.systextil.connection.Amount valor_cofins, br.com.intersys.systextil.connection.Amount perc_iss, int cvf_cofins, int cvf_pis, br.com.intersys.systextil.connection.Amount perc_pis, br.com.intersys.systextil.connection.Amount basi_pis_cofins, int cvf_ipi_saida, int nr_solicitacao, int cod_csosn) Deprecated.static void
insertItemDeLoja
(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, int seq_item_pedido, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, int lote_acomp, int deposito, int transacao, Date data_emissao, double qtde_item_fatur, double valor_unitario, br.com.intersys.systextil.connection.Amount valor_faturado, br.com.intersys.systextil.connection.Amount valor_contabil, br.com.intersys.systextil.connection.Amount desconto_item, int natopeno_nat_oper, String natopeno_est_oper, br.com.intersys.systextil.connection.Amount base_ipi, br.com.intersys.systextil.connection.Amount perc_ipi, br.com.intersys.systextil.connection.Amount valor_ipi, int cvf_ipi, br.com.intersys.systextil.connection.Amount base_icms, br.com.intersys.systextil.connection.Amount perc_icms, br.com.intersys.systextil.connection.Amount valor_icms, int cvf_icms, br.com.intersys.systextil.connection.Amount valor_icms_difer, double peso_liquido, String descricao_item, String classific_fiscal, int classif_contabil, int centro_custo, String unidade_medida, br.com.intersys.systextil.connection.Amount rateio_despesa, int procedencia, int codigo_contabil, String obs_livro1, String obs_livro2, br.com.intersys.systextil.connection.Amount rateio_desc_propaganda, br.com.intersys.systextil.connection.Amount base_icms_difer, br.com.intersys.systextil.connection.Amount rateio_despesas_ipi, br.com.intersys.systextil.connection.Amount rateio_descontos_ipi, int pedido_venda, br.com.intersys.systextil.connection.Amount valor_iss, br.com.intersys.systextil.connection.Amount valor_pis, br.com.intersys.systextil.connection.Amount valor_cofins, br.com.intersys.systextil.connection.Amount perc_iss, int cvf_cofins, int cvf_pis, br.com.intersys.systextil.connection.Amount perc_pis, br.com.intersys.systextil.connection.Amount perc_cofins, br.com.intersys.systextil.connection.Amount basi_pis_cofins, int cvf_ipi_saida, int nr_solicitacao, int cod_csosn) static void
insertItemNotaEntrega
(br.com.intersys.systextil.connection.AppConnection conn, Fatu060Dto item) static NotaFiscalDeSaidaItem[]
list
(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis) static NotaFiscalDeSaidaItem[]
list
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) static NotaFiscalDeSaidaItem[]
list
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota, String complementoSQL) static NotaFiscalDeSaidaItem[]
listarPorChave
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) static List
<NotaFiscalDeSaidaItem> listByNotaFiscalSaida
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida notaFiscalDeSaida) static NotaFiscalDeSaidaItem[]
listCapaAndRcnb060
(br.com.intersys.systextil.connection.AppConnection conn, int empresa, int nrnota, String srnota, String nivelItem, int lote_entrega, int lote_entrega2, int lote_entrega3, int lote_entrega4, int lote_entrega5, int naturezaOperacao, int codigo_usuario) static NotaFiscalDeSaidaItem[]
listNotInvetFiscal
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota, String complementoSQL) static NotaFiscalDeSaidaItem[]
listOrderByClassificFiscal
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) static NotaFiscalDeSaidaItem[]
listOrderByEstrutura
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) static List
<NotaFiscalDeSaidaItem> listOrderByFaturado
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) static List
<NotaFiscalDeSaidaItem> listOrderByFaturado
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota, String complementoSQL) static NotaFiscalDeSaidaItem[]
listOrderByNotaOrig
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) static NotaFiscalDeSaidaItem[]
listOrderByPedidoEEstrutura
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) static Integer[]
listPedidosVendaDosItens
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) Retorna a lista de todos os números de pedido associados aos itens da nota fiscal, inclusive zero se houver, em ordem crescente.static NotaFiscalDeSaidaItem[]
listPorEmpresaNotaSerieSequenciaCnpj
(br.com.intersys.systextil.connection.AppConnection conn, int codigoEmpresa, int numeroNota, String serie, int sequencia, Cnpj cgc, int codigoCancelamento) static NotaFiscalDeSaidaItem[]
listPorSolicitacao
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota, int nr_solicitacao) static boolean
periodoTemNotasComMaisDeUmPedido
(br.com.intersys.systextil.connection.AppConnection conn, Date data_inicio, Date data_fim) static boolean
serieNFPossuiMaisDeUmPedido
(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis) void
updateAtualizouEstq
(br.com.intersys.systextil.connection.AppConnection conn, int atualizou_estq) static void
updateCamposConsignacao
(br.com.intersys.systextil.connection.AppConnection conn, int cod_empresa, int numero_nota, String serie_nota, Date data_emissao, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, int fornecedor_cgc9, int fornecedor_cgc4, int fornecedor_cgc2, int lote_fornec) void
updateCancelamento
(br.com.intersys.systextil.connection.AppConnection conn, int cod_cancelamento, Date data_canc_nfisc, int transacao_canc_nfisc, String usuario_cardex, String nome_programa) static void
updateItemDeIntegracao
(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalIntegracaoItem item) int
updateSuframa
(br.com.intersys.systextil.connection.AppConnection conn, br.com.intersys.systextil.connection.Amount baseSuframa, br.com.intersys.systextil.connection.Amount valorSuframa) static void
updateValoresItem
(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, double valor_contabil) Methods inherited from class systextil.dao.NotaFiscalItem
getNatOper, getNatOperNotNull, getPedidoVendaItem, getProduto, getTransacao, getTransacaoNotNull
-
Field Details
-
TABELA_ORIGEM
- See Also:
-
capa_nota
-
codigo_empresa
public final int codigo_empresa -
data_emissao
-
valor_faturado
public final br.com.intersys.systextil.connection.Amount valor_faturado -
valor_contabil
public final br.com.intersys.systextil.connection.Amount valor_contabil -
desconto_item
public final br.com.intersys.systextil.connection.Amount desconto_item -
valor_icms_difer
public final br.com.intersys.systextil.connection.Amount valor_icms_difer -
base_icms_difer
public final br.com.intersys.systextil.connection.Amount base_icms_difer -
perc_icms_diferido
public final br.com.intersys.systextil.connection.Amount perc_icms_diferido -
valor_icms_diferido
public final br.com.intersys.systextil.connection.Amount valor_icms_diferido -
peso_liquido
public final double peso_liquido -
cod_cancelamento
public final int cod_cancelamento -
nr_solicitacao
public final int nr_solicitacao -
atualizou_estq
public final int atualizou_estq -
deposito_transf
public final int deposito_transf -
cen_custo_transf
public final int cen_custo_transf -
num_ordem_serv
public final int num_ordem_serv -
seq_item_ordem
public final int seq_item_ordem -
motivo_devolucao
public final int motivo_devolucao -
qtde_fatu_empe
public final double qtde_fatu_empe -
origem
-
rateio_desc_propaganda
public final br.com.intersys.systextil.connection.Amount rateio_desc_propaganda -
atualizou_plano
public final int atualizou_plano -
sequencia_mao_obra
public final int sequencia_mao_obra -
perc_mao_obra
public final double perc_mao_obra -
valor_negociacao
public final br.com.intersys.systextil.connection.Amount valor_negociacao -
empresa_nota_reemissao
public final int empresa_nota_reemissao -
numero_nota_reemissao
public final int numero_nota_reemissao -
serie_nota_reemissao
-
seq_nota_reemissao
public final int seq_nota_reemissao -
nro_rolo_peca
public final int nro_rolo_peca -
processo_contabil_estoque
public final int processo_contabil_estoque -
valor_iss
public final br.com.intersys.systextil.connection.Amount valor_iss -
um_faturamento_um
-
um_faturamento_qtde
public final double um_faturamento_qtde -
um_faturamento_valor_unit
public final double um_faturamento_valor_unit -
requisicao
public final int requisicao -
seq_requisicao
public final int seq_requisicao -
perc_iss
public final br.com.intersys.systextil.connection.Amount perc_iss -
cvf_ipi_saida
public final int cvf_ipi_saida -
nota_ajuste
public final int nota_ajuste -
serie_ajuste
-
cod_csosn
public final int cod_csosn -
perc_fcp_uf_dest
public final br.com.intersys.systextil.connection.Amount perc_fcp_uf_dest -
perc_icms_uf_dest
public final br.com.intersys.systextil.connection.Amount perc_icms_uf_dest -
perc_icms_partilha
public final br.com.intersys.systextil.connection.Amount perc_icms_partilha -
val_fcp_uf_dest
public final br.com.intersys.systextil.connection.Amount val_fcp_uf_dest -
val_icms_uf_dest
public final br.com.intersys.systextil.connection.Amount val_icms_uf_dest -
val_icms_uf_remet
public final br.com.intersys.systextil.connection.Amount val_icms_uf_remet -
nr_cupom
public final int nr_cupom -
num_serie_ecf
-
nr_caixa
public final int nr_caixa -
pdif51
public final br.com.intersys.systextil.connection.Amount pdif51 -
vicmsop51
public final br.com.intersys.systextil.connection.Amount vicmsop51 -
vicmsdif51
public final br.com.intersys.systextil.connection.Amount vicmsdif51 -
nr_patrimonio_str
-
sequencia_patrimonio
public final int sequencia_patrimonio -
cod_estagio_agrupador_prod
public final int cod_estagio_agrupador_prod -
cod_estagio_agrupador_insu
public final int cod_estagio_agrupador_insu -
cod_estagio_simultaneo_insu
public final int cod_estagio_simultaneo_insu -
ordem_producao_blk
public final int ordem_producao_blk -
valor_seguro
public final br.com.intersys.systextil.connection.Amount valor_seguro -
valor_frete
public final br.com.intersys.systextil.connection.Amount valor_frete -
valor_outros
public final br.com.intersys.systextil.connection.Amount valor_outros -
valor_desc
public final br.com.intersys.systextil.connection.Amount valor_desc -
valor_suframa_icms
public final br.com.intersys.systextil.connection.Amount valor_suframa_icms -
qtde_item_fatur
-
-
Method Details
-
get
public static NotaFiscalDeSaidaItem get(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota, int seq_item) -
get
public static NotaFiscalDeSaidaItem get(br.com.intersys.systextil.connection.AppConnection conn, int codigo_empresa, int numero_nota, String serie, int seq_item) -
getDepositoDifZero
public static NotaFiscalDeSaidaItem getDepositoDifZero(br.com.intersys.systextil.connection.AppConnection conn, int codigoEmpresa, int numeroNota, String serie) -
existeItemPatrimonial
public static boolean existeItemPatrimonial(br.com.intersys.systextil.connection.AppConnection conn, int numNotaFiscal, String serieNotaFiscal, int seqItemNFisc) -
getQtdeProdutosPorPedido
public static Integer getQtdeProdutosPorPedido(br.com.intersys.systextil.connection.AppConnection conn, int codigo_empresa, int pedido) -
exists
-
existeItem
public static boolean existeItem(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capaNota, CodProduto item) -
listNotInvetFiscal
public static NotaFiscalDeSaidaItem[] listNotInvetFiscal(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota, String complementoSQL) -
list
public static NotaFiscalDeSaidaItem[] list(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota, String complementoSQL) -
listarPorChave
public static NotaFiscalDeSaidaItem[] listarPorChave(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) -
listOrderByFaturado
public static List<NotaFiscalDeSaidaItem> listOrderByFaturado(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota, String complementoSQL) -
list
public static NotaFiscalDeSaidaItem[] list(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis) -
list
public static NotaFiscalDeSaidaItem[] list(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) -
listOrderByFaturado
public static List<NotaFiscalDeSaidaItem> listOrderByFaturado(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) -
listOrderByClassificFiscal
public static NotaFiscalDeSaidaItem[] listOrderByClassificFiscal(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) -
listOrderByPedidoEEstrutura
public static NotaFiscalDeSaidaItem[] listOrderByPedidoEEstrutura(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) -
listOrderByEstrutura
public static NotaFiscalDeSaidaItem[] listOrderByEstrutura(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) -
listOrderByNotaOrig
public static NotaFiscalDeSaidaItem[] listOrderByNotaOrig(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) -
listPorSolicitacao
public static NotaFiscalDeSaidaItem[] listPorSolicitacao(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota, int nr_solicitacao) -
serieNFPossuiMaisDeUmPedido
public static boolean serieNFPossuiMaisDeUmPedido(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis) - Returns:
- true se houver itens com mais de um pedido diferente para a sequencia de nota fiscal informada
-
periodoTemNotasComMaisDeUmPedido
-
getTotalValorContabil
public static br.com.intersys.systextil.connection.Amount getTotalValorContabil(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis) -
getTotalValorFaturado
public static br.com.intersys.systextil.connection.Amount getTotalValorFaturado(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis) -
listPedidosVendaDosItens
public static Integer[] listPedidosVendaDosItens(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa_nota) Retorna a lista de todos os números de pedido associados aos itens da nota fiscal, inclusive zero se houver, em ordem crescente. -
listCapaAndRcnb060
public static NotaFiscalDeSaidaItem[] listCapaAndRcnb060(br.com.intersys.systextil.connection.AppConnection conn, int empresa, int nrnota, String srnota, String nivelItem, int lote_entrega, int lote_entrega2, int lote_entrega3, int lote_entrega4, int lote_entrega5, int naturezaOperacao, int codigo_usuario) -
updateAtualizouEstq
public void updateAtualizouEstq(br.com.intersys.systextil.connection.AppConnection conn, int atualizou_estq) -
updateCancelamento
-
updateSuframa
public int updateSuframa(br.com.intersys.systextil.connection.AppConnection conn, br.com.intersys.systextil.connection.Amount baseSuframa, br.com.intersys.systextil.connection.Amount valorSuframa) -
updateValoresItem
public static void updateValoresItem(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, double valor_contabil) -
insertItem
public static void insertItem(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, int nr_solicitacao, Date data_emissao, int natopeno_nat_oper, String natopeno_est_oper, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, String descricao_item, String classific_fiscal, int seq_item_pedido, String unidade_medida, int procedencia, int classif_contabil, int codigo_contabil, double qtde_item_fatur, double valor_unitario, br.com.intersys.systextil.connection.Amount valor_faturado, br.com.intersys.systextil.connection.Amount desconto_item, int deposito, int lote_acomp, int transacao, double peso_liquido, int cvf_ipi, br.com.intersys.systextil.connection.Amount base_ipi, br.com.intersys.systextil.connection.Amount perc_ipi, br.com.intersys.systextil.connection.Amount valor_ipi, br.com.intersys.systextil.connection.Amount perc_icms, int cvf_icms, int deposito_transf, int num_nota_orig, String serie_nota_orig, int seq_nota_orig, int cgc9_origem, int cgc4_origem, int cgc2_origem, br.com.intersys.systextil.connection.Amount valor_negociacao, double perc_mao_obra, double qtde_fatu_empe, int motivo_devolucao, br.com.intersys.systextil.connection.Amount base_icms, br.com.intersys.systextil.connection.Amount valor_icms, String usuario_cardex, String nome_programa, int centro_custo, int pedido_venda, br.com.intersys.systextil.connection.Amount valor_iss, int sequencia_mao_obra, String obs_livro1, String obs_livro2, String um_faturamento_um, double um_faturamento_qtde, double um_faturamento_valor_unit, int cvf_pis, int cvf_cofins, br.com.intersys.systextil.connection.Amount valor_pis, br.com.intersys.systextil.connection.Amount valor_cofins, br.com.intersys.systextil.connection.Amount basi_pis_cofins, int cvf_ipi_saida, br.com.intersys.systextil.connection.Amount perc_pis, br.com.intersys.systextil.connection.Amount perc_cofins, int cod_csosn) -
insertItem
public static void insertItem(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, int nr_solicitacao, Date data_emissao, int natopeno_nat_oper, String natopeno_est_oper, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, String descricao_item, String classific_fiscal, int seq_item_pedido, String unidade_medida, int procedencia, int classif_contabil, int codigo_contabil, double qtde_item_fatur, double valor_unitario, br.com.intersys.systextil.connection.Amount valor_faturado, br.com.intersys.systextil.connection.Amount desconto_item, int deposito, int lote_acomp, int transacao, double peso_liquido, int cvf_ipi, br.com.intersys.systextil.connection.Amount base_ipi, br.com.intersys.systextil.connection.Amount perc_ipi, br.com.intersys.systextil.connection.Amount valor_ipi, br.com.intersys.systextil.connection.Amount perc_icms, int cvf_icms, int deposito_transf, int num_nota_orig, String serie_nota_orig, int seq_nota_orig, int cgc9_origem, int cgc4_origem, int cgc2_origem, br.com.intersys.systextil.connection.Amount valor_negociacao, double perc_mao_obra, double qtde_fatu_empe, int motivo_devolucao, br.com.intersys.systextil.connection.Amount base_icms, br.com.intersys.systextil.connection.Amount valor_icms, String usuario_cardex, String nome_programa, int centro_custo, int pedido_venda, br.com.intersys.systextil.connection.Amount valor_iss, int sequencia_mao_obra, String obs_livro1, String obs_livro2, String um_faturamento_um, double um_faturamento_qtde, double um_faturamento_valor_unit, int cvf_pis, int cvf_cofins, br.com.intersys.systextil.connection.Amount valor_pis, br.com.intersys.systextil.connection.Amount valor_cofins, br.com.intersys.systextil.connection.Amount basi_pis_cofins, int cvf_ipi_saida, br.com.intersys.systextil.connection.Amount perc_pis, br.com.intersys.systextil.connection.Amount perc_cofins, int cod_csosn, int num_ordem_serv, int seq_item_ordem) -
insertItem
public static void insertItem(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, int nr_solicitacao, Date data_emissao, int natopeno_nat_oper, String natopeno_est_oper, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, String descricao_item, String classific_fiscal, int seq_item_pedido, String unidade_medida, int procedencia, int classif_contabil, int codigo_contabil, double qtde_item_fatur, double valor_unitario, br.com.intersys.systextil.connection.Amount valor_faturado, br.com.intersys.systextil.connection.Amount desconto_item, int deposito, int lote_acomp, int transacao, double peso_liquido, int cvf_ipi, br.com.intersys.systextil.connection.Amount base_ipi, br.com.intersys.systextil.connection.Amount perc_ipi, br.com.intersys.systextil.connection.Amount valor_ipi, br.com.intersys.systextil.connection.Amount perc_icms, int cvf_icms, int deposito_transf, int num_nota_orig, String serie_nota_orig, int seq_nota_orig, int cgc9_origem, int cgc4_origem, int cgc2_origem, br.com.intersys.systextil.connection.Amount valor_negociacao, double perc_mao_obra, double qtde_fatu_empe, int motivo_devolucao, br.com.intersys.systextil.connection.Amount base_icms, br.com.intersys.systextil.connection.Amount valor_icms, String usuario_cardex, String nome_programa, int centro_custo, int pedido_venda, br.com.intersys.systextil.connection.Amount valor_iss, int sequencia_mao_obra, String obs_livro1, String obs_livro2, String um_faturamento_um, double um_faturamento_qtde, double um_faturamento_valor_unit, int cvf_pis, int cvf_cofins, br.com.intersys.systextil.connection.Amount valor_pis, br.com.intersys.systextil.connection.Amount valor_cofins, br.com.intersys.systextil.connection.Amount basi_pis_cofins, int cvf_ipi_saida, br.com.intersys.systextil.connection.Amount perc_pis, br.com.intersys.systextil.connection.Amount perc_cofins, int cod_csosn, int num_nota_relacionada, String serie_nota_relacionada) -
insertItemDeLoja
@Deprecated public static void insertItemDeLoja(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, int seq_item_pedido, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, int lote_acomp, int deposito, int transacao, Date data_emissao, double qtde_item_fatur, double valor_unitario, br.com.intersys.systextil.connection.Amount valor_faturado, br.com.intersys.systextil.connection.Amount valor_contabil, br.com.intersys.systextil.connection.Amount desconto_item, int natopeno_nat_oper, String natopeno_est_oper, br.com.intersys.systextil.connection.Amount base_ipi, br.com.intersys.systextil.connection.Amount perc_ipi, br.com.intersys.systextil.connection.Amount valor_ipi, int cvf_ipi, br.com.intersys.systextil.connection.Amount base_icms, br.com.intersys.systextil.connection.Amount perc_icms, br.com.intersys.systextil.connection.Amount valor_icms, int cvf_icms, br.com.intersys.systextil.connection.Amount valor_icms_difer, double peso_liquido, String descricao_item, String classific_fiscal, int classif_contabil, int centro_custo, String unidade_medida, br.com.intersys.systextil.connection.Amount rateio_despesa, int procedencia, int codigo_contabil, String obs_livro1, String obs_livro2, br.com.intersys.systextil.connection.Amount rateio_desc_propaganda, br.com.intersys.systextil.connection.Amount base_icms_difer, br.com.intersys.systextil.connection.Amount rateio_despesas_ipi, br.com.intersys.systextil.connection.Amount rateio_descontos_ipi, int pedido_venda, br.com.intersys.systextil.connection.Amount valor_iss, br.com.intersys.systextil.connection.Amount valor_pis, br.com.intersys.systextil.connection.Amount valor_cofins, br.com.intersys.systextil.connection.Amount perc_iss, int cvf_cofins, int cvf_pis, br.com.intersys.systextil.connection.Amount perc_pis, br.com.intersys.systextil.connection.Amount basi_pis_cofins, int cvf_ipi_saida, int nr_solicitacao, int cod_csosn) Deprecated. -
insertItemDeLoja
public static void insertItemDeLoja(br.com.intersys.systextil.connection.AppConnection conn, int ch_it_nf_cd_empr, int ch_it_nf_num_nfis, String ch_it_nf_ser_nfis, int seq_item_nfisc, int seq_item_pedido, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, int lote_acomp, int deposito, int transacao, Date data_emissao, double qtde_item_fatur, double valor_unitario, br.com.intersys.systextil.connection.Amount valor_faturado, br.com.intersys.systextil.connection.Amount valor_contabil, br.com.intersys.systextil.connection.Amount desconto_item, int natopeno_nat_oper, String natopeno_est_oper, br.com.intersys.systextil.connection.Amount base_ipi, br.com.intersys.systextil.connection.Amount perc_ipi, br.com.intersys.systextil.connection.Amount valor_ipi, int cvf_ipi, br.com.intersys.systextil.connection.Amount base_icms, br.com.intersys.systextil.connection.Amount perc_icms, br.com.intersys.systextil.connection.Amount valor_icms, int cvf_icms, br.com.intersys.systextil.connection.Amount valor_icms_difer, double peso_liquido, String descricao_item, String classific_fiscal, int classif_contabil, int centro_custo, String unidade_medida, br.com.intersys.systextil.connection.Amount rateio_despesa, int procedencia, int codigo_contabil, String obs_livro1, String obs_livro2, br.com.intersys.systextil.connection.Amount rateio_desc_propaganda, br.com.intersys.systextil.connection.Amount base_icms_difer, br.com.intersys.systextil.connection.Amount rateio_despesas_ipi, br.com.intersys.systextil.connection.Amount rateio_descontos_ipi, int pedido_venda, br.com.intersys.systextil.connection.Amount valor_iss, br.com.intersys.systextil.connection.Amount valor_pis, br.com.intersys.systextil.connection.Amount valor_cofins, br.com.intersys.systextil.connection.Amount perc_iss, int cvf_cofins, int cvf_pis, br.com.intersys.systextil.connection.Amount perc_pis, br.com.intersys.systextil.connection.Amount perc_cofins, br.com.intersys.systextil.connection.Amount basi_pis_cofins, int cvf_ipi_saida, int nr_solicitacao, int cod_csosn) -
updateCamposConsignacao
public static void updateCamposConsignacao(br.com.intersys.systextil.connection.AppConnection conn, int cod_empresa, int numero_nota, String serie_nota, Date data_emissao, String nivel_estrutura, String grupo_estrutura, String subgru_estrutura, String item_estrutura, int fornecedor_cgc9, int fornecedor_cgc4, int fornecedor_cgc2, int lote_fornec) -
insertItemDeIntegracao
public static void insertItemDeIntegracao(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalIntegracaoItem item) -
updateItemDeIntegracao
public static void updateItemDeIntegracao(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalIntegracaoItem item) -
delete
public static void delete(br.com.intersys.systextil.connection.AppConnection conn, int codigo_empresa, int num_nota, String serie) -
insertItem
public static void insertItem(br.com.intersys.systextil.connection.AppConnection conn, Fatu060Dto fatu060) -
getItensParalancamentosContabeis
public static List<Fatu060Dto> getItensParalancamentosContabeis(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida nf) GRAVA OS LANCAMENTOS CONTABEIS -
getNivelEstrutura
-
insertItemNotaEntrega
public static void insertItemNotaEntrega(br.com.intersys.systextil.connection.AppConnection conn, Fatu060Dto item) -
listPorEmpresaNotaSerieSequenciaCnpj
public static NotaFiscalDeSaidaItem[] listPorEmpresaNotaSerieSequenciaCnpj(br.com.intersys.systextil.connection.AppConnection conn, int codigoEmpresa, int numeroNota, String serie, int sequencia, Cnpj cgc, int codigoCancelamento) -
get
public static NotaFiscalDeSaidaItem get(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida capa, CodProduto p) -
atualizarEncargosSubstituicaoTributaria
public static int atualizarEncargosSubstituicaoTributaria(br.com.intersys.systextil.connection.AppConnection conn, BigDecimal percentualReducaoICMS, BigDecimal valorIcmsOperacao, BigDecimal valorIcmsDif, BigDecimal valorIcms, NotaFiscalDeSaida nf, Integer sequenciaDoItem) throws br.com.intersys.systextil.connection.DebugException Atualiza os encargos de ICMS cobrado integralmente com substituição tributária (Quando o CST for 51).- Returns:
- A quantidade de registros alterados.
- Throws:
br.com.intersys.systextil.connection.DebugException
-
getMaxdataEmissao
public static Date getMaxdataEmissao(br.com.intersys.systextil.connection.AppConnection conn, int pedidovenda) -
getTotalFaturadoByNotaFiscal
public static double getTotalFaturadoByNotaFiscal(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida notaFiscalDeSaida) -
listByNotaFiscalSaida
public static List<NotaFiscalDeSaidaItem> listByNotaFiscalSaida(br.com.intersys.systextil.connection.AppConnection conn, NotaFiscalDeSaida notaFiscalDeSaida) -
getQtdeDevolvida
public double getQtdeDevolvida(br.com.intersys.systextil.connection.AppConnection conn)
-