CREATE TABLE mov_facturasnominarequest
(
  idu_foliomovto integer NOT NULL,
  clv_rfcempresa character varying(13) NOT NULL,
  num_empleado integer NOT NULL,
  num_empleadogenera integer NOT NULL,
  fec_nomina date NOT NULL,
  arc_xmlnomina text NOT NULL,
  num_paccfdi smallint,
  fec_movto timestamp without time zone NOT NULL,
  CONSTRAINT pk_mov_facturaselectronicasnominarequest_idu_foliomovto PRIMARY KEY (idu_foliomovto ),
  CONSTRAINT fk_mov_facturaselectronicasnominarequest_clv_rfcempresa FOREIGN KEY (clv_rfcempresa)
      REFERENCES cat_empresasnomina (clv_rfc) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_mov_facturaselectronicasnominarequest_num_paccfdi FOREIGN KEY (num_paccfdi)
      REFERENCES cat_paccfdi (idu_paccfdi) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT chk_mov_facturaselectronicasnominarequest_xmlvalido CHECK (btrim(arc_xmlnomina) <> ''::text)
);
ALTER TABLE mov_facturasnominarequest
  OWNER TO sysfacturaelectronicaadmin;
