CREATE TABLE public.ent_aux_porte_participante
( 
  terminal_ip character varying(20) NOT NULL,
  filial integer NOT NULL,
  fornecedor_cliente character varying(1) NOT NULL,  
  cpf character varying(14) NOT NULL,
  cnpj character varying(16) NOT NULL,
  nome character varying NOT NULL,
  ie character varying(20) NOT NULL,
  im character varying(20) NOT NULL,
  fat_endereco character varying(100) NOT NULL,
  fat_numero integer NOT NULL,
  fat_bairro character varying(80) NOT NULL,
  fat_complemento character varying(50) NOT NULL,
  fat_uf character varying(2) NOT NULL,
  fat_codigo_uf_ibge integer NOT NULL,
  fat_cidade character varying(50) NOT NULL,
  fat_codigo_municipio_ibge integer NOT NULL,
  fat_pais character varying(50) NOT NULL,
  fat_cod_pais_ibge integer NOT NULL,
  fat_cep character varying(8) NOT NULL,
  fat_fone character varying(20) NOT NULL,

  ent_endereco character varying(100) NOT NULL,
  ent_numero integer NOT NULL,
  ent_bairro character varying(80) NOT NULL,
  ent_complemento character varying(50) NOT NULL,
  ent_uf character varying(2) NOT NULL,
  ent_codigo_uf_ibge integer NOT NULL,
  ent_cidade character varying(50) NOT NULL,
  ent_codigo_municipio_ibge integer NOT NULL,
  ent_pais character varying(50) NOT NULL,
  ent_cod_pais_ibge integer NOT NULL,
  ent_cep character varying(8) NOT NULL,
  ent_fone character varying(20) NOT NULL,

  importa_sn character varying(1) NOT NULL,
  CONSTRAINT pk_ent_aux_porte_participante PRIMARY KEY (terminal_ip, filial, fornecedor_cliente, cpf, cnpj, ie)
  
      
)
WITH (
  OIDS=FALSE
);

ALTER TABLE public.ent_aux_porte_participante
  OWNER TO postgres;

COMMENT ON TABLE public.ent_aux_porte_participante
  IS 'Auxiliar para Porte de cliente/fornecedor';


CREATE TABLE public.ent_aux_porte_produto
( 
  terminal_ip character varying(20) NOT NULL,
  filial integer NOT NULL,
  fornecedor_cliente character varying(1) NOT NULL,
  cpf character varying(14) NOT NULL,
  cnpj character varying(16) NOT NULL,
  ie character varying(20) NOT NULL,
  codigo character varying NOT NULL,
  codigo_barras character varying NOT NULL,
  descricao character varying NOT NULL,
  unidade character varying NOT NULL,
  valor numeric(18, 6) NOT NULL,
  classif_fiscal character varying NOT NULL,

  cst_icms integer NOT NULL,
  faixa_icms integer NOT NULL,

  cst_pis integer NOT NULL,
  aliq_pis numeric(18, 6) NOT NULL,

  cst_cofins integer NOT NULL,
  aliq_cofins numeric(18, 6) NOT NULL,

  cst_ipi integer NOT NULL,
  aliq_ipi numeric(18, 6) NOT NULL,
  
  importa_sn character varying(1) NOT NULL,
  CONSTRAINT pk_ent_aux_porte_produto PRIMARY KEY (terminal_ip, filial, fornecedor_cliente, cpf, cnpj, codigo, ie)
  
      
)
WITH (
  OIDS=FALSE
);

ALTER TABLE public.ent_aux_porte_participante
  OWNER TO postgres;

COMMENT ON TABLE public.ent_aux_porte_participante
  IS 'Auxiliar para Porte de produtos';