1-- ===================================================================
2-- Copyright (C) 2003		Rodolphe Quiedeville	<rodolphe@quiedeville.org>
3-- Copyright (C) 2009-2014	Laurent Destailleur		<eldy@users.sourceforge.net>
4-- Copyright (C) 2010		Juanjo Menent			<jmenent@2byte.es>
5-- Copyright (C) 2010-2012	Regis Houssin			<regis.houssin@inodbox.com>
6-- Copyright (C) 2012		Cédric Salvador			<csalvador@gpcsolutions.fr>
7-- Copyright (C) 2016-2018	Charlene Benke			<charlie@patas-monkey.com>
8--
9-- This program is free software; you can redistribute it and/or modify
10-- it under the terms of the GNU General Public License as published by
11-- the Free Software Foundation; either version 3 of the License, or
12-- (at your option) any later version.
13--
14-- This program is distributed in the hope that it will be useful,
15-- but WITHOUT ANY WARRANTY; without even the implied warranty of
16-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
17-- GNU General Public License for more details.
18--
19-- You should have received a copy of the GNU General Public License
20-- along with this program. If not, see <https://www.gnu.org/licenses/>.
21--
22-- ===================================================================
23
24create table llx_fichinterdet_rec
25(
26	rowid				integer AUTO_INCREMENT PRIMARY KEY,
27	fk_fichinter		integer NOT NULL,
28	date				datetime,				-- date de la ligne d'intervention
29	description			text,					-- description de la ligne d'intervention
30	duree				integer,				-- duree de la ligne d'intervention
31	rang				integer DEFAULT 0,		-- ordre affichage sur la fiche
32	total_ht			DOUBLE(24, 8) NULL DEFAULT NULL,
33	subprice			DOUBLE(24, 8) NULL DEFAULT NULL,
34	fk_parent_line		integer NULL DEFAULT NULL,
35	fk_product			integer NULL DEFAULT NULL,
36	label				varchar(255) NULL DEFAULT NULL,
37	tva_tx				DOUBLE(6, 3) NULL DEFAULT NULL,
38	localtax1_tx		DOUBLE(6, 3) NULL DEFAULT 0,
39	localtax1_type		VARCHAR(1) NULL DEFAULT NULL,
40	localtax2_tx		DOUBLE(6, 3) NULL DEFAULT 0,
41	localtax2_type		VARCHAR(1) NULL DEFAULT NULL,
42	qty					double NULL DEFAULT NULL,
43	remise_percent		double NULL DEFAULT 0,
44	remise				double NULL DEFAULT 0,
45	fk_remise_except	integer NULL DEFAULT NULL,
46	price				DOUBLE(24, 8) NULL DEFAULT NULL,
47	total_tva			DOUBLE(24, 8) NULL DEFAULT NULL,
48	total_localtax1		DOUBLE(24, 8) NULL DEFAULT 0,
49	total_localtax2		DOUBLE(24, 8) NULL DEFAULT 0,
50	total_ttc			DOUBLE(24, 8) NULL DEFAULT NULL,
51	product_type		INTEGER NULL DEFAULT 0,
52	date_start			datetime NULL DEFAULT NULL,
53	date_end			datetime NULL DEFAULT NULL,
54	info_bits			INTEGER NULL DEFAULT 0,
55	buy_price_ht		DOUBLE(24, 8) NULL DEFAULT 0,
56	fk_product_fournisseur_price	integer NULL DEFAULT NULL,
57	fk_code_ventilation	integer NOT NULL DEFAULT 0,
58	fk_export_commpta	integer NOT NULL DEFAULT 0,
59	special_code		integer UNSIGNED NULL DEFAULT 0,
60	fk_unit				integer NULL DEFAULT NULL,
61	import_key			varchar(14) NULL DEFAULT NULL
62
63)ENGINE=innodb;
64