1-- =================================================================== 2-- Copyright (C) 2017-2019 Alexandre Spangaro <aspangaro@open-dsi.fr> 3-- 4-- This program is free software; you can redistribute it and/or modify 5-- it under the terms of the GNU General Public License as published by 6-- the Free Software Foundation; either version 3 of the License, or 7-- (at your option) any later version. 8-- 9-- This program is distributed in the hope that it will be useful, 10-- but WITHOUT ANY WARRANTY; without even the implied warranty of 11-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 12-- GNU General Public License for more details. 13-- 14-- You should have received a copy of the GNU General Public License 15-- along with this program. If not, see <https://www.gnu.org/licenses/>. 16-- 17-- =================================================================== 18 19create table llx_payment_various 20( 21 rowid integer AUTO_INCREMENT PRIMARY KEY, 22 ref varchar(30) NULL, -- payment reference number (currently NULL because there is no numbering manager yet) 23 num_payment varchar(50), -- num cheque or other 24 label varchar(255), 25 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 26 datec datetime, -- Create date 27 datep date, -- date de paiement 28 datev date, -- date de valeur (this field should not be here, only into bank tables) 29 sens smallint DEFAULT 0 NOT NULL,-- Sens of the operation: 0 for debit operation, 1 for credit operation 30 amount double(24,8) DEFAULT 0 NOT NULL, 31 fk_typepayment integer NOT NULL, 32 accountancy_code varchar(32), 33 subledger_account varchar(32), 34 fk_projet integer DEFAULT NULL, 35 entity integer DEFAULT 1 NOT NULL, -- multi company id 36 note text, 37 fk_bank integer, 38 fk_user_author integer, -- utilisateur qui a cree l'info 39 fk_user_modif integer -- utilisateur qui a modifié l'info 40)ENGINE=innodb; 41