Package systextil.dao

Class NotaFiscalDeSaidaItem

java.lang.Object

systextil.dao.NotaFiscalItem

systextil.dao.NotaFiscalDeSaidaItem

public class NotaFiscalDeSaidaItem
extends NotaFiscalItem

Representa a tabela FATU_060

Field Summary

Fields

Modifier and Type	Field	Description
final int	atualizou_estq
final int	atualizou_plano
final br.com.intersys.systextil.connection.Amount	base_icms_difer
final NotaFiscalDeSaida	capa_nota
final int	cen_custo_transf
final int	cod_cancelamento
final int	cod_csosn
final int	codigo_empresa
final int	cvf_ipi_saida
final Date	data_emissao
final int	deposito_transf
final br.com.intersys.systextil.connection.Amount	desconto_item
final int	empresa_nota_reemissao
final int	motivo_devolucao
final int	nota_ajuste
final int	nr_solicitacao
final int	nro_rolo_peca
final int	num_ordem_serv
final int	numero_nota_reemissao
final Cnpj	origem
final br.com.intersys.systextil.connection.Amount	perc_icms_diferido
final br.com.intersys.systextil.connection.Amount	perc_iss
final double	perc_mao_obra
final double	peso_liquido
final int	processo_contabil_estoque
final double	qtde_fatu_empe
final br.com.intersys.systextil.connection.Amount	rateio_desc_propaganda
final int	requisicao
final int	seq_item_ordem
final int	seq_nota_reemissao
final int	seq_requisicao
final int	sequencia_mao_obra
final String	serie_ajuste
final String	serie_nota_reemissao
static final String	TABELA_ORIGEM
final double	um_faturamento_qtde
final String	um_faturamento_um
final double	um_faturamento_valor_unit
final br.com.intersys.systextil.connection.Amount	valor_contabil
final br.com.intersys.systextil.connection.Amount	valor_faturado
final br.com.intersys.systextil.connection.Amount	valor_icms_difer
final br.com.intersys.systextil.connection.Amount	valor_icms_diferido
final br.com.intersys.systextil.connection.Amount	valor_iss
final br.com.intersys.systextil.connection.Amount	valor_negociacao

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 Type	Method	Description
static void	delete(br.com.intersys.systextil.connection.AppConnection conn, int codigo_empresa, int num_nota, String serie)
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	getDepositoDifZero(br.com.intersys.systextil.connection.AppConnection conn, int codigoEmpresa, int numeroNota, String serie)
static String	getNivelEstrutura(br.com.intersys.systextil.connection.AppConnection conn, int codigoEmpresa, int numeroNota, String serie)
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	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)
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[]	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 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)
void	updateAtualizouEstq(br.com.intersys.systextil.connection.AppConnection conn, int atualizou_estq)
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)

Methods inherited from class systextil.dao.NotaFiscalItem

getNatOper, getNatOperNotNull, getPedidoVendaItem, getProduto, getTransacao, getTransacaoNotNull

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

TABELA_ORIGEM

public static final String TABELA_ORIGEM

See Also:

• Constant Field Values

capa_nota

public final NotaFiscalDeSaida capa_nota

codigo_empresa

public final int codigo_empresa

data_emissao

public final Date 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

public final Cnpj 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

public final String 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

public final String 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

public final String serie_ajuste

cod_csosn

public final int cod_csosn

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)

list

public static NotaFiscalDeSaidaItem[] list(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)

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)

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.

updateAtualizouEstq

public void updateAtualizouEstq(br.com.intersys.systextil.connection.AppConnection conn,
 int atualizou_estq)

updateCancelamento

public 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)

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)

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 basi_pis_cofins,
 int cvf_ipi_saida,
 int nr_solicitacao,
 int cod_csosn)

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)

listPorEmpresaNotaSerieSequenciaCnpj

public static NotaFiscalDeSaidaItem[] listPorEmpresaNotaSerieSequenciaCnpj(br.com.intersys.systextil.connection.AppConnection conn,
 int codigoEmpresa,
 int numeroNota,
 String serie,
 int sequencia,
 Cnpj cgc,
 int codigoCancelamento)

getNivelEstrutura

public static String getNivelEstrutura(br.com.intersys.systextil.connection.AppConnection conn,
 int codigoEmpresa,
 int numeroNota,
 String serie)

getDepositoDifZero

public static NotaFiscalDeSaidaItem getDepositoDifZero(br.com.intersys.systextil.connection.AppConnection conn,
 int codigoEmpresa,
 int numeroNota,
 String serie)

exists

public static boolean exists(br.com.intersys.systextil.connection.AppConnection conn,
 int codigoEmpresa,
 int numeroNota,
 String serie,
 String nivel)

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)