CREATE TABLE stock_picking
(
  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
  address_id integer, -- Address
  date_done timestamp without time zone, -- Date Done
  min_date timestamp without time zone, -- Expected Date
  date timestamp without time zone, -- Order Date
  location_id integer, -- Location
  stock_journal_id integer, -- Stock Journal
  backorder_id integer, -- Back Order of
  partner_id integer, -- Partner
  name character varying(64), -- Reference
  auto_picking boolean, -- Auto-Picking
  move_type character varying NOT NULL, -- Delivery Method
  company_id integer NOT NULL, -- Company
  invoice_state character varying NOT NULL, -- Invoice Control
  note text, -- Notes
  state character varying, -- State
  location_dest_id integer, -- Dest. Location
  max_date timestamp without time zone, -- Max. Expected Date
  type character varying NOT NULL, -- Shipping Type
  purchase_id integer, -- Purchase Order
  sale_id integer, -- Sales Order
  vacuna_id integer, -- ID Orden vacunación
  receta_id integer, -- ID Receta
  secuencia_bodega_id integer, -- Programa Nacional de Salud
  programa_id integer, -- Programa Nacional
  tiene_programa boolean, -- Programa
  nro_factura character varying(50), -- Factura
  encargado_egreso boolean, -- Es Encargado
  encargado boolean, -- Es Encargado
  global_loc_dest_id integer, -- Dest. global
  global_loc_id integer, -- Origen global
  estado_impreso character varying, -- unknown
  trans_intercompany boolean, -- Intercompañias
  nombre_recibi character varying(100), -- Nombre
  cargo_recibi character varying(100), -- Cargo
  document_type character varying, -- Tipo de documento
  cedula_recibi character varying(14), -- Cedula
  user_recibe integer, -- Valida recepción
  aprobacion_origen boolean, -- Aprobación origen de inventarios
  aprobacion_destino boolean, -- Aprobación destino de inventarios
  prescripcion_id integer, -- ID Prescripción dispositivos
  paciente_id integer, -- Paciente
  descargo_contra_paciente boolean, -- Descargar contra paciente
  nro_comprobante character varying(256),
  referencia character varying(64), -- Nro de Referencia
  global_loc_id_usr integer, -- Origen global
  global_loc_dest_id_usr integer, -- Dest. global
  motivo_cancelacion text, -- Motivo de la Cancelación
  fecha_validacion timestamp without time zone, -- Fecha de validación
  user_id integer, -- Guarda Almacen
  codigo_receta integer, -- Código receta
  CONSTRAINT stock_picking_pkey PRIMARY KEY (id),
  CONSTRAINT stock_picking_address_id_fkey FOREIGN KEY (address_id)
      REFERENCES res_partner_address (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_backorder_id_fkey FOREIGN KEY (backorder_id)
      REFERENCES stock_picking (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_company_id_fkey FOREIGN KEY (company_id)
      REFERENCES res_company (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_create_uid_fkey FOREIGN KEY (create_uid)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_global_loc_dest_id_fkey FOREIGN KEY (global_loc_dest_id)
      REFERENCES stock_location (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_global_loc_dest_id_usr_fkey FOREIGN KEY (global_loc_dest_id_usr)
      REFERENCES stock_location (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_global_loc_id_fkey FOREIGN KEY (global_loc_id)
      REFERENCES stock_location (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_global_loc_id_usr_fkey FOREIGN KEY (global_loc_id_usr)
      REFERENCES stock_location (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_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_picking_location_id_fkey FOREIGN KEY (location_id)
      REFERENCES stock_location (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_paciente_id_fkey FOREIGN KEY (paciente_id)
      REFERENCES res_partner (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_prescripcion_id_fkey FOREIGN KEY (prescripcion_id)
      REFERENCES sgi_prescripcion_dispositivos (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_programa_id_fkey FOREIGN KEY (programa_id)
      REFERENCES sgi_programa_nacional (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_purchase_id_fkey FOREIGN KEY (purchase_id)
      REFERENCES purchase_order (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_receta_id_fkey FOREIGN KEY (receta_id)
      REFERENCES sgi_receta (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_sale_id_fkey FOREIGN KEY (sale_id)
      REFERENCES sale_order (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_secuencia_bodega_id_fkey FOREIGN KEY (secuencia_bodega_id)
      REFERENCES sgi_bodegas_secuencias (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_stock_journal_id_fkey FOREIGN KEY (stock_journal_id)
      REFERENCES stock_journal (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_user_id_fkey FOREIGN KEY (user_id)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_user_recibe_fkey FOREIGN KEY (user_recibe)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_vacuna_id_fkey FOREIGN KEY (vacuna_id)
      REFERENCES sgi_vacuna (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_write_uid_fkey FOREIGN KEY (write_uid)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_picking_name_uniq UNIQUE (name, company_id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE stock_picking
  OWNER TO openerp;
GRANT ALL ON TABLE stock_picking TO openerp;
GRANT SELECT ON TABLE stock_picking TO esb_msp;
GRANT SELECT, UPDATE ON TABLE stock_picking TO lectura;
GRANT SELECT ON TABLE stock_picking TO consulta;
GRANT ALL ON TABLE stock_picking TO inven_lectu;
GRANT SELECT ON TABLE stock_picking TO "wladimir.quijije";
GRANT SELECT ON TABLE stock_picking TO "diego.molina";
GRANT SELECT ON TABLE stock_picking TO "fausto.suarez";
COMMENT ON TABLE stock_picking
  IS 'Picking List';
COMMENT ON COLUMN stock_picking.origin IS 'Origin';
COMMENT ON COLUMN stock_picking.address_id IS 'Address';
COMMENT ON COLUMN stock_picking.date_done IS 'Date Done';
COMMENT ON COLUMN stock_picking.min_date IS 'Expected Date';
COMMENT ON COLUMN stock_picking.date IS 'Order Date';
COMMENT ON COLUMN stock_picking.location_id IS 'Location';
COMMENT ON COLUMN stock_picking.stock_journal_id IS 'Stock Journal';
COMMENT ON COLUMN stock_picking.backorder_id IS 'Back Order of';
COMMENT ON COLUMN stock_picking.partner_id IS 'Partner';
COMMENT ON COLUMN stock_picking.name IS 'Reference';
COMMENT ON COLUMN stock_picking.auto_picking IS 'Auto-Picking';
COMMENT ON COLUMN stock_picking.move_type IS 'Delivery Method';
COMMENT ON COLUMN stock_picking.company_id IS 'Company';
COMMENT ON COLUMN stock_picking.invoice_state IS 'Invoice Control';
COMMENT ON COLUMN stock_picking.note IS 'Notes';
COMMENT ON COLUMN stock_picking.state IS 'State';
COMMENT ON COLUMN stock_picking.location_dest_id IS 'Dest. Location';
COMMENT ON COLUMN stock_picking.max_date IS 'Max. Expected Date';
COMMENT ON COLUMN stock_picking.type IS 'Shipping Type';
COMMENT ON COLUMN stock_picking.purchase_id IS 'Purchase Order';
COMMENT ON COLUMN stock_picking.sale_id IS 'Sales Order';
COMMENT ON COLUMN stock_picking.vacuna_id IS 'ID Orden vacunación';
COMMENT ON COLUMN stock_picking.receta_id IS 'ID Receta';
COMMENT ON COLUMN stock_picking.secuencia_bodega_id IS 'Programa Nacional de Salud';
COMMENT ON COLUMN stock_picking.programa_id IS 'Programa Nacional';
COMMENT ON COLUMN stock_picking.tiene_programa IS 'Programa';
COMMENT ON COLUMN stock_picking.nro_factura IS 'Factura';
COMMENT ON COLUMN stock_picking.encargado_egreso IS 'Es Encargado';
COMMENT ON COLUMN stock_picking.encargado IS 'Es Encargado';
COMMENT ON COLUMN stock_picking.global_loc_dest_id IS 'Dest. global';
COMMENT ON COLUMN stock_picking.global_loc_id IS 'Origen global';
COMMENT ON COLUMN stock_picking.estado_impreso IS 'unknown';
COMMENT ON COLUMN stock_picking.trans_intercompany IS 'Intercompañias';
COMMENT ON COLUMN stock_picking.nombre_recibi IS 'Nombre';
COMMENT ON COLUMN stock_picking.cargo_recibi IS 'Cargo';
COMMENT ON COLUMN stock_picking.document_type IS 'Tipo de documento';
COMMENT ON COLUMN stock_picking.cedula_recibi IS 'Cedula';
COMMENT ON COLUMN stock_picking.user_recibe IS 'Valida recepción';
COMMENT ON COLUMN stock_picking.aprobacion_origen IS 'Aprobación origen de inventarios';
COMMENT ON COLUMN stock_picking.aprobacion_destino IS 'Aprobación destino de inventarios';
COMMENT ON COLUMN stock_picking.prescripcion_id IS 'ID Prescripción dispositivos';
COMMENT ON COLUMN stock_picking.paciente_id IS 'Paciente';
COMMENT ON COLUMN stock_picking.descargo_contra_paciente IS 'Descargar contra paciente';
COMMENT ON COLUMN stock_picking.referencia IS 'Nro de Referencia';
COMMENT ON COLUMN stock_picking.global_loc_id_usr IS 'Origen global';
COMMENT ON COLUMN stock_picking.global_loc_dest_id_usr IS 'Dest. global';
COMMENT ON COLUMN stock_picking.motivo_cancelacion IS 'Motivo de la Cancelación';
COMMENT ON COLUMN stock_picking.fecha_validacion IS 'Fecha de validación';
COMMENT ON COLUMN stock_picking.user_id IS 'Guarda Almacen';
COMMENT ON COLUMN stock_picking.codigo_receta IS 'Código receta';


-- Index: stock_picking_backorder_id_index

-- DROP INDEX stock_picking_backorder_id_index;

CREATE INDEX stock_picking_backorder_id_index
  ON stock_picking
  USING btree
  (backorder_id);

-- Index: stock_picking_company_id_index

-- DROP INDEX stock_picking_company_id_index;

CREATE INDEX stock_picking_company_id_index
  ON stock_picking
  USING btree
  (company_id);

-- Index: stock_picking_date_index

-- DROP INDEX stock_picking_date_index;

CREATE INDEX stock_picking_date_index
  ON stock_picking
  USING btree
  (date);

-- Index: stock_picking_invoice_state_index

-- DROP INDEX stock_picking_invoice_state_index;

CREATE INDEX stock_picking_invoice_state_index
  ON stock_picking
  USING btree
  (invoice_state COLLATE pg_catalog."default");

-- Index: stock_picking_location_dest_id_index

-- DROP INDEX stock_picking_location_dest_id_index;

CREATE INDEX stock_picking_location_dest_id_index
  ON stock_picking
  USING btree
  (location_dest_id);

-- Index: stock_picking_location_id_index

-- DROP INDEX stock_picking_location_id_index;

CREATE INDEX stock_picking_location_id_index
  ON stock_picking
  USING btree
  (location_id);

-- Index: stock_picking_max_date_index

-- DROP INDEX stock_picking_max_date_index;

CREATE INDEX stock_picking_max_date_index
  ON stock_picking
  USING btree
  (max_date);

-- Index: stock_picking_min_date_index

-- DROP INDEX stock_picking_min_date_index;

CREATE INDEX stock_picking_min_date_index
  ON stock_picking
  USING btree
  (min_date);

-- Index: stock_picking_name_index

-- DROP INDEX stock_picking_name_index;

CREATE INDEX stock_picking_name_index
  ON stock_picking
  USING btree
  (name COLLATE pg_catalog."default");

-- Index: stock_picking_origin_index

-- DROP INDEX stock_picking_origin_index;

CREATE INDEX stock_picking_origin_index
  ON stock_picking
  USING btree
  (origin COLLATE pg_catalog."default");

-- Index: stock_picking_purchase_id_index

-- DROP INDEX stock_picking_purchase_id_index;

CREATE INDEX stock_picking_purchase_id_index
  ON stock_picking
  USING btree
  (purchase_id);

-- Index: stock_picking_sale_id_index

-- DROP INDEX stock_picking_sale_id_index;

CREATE INDEX stock_picking_sale_id_index
  ON stock_picking
  USING btree
  (sale_id);

-- Index: stock_picking_state_index

-- DROP INDEX stock_picking_state_index;

CREATE INDEX stock_picking_state_index
  ON stock_picking
  USING btree
  (state COLLATE pg_catalog."default");

-- Index: stock_picking_stock_journal_id_index

-- DROP INDEX stock_picking_stock_journal_id_index;

CREATE INDEX stock_picking_stock_journal_id_index
  ON stock_picking
  USING btree
  (stock_journal_id);

-- Index: stock_picking_type_index

-- DROP INDEX stock_picking_type_index;

CREATE INDEX stock_picking_type_index
  ON stock_picking
  USING btree
  (type COLLATE pg_catalog."default");

-- Index: "índice_id"

-- DROP INDEX "índice_id";

CREATE UNIQUE INDEX "índice_id"
  ON stock_picking
  USING btree
  (id);


-- Trigger: tgg_spubicaciondestino_mov on stock_picking

-- DROP TRIGGER tgg_spubicaciondestino_mov ON stock_picking;

CREATE TRIGGER tgg_spubicaciondestino_mov
  AFTER UPDATE
  ON stock_picking
  FOR EACH ROW
  EXECUTE PROCEDURE tgg_spubicaciondestino_mov();
ALTER TABLE stock_picking DISABLE TRIGGER tgg_spubicaciondestino_mov;