DELETE from llx_t_cotizacion;
DELETE from llx_t_cotizacion_det;
DELETE from llx_t_fotovehiculo;
DELETE from llx_t_modelos;
DELETE from llx_t_marcas;
DELETE from llx_t_vehiculos;
DELETE from llx_facture;
DELETE from llx_facturedet;
DELETE from llx_product;
DELETE from llx_societe;
INSERT INTO `llx_t_vehiculos` (`idvehiculo`, `nombrecorto`, `marca`, `modelo`, `color`, `linea1`, `linea2`, `tipocombustible`, `cilindraje`, `servicio`, `tipocarroceria`, `potencia`, `numeroserie`, `numeromotor`, `numerochasis`, `aireacondicionado`, `sistemacombustion`, `capacidad`, `propietario`, `observaciones`, `fk_product`, `kilometraje`, `fechaultimomtto`, `tipo`, `transmision`, `direccion`, `cedulapropietario`) VALUES
(1, 'Chevrolet ', '1', ' hatchback', '#46a9ca', NULL, NULL, 'Diesel', '233', 'Particular', NULL, '200HP', '121212', '121212', '12121212', 1, 'Carburado', '5', 'Alexander Pire ', 'Estados Buenos', NULL, 300, '2018-03-14 00:00:00', 'Automovil', 'Mecanica', 'Hidraulica', '12342342342344');
INSERT INTO `llx_product` (`rowid`, `ref`, `entity`, `ref_ext`, `datec`, `tms`, `fk_parent`, `label`, `description`, `note_public`, `note`, `customcode`, `fk_country`, `price`, `price_ttc`, `price_min`, `price_min_ttc`, `price_base_type`, `cost_price`, `default_vat_code`, `tva_tx`, `recuperableonly`, `localtax1_tx`, `localtax1_type`, `localtax2_tx`, `localtax2_type`, `fk_user_author`, `fk_user_modif`, `tosell`, `tobuy`, `onportal`, `tobatch`, `fk_product_type`, `duration`, `seuil_stock_alerte`, `url`, `barcode`, `fk_barcode_type`, `accountancy_code_sell`, `accountancy_code_buy`, `partnumber`, `weight`, `weight_units`, `length`, `length_units`, `width`, `width_units`, `height`, `height_units`, `surface`, `surface_units`, `volume`, `volume_units`, `stock`, `pmp`, `fifo`, `lifo`, `canvas`, `finished`, `hidden`, `import_key`, `model_pdf`, `fk_price_expression`, `desiredstock`, `fk_unit`, `price_autogen`) VALUES
(1, 'srv01', 1, NULL, '2017-10-30 20:05:16', '2017-10-30 19:05:16', 0, 'Servicio 1', '', NULL, '', '', NULL, 23.00000000, 27.83000000, 0.00000000, 0.00000000, 'HT', NULL, NULL, 21.000, 0, 0.000, '0', 0.000, '0', 1, 1, 1, 1, 0, 0, 1, '', NULL, NULL, NULL, NULL, '629', '755', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00000000, NULL, NULL, '', 0, 0, NULL, NULL, NULL, NULL, NULL, 0),
(2, 'prd001', 1, NULL, '2017-10-30 20:20:24', '2017-10-30 19:54:29', 0, 'Producto de Prueba1', '', NULL, '', '', NULL, 45.00000000, 54.45000000, 0.00000000, 0.00000000, 'HT', 11.00000000, NULL, 21.000, 0, 0.000, '0', 0.000, '0', 1, 1, 1, 1, 0, 0, 0, '', NULL, NULL, NULL, NULL, '701', '600', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0.00000000, NULL, NULL, '', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `llx_societe` (`rowid`, `nom`, `name_alias`, `entity`, `ref_ext`, `ref_int`, `statut`, `parent`, `tms`, `datec`, `status`, `code_client`, `code_fournisseur`, `code_compta`, `code_compta_fournisseur`, `address`, `zip`, `town`, `fk_departement`, `fk_pays`, `fk_account`, `phone`, `fax`, `url`, `email`, `skype`, `fk_effectif`, `fk_typent`, `fk_forme_juridique`, `fk_currency`, `siren`, `siret`, `ape`, `idprof4`, `idprof5`, `idprof6`, `tva_intra`, `capital`, `fk_stcomm`, `note_private`, `note_public`, `model_pdf`, `prefix_comm`, `client`, `fournisseur`, `supplier_account`, `fk_prospectlevel`, `fk_incoterms`, `location_incoterms`, `customer_bad`, `customer_rate`, `supplier_rate`, `fk_user_creat`, `fk_user_modif`, `remise_client`, `mode_reglement`, `cond_reglement`, `mode_reglement_supplier`, `cond_reglement_supplier`, `fk_shipping_method`, `tva_assuj`, `localtax1_assuj`, `localtax1_value`, `localtax2_assuj`, `localtax2_value`, `barcode`, `fk_barcode_type`, `price_level`, `outstanding_limit`, `default_lang`, `logo`, `canvas`, `import_key`, `webservices_url`, `webservices_key`, `fk_multicurrency`, `multicurrency_code`) VALUES
(1, 'Cliente1', 'Cliente1', 1, NULL, NULL, 0, NULL, '2017-10-30 19:53:17', '2017-10-30 20:53:17', 1, 'CU1710-0001', NULL, NULL, NULL, '', NULL, NULL, 0, 4, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '', '', '', '', '', '', NULL, 0, NULL, NULL, NULL, NULL, 1, 0, NULL, '', 0, NULL, 0, 0, 0, 1, 1, 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0.000, NULL, 0.000, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'EUR'),
(2, 'Proveedor1', 'proveeor1', 1, NULL, NULL, 0, NULL, '2018-01-10 14:46:27', '2017-10-30 20:53:39', 1, NULL, 'SU1710-0001', NULL, NULL, '', NULL, NULL, 0, 67, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', '', '', '', '', '', '', NULL, 0, NULL, NULL, NULL, NULL, 0, 1, NULL, '', 0, NULL, 0, 0, 0, 1, 1, 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0.000, NULL, 0.000, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '');
INSERT INTO `llx_facture` (`rowid`, `facnumber`, `entity`, `ref_ext`, `ref_int`, `ref_client`, `type`, `increment`, `fk_soc`, `datec`, `datef`, `date_pointoftax`, `date_valid`, `tms`, `paye`, `amount`, `remise_percent`, `remise_absolue`, `remise`, `close_code`, `close_note`, `tva`, `localtax1`, `localtax2`, `revenuestamp`, `total`, `total_ttc`, `fk_statut`, `fk_user_author`, `fk_user_modif`, `fk_user_valid`, `fk_fac_rec_source`, `fk_facture_source`, `fk_projet`, `fk_account`, `fk_currency`, `fk_cond_reglement`, `fk_mode_reglement`, `date_lim_reglement`, `note_private`, `note_public`, `model_pdf`, `fk_incoterms`, `location_incoterms`, `situation_cycle_ref`, `situation_counter`, `situation_final`, `import_key`, `extraparams`, `fk_multicurrency`, `multicurrency_code`, `multicurrency_tx`, `multicurrency_total_ht`, `multicurrency_total_tva`, `multicurrency_total_ttc`, `id_cotizacion`) VALUES
(5, 'FA1710-0001', 1, NULL, NULL, NULL, 0, NULL, 1, '2017-10-31 14:53:00', '2017-10-31', NULL, '2018-01-09', '2018-01-09 14:47:05', 0, 0.00000000, NULL, NULL, 0, NULL, NULL, 9.45000000, 0.00000000, 0.00000000, 0.00000000, 45.00000000, 54.45000000, 1, 1, NULL, 1, NULL, NULL, NULL, 1, NULL, 1, 4, '2017-11-01', NULL, NULL, 'crabe', 0, '', NULL, NULL, 0, NULL, NULL, 1, 'EUR', 1.00000000, 45.00000000, 9.45000000, 54.45000000, NULL),
(6, 'FA1710-0002', 1, NULL, NULL, NULL, 0, NULL, 1, '2017-10-31 17:24:49', '2017-10-31', NULL, '2018-01-10', '2018-01-10 14:37:25', 0, 0.00000000, NULL, NULL, 0, NULL, NULL, 321.30000000, 0.00000000, 0.00000000, 0.00000000, 1530.00000000, 1851.30000000, 1, 1, NULL, 1, NULL, NULL, NULL, 1, NULL, 1, 4, '2017-11-01', NULL, NULL, 'crabe', 0, '', NULL, NULL, 0, NULL, NULL, 1, 'EUR', 1.00000000, 1530.00000000, 321.30000000, 1851.30000000, NULL),
(7, 'FA1801-0004', 1, NULL, NULL, NULL, 0, NULL, 1, '2018-01-10 15:41:35', '2018-01-10', NULL, '2018-04-02', '2018-04-02 12:16:31', 0, 0.00000000, NULL, NULL, 0, NULL, NULL, 0.00000000, 0.00000000, 0.00000000, 0.00000000, 180.00000000, 180.00000000, 1, 1, NULL, 1, NULL, NULL, NULL, 1, NULL, 1, 7, '2018-01-11', NULL, NULL, 'crabe', 0, '', NULL, NULL, 0, NULL, NULL, 0, 'CLP', 1.00000000, 180.00000000, 0.00000000, 180.00000000, NULL),
(8, 'FA1801-0003', 1, NULL, NULL, NULL, 0, NULL, 1, '2018-01-10 15:43:43', '2018-01-10', NULL, '2018-01-10', '2018-01-10 14:44:23', 0, 0.00000000, NULL, NULL, 0, NULL, NULL, 285000.00000000, 0.00000000, 0.00000000, 0.00000000, 1500000.00000000, 1785000.00000000, 1, 1, NULL, 1, NULL, NULL, NULL, 1, NULL, 1, 7, '2018-01-11', NULL, NULL, 'crabe', 0, '', NULL, NULL, 0, NULL, NULL, 0, 'CLP', 1.00000000, 1500000.00000000, 285000.00000000, 1785000.00000000, NULL),
(9, 'FA1804-0005', 1, NULL, NULL, NULL, 0, NULL, 1, '2018-04-02 09:41:42', '2018-04-02', NULL, '2018-04-02', '2018-04-02 13:41:42', 0, 0.00000000, NULL, NULL, 0, NULL, NULL, 28.35000000, 0.00000000, 0.00000000, 0.00000000, 135.00000000, 163.35000000, 1, 1, NULL, 1, NULL, NULL, NULL, 1, NULL, 2, 4, '2018-05-02', NULL, 'Orden de Taller Nro - 2', 'crabe', 0, '', NULL, NULL, 0, NULL, NULL, 0, 'CLP', 1.00000000, 135.00000000, 28.35000000, 163.35000000, 2);
INSERT INTO `llx_facturedet` (`rowid`, `fk_facture`, `fk_parent_line`, `fk_product`, `label`, `description`, `vat_src_code`, `tva_tx`, `localtax1_tx`, `localtax1_type`, `localtax2_tx`, `localtax2_type`, `qty`, `remise_percent`, `remise`, `fk_remise_except`, `subprice`, `price`, `total_ht`, `total_tva`, `total_localtax1`, `total_localtax2`, `total_ttc`, `product_type`, `date_start`, `date_end`, `info_bits`, `buy_price_ht`, `fk_product_fournisseur_price`, `fk_code_ventilation`, `special_code`, `rang`, `fk_contract_line`, `import_key`, `situation_percent`, `fk_prev_id`, `fk_unit`, `fk_user_author`, `fk_user_modif`, `fk_multicurrency`, `multicurrency_code`, `multicurrency_subprice`, `multicurrency_total_ht`, `multicurrency_total_tva`, `multicurrency_total_ttc`) VALUES
(1, 5, NULL, 2, NULL, '', '', 21.000, 0.000, '3', 0.000, '5', 1, 0, 0, NULL, 45.00000000, NULL, 45.00000000, 9.45000000, 0.00000000, 0.00000000, 54.45000000, 0, NULL, NULL, 0, 11.00000000, NULL, 0, 0, 1, NULL, NULL, 100, NULL, NULL, 1, 1, 1, 'EUR', 45.00000000, 45.00000000, 9.45000000, 54.45000000),
(2, 6, NULL, 2, NULL, '', '', 21.000, 0.000, '3', 0.000, '5', 34, 0, 0, NULL, 45.00000000, NULL, 1530.00000000, 321.30000000, 0.00000000, 0.00000000, 1851.30000000, 0, NULL, NULL, 0, 11.00000000, NULL, 0, 0, 1, NULL, NULL, 100, NULL, NULL, 1, 1, 1, 'EUR', 45.00000000, 1530.00000000, 321.30000000, 1851.30000000),
(3, 8, NULL, NULL, NULL, 'ejemplo', '', 19.000, 0.000, '0', 0.000, '0', 1, 0, 0, NULL, 1500000.00000000, NULL, 1500000.00000000, 285000.00000000, 0.00000000, 0.00000000, 1785000.00000000, 0, NULL, NULL, 0, 0.00000000, NULL, 0, 0, 1, NULL, NULL, 100, NULL, NULL, 1, 1, 0, 'CLP', 1500000.00000000, 1500000.00000000, 285000.00000000, 1785000.00000000),
(4, 7, NULL, 2, NULL, '', '', 0.000, 0.000, '0', 0.000, '0', 4, 0, 0, NULL, 45.00000000, NULL, 180.00000000, 0.00000000, 0.00000000, 0.00000000, 180.00000000, 0, NULL, NULL, 0, 11.00000000, NULL, 0, 0, 1, NULL, NULL, 100, NULL, NULL, 1, 1, 0, 'CLP', 45.00000000, 180.00000000, 0.00000000, 180.00000000),
(5, 9, NULL, 2, NULL, '', '', 21.000, 0.000, '0', 0.000, '0', 3, 0, 0, NULL, 45.00000000, NULL, 135.00000000, 28.35000000, 0.00000000, 0.00000000, 163.35000000, 0, NULL, NULL, 0, 0.00000000, NULL, 0, 0, 0, NULL, NULL, 100, NULL, NULL, 1, 1, 0, 'CLP', 45.00000000, 135.00000000, 28.35000000, 163.35000000);