1-- ===================================================================
2-- Copyright (C) 2003-2004	Rodolphe Quiedeville <rodolphe@quiedeville.org>
3-- Copyright (C) 2004		Laurent Destailleur  <eldy@users.sourceforge.net>
4--
5-- This program is free software; you can redistribute it and/or modify
6-- it under the terms of the GNU General Public License as published by
7-- the Free Software Foundation; either version 3 of the License, or
8-- (at your option) any later version.
9--
10-- This program is distributed in the hope that it will be useful,
11-- but WITHOUT ANY WARRANTY; without even the implied warranty of
12-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
13-- GNU General Public License for more details.
14--
15-- You should have received a copy of the GNU General Public License
16-- along with this program. If not, see <https://www.gnu.org/licenses/>.
17--
18-- ===================================================================
19
20create table llx_paiementfourn
21(
22  rowid					integer AUTO_INCREMENT PRIMARY KEY,
23  ref					varchar(30),
24  entity				integer DEFAULT 1,
25  tms					timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
26  datec					datetime,          -- date de creation de l'enregistrement
27  datep					datetime,          -- date de paiement
28  amount				double(24,8) DEFAULT 0,    -- montant
29  multicurrency_amount	double(24,8) DEFAULT 0,    -- multicurrency amount
30  fk_user_author		integer,           -- auteur
31  fk_user_modif 		integer,
32  fk_paiement			integer NOT NULL,  -- moyen de paiement
33  num_paiement			varchar(50),       -- numero de paiement (cheque)
34  note					text,
35  fk_bank				integer NOT NULL,
36  statut				smallint NOT NULL DEFAULT 0,
37  model_pdf				varchar(255)
38)ENGINE=innodb;
39