-- ===================================================================
-- Copyright (C) 2002-2003  Rodolphe Quiedeville    <rodolphe@quiedeville.org>
-- Copyright (C) 2005-2012  Regis Houssin           <regis.houssin@inodbox.com>
-- Copyright (C) 2010       Juanjo Menent           <jmenent@2byte.es>
-- Copyright (C) 2012       Cédric Salvador         <csalvador@gpcsolutions.fr>
-- Copyright (C) 2022       OpenDSI                 <support@open-dsi.fr>
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 3 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program. If not, see <https://www.gnu.org/licenses/>.
--
-- ===================================================================

create table llx_propaldet
(
    rowid                           integer AUTO_INCREMENT PRIMARY KEY,
    fk_propal                       integer         NOT NULL,
    fk_parent_line					integer         NULL,
    fk_product						integer         NULL,
    label                           varchar(255)    DEFAULT NULL,
    description                     text,
    fk_remise_except                integer         NULL,           -- Link to table of fixed discounts
    vat_src_code                    varchar(10)     DEFAULT '',		-- Vat code used as source of vat fields. Not strict foreign key here.
    tva_tx                          double(7,4)     DEFAULT 0, 	    -- Vat rate
    localtax1_tx                    double(7,4)     DEFAULT 0,    	-- localtax1 rate
    localtax1_type                  varchar(10)	    NULL,           -- localtax1 type
    localtax2_tx               		double(7,4)     DEFAULT 0,      -- localtax2 rate
    localtax2_type			 		varchar(10)     NULL,           -- localtax2 type
    qty								real,                           -- quantity
    remise_percent					real            DEFAULT 0,      -- discount percentage
    remise							real            DEFAULT 0,      -- discount amount (obsolete)
    price                           real,                           -- final price (obsolete)
    subprice                        double(24,8)    DEFAULT 0,      -- unit price without tax
    subprice_ttc    	  			double(24,8) 	DEFAULT 0,    	-- unit price if price was entered including tax
    total_ht                        double(24,8)    DEFAULT 0,      -- Total excluding VAT of the line all quantities and including line and global discount
    total_tva                       double(24,8)    DEFAULT 0,      -- Total VAT of the line any quantity and including discount line and global
    total_localtax1					double(24,8)    DEFAULT 0,      -- Total localtax1
    total_localtax2					double(24,8)    DEFAULT 0,      -- Total localtax2
    total_ttc                       double(24,8)    DEFAULT 0,      -- Total TTC of the line all quantity and including line and global discount
    product_type                    integer         DEFAULT 0,      -- 0 or 1. Value 9 may be used by some modules (amount of line may not be included into generated discount if value is 9).
    date_start						datetime        DEFAULT NULL,   -- start date if service
    date_end                        datetime        DEFAULT NULL,   -- end date if service
    info_bits                       integer         DEFAULT 0,      -- VAT NPR or not

    buy_price_ht					double(24,8)    DEFAULT 0,      -- buying price
    fk_product_fournisseur_price	integer         DEFAULT NULL,   -- reference of supplier price when line was added (may be used to update buy_price_ht current price when future invoice will be created)

    special_code					integer         DEFAULT 0,      -- code for special lines (may be 1=transport, 2=ecotax, 3=option, moduleid=...)
    rang							integer         DEFAULT 0,      -- order display on the propal
    fk_unit                         integer         DEFAULT NULL,   -- link to table of units

    fk_multicurrency                integer,
    multicurrency_code              varchar(3),
    multicurrency_subprice          double(24,8)    DEFAULT 0,
	multicurrency_subprice_ttc		double(24,8) 	DEFAULT 0,
    multicurrency_total_ht          double(24,8)    DEFAULT 0,
    multicurrency_total_tva         double(24,8)    DEFAULT 0,
    multicurrency_total_ttc         double(24,8)    DEFAULT 0,

    import_key                      varchar(14),
	extraparams				 		varchar(255)				 	-- to stock other parameters in json format
)ENGINE=innodb;

--
-- List of codes for special_code
--
-- 1 : shipping costs
-- 2 : ecotax
-- 3 : optional product/service
--