| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647 |
- -- ============================================================================
- -- Copyright (C) 2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
- -- Copyright (C) 2006-2007 Laurent Destailleur <eldy@users.sourceforge.net>
- --
- -- 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/>.
- --
- --
- -- Remises exceptionnelles
- -- ============================================================================
- create table llx_societe_remise_except
- (
- rowid integer AUTO_INCREMENT PRIMARY KEY,
- entity integer DEFAULT 1 NOT NULL, -- multi company id
- fk_soc integer NOT NULL, -- customer or supplier
- discount_type integer DEFAULT 0 NOT NULL, -- 0 => customer, 1 => supplier
- datec datetime,
- amount_ht double(24,8) NOT NULL,
- amount_tva double(24,8) DEFAULT 0 NOT NULL,
- amount_ttc double(24,8) DEFAULT 0 NOT NULL,
- tva_tx double(7,4) DEFAULT 0 NOT NULL,
- vat_src_code varchar(10) DEFAULT '', -- Vat code used as source of vat fields. Not strict foreign key here.
- fk_user integer NOT NULL,
- fk_facture_line integer,
- fk_facture integer,
- fk_facture_source integer,
- fk_invoice_supplier_line integer,
- fk_invoice_supplier integer,
- fk_invoice_supplier_source integer,
- description text NOT NULL,
- multicurrency_code varchar(3) NULL,
- multicurrency_tx double(24,8) NULL,
- multicurrency_amount_ht double(24,8) DEFAULT 0 NOT NULL,
- multicurrency_amount_tva double(24,8) DEFAULT 0 NOT NULL,
- multicurrency_amount_ttc double(24,8) DEFAULT 0 NOT NULL
- )ENGINE=innodb;
|
