CREATE TABLE stock_move
(
  id serial NOT NULL,
  create_uid integer,
  create_date timestamp without time zone,
  write_date timestamp without time zone,
  write_uid integer,
  origin character varying(64), -- Origin
  product_uos_qty numeric, -- Quantity (UOS)
  address_id integer, -- Destination Address
  product_uom integer NOT NULL, -- Unit of Measure
  price_unit numeric, -- Unit Price
  date_expected timestamp without time zone NOT NULL, -- Scheduled Date
  date timestamp without time zone NOT NULL, -- Date
  prodlot_id integer, -- Production Lot
  move_dest_id integer, -- Destination Move
  product_qty numeric NOT NULL, -- Quantity
  product_uos integer, -- Product UOS
  location_id integer NOT NULL, -- Source Location
  name character varying(250) NOT NULL, -- Name
  note text, -- Notes
  product_id integer NOT NULL, -- Product
  auto_validate boolean, -- Auto Validate
  price_currency_id integer, -- Currency for average price
  partner_id integer, -- Partner
  company_id integer NOT NULL, -- Company
  picking_id integer, -- Reference
  priority character varying, -- Priority
  state character varying, -- State
  location_dest_id integer NOT NULL, -- Destination Location
  tracking_id integer, -- Pack
  product_packaging integer, -- Packaging
  purchase_line_id integer, -- Purchase Order Line
  sale_line_id integer, -- Sales Order Line
  linea_vacuna_id integer, -- Línea de vacuna
  linea_receta_id integer, -- Línea de receta
  discount double precision, -- Descuento (%)
  trans_intercompany boolean, -- Intercompañias
  precio_unitario_lote numeric, -- Precio unitario
  linea_prescripcion_id integer, -- Línea de prescripcion de dispositivos
  type_rp character varying, -- Tipo RP
  fecha_caducidad_usr timestamp without time zone, -- Fecha Caducidad del lote
  caducidad character varying, -- Caducidad
  fecha_caducidad timestamp without time zone, -- Fecha Caducidad del lote
  precio_unitario_lote_usr numeric, -- Precio unitario
  edicion character varying, -- Edicion
  CONSTRAINT stock_move_pkey PRIMARY KEY (id),
  CONSTRAINT stock_move_address_id_fkey FOREIGN KEY (address_id)
      REFERENCES res_partner_address (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_company_id_fkey FOREIGN KEY (company_id)
      REFERENCES res_company (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_create_uid_fkey FOREIGN KEY (create_uid)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_linea_prescripcion_id_fkey FOREIGN KEY (linea_prescripcion_id)
      REFERENCES sgi_lineas_prescripcion (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_linea_receta_id_fkey FOREIGN KEY (linea_receta_id)
      REFERENCES sgi_lineas_receta (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_linea_vacuna_id_fkey FOREIGN KEY (linea_vacuna_id)
      REFERENCES sgi_lineas_vacuna (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_location_dest_id_fkey FOREIGN KEY (location_dest_id)
      REFERENCES stock_location (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_location_id_fkey FOREIGN KEY (location_id)
      REFERENCES stock_location (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_move_dest_id_fkey FOREIGN KEY (move_dest_id)
      REFERENCES stock_move (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_picking_id_fkey FOREIGN KEY (picking_id)
      REFERENCES stock_picking (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_price_currency_id_fkey FOREIGN KEY (price_currency_id)
      REFERENCES res_currency (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_prodlot_id_fkey FOREIGN KEY (prodlot_id)
      REFERENCES stock_production_lot (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_product_id_fkey FOREIGN KEY (product_id)
      REFERENCES product_product (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_product_packaging_fkey FOREIGN KEY (product_packaging)
      REFERENCES product_packaging (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_product_uom_fkey FOREIGN KEY (product_uom)
      REFERENCES product_uom (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_product_uos_fkey FOREIGN KEY (product_uos)
      REFERENCES product_uom (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_purchase_line_id_fkey FOREIGN KEY (purchase_line_id)
      REFERENCES purchase_order_line (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_sale_line_id_fkey FOREIGN KEY (sale_line_id)
      REFERENCES sale_order_line (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_tracking_id_fkey FOREIGN KEY (tracking_id)
      REFERENCES stock_tracking (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_move_write_uid_fkey FOREIGN KEY (write_uid)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL
)
WITH (
  OIDS=FALSE
);
ALTER TABLE stock_move
  OWNER TO openerp;
GRANT ALL ON TABLE stock_move TO openerp;
GRANT SELECT ON TABLE stock_move TO esb_msp;
GRANT SELECT, UPDATE ON TABLE stock_move TO lectura;
GRANT SELECT ON TABLE stock_move TO consulta;
GRANT ALL ON TABLE stock_move TO inven_lectu;
GRANT SELECT ON TABLE stock_move TO "wladimir.quijije";
GRANT SELECT ON TABLE stock_move TO "diego.molina";
GRANT SELECT ON TABLE stock_move TO "fausto.suarez";
COMMENT ON TABLE stock_move
  IS 'Stock Move';
COMMENT ON COLUMN stock_move.origin IS 'Origin';
COMMENT ON COLUMN stock_move.product_uos_qty IS 'Quantity (UOS)';
COMMENT ON COLUMN stock_move.address_id IS 'Destination Address ';
COMMENT ON COLUMN stock_move.product_uom IS 'Unit of Measure';
COMMENT ON COLUMN stock_move.price_unit IS 'Unit Price';
COMMENT ON COLUMN stock_move.date_expected IS 'Scheduled Date';
COMMENT ON COLUMN stock_move.date IS 'Date';
COMMENT ON COLUMN stock_move.prodlot_id IS 'Production Lot';
COMMENT ON COLUMN stock_move.move_dest_id IS 'Destination Move';
COMMENT ON COLUMN stock_move.product_qty IS 'Quantity';
COMMENT ON COLUMN stock_move.product_uos IS 'Product UOS';
COMMENT ON COLUMN stock_move.location_id IS 'Source Location';
COMMENT ON COLUMN stock_move.name IS 'Name';
COMMENT ON COLUMN stock_move.note IS 'Notes';
COMMENT ON COLUMN stock_move.product_id IS 'Product';
COMMENT ON COLUMN stock_move.auto_validate IS 'Auto Validate';
COMMENT ON COLUMN stock_move.price_currency_id IS 'Currency for average price';
COMMENT ON COLUMN stock_move.partner_id IS 'Partner';
COMMENT ON COLUMN stock_move.company_id IS 'Company';
COMMENT ON COLUMN stock_move.picking_id IS 'Reference';
COMMENT ON COLUMN stock_move.priority IS 'Priority';
COMMENT ON COLUMN stock_move.state IS 'State';
COMMENT ON COLUMN stock_move.location_dest_id IS 'Destination Location';
COMMENT ON COLUMN stock_move.tracking_id IS 'Pack';
COMMENT ON COLUMN stock_move.product_packaging IS 'Packaging';
COMMENT ON COLUMN stock_move.purchase_line_id IS 'Purchase Order Line';
COMMENT ON COLUMN stock_move.sale_line_id IS 'Sales Order Line';
COMMENT ON COLUMN stock_move.linea_vacuna_id IS 'Línea de vacuna';
COMMENT ON COLUMN stock_move.linea_receta_id IS 'Línea de receta';
COMMENT ON COLUMN stock_move.discount IS 'Descuento (%)';
COMMENT ON COLUMN stock_move.trans_intercompany IS 'Intercompañias';
COMMENT ON COLUMN stock_move.precio_unitario_lote IS 'Precio unitario';
COMMENT ON COLUMN stock_move.linea_prescripcion_id IS 'Línea de prescripcion de dispositivos';
COMMENT ON COLUMN stock_move.type_rp IS 'Tipo RP';
COMMENT ON COLUMN stock_move.fecha_caducidad_usr IS 'Fecha Caducidad del lote';
COMMENT ON COLUMN stock_move.caducidad IS 'Caducidad';
COMMENT ON COLUMN stock_move.fecha_caducidad IS 'Fecha Caducidad del lote';
COMMENT ON COLUMN stock_move.precio_unitario_lote_usr IS 'Precio unitario';
COMMENT ON COLUMN stock_move.edicion IS 'Edicion';


-- Index: sgi_product

-- DROP INDEX sgi_product;

CREATE INDEX sgi_product
  ON stock_move
  USING btree
  (product_qty);

-- Index: sgi_product_uom

-- DROP INDEX sgi_product_uom;

CREATE INDEX sgi_product_uom
  ON stock_move
  USING btree
  (product_uom);

-- Index: sgi_state

-- DROP INDEX sgi_state;

CREATE INDEX sgi_state
  ON stock_move
  USING btree
  (state COLLATE pg_catalog."default");

-- Index: stock_move_company_id_index

-- DROP INDEX stock_move_company_id_index;

CREATE INDEX stock_move_company_id_index
  ON stock_move
  USING btree
  (company_id);

-- Index: stock_move_date_expected_index

-- DROP INDEX stock_move_date_expected_index;

CREATE INDEX stock_move_date_expected_index
  ON stock_move
  USING btree
  (date_expected);

-- Index: stock_move_date_index

-- DROP INDEX stock_move_date_index;

CREATE INDEX stock_move_date_index
  ON stock_move
  USING btree
  (date);

-- Index: stock_move_id_idx

-- DROP INDEX stock_move_id_idx;

CREATE INDEX stock_move_id_idx
  ON stock_move
  USING btree
  (id);

-- Index: stock_move_location_dest_id_index

-- DROP INDEX stock_move_location_dest_id_index;

CREATE INDEX stock_move_location_dest_id_index
  ON stock_move
  USING btree
  (location_dest_id);

-- Index: stock_move_location_id_index

-- DROP INDEX stock_move_location_id_index;

CREATE INDEX stock_move_location_id_index
  ON stock_move
  USING btree
  (location_id);

-- Index: stock_move_location_id_location_dest_id_product_id_state

-- DROP INDEX stock_move_location_id_location_dest_id_product_id_state;

CREATE INDEX stock_move_location_id_location_dest_id_product_id_state
  ON stock_move
  USING btree
  (product_id, state COLLATE pg_catalog."default", location_id, location_dest_id);

-- Index: stock_move_move_dest_id_index

-- DROP INDEX stock_move_move_dest_id_index;

CREATE INDEX stock_move_move_dest_id_index
  ON stock_move
  USING btree
  (move_dest_id);

-- Index: stock_move_name_index

-- DROP INDEX stock_move_name_index;

CREATE INDEX stock_move_name_index
  ON stock_move
  USING btree
  (name COLLATE pg_catalog."default");

-- Index: stock_move_partner_id_index

-- DROP INDEX stock_move_partner_id_index;

CREATE INDEX stock_move_partner_id_index
  ON stock_move
  USING btree
  (partner_id);

-- Index: stock_move_picking_id_index

-- DROP INDEX stock_move_picking_id_index;

CREATE INDEX stock_move_picking_id_index
  ON stock_move
  USING btree
  (picking_id);

-- Index: stock_move_prodlot_id_index

-- DROP INDEX stock_move_prodlot_id_index;

CREATE INDEX stock_move_prodlot_id_index
  ON stock_move
  USING btree
  (prodlot_id);

-- Index: stock_move_product_id_index

-- DROP INDEX stock_move_product_id_index;

CREATE INDEX stock_move_product_id_index
  ON stock_move
  USING btree
  (product_id);

-- Index: stock_move_purchase_line_id_index

-- DROP INDEX stock_move_purchase_line_id_index;

CREATE INDEX stock_move_purchase_line_id_index
  ON stock_move
  USING btree
  (purchase_line_id);

-- Index: stock_move_sale_line_id_index

-- DROP INDEX stock_move_sale_line_id_index;

CREATE INDEX stock_move_sale_line_id_index
  ON stock_move
  USING btree
  (sale_line_id);

-- Index: stock_move_state_index

-- DROP INDEX stock_move_state_index;

CREATE INDEX stock_move_state_index
  ON stock_move
  USING btree
  (state COLLATE pg_catalog."default");

-- Index: stock_move_tracking_id_index

-- DROP INDEX stock_move_tracking_id_index;

CREATE INDEX stock_move_tracking_id_index
  ON stock_move
  USING btree
  (tracking_id);