1-- =================================================================== 2-- Copyright (C) 2003-2010 Rodolphe Quiedeville <rodolphe@quiedeville.org> 3-- Copyright (C) 2008-2010 Regis Houssin <regis.houssin@capnetworks.com> 4-- Copyright (C) 2011-2012 Laurent Destailleur <eldy@users.sourceforge.net> 5-- Copyright (C) 2012 Juanjo Menent <jmenent@2byte.es> 6-- 7-- This program is free software; you can redistribute it and/or modify 8-- it under the terms of the GNU General Public License as published by 9-- the Free Software Foundation; either version 3 of the License, or 10-- (at your option) any later version. 11-- 12-- This program is distributed in the hope that it will be useful, 13-- but WITHOUT ANY WARRANTY; without even the implied warranty of 14-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 15-- GNU General Public License for more details. 16-- 17-- You should have received a copy of the GNU General Public License 18-- along with this program. If not, see <https://www.gnu.org/licenses/>. 19-- 20-- =================================================================== 21 22create table llx_reception 23( 24 rowid integer AUTO_INCREMENT PRIMARY KEY, 25 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 26 ref varchar(30) NOT NULL, 27 entity integer DEFAULT 1 NOT NULL, -- multi company id 28 fk_soc integer NOT NULL, 29 fk_projet integer DEFAULT NULL, 30 31 ref_ext varchar(30), -- reference into an external system (not used by dolibarr) 32 ref_int varchar(30), -- reference into an internal system (deprecated) 33 ref_supplier varchar(30), -- customer number 34 35 date_creation datetime, -- date de creation 36 fk_user_author integer, -- author of creation 37 fk_user_modif integer, -- author of last change 38 date_valid datetime, -- date de validation 39 fk_user_valid integer, -- valideur 40 date_delivery datetime DEFAULT NULL, -- date planned of delivery 41 date_reception datetime, 42 fk_shipping_method integer, 43 tracking_number varchar(50), 44 fk_statut smallint DEFAULT 0, -- 0 = draft, 1 = validated, 2 = billed or closed depending on WORKFLOW_BILL_ON_SHIPMENT option 45 billed smallint DEFAULT 0, 46 47 height float, -- height 48 width float, -- with 49 size_units integer, -- unit of all sizes (height, width, depth) 50 size float, -- depth 51 weight_units integer, -- unit of weight 52 weight float, -- weight 53 note_private text, 54 note_public text, 55 model_pdf varchar(255), 56 fk_incoterms integer, -- for incoterms 57 location_incoterms varchar(255), -- for incoterms 58 59 import_key varchar(14), 60 extraparams varchar(255) -- for other parameters with json format 61)ENGINE=innodb; 62