-- Table: ctb_aux_sped_pis_cofins

DROP TABLE ctb_aux_sped_pis_cofins;

CREATE TABLE ctb_aux_sped_pis_cofins
(
  terminal_ip integer NOT NULL,
  usuario integer NOT NULL,
  filial integer NOT NULL,
  data_inicial date NOT NULL,
  data_final date NOT NULL,
  contador integer NOT NULL,
  tipo_escrituracao integer NOT NULL,
  indicador_situacao_especial character varying NOT NULL,
  ind_escri character varying NOT NULL,
  numero_recibo_anterior character varying NOT NULL,
  ind_nat_pj character varying NOT NULL,
  ind_ativ character varying NOT NULL,
  regime_apuracao character varying NOT NULL,
  ind_reg_cum character varying NOT NULL,
  ind_oper character varying NOT NULL,
  nat_bc_cred character varying NOT NULL,
  ind_nat_rec character varying NOT NULL,
  somente_direito_credito character varying(1) NOT NULL,
  demais_documentos character varying NOT NULL,
  
  CONSTRAINT pk_ctb_aux_sped_pis_cofins PRIMARY KEY (terminal_ip)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE ctb_aux_sped_pis_cofins
  OWNER TO postgres;