-- Distribuidora RIGA - Control de devoluciones fisicas por Nota de Credito
-- Seguro para ejecutar varias veces.
CREATE TABLE IF NOT EXISTS llx_despacho_nc_devolucion (
  rowid BIGINT NOT NULL AUTO_INCREMENT,
  entity INT NOT NULL DEFAULT 1,
  fk_facture_nc INT NOT NULL,
  ref_nc VARCHAR(30) NOT NULL,
  fk_facturedet_nc INT NOT NULL,
  fk_facture_source INT NOT NULL,
  fk_commande_source INT DEFAULT NULL,
  fk_product INT NOT NULL,
  fk_entrepot INT NOT NULL DEFAULT 4,
  qty DECIMAL(24,8) NOT NULL,
  fk_user_author INT DEFAULT NULL,
  user_name VARCHAR(255) DEFAULT NULL,
  datec DATETIME NOT NULL,
  fk_stock_mouvement INT DEFAULT NULL,
  fk_despacho_nuevo INT DEFAULT NULL,
  PRIMARY KEY (rowid),
  KEY idx_nc (fk_facture_nc),
  KEY idx_ncline (fk_facturedet_nc),
  KEY idx_source_product (fk_commande_source, fk_product),
  KEY idx_product (fk_product)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;