Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
llx_00_c_country.sql	31.04 KB	-rwxr-x---	2023-04-04 15:50
llx_10_c_regions.sql	39.32 KB	-rwxr-x---	2023-04-04 15:50
llx_20_c_departements.sql	242.22 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_abc.sql	11.05 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_at.sql	114.94 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_be.sql	204.62 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_bf.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_bj.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ca.sql	34.99 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_cd.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_cf.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_cg.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ch.sql	56.25 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ci.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_cl.sql	35.58 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_cm.sql	281.17 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_de.sql	1.63 MB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_dk.sql	20.28 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_dz.sql	171.39 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ec.sql	100.92 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_es.sql	190.42 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_fr.sql	607.11 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ga.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_gb.sql	78.13 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_gq.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_jp.sql	73.33 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_km.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_lu.sql	173.04 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ma.sql	184.91 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ml.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_mx.sql	264.92 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ne.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_nl.sql	18.9 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ro.sql	142.22 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_se.sql	7.6 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_sn.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_td.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_tg.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_tn.sql	131.66 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_us.sql	62.02 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_category.sql	1.63 KB	-rwxr-x---	2023-04-04 15:50
llx_c_action_trigger.sql	28.17 KB	-rwxr-x---	2023-04-04 15:50
llx_c_actioncomm.sql	4.79 KB	-rwxr-x---	2023-04-04 15:50
llx_c_asset_disposal_type-asset.sql	1.16 KB	-rwxr-x---	2023-04-04 15:50
llx_c_availability.sql	2.69 KB	-rwxr-x---	2023-04-04 15:50
llx_c_chargesociales.sql	5.29 KB	-rwxr-x---	2023-04-04 15:50
llx_c_civilite.sql	1.71 KB	-rwxr-x---	2023-04-04 15:50
llx_c_currencies.sql	19.51 KB	-rwxr-x---	2023-04-04 15:50
llx_c_ecotaxe.sql	4.51 KB	-rwxr-x---	2023-04-04 15:50
llx_c_effectif.sql	1.89 KB	-rwxr-x---	2023-04-04 15:50
llx_c_email_templates.sql	10.76 KB	-rwxr-x---	2023-04-04 15:50
llx_c_exp_tax_cat.sql	3.49 KB	-rwxr-x---	2023-04-04 15:50
llx_c_exp_tax_range.sql	2.52 KB	-rwxr-x---	2023-04-04 15:50
llx_c_format_cards.sql	4.85 KB	-rwxr-x---	2023-04-04 15:50
llx_c_forme_juridique.sql	41.63 KB	-rwxr-x---	2023-04-04 15:50
llx_c_holiday_type.sql	2.32 KB	-rwxr-x---	2023-04-04 15:50
llx_c_hrm_department.sql	2.6 KB	-rwxr-x---	2023-04-04 15:50
llx_c_hrm_function.sql	2.17 KB	-rwxr-x---	2023-04-04 15:50
llx_c_hrm_public_holiday.sql	10.99 KB	-rwxr-x---	2023-04-04 15:50
llx_c_incoterms.sql	4.55 KB	-rwxr-x---	2023-04-04 15:50
llx_c_input_method.sql	1.81 KB	-rwxr-x---	2023-04-04 15:50
llx_c_input_reason.sql	2.17 KB	-rwxr-x---	2023-04-04 15:50
llx_c_lead_status.sql	1.68 KB	-rwxr-x---	2023-04-04 15:50
llx_c_paiement.sql	3.01 KB	-rwxr-x---	2023-04-04 15:50
llx_c_paper_format.sql	4.39 KB	-rwxr-x---	2023-04-04 15:50
llx_c_partnership_type-partnership.sql	1.05 KB	-rwxr-x---	2023-04-04 15:50
llx_c_payment_term.sql	4.07 KB	-rwxr-x---	2023-04-04 15:50
llx_c_product_nature.sql	1.12 KB	-rwxr-x---	2023-04-04 15:50
llx_c_productbatch_qcstatus.sql	1.15 KB	-rwxr-x---	2023-04-04 15:50
llx_c_propalst.sql	1.75 KB	-rwxr-x---	2023-04-04 15:50
llx_c_prospectcontactlevel.sql	1.31 KB	-rwxr-x---	2023-04-04 15:50
llx_c_prospectlevel.sql	1.72 KB	-rwxr-x---	2023-04-04 15:50
llx_c_revenuestamp.sql	1.42 KB	-rwxr-x---	2023-04-04 15:50
llx_c_shipment_mode.sql	4.08 KB	-rwxr-x---	2023-04-04 15:50
llx_c_socialnetworks.sql	5.57 KB	-rwxr-x---	2023-04-04 15:50
llx_c_stcomm.sql	1.76 KB	-rwxr-x---	2023-04-04 15:50
llx_c_stcommcontact.sql	1.35 KB	-rwxr-x---	2023-04-04 15:50
llx_c_ticket_category.sql	917 B	-rwxr-x---	2023-04-04 15:50
llx_c_ticket_resolution.sql	1.17 KB	-rwxr-x---	2023-04-04 15:50
llx_c_ticket_severity.sql	1.38 KB	-rwxr-x---	2023-04-04 15:50
llx_c_ticket_type.sql	1.8 KB	-rwxr-x---	2023-04-04 15:50
llx_c_transport_mode.sql	1.7 KB	-rwxr-x---	2023-04-04 15:50
llx_c_tva.sql	33.41 KB	-rwxr-x---	2023-04-04 15:50
llx_c_type_contact.sql	10.44 KB	-rwxr-x---	2023-04-04 15:50
llx_c_type_container.sql	1.85 KB	-rwxr-x---	2023-04-04 15:50
llx_c_type_fees.sql	5.58 KB	-rwxr-x---	2023-04-04 15:50
llx_c_type_resource.sql	1.49 KB	-rwxr-x---	2023-04-04 15:50
llx_c_typent.sql	2.8 KB	-rwxr-x---	2023-04-04 15:50
llx_c_units.sql	6.29 KB	-rwxr-x---	2023-04-04 15:50
llx_const.sql	8.33 KB	-rwxr-x---	2023-04-04 15:50
llx_expensereport_ik.sql	2.6 KB	-rwxr-x---	2023-04-04 15:50
llx_holiday_config.sql	74 B	-rwxr-x---	2023-04-04 15:50

Rename

-- Copyright (C) 2001-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
-- Copyright (C) 2003      Jean-Louis Bergamo   <jlb@j1b.org>
-- Copyright (C) 2004-2009 Laurent Destailleur  <eldy@users.sourceforge.net>
-- Copyright (C) 2004      Benoit Mortier       <benoit.mortier@opensides.be>
-- Copyright (C) 2004      Guillaume Delecourt  <guillaume.delecourt@opensides.be>
-- Copyright (C) 2005-2009 Regis Houssin        <regis.houssin@inodbox.com>
-- Copyright (C) 2007      Patrick Raguin       <patrick.raguin@gmail.com>
-- Copyright (C) 2011-2022 Alexandre Spangaro   <aspangaro@open-dsi.fr>
-- Copyright (C) 2015-2017 Juanjo Menent        <jmenent@2byte.es>
-- Copyright (C) 2018      Abbes bahfir         <dolipar@dolipar.org>
-- Copyright (C) 2020      Udo Tamm             <dev@dolibit.de>
--
--
--------------------------------------------------------------------------------------
-- License
-- #######
-- 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/>.
--
--------------------------------------------------------------------------------------

-- Comment
-- #######
-- (EN)
-- Do not place a comment at the end of the line, this file is parsed at the end of the line.
-- from the install and all '--' are removed.
--
-- (FR)
-- Ne pas placer de commentaire en fin de ligne, ce fichier est parsé lors
-- de l'install et tous les sigles '--' sont supprimés.
--
--------------------------------------------------------------------------------------
-- PCG = Plan Comptable Général (FR) - General Accounting Plan (EN)
--------------------------------------------------------------------------------------

-- Accounting Journals

INSERT INTO llx_accounting_journal (code, label, nature, active, entity) VALUES ('VT',  'ACCOUNTING_SELL_JOURNAL',          2, 1, 1);
INSERT INTO llx_accounting_journal (code, label, nature, active, entity) VALUES ('AC',  'ACCOUNTING_PURCHASE_JOURNAL',      3, 1, 1);
INSERT INTO llx_accounting_journal (code, label, nature, active, entity) VALUES ('BQ',  'FinanceJournal',                   4, 1, 1);
INSERT INTO llx_accounting_journal (code, label, nature, active, entity) VALUES ('OD',  'ACCOUNTING_MISCELLANEOUS_JOURNAL', 1, 1, 1);
INSERT INTO llx_accounting_journal (code, label, nature, active, entity) VALUES ('AN',  'ACCOUNTING_HAS_NEW_JOURNAL',       9, 1, 1);
INSERT INTO llx_accounting_journal (code, label, nature, active, entity) VALUES ('ER',  'ExpenseReportsJournal',            5, 1, 1);
INSERT INTO llx_accounting_journal (code, label, nature, active, entity) VALUES ('INV', 'InventoryJournal',                 8, 1, 1);

-- Accounting Charts / Plans (Templates) for Countries

-- Description of chart of account FR PCG99-ABREGE
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (  1, 'PCG99-ABREGE', 'The simple accountancy french plan', 1);
-- Description of chart of account FR PCG99-BASE
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (  1, 'PCG99-BASE', 'The base accountancy french plan', 1);
-- Description of chart of account FR PCG14-DEV
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (  1, 'PCG14-DEV', 'The developed accountancy french plan 2014', 1);
-- Description of chart of account FR PCG18-ASSOC
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (  1, 'PCG18-ASSOC', 'French foundation chart of accounts 2018', 1);
-- Description of chart of account FR PCGAFR14-DEV 
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (  1, 'PCGAFR14-DEV', 'The developed farm accountancy french plan 2014', 1);

-- Description of chart of account BE PCMN-BASE
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (  2, 'PCMN-BASE', 'The base accountancy belgium plan', 1);

-- Description of chart of account ES PCG08-PYME
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (  4, 'PCG08-PYME', 'The PYME accountancy spanish plan', 1);

-- Description of chart of account DE SKR-03
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (  5, 'SKR03', 'Standardkontenrahmen SKR 03', 1);
-- Description of chart of account DE SKR-04
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (  5, 'SKR04', 'Standardkontenrahmen SKR 04', 1);

-- Description of chart of account CH PCG_SUISSE
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (  6, 'PCG_SUISSE', 'Switzerland plan', 1);

-- Description of chart of account GB ENG-BASE
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (  7, 'ENG-BASE', 'England plan', 1);

-- Description of chart of account TN PCT
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 10, 'PCT', 'The Tunisia plan', 1);

-- Description of chart of account MA PCG
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 12, 'PCG', 'The Moroccan chart of accounts', 1);

-- Description of chart of account DZ NSCF
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 13, 'NSCF', 'Nouveau système comptable financier', 1);

-- Description of chart of account NL NL-VERKORT
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 17, 'NL-VERKORT', 'Verkort rekeningschema', 1);

-- Description of chart of account SE BAS-K1-MINI
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 20, 'BAS-K1-MINI', 'The Swedish mini chart of accounts', 1);

-- Description of chart of account AT AT-BASE
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 41, 'AT-BASE', 'Plan Austria', 1);

-- Description of chart of account CL CL-PYME
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 67, 'PC-MIPYME', 'The PYME accountancy Chile plan', 1);

-- Description of chart of account DK DK-STD
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 80, 'DK-STD', 'Standardkontoplan fra SKAT', 1);

-- Description of chart of account EC EC-SUPERCIAS
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 84, 'EC-SUPERCIAS', 'Plan de cuentas Ecuador', 1);

-- Description of chart of account LU PCN2020-LUXEMBURG
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (140, 'PCN2020-LUXEMBURG', 'Plan comptable normalisé 2020 Luxembourgeois', 1);

-- Description of chart of account RO RO-BASE
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (188, 'RO-BASE', 'Plan de conturi romanesc', 1);

--DELETE FROM llx_accounting_system WHERE pcg_version = 'SYSCOHADA';

-- Plans SYSCOAHA Western Africa -- sorted alphabetical by countries abbreviations

-- Description of chart of account BJ SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 49,'SYSCOHADA-BJ', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account BF SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 60,'SYSCOHADA-BF', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account CD SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 73,'SYSCOHADA-CD', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account CF SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 65,'SYSCOHADA-CF', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account CG SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 72,'SYSCOHADA-CG', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account CI SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 21,'SYSCOHADA-CI', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account CM SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 24,'SYSCOHADA-CM', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account GA SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 16,'SYSCOHADA-GA', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account GQ SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 87,'SYSCOHADA-GQ', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account KM SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 71,'SYSCOHADA-KM', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account ML SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (147,'SYSCOHADA-ML', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account NE SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (168,'SYSCOHADA-NE', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account SN SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 22,'SYSCOHADA-SN', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account TD SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 66,'SYSCOHADA-TD', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account TG SYSCOHADA
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 15,'SYSCOHADA-TG', 'Plan comptable Ouest-Africain', 1);

-- Description of chart of account USA US-BASE
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 11, 'US-BASE', 'USA basic chart of accounts', 1);

-- Description of chart of account USA US-GAAP-BASIC
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 11, 'US-GAAP-BASIC', 'USA GAAP basic chart of accounts', 1);

-- Description of chart of account Canada CA-ENG-BASE
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 14, 'CA-ENG-BASE', 'Canadian basic chart of accounts - English', 1);

-- Description of chart of account Mexico SAT/24-2019
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 154, 'SAT/24-2019', 'Catalogo y codigo agrupador fiscal del 2019', 1);

-- Description of chart of account Japan JPN-BASE
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 123, 'JPN-BASE', '日本 勘定科目表 基本版', 1);