Merge lp:~openobject-italia-core-devs/openobject-addons/l10n_it_6.1_fixes into lp:openobject-addons

Proposed by Lorenzo Battistini
Status: Merged
Merged at revision: 5779
Proposed branch: lp:~openobject-italia-core-devs/openobject-addons/l10n_it_6.1_fixes
Merge into: lp:openobject-addons
Diff against target: 2541 lines (+365/-1973)
19 files modified
l10n_it/__init__.py (+5/-6)
l10n_it/__openerp__.py (+4/-5)
l10n_it/data/account.account.template.csv (+234/-233)
l10n_it/data/account.account.type.csv (+5/-5)
l10n_it/data/account.tax.code.template.csv (+14/-0)
l10n_it/data/account.tax.template.csv (+64/-40)
l10n_it/i18n/it.po (+28/-159)
l10n_it/i18n/l10n_it.pot (+11/-126)
l10n_it/libroIVA.py (+0/-54)
l10n_it/libroIVA_menu.xml (+0/-16)
l10n_it/libroIVA_view.xml (+0/-47)
l10n_it/report.xml (+0/-24)
l10n_it/report/__init__.py (+0/-2)
l10n_it/report/libroIVA_credito.py (+0/-79)
l10n_it/report/libroIVA_credito.rml (+0/-203)
l10n_it/report/libroIVA_debito.py (+0/-80)
l10n_it/report/libroIVA_debito.rml (+0/-195)
l10n_it/report/normalized_oo2rml.xsl (+0/-696)
l10n_it/security/ir.model.access.csv (+0/-3)
To merge this branch: bzr merge lp:~openobject-italia-core-devs/openobject-addons/l10n_it_6.1_fixes
Reviewer Review Type Date Requested Status
Olivier Dony (Odoo) Needs Fixing
Lorenzo Battistini (community) Needs Resubmitting
OpenERP Core Team Pending
Review via email: mp+73349@code.launchpad.net

Description of the change

These changes fix several important problems related to Italian partially deductible VAT.

Main issues are described here http://wiki.openerp-italia.org/doku.php/moduli/l10n_it_iva_indetraibile

We removed the 'libro IVA' report because we implemented it in the 'l10n_it_vat_registries' module http://apps.openerp.com/addon/6074 and it depends on 'l10n_it_corrispettivi' http://apps.openerp.com/addon/6055

To post a comment you must log in.
Revision history for this message
Lorenzo Battistini (elbati) wrote :

Verify if it's possible to avoid 'Decimal'
Verify 'tax_amount' and 'base_amount' (for tax.code)

review: Needs Fixing
Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

On 11/05/2011 02:38 PM, Lorenzo Battistini - Agile BG - Domsense wrote:
> Review: Needs Fixing
>
> Verify if it's possible to avoid 'Decimal'

I was about to write the same comment, well done! :-)
Normally my recent bug comments about Decimal vs Float should give you
some pointers, but do not hesitate to ask if you need more info.

Revision history for this message
Lorenzo Battistini (elbati) :
review: Needs Resubmitting
Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

Hi Lorenzo,

Thanks for updating the merge proposal!

Now all it does is remove the IVA reports and update the chart of accounts, which I can hardly review functionally ;-)
I will merge it after a final installation test.

Please note that you could later suggest the inclusion of your l10n_it_* modules into the official addons, if they are considered required in Italia. You can check our "Merge Proposal Acceptance Policy" [1] for our guidelines in this matter.
As was discussed recently for the Brazilian localization, you would just need to make sure the modules can pass the technical review, i.e. they need to be clean enough in terms of Python overrides (no impact on other l10n modules) and external dependencies. It seems relatively doable from what I can see, even if you have to start with a few merge proposals to make the OpenERP core extensible enough to fit your needs...

Thanks!

[1] http://bit.ly/openerp-contrib-mp

review: Approve
Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

Something still needs to be corrected, there's an inconsistency with the "2605 - erario c/IVA account", which is declared as "account_type_tax" and "payable", while account_type_tax has closing method "balance".
Any payable account should have closing method "unreconciled", so this is inconsistent.

Did you double check? Shouldn't 2605 have "other" as internal_type?

review: Needs Fixing
Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

I've just merged it, and temporarily set the internal_type of "2605 - erario c/IVA account" to "other", to avoid breaking the trunk. I think that was the value in the previous version of l10n_it.

Let me know if this was not the correct fix, send me a patch or post a small merge prop to fix it, I will process it quickly.

Thanks!

Revision history for this message
Lorenzo Battistini (elbati) wrote :

Hello Olivier,
thanks for your review.

Actually we often need to associate the 2605 account to the tax authority partner. So, maybe better if we set it as 'account_type_payable' and 'payable'?

See new proposal: https://code.launchpad.net/~openobject-italia-core-devs/openobject-addons/l10n_it_6.1_fixes/+merge/83374 (sorry for quotes due to new version of libreoffice, I guess)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'l10n_it/__init__.py'
--- l10n_it/__init__.py 2011-01-14 00:11:01 +0000
+++ l10n_it/__init__.py 2011-11-23 14:06:29 +0000
@@ -1,13 +1,15 @@
1# -*- encoding: utf-8 -*-
2##############################################################################1##############################################################################
3#2#
4# OpenERP, Open Source Management Solution3# OpenERP, Open Source Management Solution
5# Copyright (C) 20104# Copyright (C) 2010
6# Italian OpenERP Community (<http://www.openerp-italia.com>)5# OpenERP Italian Community (<http://www.openerp-italia.org>)
7# Servabit srl6# Servabit srl
8# Agile Business Group sagl7# Agile Business Group sagl
9# Domsense srl8# Domsense srl
10# Albatos srl 9# Albatos srl
10#
11# Copyright (C) 2011
12# Associazione OpenERP Italia (<http://www.openerp-italia.org>)
11#13#
12# This program is free software: you can redistribute it and/or modify14# This program is free software: you can redistribute it and/or modify
13# it under the terms of the GNU Affero General Public License as15# it under the terms of the GNU Affero General Public License as
@@ -23,6 +25,3 @@
23# along with this program. If not, see <http://www.gnu.org/licenses/>.25# along with this program. If not, see <http://www.gnu.org/licenses/>.
24#26#
25##############################################################################27##############################################################################
26
27import libroIVA
28import report
2928
=== modified file 'l10n_it/__openerp__.py'
--- l10n_it/__openerp__.py 2011-10-11 20:05:49 +0000
+++ l10n_it/__openerp__.py 2011-11-23 14:06:29 +0000
@@ -3,12 +3,15 @@
3#3#
4# OpenERP, Open Source Management Solution4# OpenERP, Open Source Management Solution
5# Copyright (C) 20105# Copyright (C) 2010
6# Italian OpenERP Community (<http://www.openerp-italia.org>)6# OpenERP Italian Community (<http://www.openerp-italia.org>)
7# Servabit srl7# Servabit srl
8# Agile Business Group sagl8# Agile Business Group sagl
9# Domsense srl9# Domsense srl
10# Albatos srl10# Albatos srl
11#11#
12# Copyright (C) 2011
13# Associazione OpenERP Italia (<http://www.openerp-italia.org>)
14#
12# This program is free software: you can redistribute it and/or modify15# This program is free software: you can redistribute it and/or modify
13# it under the terms of the GNU Affero General Public License as16# it under the terms of the GNU Affero General Public License as
14# published by the Free Software Foundation, either version 3 of the17# published by the Free Software Foundation, either version 3 of the
@@ -39,9 +42,6 @@
39 "category" : "Localization/Account Charts",42 "category" : "Localization/Account Charts",
40 'website': 'http://www.openerp-italia.org/',43 'website': 'http://www.openerp-italia.org/',
41 'init_xml': [44 'init_xml': [
42 'report.xml',
43 'libroIVA_view.xml',
44 'libroIVA_menu.xml',
45 ],45 ],
46 'update_xml': [46 'update_xml': [
47 'data/account.account.type.csv',47 'data/account.account.type.csv',
@@ -51,7 +51,6 @@
51 'data/account.tax.template.csv',51 'data/account.tax.template.csv',
52 'data/account.fiscal.position.template.csv',52 'data/account.fiscal.position.template.csv',
53 'l10n_chart_it_generic.xml',53 'l10n_chart_it_generic.xml',
54 'security/ir.model.access.csv',
55 ],54 ],
56 'demo_xml': [55 'demo_xml': [
57 ],56 ],
5857
=== modified file 'l10n_it/data/account.account.template.csv'
--- l10n_it/data/account.account.template.csv 2011-10-16 01:28:00 +0000
+++ l10n_it/data/account.account.template.csv 2011-11-23 14:06:29 +0000
@@ -1,234 +1,235 @@
1"id","code","name","parent_id:id","user_type:id","type","reconcile"1"id","code","name","parent_id:id","user_type:id","type","reconcile"
20,0,"Azienda",,"account_type_view","view",FALSE2"0","0","Azienda",,"account_type_view","view","FALSE"
31,1,"ATTIVO ",0,"account_type_view","view",TRUE3"1","1","ATTIVO ","0","account_type_view","view","TRUE"
411,11,"IMMOBILIZZAZIONI IMMATERIALI ",1,"account_type_view","view",TRUE4"11","11","IMMOBILIZZAZIONI IMMATERIALI ","1","account_type_view","view","TRUE"
51101,1101,"costi di impianto ",11,"account_type_view","other",TRUE5"1101","1101","costi di impianto ","11","account_type_asset","other","TRUE"
61106,1106,"software ",11,"account_type_view","other",TRUE6"1106","1106","software ","11","account_type_asset","other","TRUE"
71108,1108,"avviamento ",11,"account_type_view","other",TRUE7"1108","1108","avviamento ","11","account_type_asset","other","TRUE"
81111,1111,"fondo ammortamento costi di impianto ",11,"account_type_view","other",TRUE8"1111","1111","fondo ammortamento costi di impianto ","11","account_type_asset","other","TRUE"
91116,1116,"fondo ammortamento software ",11,"account_type_view","other",TRUE9"1116","1116","fondo ammortamento software ","11","account_type_asset","other","TRUE"
101118,1118,"fondo ammortamento avviamento ",11,"account_type_view","other",TRUE10"1118","1118","fondo ammortamento avviamento ","11","account_type_asset","other","TRUE"
1112,12,"IMMOBILIZZAZIONI MATERIALI ",1,"account_type_view","view",TRUE11"12","12","IMMOBILIZZAZIONI MATERIALI ","1","account_type_view","view","TRUE"
121201,1201,"fabbricati ",12,"account_type_view","other",TRUE12"1201","1201","fabbricati ","12","account_type_asset","other","TRUE"
131202,1202,"impianti e macchinari ",12,"account_type_view","other",TRUE13"1202","1202","impianti e macchinari ","12","account_type_asset","other","TRUE"
141204,1204,"attrezzature commerciali ",12,"account_type_view","other",TRUE14"1204","1204","attrezzature commerciali ","12","account_type_asset","other","TRUE"
151205,1205,"macchine d'ufficio ",12,"account_type_view","other",TRUE15"1205","1205","macchine d'ufficio ","12","account_type_asset","other","TRUE"
161206,1206,"arredamento ",12,"account_type_view","other",TRUE16"1206","1206","arredamento ","12","account_type_asset","other","TRUE"
171207,1207,"automezzi ",12,"account_type_view","other",TRUE17"1207","1207","automezzi ","12","account_type_asset","other","TRUE"
181208,1208,"imballaggi durevoli ",12,"account_type_view","other",TRUE18"1208","1208","imballaggi durevoli ","12","account_type_asset","other","TRUE"
191211,1211,"fondo ammortamento fabbricati ",12,"account_type_view","other",TRUE19"1211","1211","fondo ammortamento fabbricati ","12","account_type_asset","other","TRUE"
201212,1212,"fondo ammortamento impianti e macchinari ",12,"account_type_view","other",TRUE20"1212","1212","fondo ammortamento impianti e macchinari ","12","account_type_asset","other","TRUE"
211214,1214,"fondo ammortamento attrezzature commerciali ",12,"account_type_view","other",TRUE21"1214","1214","fondo ammortamento attrezzature commerciali ","12","account_type_asset","other","TRUE"
221215,1215,"fondo ammortamento macchine d'ufficio ",12,"account_type_view","other",TRUE22"1215","1215","fondo ammortamento macchine d'ufficio ","12","account_type_asset","other","TRUE"
231216,1216,"fondo ammortamento arredamento ",12,"account_type_view","other",TRUE23"1216","1216","fondo ammortamento arredamento ","12","account_type_asset","other","TRUE"
241217,1217,"fondo ammortamento automezzi ",12,"account_type_view","other",TRUE24"1217","1217","fondo ammortamento automezzi ","12","account_type_asset","other","TRUE"
251218,1218,"fondo ammortamento imballaggi durevoli ",12,"account_type_view","other",TRUE25"1218","1218","fondo ammortamento imballaggi durevoli ","12","account_type_asset","other","TRUE"
261220,1220,"fornitori immobilizzazioni c/acconti ",12,"account_type_view","other",TRUE26"1220","1220","fornitori immobilizzazioni c/acconti ","12","account_type_asset","other","TRUE"
2713,13,"IMMOBILIZZAZIONI FINANZIARIE ",1,"account_type_view","view",TRUE27"13","13","IMMOBILIZZAZIONI FINANZIARIE ","1","account_type_view","view","TRUE"
281301,1301,"mutui attivi ",13,"account_type_view","other",TRUE28"1301","1301","mutui attivi ","13","account_type_asset","other","TRUE"
2914,14,"RIMANENZE ",1,"account_type_view","view",TRUE29"14","14","RIMANENZE ","1","account_type_view","view","TRUE"
301401,1401,"materie di consumo ",14,"account_type_view","other",TRUE30"1401","1401","materie di consumo ","14","account_type_asset","other","TRUE"
311404,1404,"merci ",14,"account_type_view","other",TRUE31"1404","1404","merci ","14","account_type_asset","other","TRUE"
321410,1410,"fornitori c/acconti ",14,"account_type_view","other",TRUE32"1410","1410","fornitori c/acconti ","14","account_type_asset","other","TRUE"
3315,15,"CREDITI COMMERCIALI ",1,"account_type_view","view",TRUE33"15","15","CREDITI COMMERCIALI ","1","account_type_view","view","TRUE"
341501,1501,"crediti v/clienti ",15,"account_type_receivable","receivable",TRUE34"1501","1501","crediti v/clienti ","15","account_type_receivable","receivable","TRUE"
351502,1502,"crediti commerciali diversi ",15,"account_type_receivable","other",TRUE35"1502","1502","crediti commerciali diversi ","15","account_type_receivable","other","TRUE"
361503,1503,"clienti c/spese anticipate ",15,"account_type_receivable","receivable",TRUE36"1503","1503","clienti c/spese anticipate ","15","account_type_receivable","receivable","TRUE"
371505,1505,"cambiali attive ",15,"account_type_receivable","other",TRUE37"1505","1505","cambiali attive ","15","account_type_receivable","other","TRUE"
381506,1506,"cambiali allo sconto ",15,"account_type_receivable","other",TRUE38"1506","1506","cambiali allo sconto ","15","account_type_receivable","other","TRUE"
391507,1507,"cambiali all'incasso ",15,"account_type_receivable","other",TRUE39"1507","1507","cambiali all'incasso ","15","account_type_receivable","other","TRUE"
401509,1509,"fatture da emettere ",15,"account_type_receivable","other",TRUE40"1509","1509","fatture da emettere ","15","account_type_receivable","other","TRUE"
411510,1510,"crediti insoluti ",15,"account_type_receivable","other",TRUE41"1510","1510","crediti insoluti ","15","account_type_receivable","other","TRUE"
421511,1511,"cambiali insolute ",15,"account_type_receivable","other",TRUE42"1511","1511","cambiali insolute ","15","account_type_receivable","other","TRUE"
431531,1531,"crediti da liquidare ",15,"account_type_receivable","other",TRUE43"1531","1531","crediti da liquidare ","15","account_type_receivable","other","TRUE"
441540,1540,"fondo svalutazione crediti ",15,"account_type_receivable","other",TRUE44"1540","1540","fondo svalutazione crediti ","15","account_type_receivable","other","TRUE"
451541,1541,"fondo rischi su crediti ",15,"account_type_receivable","other",TRUE45"1541","1541","fondo rischi su crediti ","15","account_type_receivable","other","TRUE"
4616,16,"CREDITI DIVERSI ",1,"account_type_view","view",TRUE46"16","16","CREDITI DIVERSI ","1","account_type_view","view","TRUE"
471601,1601,"IVA n/credito ",16,"account_type_receivable","other",TRUE47"1601","1601","IVA n/credito ","16","account_type_tax","other","TRUE"
481602,1602,"IVA c/acconto ",16,"account_type_receivable","other",TRUE48"1602","1602","IVA c/acconto ","16","account_type_tax","other","TRUE"
491605,1605,"crediti per IVA ",16,"account_type_receivable","other",TRUE49"1605","1605","crediti per IVA ","16","account_type_tax","other","TRUE"
501607,1607,"imposte c/acconto ",16,"account_type_receivable","other",TRUE50"1607","1607","imposte c/acconto ","16","account_type_tax","other","TRUE"
511608,1608,"crediti per imposte ",16,"account_type_receivable","other",TRUE51"1608","1608","crediti per imposte ","16","account_type_tax","other","TRUE"
521609,1609,"crediti per ritenute subite ",16,"account_type_receivable","other",TRUE52"1609","1609","crediti per ritenute subite ","16","account_type_asset","other","TRUE"
531610,1610,"crediti per cauzioni ",16,"account_type_receivable","other",TRUE53"1610","1610","crediti per cauzioni ","16","account_type_asset","other","TRUE"
541620,1620,"personale c/acconti ",16,"account_type_receivable","other",TRUE54"1620","1620","personale c/acconti ","16","account_type_asset","other","TRUE"
551630,1630,"crediti v/istituti previdenziali ",16,"account_type_receivable","other",TRUE55"1630","1630","crediti v/istituti previdenziali ","16","account_type_asset","other","TRUE"
561640,1640,"debitori diversi ",16,"account_type_receivable","receivable",TRUE56"1640","1640","debitori diversi ","16","account_type_receivable","receivable","TRUE"
5718,18,"DISPONIBILITÀ LIQUIDE ",1,"account_type_view","view",TRUE57"18","18","DISPONIBILITÀ LIQUIDE ","1","account_type_view","view","TRUE"
581801,1801,"banche c/c ",18,"account_type_bank","liquidity",TRUE58"1801","1801","banche c/c ","18","account_type_bank","liquidity","TRUE"
591810,1810,"c/c postali ",18,"account_type_cash","liquidity",TRUE59"1810","1810","c/c postali ","18","account_type_cash","liquidity","TRUE"
601820,1820,"denaro in cassa ",18,"account_type_cash","liquidity",TRUE60"1820","1820","denaro in cassa ","18","account_type_cash","liquidity","TRUE"
611821,1821,"assegni ",18,"account_type_cash","liquidity",TRUE61"1821","1821","assegni ","18","account_type_cash","liquidity","TRUE"
621822,1822,"valori bollati ",18,"account_type_cash","liquidity",TRUE62"1822","1822","valori bollati ","18","account_type_cash","liquidity","TRUE"
6319,19,"RATEI E RISCONTI ATTIVI ",1,"account_type_view","view",TRUE63"19","19","RATEI E RISCONTI ATTIVI ","1","account_type_view","view","TRUE"
641901,1901,"ratei attivi ",19,"account_type_view","other",TRUE64"1901","1901","ratei attivi ","19","account_type_asset","other","TRUE"
651902,1902,"risconti attivi ",19,"account_type_view","other",TRUE65"1902","1902","risconti attivi ","19","account_type_asset","other","TRUE"
662,2,"PASSIVO ",0,"account_type_view","view",TRUE66"2","2","PASSIVO ","0","account_type_view","view","TRUE"
6720,20,"PATRIMONIO NETTO ",2,"account_type_view","view",TRUE67"20","20","PATRIMONIO NETTO ","2","account_type_view","view","TRUE"
682101,2101,"patrimonio netto ",20,"account_type_view","other",TRUE68"2101","2101","patrimonio netto ","20","account_type_asset","other","TRUE"
692102,2102,"utile d'esercizio ",20,"account_type_receivable","receivable",TRUE69"2102","2102","utile d'esercizio ","20","account_type_asset","other","TRUE"
702103,2103,"perdita d'esercizio ",20,"account_type_payable","payable",TRUE70"2103","2103","perdita d'esercizio ","20","account_type_asset","other","TRUE"
712104,2104,"prelevamenti extra gestione ",20,"account_type_view","other",TRUE71"2104","2104","prelevamenti extra gestione ","20","account_type_asset","other","TRUE"
722105,2105,"titolare c/ritenute subite ",20,"account_type_view","other",TRUE72"2105","2105","titolare c/ritenute subite ","20","account_type_asset","other","TRUE"
7322,22,"FONDI PER RISCHI E ONERI ",2,"account_type_view","view",TRUE73"22","22","FONDI PER RISCHI E ONERI ","2","account_type_view","view","TRUE"
742201,2201,"fondo per imposte ",22,"account_type_view","other",TRUE74"2201","2201","fondo per imposte ","22","account_type_asset","other","TRUE"
752204,2204,"fondo responsabilità civile ",22,"account_type_view","other",TRUE75"2204","2204","fondo responsabilità civile ","22","account_type_asset","other","TRUE"
762205,2205,"fondo spese future ",22,"account_type_view","other",TRUE76"2205","2205","fondo spese future ","22","account_type_asset","other","TRUE"
772211,2211,"fondo manutenzioni programmate ",22,"account_type_view","other",TRUE77"2211","2211","fondo manutenzioni programmate ","22","account_type_asset","other","TRUE"
7823,23,"TRATTAMENTO FINE RAPPORTO DI LAVORO ",2,"account_type_view","view",TRUE78"23","23","TRATTAMENTO FINE RAPPORTO DI LAVORO ","2","account_type_view","view","TRUE"
792301,2301,"debiti per TFRL ",23,"account_type_view","other",TRUE79"2301","2301","debiti per TFRL ","23","account_type_asset","other","TRUE"
8024,24,"DEBITI FINANZIARI ",2,"account_type_view","view",TRUE80"24","24","DEBITI FINANZIARI ","2","account_type_view","view","TRUE"
812410,2410,"mutui passivi ",24,"account_type_payable","other",TRUE81"2410","2410","mutui passivi ","24","account_type_asset","other","TRUE"
822411,2411,"banche c/sovvenzioni ",24,"account_type_payable","other",TRUE82"2411","2411","banche c/sovvenzioni ","24","account_type_asset","other","TRUE"
832420,2420,"banche c/c passivi ",24,"account_type_payable","other",TRUE83"2420","2420","banche c/c passivi ","24","account_type_asset","other","TRUE"
842421,2421,"banche c/RIBA all'incasso ",24,"account_type_payable","other",TRUE84"2421","2421","banche c/RIBA all'incasso ","24","account_type_asset","other","TRUE"
852422,2422,"banche c/cambiali all'incasso ",24,"account_type_payable","other",TRUE85"2422","2422","banche c/cambiali all'incasso ","24","account_type_asset","other","TRUE"
862423,2423,"banche c/anticipi su fatture ",24,"account_type_payable","other",TRUE86"2423","2423","banche c/anticipi su fatture ","24","account_type_asset","other","TRUE"
872440,2440,"debiti v/altri finanziatori ",24,"account_type_payable","other",TRUE87"2440","2440","debiti v/altri finanziatori ","24","account_type_asset","other","TRUE"
8825,25,"DEBITI COMMERCIALI ",2,"account_type_view","view",TRUE88"25","25","DEBITI COMMERCIALI ","2","account_type_view","view","TRUE"
892501,2501,"debiti v/fornitori ",25,"account_type_payable","payable",TRUE89"2501","2501","debiti v/fornitori ","25","account_type_payable","payable","TRUE"
902503,2503,"cambiali passive ",25,"account_type_payable","other",TRUE90"2503","2503","cambiali passive ","25","account_type_asset","other","TRUE"
912520,2520,"fatture da ricevere ",25,"account_type_payable","other",TRUE91"2520","2520","fatture da ricevere ","25","account_type_asset","other","TRUE"
922521,2521,"debiti da liquidare ",25,"account_type_payable","other",TRUE92"2521","2521","debiti da liquidare ","25","account_type_asset","other","TRUE"
932530,2530,"clienti c/acconti ",25,"account_type_payable","payable",TRUE93"2530","2530","clienti c/acconti ","25","account_type_payable","payable","TRUE"
9426,26,"DEBITI DIVERSI ",2,"account_type_view","view",TRUE94"26","26","DEBITI DIVERSI ","2","account_type_view","view","TRUE"
952601,2601,"IVA n/debito ",26,"account_type_payable","other",TRUE95"2601","2601","IVA n/debito ","26","account_type_tax","other","TRUE"
962602,2602,"debiti per ritenute da versare ",26,"account_type_payable","other",TRUE96"2602","2602","debiti per ritenute da versare ","26","account_type_tax","other","TRUE"
972605,2605,"erario c/IVA ",26,"account_type_payable","other",TRUE97"2605","2605","erario c/IVA ","26","account_type_tax","payable","TRUE"
982606,2606,"debiti per imposte ",26,"account_type_payable","other",TRUE98"2606","2606","debiti per imposte ","26","account_type_tax","other","TRUE"
992619,2619,"debiti per cauzioni ",26,"account_type_payable","other",TRUE99"2619","2619","debiti per cauzioni ","26","account_type_asset","other","TRUE"
1002620,2620,"personale c/retribuzioni ",26,"account_type_payable","other",TRUE100"2620","2620","personale c/retribuzioni ","26","account_type_asset","other","TRUE"
1012621,2621,"personale c/liquidazioni ",26,"account_type_payable","other",TRUE101"2621","2621","personale c/liquidazioni ","26","account_type_asset","other","TRUE"
1022622,2622,"clienti c/cessione ",26,"account_type_payable","other",TRUE102"2622","2622","clienti c/cessione ","26","account_type_asset","other","TRUE"
1032630,2630,"debiti v/istituti previdenziali ",26,"account_type_payable","other",TRUE103"2630","2630","debiti v/istituti previdenziali ","26","account_type_asset","other","TRUE"
1042640,2640,"creditori diversi ",26,"account_type_payable","payable",TRUE104"2640","2640","creditori diversi ","26","account_type_payable","payable","TRUE"
10527,27,"RATEI E RISCONTI PASSIVI ",2,"account_type_view","view",TRUE105"27","27","RATEI E RISCONTI PASSIVI ","2","account_type_view","view","TRUE"
1062701,2701,"ratei passivi ",27,"account_type_view","other",TRUE106"2701","2701","ratei passivi ","27","account_type_asset","other","TRUE"
1072702,2702,"risconti passivi ",27,"account_type_view","other",TRUE107"2702","2702","risconti passivi ","27","account_type_asset","other","TRUE"
10828,28,"CONTI TRANSITORI E DIVERSI ",2,"account_type_view","view",TRUE108"28","28","CONTI TRANSITORI E DIVERSI ","2","account_type_view","view","TRUE"
1092801,2801,"bilancio di apertura ",28,"account_type_view","other",TRUE109"2801","2801","bilancio di apertura ","28","account_type_asset","other","TRUE"
1102802,2802,"bilancio di chiusura ",28,"account_type_view","other",TRUE110"2802","2802","bilancio di chiusura ","28","account_type_asset","other","TRUE"
1112810,2810,"IVA c/liquidazioni ",28,"account_type_view","other",TRUE111"2810","2810","IVA c/liquidazioni ","28","account_type_asset","other","TRUE"
1122811,2811,"istituti previdenziali ",28,"account_type_view","other",TRUE112"2811","2811","istituti previdenziali ","28","account_type_asset","other","TRUE"
1132820,2820,"banca ... c/c ",28,"account_type_view","other",TRUE113"2820","2820","banca ... c/c ","28","account_type_asset","other","TRUE"
1142821,2821,"banca ... c/c ",28,"account_type_view","other",TRUE114"2821","2821","banca ... c/c ","28","account_type_asset","other","TRUE"
1152822,2822,"banca ... c/c ",28,"account_type_view","other",TRUE115"2822","2822","banca ... c/c ","28","account_type_asset","other","TRUE"
11629,29,"CONTI DEI SISTEMI SUPPLEMENTARI ",2,"account_type_view","view",TRUE116"29","29","CONTI DEI SISTEMI SUPPLEMENTARI ","2","account_type_view","view","TRUE"
1172901,2901,"beni di terzi ",29,"account_type_view","other",TRUE117"2901","2901","beni di terzi ","29","account_type_asset","other","TRUE"
1182902,2902,"depositanti beni ",29,"account_type_view","other",TRUE118"2902","2902","depositanti beni ","29","account_type_asset","other","TRUE"
1192911,2911,"merci da ricevere ",29,"account_type_view","other",TRUE119"2911","2911","merci da ricevere ","29","account_type_asset","other","TRUE"
1202912,2912,"fornitori c/impegni ",29,"account_type_view","other",TRUE120"2912","2912","fornitori c/impegni ","29","account_type_asset","other","TRUE"
1212913,2913,"impegni per beni in leasing ",29,"account_type_view","other",TRUE121"2913","2913","impegni per beni in leasing ","29","account_type_asset","other","TRUE"
1222914,2914,"creditori c/leasing ",29,"account_type_view","other",TRUE122"2914","2914","creditori c/leasing ","29","account_type_asset","other","TRUE"
1232916,2916,"clienti c/impegni ",29,"account_type_view","other",TRUE123"2916","2916","clienti c/impegni ","29","account_type_asset","other","TRUE"
1242917,2917,"merci da consegnare ",29,"account_type_view","other",TRUE124"2917","2917","merci da consegnare ","29","account_type_asset","other","TRUE"
1252921,2921,"rischi per effetti scontati ",29,"account_type_view","other",TRUE125"2921","2921","rischi per effetti scontati ","29","account_type_asset","other","TRUE"
1262922,2922,"banche c/effetti scontati ",29,"account_type_view","other",TRUE126"2922","2922","banche c/effetti scontati ","29","account_type_asset","other","TRUE"
1272926,2926,"rischi per fideiussioni ",29,"account_type_view","other",TRUE127"2926","2926","rischi per fideiussioni ","29","account_type_asset","other","TRUE"
1282927,2927,"creditori per fideiussioni ",29,"account_type_view","other",TRUE128"2927","2927","creditori per fideiussioni ","29","account_type_asset","other","TRUE"
1292931,2931,"rischi per avalli ",29,"account_type_view","other",TRUE129"2931","2931","rischi per avalli ","29","account_type_asset","other","TRUE"
1302932,2932,"creditori per avalli ",29,"account_type_view","other",TRUE130"2932","2932","creditori per avalli ","29","account_type_asset","other","TRUE"
1313,3,"VALORE DELLA PRODUZIONE ",0,"account_type_view","view",TRUE131"3","3","VALORE DELLA PRODUZIONE ","0","account_type_view","view","TRUE"
13231,31,"VENDITE E PRESTAZIONI ",3,"account_type_view","view",TRUE132"31","31","VENDITE E PRESTAZIONI ","3","account_type_view","view","TRUE"
1333101,3101,"merci c/vendite ",31,"account_type_income","other",TRUE133"3101","3101","merci c/vendite ","31","account_type_income","other","TRUE"
1343103,3103,"rimborsi spese di vendita ",31,"account_type_income","other",TRUE134"3103","3103","rimborsi spese di vendita ","31","account_type_income","other","TRUE"
1353110,3110,"resi su vendite ",31,"account_type_income","other",TRUE135"3110","3110","resi su vendite ","31","account_type_income","other","TRUE"
1363111,3111,"ribassi e abbuoni passivi ",31,"account_type_income","other",TRUE136"3111","3111","ribassi e abbuoni passivi ","31","account_type_income","other","TRUE"
1373112,3112,"premi su vendite ",31,"account_type_income","other",TRUE137"3112","3112","premi su vendite ","31","account_type_income","other","TRUE"
13832,32,"RICAVI E PROVENTI DIVERSI ",3,"account_type_view","view",TRUE138"32","32","RICAVI E PROVENTI DIVERSI ","3","account_type_view","view","TRUE"
1393201,3201,"fitti attivi ",32,"account_type_income","other",TRUE139"3201","3201","fitti attivi ","32","account_type_income","other","TRUE"
1403202,3202,"proventi vari ",32,"account_type_income","other",TRUE140"3202","3202","proventi vari ","32","account_type_income","other","TRUE"
1413210,3210,"arrotondamenti attivi ",32,"account_type_income","other",TRUE141"3210","3210","arrotondamenti attivi ","32","account_type_income","other","TRUE"
1423220,3220,"plusvalenze ordinarie diverse ",32,"account_type_income","other",TRUE142"3220","3220","plusvalenze ordinarie diverse ","32","account_type_income","other","TRUE"
1433230,3230,"sopravvenienze attive ordinarie diverse ",32,"account_type_income","other",TRUE143"3230","3230","sopravvenienze attive ordinarie diverse ","32","account_type_income","other","TRUE"
1443240,3240,"insussistenze attive ordinarie diverse ",32,"account_type_income","other",TRUE144"3240","3240","insussistenze attive ordinarie diverse ","32","account_type_income","other","TRUE"
1454,4,"COSTI DELLA PRODUZIONE ",0,"account_type_view","view",TRUE145"4","4","COSTI DELLA PRODUZIONE ","0","account_type_view","view","TRUE"
14641,41,"COSTO DEL VENDUTO ",4,"account_type_view","view",TRUE146"41","41","COSTO DEL VENDUTO ","4","account_type_view","view","TRUE"
1474101,4101,"merci c/acquisti ",41,"account_type_expense","other",TRUE147"4101","4101","merci c/acquisti ","41","account_type_expense","other","TRUE"
1484102,4102,"materie di consumo c/acquisti ",41,"account_type_expense","other",TRUE148"4102","4102","materie di consumo c/acquisti ","41","account_type_expense","other","TRUE"
1494105,4105,"merci c/apporti ",41,"account_type_expense","other",TRUE149"4105","4105","merci c/apporti ","41","account_type_expense","other","TRUE"
1504110,4110,"resi su acquisti ",41,"account_type_expense","other",TRUE150"4110","4110","resi su acquisti ","41","account_type_expense","other","TRUE"
1514111,4111,"ribassi e abbuoni attivi ",41,"account_type_expense","other",TRUE151"4111","4111","ribassi e abbuoni attivi ","41","account_type_expense","other","TRUE"
1524112,4112,"premi su acquisti ",41,"account_type_expense","other",TRUE152"4112","4112","premi su acquisti ","41","account_type_expense","other","TRUE"
1534121,4121,"merci c/esistenze iniziali ",41,"account_type_expense","other",TRUE153"4121","4121","merci c/esistenze iniziali ","41","account_type_expense","other","TRUE"
1544122,4122,"materie di consumo c/esistenze iniziali ",41,"account_type_expense","other",TRUE154"4122","4122","materie di consumo c/esistenze iniziali ","41","account_type_expense","other","TRUE"
1554131,4131,"merci c/rimanenze finali ",41,"account_type_expense","other",TRUE155"4131","4131","merci c/rimanenze finali ","41","account_type_expense","other","TRUE"
1564132,4132,"materie di consumo c/rimanenze finali ",41,"account_type_expense","other",TRUE156"4132","4132","materie di consumo c/rimanenze finali ","41","account_type_expense","other","TRUE"
15742,42,"COSTI PER SERVIZI ",4,"account_type_view","view",TRUE157"42","42","COSTI PER SERVIZI ","4","account_type_view","view","TRUE"
1584201,4201,"costi di trasporto ",42,"account_type_expense","other",TRUE158"4201","4201","costi di trasporto ","42","account_type_expense","other","TRUE"
1594202,4202,"costi per energia ",42,"account_type_expense","other",TRUE159"4202","4202","costi per energia ","42","account_type_expense","other","TRUE"
1604203,4203,"costi di pubblicità ",42,"account_type_expense","other",TRUE160"4203","4203","costi di pubblicità ","42","account_type_expense","other","TRUE"
1614204,4204,"costi di consulenze ",42,"account_type_expense","other",TRUE161"4204","4204","costi di consulenze ","42","account_type_expense","other","TRUE"
1624205,4205,"costi postali ",42,"account_type_expense","other",TRUE162"4205","4205","costi postali ","42","account_type_expense","other","TRUE"
1634206,4206,"costi telefonici ",42,"account_type_expense","other",TRUE163"4206","4206","costi telefonici ","42","account_type_expense","other","TRUE"
1644207,4207,"costi di assicurazione ",42,"account_type_expense","other",TRUE164"4207","4207","costi di assicurazione ","42","account_type_expense","other","TRUE"
1654208,4208,"costi di vigilanza ",42,"account_type_expense","other",TRUE165"4208","4208","costi di vigilanza ","42","account_type_expense","other","TRUE"
1664209,4209,"costi per i locali ",42,"account_type_expense","other",TRUE166"4209","4209","costi per i locali ","42","account_type_expense","other","TRUE"
1674210,4210,"costi di esercizio automezzi ",42,"account_type_expense","other",TRUE167"4210","4210","costi di esercizio automezzi ","42","account_type_expense","other","TRUE"
1684211,4211,"costi di manutenzione e riparazione ",42,"account_type_expense","other",TRUE168"4211","4211","costi di manutenzione e riparazione ","42","account_type_expense","other","TRUE"
1694212,4212,"provvigioni passive ",42,"account_type_expense","other",TRUE169"4212","4212","provvigioni passive ","42","account_type_expense","other","TRUE"
1704213,4213,"spese di incasso ",42,"account_type_expense","other",TRUE170"4213","4213","spese di incasso ","42","account_type_expense","other","TRUE"
17143,43,"COSTI PER GODIMENTO BENI DI TERZI ",4,"account_type_view","view",TRUE171"43","43","COSTI PER GODIMENTO BENI DI TERZI ","4","account_type_view","view","TRUE"
1724301,4301,"fitti passivi ",43,"account_type_expense","other",TRUE172"4301","4301","fitti passivi ","43","account_type_expense","other","TRUE"
1734302,4302,"canoni di leasing ",43,"account_type_expense","other",TRUE173"4302","4302","canoni di leasing ","43","account_type_expense","other","TRUE"
17444,44,"COSTI PER IL PERSONALE ",4,"account_type_view","view",TRUE174"44","44","COSTI PER IL PERSONALE ","4","account_type_view","view","TRUE"
1754401,4401,"salari e stipendi ",44,"account_type_expense","other",TRUE175"4401","4401","salari e stipendi ","44","account_type_expense","other","TRUE"
1764402,4402,"oneri sociali ",44,"account_type_expense","other",TRUE176"4402","4402","oneri sociali ","44","account_type_expense","other","TRUE"
1774403,4403,"TFRL ",44,"account_type_expense","other",TRUE177"4403","4403","TFRL ","44","account_type_expense","other","TRUE"
1784404,4404,"altri costi per il personale ",44,"account_type_expense","other",TRUE178"4404","4404","altri costi per il personale ","44","account_type_expense","other","TRUE"
17945,45,"AMMORTAMENTI IMMOBILIZZAZIONI IMMATERIALI ",4,"account_type_view","view",TRUE179"45","45","AMMORTAMENTI IMMOBILIZZAZIONI IMMATERIALI ","4","account_type_view","view","TRUE"
1804501,4501,"ammortamento costi di impianto ",45,"account_type_view","other",TRUE180"4501","4501","ammortamento costi di impianto ","45","account_type_p_l","other","TRUE"
1814506,4506,"ammortamento software ",45,"account_type_view","other",TRUE181"4506","4506","ammortamento software ","45","account_type_p_l","other","TRUE"
1824508,4508,"ammortamento avviamento ",45,"account_type_view","other",TRUE182"4508","4508","ammortamento avviamento ","45","account_type_p_l","other","TRUE"
18346,46,"AMMORTAMENTI IMMOBILIZZAZIONI MATERIALI ",4,"account_type_view","view",TRUE183"46","46","AMMORTAMENTI IMMOBILIZZAZIONI MATERIALI ","4","account_type_view","view","TRUE"
1844601,4601,"ammortamento fabbricati ",46,"account_type_view","other",TRUE184"4601","4601","ammortamento fabbricati ","46","account_type_p_l","other","TRUE"
1854602,4602,"ammortamento impianti e macchinari ",46,"account_type_view","other",TRUE185"4602","4602","ammortamento impianti e macchinari ","46","account_type_p_l","other","TRUE"
1864604,4604,"ammortamento attrezzature commerciali ",46,"account_type_view","other",TRUE186"4604","4604","ammortamento attrezzature commerciali ","46","account_type_p_l","other","TRUE"
1874605,4605,"ammortamento macchine d'ufficio ",46,"account_type_view","other",TRUE187"4605","4605","ammortamento macchine d'ufficio ","46","account_type_p_l","other","TRUE"
1884606,4606,"ammortamento arredamento ",46,"account_type_view","other",TRUE188"4606","4606","ammortamento arredamento ","46","account_type_p_l","other","TRUE"
1894607,4607,"ammortamento automezzi ",46,"account_type_view","other",TRUE189"4607","4607","ammortamento automezzi ","46","account_type_p_l","other","TRUE"
1904608,4608,"ammortamento imballaggi durevoli ",46,"account_type_view","other",TRUE190"4608","4608","ammortamento imballaggi durevoli ","46","account_type_p_l","other","TRUE"
19147,47,"SVALUTAZIONI ",4,"account_type_view","view",TRUE191"47","47","SVALUTAZIONI ","4","account_type_view","view","TRUE"
1924701,4701,"svalutazioni immobilizzazioni immateriali ",47,"account_type_view","other",TRUE192"4701","4701","svalutazioni immobilizzazioni immateriali ","47","account_type_p_l","other","TRUE"
1934702,4702,"svalutazioni immobilizzazioni materiali ",47,"account_type_view","other",TRUE193"4702","4702","svalutazioni immobilizzazioni materiali ","47","account_type_p_l","other","TRUE"
1944706,4706,"svalutazione crediti ",47,"account_type_view","other",TRUE194"4706","4706","svalutazione crediti ","47","account_type_p_l","other","TRUE"
19548,48,"ACCANTONAMENTI ",4,"account_type_view","view",TRUE195"48","48","ACCANTONAMENTI ","4","account_type_view","view","TRUE"
196481,481,"ACCANTONAMENTI PER RISCHI ",48,"account_type_view","view",TRUE196"481","481","ACCANTONAMENTI PER RISCHI ","48","account_type_view","view","TRUE"
1974814,4814,"accantonamento per responsabilità civile ",481,"account_type_view","other",TRUE197"4814","4814","accantonamento per responsabilità civile ","481","account_type_p_l","other","TRUE"
198482,482,"ALTRI ACCANTONAMENTI ",48,"account_type_view","view",TRUE198"482","482","ALTRI ACCANTONAMENTI ","48","account_type_view","view","TRUE"
1994821,4821,"accantonamento per spese future ",482,"account_type_view","other",TRUE199"4821","4821","accantonamento per spese future ","482","account_type_p_l","other","TRUE"
2004823,4823,"accantonamento per manutenzioni programmate ",482,"account_type_view","other",TRUE200"4823","4823","accantonamento per manutenzioni programmate ","482","account_type_p_l","other","TRUE"
20149,49,"ONERI DIVERSI ",4,"account_type_view","view",TRUE201"49","49","ONERI DIVERSI ","4","account_type_view","view","TRUE"
2024901,4901,"oneri fiscali diversi ",49,"account_type_view","other",TRUE202"4901","4901","oneri fiscali diversi ","49","account_type_p_l","other","TRUE"
2034903,4903,"oneri vari ",49,"account_type_view","other",TRUE203"4903","4903","oneri vari ","49","account_type_p_l","other","TRUE"
2044905,4905,"perdite su crediti ",49,"account_type_view","other",TRUE204"4905","4905","perdite su crediti ","49","account_type_p_l","other","TRUE"
2054910,4910,"arrotondamenti passivi ",49,"account_type_view","other",TRUE205"4910","4910","arrotondamenti passivi ","49","account_type_p_l","other","TRUE"
2064920,4920,"minusvalenze ordinarie diverse ",49,"account_type_view","other",TRUE206"4920","4920","minusvalenze ordinarie diverse ","49","account_type_p_l","other","TRUE"
2074930,4930,"sopravvenienze passive ordinarie diverse ",49,"account_type_view","other",TRUE207"4930","4930","sopravvenienze passive ordinarie diverse ","49","account_type_p_l","other","TRUE"
2084940,4940,"insussistenze passive ordinarie diverse ",49,"account_type_view","other",TRUE208"4940","4940","insussistenze passive ordinarie diverse ","49","account_type_p_l","other","TRUE"
2095,5,"PROVENTI E ONERI FINANZIARI ",0,"account_type_view","view",TRUE209"5","5","PROVENTI E ONERI FINANZIARI ","0","account_type_view","view","TRUE"
21051,51,"PROVENTI FINANZIARI ",5,"account_type_view","view",TRUE210"51","51","PROVENTI FINANZIARI ","5","account_type_view","view","TRUE"
2115110,5110,"interessi attivi v/clienti ",51,"account_type_view","other",TRUE211"5110","5110","interessi attivi v/clienti ","51","account_type_p_l","other","TRUE"
2125115,5115,"interessi attivi bancari ",51,"account_type_view","other",TRUE212"5115","5115","interessi attivi bancari ","51","account_type_p_l","other","TRUE"
2135116,5116,"interessi attivi postali ",51,"account_type_view","other",TRUE213"5116","5116","interessi attivi postali ","51","account_type_p_l","other","TRUE"
2145140,5140,"proventi finanziari diversi ",51,"account_type_view","other",TRUE214"5140","5140","proventi finanziari diversi ","51","account_type_p_l","other","TRUE"
21552,52,"ONERI FINANZIARI ",5,"account_type_view","view",TRUE215"52","52","ONERI FINANZIARI ","5","account_type_view","view","TRUE"
2165201,5201,"interessi passivi v/fornitori ",52,"account_type_view","other",TRUE216"5201","5201","interessi passivi v/fornitori ","52","account_type_p_l","other","TRUE"
2175202,5202,"interessi passivi bancari ",52,"account_type_view","other",TRUE217"5202","5202","interessi passivi bancari ","52","account_type_p_l","other","TRUE"
2185203,5203,"sconti passivi bancari ",52,"account_type_view","other",TRUE218"5203","5203","sconti passivi bancari ","52","account_type_p_l","other","TRUE"
2195210,5210,"interessi passivi su mutui ",52,"account_type_view","other",TRUE219"5210","5210","interessi passivi su mutui ","52","account_type_p_l","other","TRUE"
2205240,5240,"oneri finanziari diversi ",52,"account_type_view","other",TRUE220"5240","5240","oneri finanziari diversi ","52","account_type_p_l","other","TRUE"
2217,7,"PROVENTI E ONERI STRAORDINARI ",0,"account_type_view","view",TRUE221"7","7","PROVENTI E ONERI STRAORDINARI ","0","account_type_view","view","TRUE"
22271,71,"PROVENTI STRAORDINARI ",7,"account_type_view","view",TRUE222"71","71","PROVENTI STRAORDINARI ","7","account_type_view","view","TRUE"
2237101,7101,"plusvalenze straordinarie ",71,"account_type_view","other",TRUE223"7101","7101","plusvalenze straordinarie ","71","account_type_p_l","other","TRUE"
2247102,7102,"sopravvenienze attive straordinarie ",71,"account_type_view","other",TRUE224"7102","7102","sopravvenienze attive straordinarie ","71","account_type_p_l","other","TRUE"
2257103,7103,"insussistenze attive straordinarie ",71,"account_type_view","other",TRUE225"7103","7103","insussistenze attive straordinarie ","71","account_type_p_l","other","TRUE"
22672,72,"ONERI STRAORDINARI ",7,"account_type_view","view",TRUE226"72","72","ONERI STRAORDINARI ","7","account_type_view","view","TRUE"
2277201,7201,"minusvalenze straordinarie ",72,"account_type_view","other",TRUE227"7201","7201","minusvalenze straordinarie ","72","account_type_p_l","other","TRUE"
2287202,7202,"sopravvenienze passive straordinarie ",72,"account_type_view","other",TRUE228"7202","7202","sopravvenienze passive straordinarie ","72","account_type_p_l","other","TRUE"
2297203,7203,"insussistenze passive straordinarie ",72,"account_type_view","other",TRUE229"7203","7203","insussistenze passive straordinarie ","72","account_type_p_l","other","TRUE"
2307204,7204,"imposte esercizi precedenti ",72,"account_type_view","other",TRUE230"7204","7204","imposte esercizi precedenti ","72","account_type_p_l","other","TRUE"
23181,81,"IMPOSTE DELL'ESERCIZIO ",7,"account_type_view","view",TRUE231"8","8","IMPOSTE DELL'ESERCIZIO ","0","account_type_view","view","TRUE"
2328101,8101,"imposte dell'esercizio ",81,"account_type_view","other",TRUE232"8101","8101","imposte dell'esercizio ","8","account_type_p_l","other","TRUE"
23391,91,"CONTI DI RISULTATO ",7,"account_type_view","view",TRUE233"9","9","CONTI DI RISULTATO ","0","account_type_view","view","TRUE"
2349101,9101,"conto di risultato economico ",91,"account_type_view","other",TRUE234"9101","9101","conto di risultato economico ","9","account_type_p_l","other","TRUE"
235"9102","9102","stato patrimoniale","9","account_type_p_l","other","TRUE"
235236
=== modified file 'l10n_it/data/account.account.type.csv'
--- l10n_it/data/account.account.type.csv 2011-10-16 01:28:00 +0000
+++ l10n_it/data/account.account.type.csv 2011-11-23 14:06:29 +0000
@@ -1,11 +1,11 @@
1"id","code","name","close_method","report_type"1"id","code","name","close_method","report_type"
2"account_type_receivable","receivable","Debiti","unreconciled","liability"2"account_type_receivable","receivable","Crediti","unreconciled","asset"
3"account_type_payable","payable","Crediti","unreconciled","asset"3"account_type_payable","payable","Debiti","unreconciled","liability"
4"account_type_view","view","Gerarchia","none",4"account_type_view","view","Gerarchia","none",
5"account_type_income","income","Entrate","none","income"5"account_type_income","income","Entrate","none","income"
6"account_type_expense","expense","Uscite","none","expense"6"account_type_expense","expense","Uscite","none","expense"
7"account_type_tax","tax","Tasse","none",7"account_type_tax","tax","Tasse","balance",
8"account_type_cash","cash","Liquidità","balance","asset"8"account_type_cash","cash","Liquidità","balance","asset"
9"account_type_asset","asset","Beni","none","asset"9"account_type_asset","asset","Beni","balance","asset"
10"account_type_bank","bank","Banca","balance","asset"10"account_type_bank","bank","Banca","balance","asset"
11"account_type_equity","equity","Capitale","none","asset"11"account_type_p_l","p_l","Conto Economico","none",
1212
=== modified file 'l10n_it/data/account.tax.code.template.csv'
--- l10n_it/data/account.tax.code.template.csv 2011-01-14 00:11:01 +0000
+++ l10n_it/data/account.tax.code.template.csv 2011-11-23 14:06:29 +0000
@@ -26,6 +26,8 @@
26"IVC4Idet50","template_impcode_pagata_4det50","IVA a credito 4% detraibile 50% (imponibile)","template_impcode_pagata"26"IVC4Idet50","template_impcode_pagata_4det50","IVA a credito 4% detraibile 50% (imponibile)","template_impcode_pagata"
27"IVC20","template_ivacode_pagata_20","IVA a credito 20%","template_ivacode_pagata"27"IVC20","template_ivacode_pagata_20","IVA a credito 20%","template_ivacode_pagata"
28"IVC20I","template_impcode_pagata_20","IVA a credito 20% (imponibile)","template_impcode_pagata"28"IVC20I","template_impcode_pagata_20","IVA a credito 20% (imponibile)","template_impcode_pagata"
29"IVC21","template_ivacode_pagata_21","IVA a credito 21%","template_ivacode_pagata"
30"IVC21I","template_impcode_pagata_21","IVA a credito 21% (imponibile)","template_impcode_pagata"
29"IVC4","template_ivacode_pagata_4","IVA a credito 4%","template_ivacode_pagata"31"IVC4","template_ivacode_pagata_4","IVA a credito 4%","template_ivacode_pagata"
30"IVC4I","template_impcode_pagata_4","IVA a credito 4% (imponibile)","template_impcode_pagata"32"IVC4I","template_impcode_pagata_4","IVA a credito 4% (imponibile)","template_impcode_pagata"
31"IVC12","template_ivacode_pagata_12","IVA a credito 12%","template_ivacode_pagata"33"IVC12","template_ivacode_pagata_12","IVA a credito 12%","template_ivacode_pagata"
@@ -40,9 +42,21 @@
40"IVD10I","template_impcode_riscossa_10","IVA a debito 10% (imponibile)","template_impcode_riscossa"42"IVD10I","template_impcode_riscossa_10","IVA a debito 10% (imponibile)","template_impcode_riscossa"
41"IVD20","template_ivacode_riscossa_20","IVA a debito 20%","template_ivacode_riscossa"43"IVD20","template_ivacode_riscossa_20","IVA a debito 20%","template_ivacode_riscossa"
42"IVD20I","template_impcode_riscossa_20","IVA a debito 20% (imponibile)","template_impcode_riscossa"44"IVD20I","template_impcode_riscossa_20","IVA a debito 20% (imponibile)","template_impcode_riscossa"
45"IVD21","template_ivacode_riscossa_21","IVA a debito 21%","template_ivacode_riscossa"
46"IVD21I","template_impcode_riscossa_21","IVA a debito 21% (imponibile)","template_impcode_riscossa"
43"IVD4","template_ivacode_riscossa_4","IVA a debito 4%","template_ivacode_riscossa"47"IVD4","template_ivacode_riscossa_4","IVA a debito 4%","template_ivacode_riscossa"
44"IVD4I","template_impcode_riscossa_4","IVA a debito 4% (imponibile)","template_impcode_riscossa"48"IVD4I","template_impcode_riscossa_4","IVA a debito 4% (imponibile)","template_impcode_riscossa"
45"IVD12","template_ivacode_riscossa_12","IVA a debito 12%","template_ivacode_riscossa"49"IVD12","template_ivacode_riscossa_12","IVA a debito 12%","template_ivacode_riscossa"
46"IVD12I","template_impcode_riscossa_12","IVA a debito 12% (imponibile)","template_impcode_riscossa"50"IVD12I","template_impcode_riscossa_12","IVA a debito 12% (imponibile)","template_impcode_riscossa"
47"IVD2","template_ivacode_riscossa_2","IVA a debito 2%","template_ivacode_riscossa"51"IVD2","template_ivacode_riscossa_2","IVA a debito 2%","template_ivacode_riscossa"
48"IVD2I","template_impcode_riscossa_2","IVA a debito 2% (imponibile)","template_impcode_riscossa"52"IVD2I","template_impcode_riscossa_2","IVA a debito 2% (imponibile)","template_impcode_riscossa"
53"IVC21ind","template_ivacode_pagata_21ind","IVA a credito 21% indetraibile","template_ivacode_pagata"
54"IVC21Iind","template_impcode_pagata_21ind","IVA a credito 21% indetraibile (imponibile)","template_impcode_pagata"
55"IVC21det10","template_ivacode_pagata_21det10","IVA a credito 21% detraibile 10%","template_ivacode_pagata"
56"IVC21Idet10","template_impcode_pagata_21det10","IVA a credito 21% detraibile 10% (imponibile)","template_impcode_pagata"
57"IVC21det15","template_ivacode_pagata_21det15","IVA a credito 21% detraibile 15%","template_ivacode_pagata"
58"IVC21Idet15","template_impcode_pagata_21det15","IVA a credito 21% detraibile 15% (imponibile)","template_impcode_pagata"
59"IVC21det40","template_ivacode_pagata_21det40","IVA a credito 21% detraibile 40%","template_ivacode_pagata"
60"IVC21Idet40","template_impcode_pagata_21det40","IVA a credito 21% detraibile 40% (imponibile)","template_impcode_pagata"
61"IVC21det50","template_ivacode_pagata_21det50","IVA a credito 21% detraibile 50%","template_ivacode_pagata"
62"IVC21Idet50","template_impcode_pagata_21det50","IVA a credito 21% detraibile 50% (imponibile)","template_impcode_pagata"
4963
=== modified file 'l10n_it/data/account.tax.template.csv'
--- l10n_it/data/account.tax.template.csv 2011-01-14 00:11:01 +0000
+++ l10n_it/data/account.tax.template.csv 2011-11-23 14:06:29 +0000
@@ -1,40 +1,64 @@
1"id","description","chart_template_id:id","name","amount","parent_id:id","child_depend","type","account_collected_id:id","account_paid_id:id","type_tax_use","base_code_id:id","tax_code_id:id","ref_base_code_id:id","ref_tax_code_id:id"1id,description,chart_template_id:id,name,sequence,amount,parent_id:id,child_depend,type,account_collected_id:id,account_paid_id:id,type_tax_use,base_code_id:id,tax_code_id:id,ref_base_code_id:id,ref_tax_code_id:id,ref_base_sign,ref_tax_sign,price_include,base_sign,tax_sign
2"20a","20a","l10n_it_chart_template_generic","Iva al 20% (debito)","0.2",,"False","percent","2601","2601","sale","template_impcode_riscossa_20","template_ivacode_riscossa_20","template_impcode_riscossa_20","template_ivacode_riscossa_20"221a,21a,l10n_it_chart_template_generic,Iva al 21% (debito),,0.21,,False,percent,2601,2601,sale,template_impcode_riscossa_21,template_ivacode_riscossa_21,template_impcode_riscossa_21,template_ivacode_riscossa_21,-1,-1,False,,
3"20b","20b","l10n_it_chart_template_generic","Iva al 20% (credito)","0.2",,"False","percent","1601","1601","purchase","template_impcode_pagata_20","template_ivacode_pagata_20","template_impcode_pagata_20","template_ivacode_pagata_20"321b,21b,l10n_it_chart_template_generic,Iva al 21% (credito),,0.21,,False,percent,1601,1601,purchase,template_impcode_pagata_21,template_ivacode_pagata_21,template_impcode_pagata_21,template_ivacode_pagata_21,,,False,-1,-1
4"10a","10a","l10n_it_chart_template_generic","Iva al 10% (debito)","0.1",,"False","percent","2601","2601","sale","template_impcode_riscossa_10","template_ivacode_riscossa_10","template_impcode_riscossa_10","template_ivacode_riscossa_10"420a,20a,l10n_it_chart_template_generic,Iva al 20% (debito),,0.2,,False,percent,2601,2601,sale,template_impcode_riscossa_20,template_ivacode_riscossa_20,template_impcode_riscossa_20,template_ivacode_riscossa_20,-1,-1,False,,
5"10b","10b","l10n_it_chart_template_generic","Iva al 10% (credito)","0.1",,"False","percent","1601","1601","purchase","template_impcode_pagata_10","template_ivacode_pagata_10","template_impcode_pagata_10","template_ivacode_pagata_10"520b,20b,l10n_it_chart_template_generic,Iva al 20% (credito),,0.2,,False,percent,1601,1601,purchase,template_impcode_pagata_20,template_ivacode_pagata_20,template_impcode_pagata_20,template_ivacode_pagata_20,,,False,-1,-1
6"10AO","10AO","l10n_it_chart_template_generic","Iva al 10% indetraibile","1",,"True","percent",,,"purchase",,,,610a,10a,l10n_it_chart_template_generic,Iva al 10% (debito),,0.1,,False,percent,2601,2601,sale,template_impcode_riscossa_10,template_ivacode_riscossa_10,template_impcode_riscossa_10,template_ivacode_riscossa_10,-1,-1,False,,
7"10AOa","10AOa","l10n_it_chart_template_generic","Iva al 10% indetraibile (1)","0","10AO","False","percent","1601","1601","purchase","template_impcode_pagata_10ind","template_ivacode_pagata_10ind","template_impcode_pagata_10ind","template_ivacode_pagata_10ind"710b,10b,l10n_it_chart_template_generic,Iva al 10% (credito),,0.1,,False,percent,1601,1601,purchase,template_impcode_pagata_10,template_ivacode_pagata_10,template_impcode_pagata_10,template_ivacode_pagata_10,,,False,-1,-1
8"10AOb","10AOb","l10n_it_chart_template_generic","Iva al 10% indetraibile (2)","0.1","10AO","False","percent",,,"purchase",,,,810AO,10AO,l10n_it_chart_template_generic,Iva al 10% indetraibile,,0.1,,True,percent,,,purchase,template_impcode_pagata_10ind,,template_impcode_pagata_10ind,,,,False,-1,-1
9"12a","12a","l10n_it_chart_template_generic","Iva 12% (debito)","0.12",,"False","percent","2601","2601","sale","template_impcode_riscossa_12","template_ivacode_riscossa_12","template_impcode_riscossa_12","template_ivacode_riscossa_12"910AOa,10AOa,l10n_it_chart_template_generic,Iva al 10% indetraibile (D),2,0,10AO,False,balance,1601,1601,purchase,,template_ivacode_pagata_10ind,,template_ivacode_pagata_10ind,,,False,,
10"12b","12b","l10n_it_chart_template_generic","Iva 12% (credito)","0.12",,"False","percent","1601","1601","purchase","template_impcode_pagata_12","template_ivacode_pagata_12","template_impcode_pagata_12","template_ivacode_pagata_12"1010AOb,10AOb,l10n_it_chart_template_generic,Iva al 10% indetraibile (I),1,1,10AO,False,percent,,,purchase,,,,,,,False,,
11"2010","2010","l10n_it_chart_template_generic","Iva al 20% detraibile 10%","1",,"True","percent",,,"purchase",,,,1112a,12a,l10n_it_chart_template_generic,Iva 12% (debito),,0.12,,False,percent,2601,2601,sale,template_impcode_riscossa_12,template_ivacode_riscossa_12,template_impcode_riscossa_12,template_ivacode_riscossa_12,-1,-1,False,,
12"2010a","2010a","l10n_it_chart_template_generic","Iva al 20% detraibile 10% (1)","0.02","2010","False","percent","1601","1601","purchase","template_impcode_pagata_20det10","template_ivacode_pagata_20det10","template_impcode_pagata_20det10","template_ivacode_pagata_20det10"1212b,12b,l10n_it_chart_template_generic,Iva 12% (credito),,0.12,,False,percent,1601,1601,purchase,template_impcode_pagata_12,template_ivacode_pagata_12,template_impcode_pagata_12,template_ivacode_pagata_12,,,False,-1,-1
13"2010b","2010b","l10n_it_chart_template_generic","Iva al 20% detraibile 10% (2)","0.18","2010","False","percent",,,"purchase",,,,132010,2010,l10n_it_chart_template_generic,Iva al 20% detraibile 10%,,0.2,,True,percent,,,purchase,template_impcode_pagata_20det10,,template_impcode_pagata_20det10,,,,False,-1,-1
14"2015","2015","l10n_it_chart_template_generic","Iva al 20% detraibile 15%","1",,"True","percent",,,"purchase",,,,142010a,2010a,l10n_it_chart_template_generic,Iva al 20% detraibile 10% (D),2,0,2010,False,balance,1601,1601,purchase,,template_ivacode_pagata_20det10,,template_ivacode_pagata_20det10,,,False,,
15"2015a","2015a","l10n_it_chart_template_generic","Iva al 20% detraibile 15% (1)","0.03","2015","False","percent","1601","1601","purchase","template_impcode_pagata_20det15","template_ivacode_pagata_20det15","template_impcode_pagata_20det15","template_ivacode_pagata_20det15"152010b,2010b,l10n_it_chart_template_generic,Iva al 20% detraibile 10% (I),1,0.9,2010,False,percent,,,purchase,,,,,,,False,,
16"2015b","2015b","l10n_it_chart_template_generic","Iva al 20% detraibile 15% (2)","0.17","2015","False","percent",,,"purchase",,,,162015,2015,l10n_it_chart_template_generic,Iva al 20% detraibile 15%,,0.2,,True,percent,,,purchase,template_impcode_pagata_20det15,,template_impcode_pagata_20det15,,,,False,-1,-1
17"2040","2040","l10n_it_chart_template_generic","Iva al 20% detraibile 40%","1",,"True","percent",,,"purchase",,,,172015a,2015a,l10n_it_chart_template_generic,Iva al 20% detraibile 15% (D),2,0,2015,False,balance,1601,1601,purchase,,template_ivacode_pagata_20det15,,template_ivacode_pagata_20det15,,,False,,
18"2040a","2040a","l10n_it_chart_template_generic","Iva al 20% detraibile 40% (1)","0.08","2040","False","percent","1601","1601","purchase","template_impcode_pagata_20det40","template_ivacode_pagata_20det40","template_impcode_pagata_20det40","template_ivacode_pagata_20det40"182015b,2015b,l10n_it_chart_template_generic,Iva al 20% detraibile 15% (I),1,0.85,2015,False,percent,,,purchase,,,,,,,False,,
19"2040b","2040b","l10n_it_chart_template_generic","Iva al 20% detraibile 40% (2)","0.12","2040","False","percent",,,"purchase",,,,192040,2040,l10n_it_chart_template_generic,Iva al 20% detraibile 40%,,0.2,,True,percent,,,purchase,template_impcode_pagata_20det40,,template_impcode_pagata_20det40,,,,False,-1,-1
20"20AO","20AO","l10n_it_chart_template_generic","Iva al 20% indetraibile","1",,"True","percent",,,"purchase",,,,202040a,2040a,l10n_it_chart_template_generic,Iva al 20% detraibile 40% (D),2,0,2040,False,balance,1601,1601,purchase,,template_ivacode_pagata_20det40,,template_ivacode_pagata_20det40,,,False,,
21"20AOa","20AOa","l10n_it_chart_template_generic","Iva al 20% indetraibile (1)","0","20AO","False","percent","1601","1601","purchase","template_impcode_pagata_20ind","template_ivacode_pagata_20ind","template_impcode_pagata_20ind","template_ivacode_pagata_20ind"212040b,2040b,l10n_it_chart_template_generic,Iva al 20% detraibile 40% (I),1,0.6,2040,False,percent,,,purchase,,,,,,,False,,
22"20AOb","20AOb","l10n_it_chart_template_generic","Iva al 20% indetraibile (2)","0.2","20AO","False","percent",,,"purchase",,,,2220AO,20AO,l10n_it_chart_template_generic,Iva al 20% indetraibile,,0.2,,True,percent,,,purchase,template_impcode_pagata_20ind,,template_impcode_pagata_20ind,,,,False,-1,-1
23"20I5","20I5","l10n_it_chart_template_generic","IVA al 20% detraibile al 50%","1",,"True","percent",,,"purchase",,,,2320AOa,20AOa,l10n_it_chart_template_generic,Iva al 20% indetraibile (D),2,0,20AO,False,balance,1601,1601,purchase,,template_ivacode_pagata_20ind,,template_ivacode_pagata_20ind,,,False,,
24"20I5a","20I5a","l10n_it_chart_template_generic","IVA al 20% detraibile al 50% (1)","0.1","20I5","False","percent","1601","1601","purchase","template_impcode_pagata_20det50","template_ivacode_pagata_20det50","template_impcode_pagata_20det50","template_ivacode_pagata_20det50"2420AOb,20AOb,l10n_it_chart_template_generic,Iva al 20% indetraibile (I),1,1,20AO,False,percent,,,purchase,,,,,,,False,,
25"20I5b","20I5b","l10n_it_chart_template_generic","IVA al 20% detraibile al 50% (2)","0.1","20I5","False","percent",,,"purchase",,,,2520I5,20I5,l10n_it_chart_template_generic,IVA al 20% detraibile al 50%,,0.2,,True,percent,,,purchase,template_impcode_pagata_20det50,,template_impcode_pagata_20det50,,,,False,-1,-1
26"22a","22a","l10n_it_chart_template_generic","Iva 2% (debito)","0.02",,"False","percent","2601","2601","sale","template_impcode_riscossa_2","template_ivacode_riscossa_2","template_impcode_riscossa_2","template_ivacode_riscossa_2"2620I5b,20I5b,l10n_it_chart_template_generic,IVA al 20% detraibile al 50% (I),1,0.5,20I5,False,percent,,,purchase,,,,,,,False,,
27"22b","22b","l10n_it_chart_template_generic","Iva 2% (credito)","0.02",,"False","percent","1601","1601","purchase","template_impcode_pagata_2","template_ivacode_pagata_2","template_impcode_pagata_2","template_ivacode_pagata_2"2720I5a,20I5a,l10n_it_chart_template_generic,IVA al 20% detraibile al 50% (D),2,0,20I5,False,balance,1601,1601,purchase,,template_ivacode_pagata_20det50,,template_ivacode_pagata_20det50,,,False,,
28"4a","4a","l10n_it_chart_template_generic","Iva 4% (debito)","0.04",,"False","percent","2601","2601","sale","template_impcode_riscossa_4","template_ivacode_riscossa_4","template_impcode_riscossa_4","template_ivacode_riscossa_4"2822a,22a,l10n_it_chart_template_generic,Iva 2% (debito),,0.02,,False,percent,2601,2601,sale,template_impcode_riscossa_2,template_ivacode_riscossa_2,template_impcode_riscossa_2,template_ivacode_riscossa_2,-1,-1,False,,
29"4b","4b","l10n_it_chart_template_generic","Iva 4% (credito)","0.04",,"False","percent","1601","1601","purchase","template_impcode_pagata_4","template_ivacode_pagata_4","template_impcode_pagata_4","template_ivacode_pagata_4"2922b,22b,l10n_it_chart_template_generic,Iva 2% (credito),,0.02,,False,percent,1601,1601,purchase,template_impcode_pagata_2,template_ivacode_pagata_2,template_impcode_pagata_2,template_ivacode_pagata_2,,,False,-1,-1
30"4AO","4AO","l10n_it_chart_template_generic","Iva al 4% indetraibile","1",,"True","percent",,,"purchase",,,,304a,4a,l10n_it_chart_template_generic,Iva 4% (debito),,0.04,,False,percent,2601,2601,sale,template_impcode_riscossa_4,template_ivacode_riscossa_4,template_impcode_riscossa_4,template_ivacode_riscossa_4,-1,-1,False,,
31"4AOa","4AOa","l10n_it_chart_template_generic","Iva al 4% indetraibile (1)","0","4AO","False","percent","1601","1601","purchase","template_impcode_pagata_4ind","template_ivacode_pagata_4ind","template_impcode_pagata_4ind","template_ivacode_pagata_4ind"314b,4b,l10n_it_chart_template_generic,Iva 4% (credito),,0.04,,False,percent,1601,1601,purchase,template_impcode_pagata_4,template_ivacode_pagata_4,template_impcode_pagata_4,template_ivacode_pagata_4,,,False,-1,-1
32"4AOb","4AOb","l10n_it_chart_template_generic","Iva al 4% indetraibile (2)","0.04","4AO","False","percent",,,"purchase",,,,324AO,4AO,l10n_it_chart_template_generic,Iva al 4% indetraibile,,0.04,,True,percent,,,purchase,template_impcode_pagata_4ind,,template_impcode_pagata_4ind,,,,False,-1,-1
33"10I5","10I5","l10n_it_chart_template_generic","IVA al 10% detraibile al 50%","1",,"True","percent",,,"purchase",,,,334AOa,4AOa,l10n_it_chart_template_generic,Iva al 4% indetraibile (D),2,0,4AO,False,balance,1601,1601,purchase,,template_ivacode_pagata_4ind,,template_ivacode_pagata_4ind,,,False,,
34"10I5a","10I5a","l10n_it_chart_template_generic","IVA al 10% detraibile al 50% (1)","0.05","10I5","False","percent","1601","1601","purchase","template_impcode_pagata_10det50","template_ivacode_pagata_10det50","template_impcode_pagata_10det50","template_ivacode_pagata_10det50"344AOb,4AOb,l10n_it_chart_template_generic,Iva al 4% indetraibile (I),1,1,4AO,False,percent,,,purchase,,,,,,,False,,
35"10I5b","10I5b","l10n_it_chart_template_generic","IVA al 10% detraibile al 50% (2)","0.05","10I5","False","percent",,,"purchase",,,,3510I5,10I5,l10n_it_chart_template_generic,IVA al 10% detraibile al 50%,,0.1,,True,percent,,,purchase,template_impcode_pagata_10det50,,template_impcode_pagata_10det50,,,,False,-1,-1
36"4I5","4I5","l10n_it_chart_template_generic","IVA al 4% detraibile al 50%","1",,"True","percent",,,"purchase",,,,3610I5a,10I5a,l10n_it_chart_template_generic,IVA al 10% detraibile al 50% (D),2,0,10I5,False,balance,1601,1601,purchase,,template_ivacode_pagata_10det50,,template_ivacode_pagata_10det50,,,False,,
37"4I5a","4I5a","l10n_it_chart_template_generic","IVA al 4% detraibile al 50% (1)","0.02","4I5","False","percent","1601","1601","purchase","template_impcode_pagata_4det50","template_ivacode_pagata_4det50","template_impcode_pagata_4det50","template_ivacode_pagata_4det50"3710I5b,10I5b,l10n_it_chart_template_generic,IVA al 10% detraibile al 50% (I),1,0.5,10I5,False,percent,,,purchase,,,,,,,False,,
38"4I5b","4I5b","l10n_it_chart_template_generic","IVA al 4% detraibile al 50% (2)","0.02","4I5","False","percent",,,"purchase",,,,384I5,4I5,l10n_it_chart_template_generic,IVA al 4% detraibile al 50%,,0.04,,True,percent,,,purchase,template_impcode_pagata_4det50,,template_impcode_pagata_4det50,,,,False,-1,-1
39"00a","00a","l10n_it_chart_template_generic","Esente IVA (debito)","0",,"False","percent","2601","2601","sale","template_impcode_riscossa_0","template_ivacode_riscossa_0","template_impcode_riscossa_0","template_ivacode_riscossa_0"394I5a,4I5a,l10n_it_chart_template_generic,IVA al 4% detraibile al 50% (D),2,0,4I5,False,balance,1601,1601,purchase,,template_ivacode_pagata_4det50,,template_ivacode_pagata_4det50,,,False,,
40"00b","00b","l10n_it_chart_template_generic","Esente IVA (credito)","0",,"False","percent","1601","1601","purchase","template_impcode_pagata_0","template_ivacode_pagata_0","template_impcode_pagata_0","template_ivacode_pagata_0"404I5b,4I5b,l10n_it_chart_template_generic,IVA al 4% detraibile al 50% (I),1,0.5,4I5,False,percent,,,purchase,,,,,,,False,,
4100a,00a,l10n_it_chart_template_generic,Esente IVA (debito),,0,,False,percent,2601,2601,sale,template_impcode_riscossa_0,template_ivacode_riscossa_0,template_impcode_riscossa_0,template_ivacode_riscossa_0,-1,-1,False,,
4200b,00b,l10n_it_chart_template_generic,Esente IVA (credito),,0,,False,percent,1601,1601,purchase,template_impcode_pagata_0,template_ivacode_pagata_0,template_impcode_pagata_0,template_ivacode_pagata_0,,,False,-1,-1
4321a INC,21a INC,l10n_it_chart_template_generic,Iva al 21% (debito) INC,,0.21,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_21,l10n_it.template_ivacode_riscossa_21,l10n_it.template_impcode_riscossa_21,l10n_it.template_ivacode_riscossa_21,-1,-1,True,,
4420a INC,20a INC,l10n_it_chart_template_generic,Iva al 20% (debito) INC,,0.2,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_20,l10n_it.template_ivacode_riscossa_20,l10n_it.template_impcode_riscossa_20,l10n_it.template_ivacode_riscossa_20,-1,-1,True,,
4510a INC,10a INC,l10n_it_chart_template_generic,Iva al 10% (debito) INC,,0.1,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_10,l10n_it.template_ivacode_riscossa_10,l10n_it.template_impcode_riscossa_10,l10n_it.template_ivacode_riscossa_10,-1,-1,True,,
4612a INC,12a INC,l10n_it_chart_template_generic,Iva 12% (debito) INC,,0.12,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_12,l10n_it.template_ivacode_riscossa_12,l10n_it.template_impcode_riscossa_12,l10n_it.template_ivacode_riscossa_12,-1,-1,True,,
4722a INC,22a INC,l10n_it_chart_template_generic,Iva 2% (debito) INC,,0.02,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_2,l10n_it.template_ivacode_riscossa_2,l10n_it.template_impcode_riscossa_2,l10n_it.template_ivacode_riscossa_2,-1,-1,True,,
484a INC,4a INC,l10n_it_chart_template_generic,Iva 4% (debito) INC,,0.04,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_4,l10n_it.template_ivacode_riscossa_4,l10n_it.template_impcode_riscossa_4,l10n_it.template_ivacode_riscossa_4,-1,-1,True,,
4900a INC,00a INC,l10n_it_chart_template_generic,Esente IVA (debito) INC,,0,,False,percent,l10n_it.2601,l10n_it.2601,sale,l10n_it.template_impcode_riscossa_0,l10n_it.template_ivacode_riscossa_0,l10n_it.template_impcode_riscossa_0,l10n_it.template_ivacode_riscossa_0,-1,-1,True,,
502110,2110,l10n_it_chart_template_generic,Iva al 21% detraibile 10%,,0.21,,True,percent,,,purchase,template_impcode_pagata_21det10,,template_impcode_pagata_21det10,,,,False,-1,-1
512110a,2110a,l10n_it_chart_template_generic,Iva al 21% detraibile 10% (D),2,0,2110,False,balance,1601,1601,purchase,,template_ivacode_pagata_21det10,,template_ivacode_pagata_21det10,,,False,,
522110b,2110b,l10n_it_chart_template_generic,Iva al 21% detraibile 10% (I),1,0.9,2110,False,percent,,,purchase,,,,,,,False,,
532115,2115,l10n_it_chart_template_generic,Iva al 21% detraibile 15%,,0.21,,True,percent,,,purchase,template_impcode_pagata_21det15,,template_impcode_pagata_21det15,,,,False,-1,-1
542115a,2115a,l10n_it_chart_template_generic,Iva al 21% detraibile 15% (D),2,0,2115,False,balance,1601,1601,purchase,,template_ivacode_pagata_21det15,,template_ivacode_pagata_21det15,,,False,,
552115b,2115b,l10n_it_chart_template_generic,Iva al 21% detraibile 15% (I),1,0.85,2115,False,percent,,,purchase,,,,,,,False,,
562140,2140,l10n_it_chart_template_generic,Iva al 21% detraibile 40%,,0.21,,True,percent,,,purchase,template_impcode_pagata_21det40,,template_impcode_pagata_21det40,,,,False,-1,-1
572140a,2140a,l10n_it_chart_template_generic,Iva al 21% detraibile 40% (D),2,0,2140,False,balance,1601,1601,purchase,,template_ivacode_pagata_21det40,,template_ivacode_pagata_21det40,,,False,,
582140b,2140b,l10n_it_chart_template_generic,Iva al 21% detraibile 40% (I),1,0.6,2140,False,percent,,,purchase,,,,,,,False,,
5921AO,21AO,l10n_it_chart_template_generic,Iva al 21% indetraibile,,0.21,,True,percent,,,purchase,template_impcode_pagata_21ind,,template_impcode_pagata_21ind,,,,False,-1,-1
6021AOa,21AOa,l10n_it_chart_template_generic,Iva al 21% indetraibile (D),2,0,21AO,False,balance,1601,1601,purchase,,template_ivacode_pagata_21ind,,template_ivacode_pagata_21ind,,,False,,
6121AOb,21AOb,l10n_it_chart_template_generic,Iva al 21% indetraibile (I),1,1,21AO,False,percent,,,purchase,,,,,,,False,,
6221I5,21I5,l10n_it_chart_template_generic,IVA al 21% detraibile al 50%,,0.21,,True,percent,,,purchase,template_impcode_pagata_21det50,,template_impcode_pagata_21det50,,,,False,-1,-1
6321I5b,21I5b,l10n_it_chart_template_generic,IVA al 21% detraibile al 50% (I),1,0.5,21I5,False,percent,,,purchase,,,,,,,False,,
6421I5a,21I5a,l10n_it_chart_template_generic,IVA al 21% detraibile al 50% (D),2,0,21I5,False,balance,1601,1601,purchase,,template_ivacode_pagata_21det50,,template_ivacode_pagata_21det50,,,False,,
4165
=== modified file 'l10n_it/i18n/it.po'
--- l10n_it/i18n/it.po 2011-11-09 18:12:56 +0000
+++ l10n_it/i18n/it.po 2011-11-23 14:06:29 +0000
@@ -1,167 +1,28 @@
1# Italian translation for openobject-addons1# Translation of OpenERP Server.
2# Copyright (c) 2011 Rosetta Contributors and Canonical Ltd 20112# This file contains the translation of the following modules:
3# This file is distributed under the same license as the openobject-addons package.3# * l10n_it
4# FIRST AUTHOR <EMAIL@ADDRESS>, 2011.
5#4#
6msgid ""5msgid ""
7msgstr ""6msgstr ""
8"Project-Id-Version: openobject-addons\n"7"Project-Id-Version: OpenERP Server 6.0.2\n"
9"Report-Msgid-Bugs-To: FULL NAME <EMAIL@ADDRESS>\n"8"Report-Msgid-Bugs-To: support@openerp.com\n"
10"POT-Creation-Date: 2011-01-07 06:04+0000\n"9"POT-Creation-Date: 2011-08-11 20:06+0000\n"
11"PO-Revision-Date: 2011-02-15 15:37+0000\n"10"PO-Revision-Date: 2011-08-11 20:06+0000\n"
12"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"11"Last-Translator: <>\n"
13"Language-Team: Italian <it@li.org>\n"12"Language-Team: \n"
14"MIME-Version: 1.0\n"13"MIME-Version: 1.0\n"
15"Content-Type: text/plain; charset=UTF-8\n"14"Content-Type: text/plain; charset=UTF-8\n"
16"Content-Transfer-Encoding: 8bit\n"15"Content-Transfer-Encoding: \n"
17"X-Launchpad-Export-Date: 2011-11-05 05:57+0000\n"16"Plural-Forms: \n"
18"X-Generator: Launchpad (build 14231)\n"
19
20#. module: l10n_it
21#: model:ir.actions.report.xml,name:l10n_it.account_ita_libroIVA_debit
22msgid "Registro acquisti"
23msgstr "Registro acquisti"
24
25#. module: l10n_it
26#: model:ir.actions.todo,note:l10n_it.config_call_account_template_generic
27msgid ""
28"Generate Chart of Accounts from a Chart Template. You will be asked to pass "
29"the name of the company, the chart template to follow, the no. of digits to "
30"generate the code for your accounts and Bank account, currency to create "
31"Journals. Thus,the pure copy of chart Template is generated.\n"
32"\tThis is the same wizard that runs from Financial "
33"Management/Configuration/Financial Accounting/Financial Accounts/Generate "
34"Chart of Accounts from a Chart Template."
35msgstr ""
36"Genera il Piano dei Conti da un Modello. Vi verrà richiesto di passare il "
37"nome dell'azienda, il modello da seguire, il numero di decimali per generare "
38"il codice dei tuoi conti e, per il conto della Banca, la valuta per creare "
39"il Libro Giornale. Così una copia vergine del Piano dei Conti, derivatante "
40"dal modello, viene generata.\n"
41"\tQuesto è la stessa procedura automatica che viene lanciata da: Gestione "
42"Finanziaria / Configurazione / Contabilità / Conti finanziari / Genera il "
43"Piano dei conti da un modello."
44
45#. module: l10n_it
46#: view:account.report_libroiva:0
47msgid "Anno Fiscale"
48msgstr "Anno Fiscale"
49
50#. module: l10n_it
51#: model:account.fiscal.position.template,name:l10n_it.it
52msgid "Italia"
53msgstr "Italia"
54
55#. module: l10n_it
56#: report:l10n_it.report.libroIVA_credito:0
57#: report:l10n_it.report.libroIVA_debito:0
58msgid "REGISTRO IVA"
59msgstr "REGISTRO IVA"
60
61#. module: l10n_it
62#: report:l10n_it.report.libroIVA_credito:0
63#: report:l10n_it.report.libroIVA_debito:0
64msgid "Protocollo"
65msgstr "Protocollo"
66
67#. module: l10n_it
68#: model:account.fiscal.position.template,name:l10n_it.extra
69msgid "Regime Extra comunitario"
70msgstr "Regime Extra comunitario"
71
72#. module: l10n_it
73#: report:l10n_it.report.libroIVA_credito:0
74msgid "VENDITE"
75msgstr "VENDITE"
76
77#. module: l10n_it
78#: report:l10n_it.report.libroIVA_credito:0
79#: report:l10n_it.report.libroIVA_debito:0
80msgid "Aliquota"
81msgstr "Aliquota"
82
83#. module: l10n_it
84#: field:account.report_libroiva,company_id:0
85msgid "Company"
86msgstr "Azienda"
87
88#. module: l10n_it
89#: field:account.report_libroiva,name:0
90msgid "Fiscal year"
91msgstr "Anno fiscale"
92
93#. module: l10n_it
94#: report:l10n_it.report.libroIVA_credito:0
95#: report:l10n_it.report.libroIVA_debito:0
96msgid "Numero"
97msgstr "Numero"
98
99#. module: l10n_it
100#: report:l10n_it.report.libroIVA_debito:0
101msgid "Fornitore"
102msgstr "Fornitore"
103
104#. module: l10n_it
105#: report:l10n_it.report.libroIVA_debito:0
106msgid "ACQUISTI"
107msgstr "ACQUISTI"
10817
109#. module: l10n_it18#. module: l10n_it
110#: model:ir.module.module,description:l10n_it.module_meta_information19#: model:ir.module.module,description:l10n_it.module_meta_information
111msgid ""20msgid "\n"
112"\n"21" Piano dei conti italiano di un'impresa generica\n"
113" Piano dei conti italiano di un'impresa generica\n"22" "
114" "23msgstr "\n"
115msgstr ""24" Piano dei conti italiano di un'impresa generica\n"
116"\n"25" "
117" Piano dei conti italiano di un'impresa generica\n"
118" "
119
120#. module: l10n_it
121#: report:l10n_it.report.libroIVA_credito:0
122msgid "Cliente"
123msgstr "Cliente"
124
125#. module: l10n_it
126#: model:ir.actions.report.xml,name:l10n_it.account_ita_libroIVA_credit
127msgid "Registro vendite"
128msgstr "Registro vendite"
129
130#. module: l10n_it
131#: report:l10n_it.report.libroIVA_credito:0
132#: report:l10n_it.report.libroIVA_debito:0
133msgid "Periodo"
134msgstr "Periodo"
135
136#. module: l10n_it
137#: view:account.report_libroiva:0
138#: model:ir.actions.act_window,name:l10n_it.l10n_chart_it_report_libroIVA_action
139#: model:ir.ui.menu,name:l10n_it.menu_report_l10n_chart_it_libroIVA
140msgid "Registri IVA"
141msgstr "Registri IVA"
142
143#. module: l10n_it
144#: report:l10n_it.report.libroIVA_credito:0
145#: report:l10n_it.report.libroIVA_debito:0
146msgid "Imposta"
147msgstr "Imposta"
148
149#. module: l10n_it
150#: model:account.fiscal.position.template,name:l10n_it.intra
151msgid "Regime Intra comunitario"
152msgstr "Regime Intra comunitario"
153
154#. module: l10n_it
155#: report:l10n_it.report.libroIVA_credito:0
156#: report:l10n_it.report.libroIVA_debito:0
157msgid "Data fattura"
158msgstr "Data fattura"
159
160#. module: l10n_it
161#: report:l10n_it.report.libroIVA_credito:0
162#: report:l10n_it.report.libroIVA_debito:0
163msgid "Imponibile"
164msgstr "Imponibile"
16526
166#. module: l10n_it27#. module: l10n_it
167#: model:ir.module.module,shortdesc:l10n_it.module_meta_information28#: model:ir.module.module,shortdesc:l10n_it.module_meta_information
@@ -169,6 +30,14 @@
169msgstr "Italia - Piano dei conti generico"30msgstr "Italia - Piano dei conti generico"
17031
171#. module: l10n_it32#. module: l10n_it
172#: model:ir.model,name:l10n_it.model_account_report_libroiva33#: model:ir.actions.todo,note:l10n_it.config_call_account_template_generic
173msgid "SQL view for libro IVA"34msgid "Generate Chart of Accounts from a Chart Template. You will be asked to pass the name of the company, the chart template to follow, the no. of digits to generate the code for your accounts and Bank account, currency to create Journals. Thus,the pure copy of chart Template is generated.\n"
174msgstr "Vista SQL per registro IVA"35" This is the same wizard that runs from Financial Management/Configuration/Financial Accounting/Financial Accounts/Generate Chart of Accounts from a Chart Template."
36msgstr "Genera il piano dei conti da un template. Verrà chiesto di indicare il nome dell'azienda, il piano dei conti da seguire, il numero di cifre per generare il codice dei conti, la valuta per creare i sezionali. Quindi, una semplice copia del template verrà generata.\n"
37" Questo è lo stesso wizard che viene eseguito da Contabilità/Configurazione/Contabilità Generale/Assetto finanziario della nuova azienda"
38
39#. module: l10n_it
40#: model:ir.model,name:l10n_it.model_account_tax
41msgid "account.tax"
42msgstr "account.tax"
43
17544
=== modified file 'l10n_it/i18n/l10n_it.pot'
--- l10n_it/i18n/l10n_it.pot 2011-01-07 07:09:43 +0000
+++ l10n_it/i18n/l10n_it.pot 2011-11-23 14:06:29 +0000
@@ -4,10 +4,10 @@
4#4#
5msgid ""5msgid ""
6msgstr ""6msgstr ""
7"Project-Id-Version: OpenERP Server 6.0.0-rc2\n"7"Project-Id-Version: OpenERP Server 6.0.2\n"
8"Report-Msgid-Bugs-To: support@openerp.com\n"8"Report-Msgid-Bugs-To: support@openerp.com\n"
9"POT-Creation-Date: 2011-01-07 06:04:30+0000\n"9"POT-Creation-Date: 2011-08-11 20:06+0000\n"
10"PO-Revision-Date: 2011-01-07 06:04:30+0000\n"10"PO-Revision-Date: 2011-08-11 20:06+0000\n"
11"Last-Translator: <>\n"11"Last-Translator: <>\n"
12"Language-Team: \n"12"Language-Team: \n"
13"MIME-Version: 1.0\n"13"MIME-Version: 1.0\n"
@@ -16,81 +16,6 @@
16"Plural-Forms: \n"16"Plural-Forms: \n"
1717
18#. module: l10n_it18#. module: l10n_it
19#: model:ir.actions.report.xml,name:l10n_it.account_ita_libroIVA_debit
20msgid "Registro acquisti"
21msgstr ""
22
23#. module: l10n_it
24#: model:ir.actions.todo,note:l10n_it.config_call_account_template_generic
25msgid "Generate Chart of Accounts from a Chart Template. You will be asked to pass the name of the company, the chart template to follow, the no. of digits to generate the code for your accounts and Bank account, currency to create Journals. Thus,the pure copy of chart Template is generated.\n"
26" This is the same wizard that runs from Financial Management/Configuration/Financial Accounting/Financial Accounts/Generate Chart of Accounts from a Chart Template."
27msgstr ""
28
29#. module: l10n_it
30#: view:account.report_libroiva:0
31msgid "Anno Fiscale"
32msgstr ""
33
34#. module: l10n_it
35#: model:account.fiscal.position.template,name:l10n_it.it
36msgid "Italia"
37msgstr ""
38
39#. module: l10n_it
40#: report:l10n_it.report.libroIVA_credito:0
41#: report:l10n_it.report.libroIVA_debito:0
42msgid "REGISTRO IVA"
43msgstr ""
44
45#. module: l10n_it
46#: report:l10n_it.report.libroIVA_credito:0
47#: report:l10n_it.report.libroIVA_debito:0
48msgid "Protocollo"
49msgstr ""
50
51#. module: l10n_it
52#: model:account.fiscal.position.template,name:l10n_it.extra
53msgid "Regime Extra comunitario"
54msgstr ""
55
56#. module: l10n_it
57#: report:l10n_it.report.libroIVA_credito:0
58msgid "VENDITE"
59msgstr ""
60
61#. module: l10n_it
62#: report:l10n_it.report.libroIVA_credito:0
63#: report:l10n_it.report.libroIVA_debito:0
64msgid "Aliquota"
65msgstr ""
66
67#. module: l10n_it
68#: field:account.report_libroiva,company_id:0
69msgid "Company"
70msgstr ""
71
72#. module: l10n_it
73#: field:account.report_libroiva,name:0
74msgid "Fiscal year"
75msgstr ""
76
77#. module: l10n_it
78#: report:l10n_it.report.libroIVA_credito:0
79#: report:l10n_it.report.libroIVA_debito:0
80msgid "Numero"
81msgstr ""
82
83#. module: l10n_it
84#: report:l10n_it.report.libroIVA_debito:0
85msgid "Fornitore"
86msgstr ""
87
88#. module: l10n_it
89#: report:l10n_it.report.libroIVA_debito:0
90msgid "ACQUISTI"
91msgstr ""
92
93#. module: l10n_it
94#: model:ir.module.module,description:l10n_it.module_meta_information19#: model:ir.module.module,description:l10n_it.module_meta_information
95msgid "\n"20msgid "\n"
96" Piano dei conti italiano di un'impresa generica\n"21" Piano dei conti italiano di un'impresa generica\n"
@@ -98,58 +23,18 @@
98msgstr ""23msgstr ""
9924
100#. module: l10n_it25#. module: l10n_it
101#: report:l10n_it.report.libroIVA_credito:0
102msgid "Cliente"
103msgstr ""
104
105#. module: l10n_it
106#: model:ir.actions.report.xml,name:l10n_it.account_ita_libroIVA_credit
107msgid "Registro vendite"
108msgstr ""
109
110#. module: l10n_it
111#: report:l10n_it.report.libroIVA_credito:0
112#: report:l10n_it.report.libroIVA_debito:0
113msgid "Periodo"
114msgstr ""
115
116#. module: l10n_it
117#: view:account.report_libroiva:0
118#: model:ir.actions.act_window,name:l10n_it.l10n_chart_it_report_libroIVA_action
119#: model:ir.ui.menu,name:l10n_it.menu_report_l10n_chart_it_libroIVA
120msgid "Registri IVA"
121msgstr ""
122
123#. module: l10n_it
124#: report:l10n_it.report.libroIVA_credito:0
125#: report:l10n_it.report.libroIVA_debito:0
126msgid "Imposta"
127msgstr ""
128
129#. module: l10n_it
130#: model:account.fiscal.position.template,name:l10n_it.intra
131msgid "Regime Intra comunitario"
132msgstr ""
133
134#. module: l10n_it
135#: report:l10n_it.report.libroIVA_credito:0
136#: report:l10n_it.report.libroIVA_debito:0
137msgid "Data fattura"
138msgstr ""
139
140#. module: l10n_it
141#: report:l10n_it.report.libroIVA_credito:0
142#: report:l10n_it.report.libroIVA_debito:0
143msgid "Imponibile"
144msgstr ""
145
146#. module: l10n_it
147#: model:ir.module.module,shortdesc:l10n_it.module_meta_information26#: model:ir.module.module,shortdesc:l10n_it.module_meta_information
148msgid "Italy - Generic Chart of Accounts"27msgid "Italy - Generic Chart of Accounts"
149msgstr ""28msgstr ""
15029
151#. module: l10n_it30#. module: l10n_it
152#: model:ir.model,name:l10n_it.model_account_report_libroiva31#: model:ir.actions.todo,note:l10n_it.config_call_account_template_generic
153msgid "SQL view for libro IVA"32msgid "Generate Chart of Accounts from a Chart Template. You will be asked to pass the name of the company, the chart template to follow, the no. of digits to generate the code for your accounts and Bank account, currency to create Journals. Thus,the pure copy of chart Template is generated.\n"
33" This is the same wizard that runs from Financial Management/Configuration/Financial Accounting/Financial Accounts/Generate Chart of Accounts from a Chart Template."
34msgstr ""
35
36#. module: l10n_it
37#: model:ir.model,name:l10n_it.model_account_tax
38msgid "account.tax"
154msgstr ""39msgstr ""
15540
15641
=== removed file 'l10n_it/libroIVA.py'
--- l10n_it/libroIVA.py 2011-01-14 00:11:01 +0000
+++ l10n_it/libroIVA.py 1970-01-01 00:00:00 +0000
@@ -1,54 +0,0 @@
1# -*- encoding: utf-8 -*-
2##############################################################################
3#
4# OpenERP, Open Source Management Solution
5# Copyright (C) 2010
6# Italian OpenERP Community (<http://www.openerp-italia.com>)
7# Servabit srl
8# Agile Business Group sagl
9# Domsense srl
10#
11# This program is free software: you can redistribute it and/or modify
12# it under the terms of the GNU Affero General Public License as
13# published by the Free Software Foundation, either version 3 of the
14# License, or (at your option) any later version.
15#
16# This program is distributed in the hope that it will be useful,
17# but WITHOUT ANY WARRANTY; without even the implied warranty of
18# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19# GNU Affero General Public License for more details.
20#
21# You should have received a copy of the GNU Affero General Public License
22# along with this program. If not, see <http://www.gnu.org/licenses/>.
23#
24##############################################################################
25
26
27# ##################################################################################
28# Questa vista SQL viene usata solo per far scegliere l'anno di pianificazione all'utente
29# Viene infatti costruita una vista XML di tipo tree che contiene solo i diversi anni per i quali stata fatta almeno una pianificazione
30# ##################################################################################
31
32from osv import fields, osv
33
34class l10n_chart_it_report_libroIVA (osv.osv):
35 _name = "account.report_libroiva"
36 _description = "SQL view for libro IVA"
37 _auto = False
38 _rec_name = "name"
39 #_order = "fiscal_year";
40
41 _columns = {
42 'name': fields.char('Fiscal year',size=64),
43 'company_id': fields.many2one('res.company', 'Company'),
44 }
45
46 def init (self, cr) :
47 cr.execute("""DROP VIEW IF EXISTS account_report_libroiva""")
48 cr.execute("""
49 CREATE VIEW account_report_libroiva AS (
50 SELECT id, name, company_id FROM account_fiscalyear
51 )""")
52l10n_chart_it_report_libroIVA()
53
54
550
=== removed file 'l10n_it/libroIVA_menu.xml'
--- l10n_it/libroIVA_menu.xml 2011-01-14 00:11:01 +0000
+++ l10n_it/libroIVA_menu.xml 1970-01-01 00:00:00 +0000
@@ -1,16 +0,0 @@
1<?xml version="1.0" encoding="utf-8"?>
2<!DOCTYPE terp SYSTEM "openerp-view.dtd">
3<openerp>
4 <data>
5
6 <!-- ****************************
7 MENU REPORT LIBRI IVA
8 **************************** -->
9 <menuitem name="Registri IVA"
10 id="menu_report_l10n_chart_it_libroIVA"
11 sequence="20"
12 parent="account.menu_finance_reporting"
13 action="l10n_chart_it_report_libroIVA_action"
14 />
15 </data>
16</openerp>
170
=== removed file 'l10n_it/libroIVA_view.xml'
--- l10n_it/libroIVA_view.xml 2011-01-14 00:11:01 +0000
+++ l10n_it/libroIVA_view.xml 1970-01-01 00:00:00 +0000
@@ -1,47 +0,0 @@
1<?xml version="1.0" encoding="utf-8"?>
2<openerp>
3 <data>
4
5 <!-- ****************************
6 REGISTRI IVA TREE VIEW
7 ****************************-->
8 <record model="ir.ui.view" id="l10n_chart_it_report_libroIVA_tree">
9 <field name="name">l10n_chart_it_report_libroIVA_tree</field>
10 <field name="model">account.report_libroiva</field>
11 <field name="type">tree</field>
12 <field name="arch" type="xml">
13 <tree string="Registri IVA" limit="80">
14 <field name="name" string="Anno Fiscale" readonly="True" select="1" />
15 </tree>
16 </field>
17 </record>
18
19
20 <!-- ****************************
21 REGISTRI IVA FORM VIEW
22 ****************************-->
23 <record model="ir.ui.view" id="l10n_chart_it_report_libroIVA_form">
24 <field name="name">l10n_chart_it_report_libroIVA_form</field>
25 <field name="model">account.report_libroiva</field>
26 <field name="type">form</field>
27 <field name="arch" type="xml">
28 <form string="Registri IVA" >
29 <field name="name" string="Anno Fiscale" readonly="True" />
30 </form>
31 </field>
32 </record>
33
34 <!-- ****************************
35 REGISTRI IVA ACTION
36 ****************************-->
37 <record model="ir.actions.act_window" id="l10n_chart_it_report_libroIVA_action">
38 <field name="name">Registri IVA</field>
39 <field name="res_model">account.report_libroiva</field>
40 <field name="view_id" ref="l10n_chart_it_report_libroIVA_tree"/>
41 <field name="view_type">form</field>
42 <field name="view_mode">tree,form</field>
43 </record>
44
45
46 </data>
47</openerp>
480
=== removed directory 'l10n_it/report'
=== removed file 'l10n_it/report.xml'
--- l10n_it/report.xml 2011-01-14 00:11:01 +0000
+++ l10n_it/report.xml 1970-01-01 00:00:00 +0000
@@ -1,24 +0,0 @@
1<?xml version="1.0" encoding="utf-8"?>
2<openerp>
3 <data>
4
5 <report name="l10n_it.report.libroIVA_credito"
6 id="account_ita_libroIVA_credit"
7 string="Registro vendite"
8 model="account.report_libroiva"
9 rml="addons/l10n_it/report/libroIVA_credito.rml"
10 auto="False"
11 header="False"
12 />
13
14 <report name="l10n_it.report.libroIVA_debito"
15 id="account_ita_libroIVA_debit"
16 string="Registro acquisti"
17 model="account.report_libroiva"
18 rml="addons/l10n_it/report/libroIVA_debito.rml"
19 auto="False"
20 header="False"
21 />
22
23 </data>
24</openerp>
250
=== removed file 'l10n_it/report/__init__.py'
--- l10n_it/report/__init__.py 2011-01-14 00:11:01 +0000
+++ l10n_it/report/__init__.py 1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
1import libroIVA_credito
2import libroIVA_debito
3\ No newline at end of file0\ No newline at end of file
41
=== removed file 'l10n_it/report/libroIVA_credito.py'
--- l10n_it/report/libroIVA_credito.py 2011-01-14 00:11:01 +0000
+++ l10n_it/report/libroIVA_credito.py 1970-01-01 00:00:00 +0000
@@ -1,79 +0,0 @@
1import datetime
2import time
3from report import report_sxw
4from osv import osv
5import pooler
6
7
8class l10n_chart_it_report_libroIVA_credito(report_sxw.rml_parse):
9
10 def __init__(self, cr, uid, name, context):
11 super(l10n_chart_it_report_libroIVA_credito,self).__init__(cr,uid,name,context)
12 self.localcontext.update({
13 'time' : time,
14 'get_company' : self.get_company,
15 'get_periods' : self.get_periods,
16 'get_lines' : self.get_lines,
17 })
18
19
20 def get_company(self,fiscal_year):
21 #print 'COMP = ',fiscal_year
22 return ""
23
24 def get_periods(self,fiscal_year):
25 #print 'Fiscal year id:',fiscal_year.id
26 obj=pooler.get_pool(self.cr.dbname).get('account.fiscalyear')
27 fy=obj.browse(self.cr,self.uid,fiscal_year.id)
28 #print 'Periods = ',fy.period_ids
29 res=[rec for rec in fy.period_ids]
30 #return fy.periods => non funziona?!? bool object !?!?
31 return res
32
33 def get_invoices(self,period):
34 #print 'PERIOD = ',period.name
35 obj=pooler.get_pool(self.cr.dbname).get('account.invoice')
36 # Selezione tutte le fatture emesse nel periodo
37 self.cr.execute( """
38 SELECT id FROM account_invoice
39 WHERE (state='open' OR state='paid') AND
40 period_id="""+str(period.id)+"""
41 AND (type='out_invoice' OR type='out_refund')
42 """)
43 ids=self.cr.fetchall()
44 #print 'IDS = ',
45 if ids:
46 ids=[id[0] for id in ids ]
47 invoices=obj.browse(self.cr,self.uid,ids)
48 #print 'INVOICES = ',invoices
49 return invoices
50
51 def get_lines(self,fiscal_year):
52 res=[]
53 obj_fy=pooler.get_pool(self.cr.dbname).get('account.fiscalyear')
54 fy=obj_fy.browse(self.cr,self.uid,fiscal_year.id)
55 for period in fy.period_ids:
56 invoices=self.get_invoices(period)
57 for invoice in invoices:
58 d={'periodo': period.name}
59 d['protocollo']=invoice.number
60 #print 'PARTNER ',invoice.partner_id.name
61 causale=invoice.partner_id.name
62 #print 'CAUSALE = ',causale
63 d['causale']=causale
64 d['numero']=invoice.reference
65 d['data_doc']=invoice.date_invoice
66 for tax in invoice.tax_line:
67 #print '\tTAX: ',tax
68 d['aliquota']=tax.tax_code_id.name
69 d['imponibile']=tax.base
70 d['imposta']=tax.amount
71 res.append(d)
72 d={'periodo':'', 'protocollo':'', 'causale':'', 'numero':'', 'data_doc':'', }
73 return res
74
75
76
77report_sxw.report_sxw('report.l10n_it.report.libroIVA_credito','account.report_libroiva',
78 'l10n_it/report/libroIVA_credito.rml',
79 parser=l10n_chart_it_report_libroIVA_credito,header=False)
800
=== removed file 'l10n_it/report/libroIVA_credito.rml'
--- l10n_it/report/libroIVA_credito.rml 2011-01-14 00:11:01 +0000
+++ l10n_it/report/libroIVA_credito.rml 1970-01-01 00:00:00 +0000
@@ -1,203 +0,0 @@
1<?xml version="1.0"?>
2<document filename="test.pdf">
3 <template pageSize="(612.0,792.0)" title="Test" author="Martin Simon" allowSplitting="20">
4 <pageTemplate id="first">
5 <frame id="first" x1="57.0" y1="57.0" width="498" height="678"/>
6 </pageTemplate>
7 </template>
8 <stylesheet>
9 <blockTableStyle id="Standard_Outline">
10 <blockAlignment value="LEFT"/>
11 <blockValign value="TOP"/>
12 </blockTableStyle>
13 <blockTableStyle id="Table1">
14 <blockAlignment value="LEFT"/>
15 <blockValign value="TOP"/>
16 </blockTableStyle>
17 <blockTableStyle id="Table2">
18 <blockAlignment value="LEFT"/>
19 <blockValign value="TOP"/>
20 <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
21 <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
22 <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
23 <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
24 <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
25 <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
26 <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
27 <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
28 <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
29 <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
30 <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
31 <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
32 <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
33 <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
34 <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
35 <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,0" stop="5,-1"/>
36 <lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
37 <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
38 <lineStyle kind="LINEBEFORE" colorName="#000000" start="6,0" stop="6,-1"/>
39 <lineStyle kind="LINEABOVE" colorName="#000000" start="6,0" stop="6,0"/>
40 <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
41 <lineStyle kind="LINEBEFORE" colorName="#000000" start="7,0" stop="7,-1"/>
42 <lineStyle kind="LINEAFTER" colorName="#000000" start="7,0" stop="7,-1"/>
43 <lineStyle kind="LINEABOVE" colorName="#000000" start="7,0" stop="7,0"/>
44 <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
45 <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,1" stop="0,-1"/>
46 <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
47 <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,1" stop="1,-1"/>
48 <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
49 <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,1" stop="2,-1"/>
50 <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
51 <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,1" stop="3,-1"/>
52 <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
53 <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,1" stop="4,-1"/>
54 <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
55 <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,1" stop="5,-1"/>
56 <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
57 <lineStyle kind="LINEBEFORE" colorName="#000000" start="6,1" stop="6,-1"/>
58 <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
59 <lineStyle kind="LINEBEFORE" colorName="#000000" start="7,1" stop="7,-1"/>
60 <lineStyle kind="LINEAFTER" colorName="#000000" start="7,1" stop="7,-1"/>
61 <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
62 <blockBackground colorName="#ffcc99" start="0,0" stop="0,-1"/>
63 <blockBackground colorName="#ffcc99" start="1,0" stop="1,-1"/>
64 <blockBackground colorName="#ffcc99" start="2,0" stop="2,-1"/>
65 <blockBackground colorName="#ffcc99" start="3,0" stop="3,-1"/>
66 <blockBackground colorName="#ffcc99" start="4,0" stop="4,-1"/>
67 <blockBackground colorName="#ffcc99" start="5,0" stop="5,-1"/>
68 <blockBackground colorName="#ffcc99" start="6,0" stop="6,-1"/>
69 <blockBackground colorName="#ffcc99" start="7,0" stop="7,-1"/>
70 <blockBackground colorName="#ffffff" start="0,1" stop="0,-1"/>
71 <blockBackground colorName="#ffffff" start="1,1" stop="1,-1"/>
72 <blockBackground colorName="#ffffff" start="2,1" stop="2,-1"/>
73 <blockBackground colorName="#ffffff" start="3,1" stop="3,-1"/>
74 <blockBackground colorName="#ffffff" start="4,1" stop="4,-1"/>
75 <blockBackground colorName="#ffffff" start="5,1" stop="5,-1"/>
76 <blockBackground colorName="#ffffff" start="6,1" stop="6,-1"/>
77 <blockBackground colorName="#ffffff" start="7,1" stop="7,-1"/>
78 </blockTableStyle>
79 <initialize>
80 <paraStyle name="all" alignment="justify"/>
81 </initialize>
82 <paraStyle name="P1" fontName="Times-Roman" alignment="RIGHT"/>
83 <paraStyle name="P2" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT"/>
84 <paraStyle name="P3" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER"/>
85 <paraStyle name="P4" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
86 <paraStyle name="P5" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT"/>
87 <paraStyle name="P6" rightIndent="0.0" leftIndent="71.0" fontName="Helvetica" fontSize="10.0" leading="13" alignment="RIGHT"/>
88 <paraStyle name="P7" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER"/>
89 <paraStyle name="P8" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
90 <paraStyle name="P9" fontName="Helvetica" fontSize="12.0" leading="15" alignment="LEFT"/>
91 <paraStyle name="P10" fontName="Helvetica" fontSize="12.0" leading="15" alignment="LEFT"/>
92 <paraStyle name="P11" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
93 <paraStyle name="P12" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT"/>
94 <paraStyle name="P13" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER"/>
95 <paraStyle name="P14" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT"/>
96 <paraStyle name="P15" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT"/>
97 <paraStyle name="P16" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="10.0" leading="13" alignment="RIGHT"/>
98 <paraStyle name="P17" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER"/>
99 <paraStyle name="Standard" fontName="Times-Roman"/>
100 <paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
101 <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
102 <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
103 <paraStyle name="Caption" fontName="Times-Roman" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
104 <paraStyle name="Index" fontName="Times-Roman"/>
105 <paraStyle name="Table Contents" fontName="Times-Roman"/>
106 <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/>
107 <paraStyle name="Footer" fontName="Times-Roman"/>
108 <paraStyle name="MP1" fontName="Times-Roman" alignment="RIGHT"/>
109 </stylesheet>
110 <images/>
111 <story>
112 <para style="P2">[[ repeatIn(objects, 'o') ]]</para>
113 <blockTable colWidths="249.0,249.0" style="Table1">
114 <tr>
115 <td>
116 <para style="P10">
117 <font face="Times-Roman" size="10.0">[[ get_company(o) ]]</font>
118 </para>
119 </td>
120 <td>
121 <para style="P16">
122 <font face="Times-Roman">REGISTRO IVA </font>
123 </para>
124 <para style="P16">
125 <font face="Times-Roman">VENDITE </font>
126 </para>
127 </td>
128 </tr>
129 </blockTable>
130 <para style="P2">
131 <font color="white"> </font>
132 </para>
133 <para style="P11">[[ o.name ]] </para>
134 <para style="P2">
135 <font color="white"> </font>
136 </para>
137 <blockTable colWidths="39.0,50.0,92.0,45.0,54.0,76.0,69.0,74.0" repeatRows="1" style="Table2">
138 <tr>
139 <td>
140 <para style="P7">Periodo</para>
141 </td>
142 <td>
143 <para style="P7">Protocollo</para>
144 </td>
145 <td>
146 <para style="P7">Cliente</para>
147 </td>
148 <td>
149 <para style="P7">Numero</para>
150 </td>
151 <td>
152 <para style="P7">Data fattura</para>
153 </td>
154 <td>
155 <para style="P7">Aliquota</para>
156 </td>
157 <td>
158 <para style="P7">Imponibile</para>
159 </td>
160 <td>
161 <para style="P7">Imposta</para>
162 </td>
163 </tr>
164 <tr>
165 <td>
166 <para style="P3">[[ repeatIn(get_lines(o), 'line') ]]</para>
167 <para style="P3">[[ line['periodo'] ]]</para>
168 </td>
169 <td>
170 <para style="P3">[[ line['protocollo'] ]]</para>
171 </td>
172 <td>
173 <para style="P3">[[ line['causale'] ]]</para>
174 </td>
175 <td>
176 <para style="P3">[[ line['numero'] ]]</para>
177 </td>
178 <td>
179 <para style="P3">[[ line['data_doc'] ]]</para>
180 </td>
181 <td>
182 <para style="P14">[[ line['aliquota'] ]]</para>
183 </td>
184 <td>
185 <para style="P15">[[ line['imponibile'] ]]</para>
186 </td>
187 <td>
188 <para style="P15">[[ line['imposta'] ]]</para>
189 </td>
190 </tr>
191 </blockTable>
192 <para style="P9">
193 <font color="white"> </font>
194 </para>
195 <para style="P4">
196 <font color="white"> </font>
197 </para>
198 <para style="P4">
199 <font color="white"> </font>
200 </para>
201 </story>
202</document>
203
2040
=== removed file 'l10n_it/report/libroIVA_credito.sxw'
205Binary files l10n_it/report/libroIVA_credito.sxw 2011-01-14 00:11:01 +0000 and l10n_it/report/libroIVA_credito.sxw 1970-01-01 00:00:00 +0000 differ1Binary files l10n_it/report/libroIVA_credito.sxw 2011-01-14 00:11:01 +0000 and l10n_it/report/libroIVA_credito.sxw 1970-01-01 00:00:00 +0000 differ
=== removed file 'l10n_it/report/libroIVA_debito.py'
--- l10n_it/report/libroIVA_debito.py 2011-01-14 00:11:01 +0000
+++ l10n_it/report/libroIVA_debito.py 1970-01-01 00:00:00 +0000
@@ -1,80 +0,0 @@
1import datetime
2import time
3from report import report_sxw
4from osv import osv
5import pooler
6
7
8class l10n_chart_it_report_libroIVA_debito(report_sxw.rml_parse):
9
10 def __init__(self, cr, uid, name, context):
11 super(l10n_chart_it_report_libroIVA_debito,self).__init__(cr,uid,name,context)
12 self.localcontext.update({
13 'time' : time,
14 'get_company' : self.get_company,
15 'get_periods' : self.get_periods,
16 'get_lines' : self.get_lines,
17 })
18
19
20 def get_company(self,fiscal_year):
21 #print 'COMP = ',fiscal_year
22 return ""
23
24
25 def get_periods(self,fiscal_year):
26 #print 'Fiscal year id:',fiscal_year.id
27 obj=pooler.get_pool(self.cr.dbname).get('account.fiscalyear')
28 fy=obj.browse(self.cr,self.uid,fiscal_year.id)
29 #print 'Periods = ',fy.period_ids
30 res=[rec for rec in fy.period_ids]
31 #return fy.periods => non funziona?!? bool object !?!?
32 return res
33
34 def get_invoices(self,period):
35 #print 'PERIOD = ',period.name
36 obj=pooler.get_pool(self.cr.dbname).get('account.invoice')
37 # Selezione tutte le fatture emesse nel periodo
38 self.cr.execute( """
39 SELECT id FROM account_invoice
40 WHERE (state='open' OR state='paid') AND
41 period_id="""+str(period.id)+"""
42 AND (type='in_invoice' OR type='in_refund')
43 """)
44 ids=self.cr.fetchall()
45 #print 'IDS = ',
46 if ids:
47 ids=[id[0] for id in ids ]
48 invoices=obj.browse(self.cr,self.uid,ids)
49 #print 'INVOICES = ',invoices
50 return invoices
51
52 def get_lines(self,fiscal_year):
53 res=[]
54 obj_fy=pooler.get_pool(self.cr.dbname).get('account.fiscalyear')
55 fy=obj_fy.browse(self.cr,self.uid,fiscal_year.id)
56 for period in fy.period_ids:
57 invoices=self.get_invoices(period)
58 for invoice in invoices:
59 d={'periodo': period.name}
60 d['protocollo']=invoice.number
61 #print 'PARTNER ',invoice.partner_id.name
62 causale=invoice.partner_id.name
63 #print 'CAUSALE = ',causale
64 d['causale']=causale
65 d['numero']=invoice.reference
66 d['data_doc']=invoice.date_invoice
67 for tax in invoice.tax_line:
68 #print '\tTAX: ',tax
69 d['aliquota']=tax.tax_code_id.name
70 d['imponibile']=tax.base
71 d['imposta']=tax.amount
72 res.append(d)
73 d={'periodo':'', 'protocollo':'', 'causale':'', 'numero':'', 'data_doc':'', }
74 return res
75
76
77
78report_sxw.report_sxw('report.l10n_it.report.libroIVA_debito','account.report_libroiva',
79 'l10n_it/report/libroIVA_debito.rml',
80 parser=l10n_chart_it_report_libroIVA_debito,header=False)
810
=== removed file 'l10n_it/report/libroIVA_debito.rml'
--- l10n_it/report/libroIVA_debito.rml 2011-01-14 00:11:01 +0000
+++ l10n_it/report/libroIVA_debito.rml 1970-01-01 00:00:00 +0000
@@ -1,195 +0,0 @@
1<?xml version="1.0"?>
2<document filename="test.pdf">
3 <template pageSize="(612.0,792.0)" title="Test" author="Martin Simon" allowSplitting="20">
4 <pageTemplate id="first">
5 <frame id="first" x1="57.0" y1="57.0" width="498" height="678"/>
6 </pageTemplate>
7 </template>
8 <stylesheet>
9 <blockTableStyle id="Standard_Outline">
10 <blockAlignment value="LEFT"/>
11 <blockValign value="TOP"/>
12 </blockTableStyle>
13 <blockTableStyle id="Table2">
14 <blockAlignment value="LEFT"/>
15 <blockValign value="TOP"/>
16 </blockTableStyle>
17 <blockTableStyle id="Table1">
18 <blockAlignment value="LEFT"/>
19 <blockValign value="TOP"/>
20 <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,0" stop="0,-1"/>
21 <lineStyle kind="LINEABOVE" colorName="#000000" start="0,0" stop="0,0"/>
22 <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
23 <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,0" stop="1,-1"/>
24 <lineStyle kind="LINEABOVE" colorName="#000000" start="1,0" stop="1,0"/>
25 <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
26 <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,0" stop="2,-1"/>
27 <lineStyle kind="LINEABOVE" colorName="#000000" start="2,0" stop="2,0"/>
28 <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
29 <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,0" stop="3,-1"/>
30 <lineStyle kind="LINEABOVE" colorName="#000000" start="3,0" stop="3,0"/>
31 <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
32 <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,0" stop="4,-1"/>
33 <lineStyle kind="LINEABOVE" colorName="#000000" start="4,0" stop="4,0"/>
34 <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
35 <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,0" stop="5,-1"/>
36 <lineStyle kind="LINEABOVE" colorName="#000000" start="5,0" stop="5,0"/>
37 <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
38 <lineStyle kind="LINEBEFORE" colorName="#000000" start="6,0" stop="6,-1"/>
39 <lineStyle kind="LINEABOVE" colorName="#000000" start="6,0" stop="6,0"/>
40 <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
41 <lineStyle kind="LINEBEFORE" colorName="#000000" start="7,0" stop="7,-1"/>
42 <lineStyle kind="LINEAFTER" colorName="#000000" start="7,0" stop="7,-1"/>
43 <lineStyle kind="LINEABOVE" colorName="#000000" start="7,0" stop="7,0"/>
44 <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
45 <lineStyle kind="LINEBEFORE" colorName="#000000" start="0,1" stop="0,-1"/>
46 <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
47 <lineStyle kind="LINEBEFORE" colorName="#000000" start="1,1" stop="1,-1"/>
48 <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
49 <lineStyle kind="LINEBEFORE" colorName="#000000" start="2,1" stop="2,-1"/>
50 <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
51 <lineStyle kind="LINEBEFORE" colorName="#000000" start="3,1" stop="3,-1"/>
52 <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
53 <lineStyle kind="LINEBEFORE" colorName="#000000" start="4,1" stop="4,-1"/>
54 <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
55 <lineStyle kind="LINEBEFORE" colorName="#000000" start="5,1" stop="5,-1"/>
56 <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
57 <lineStyle kind="LINEBEFORE" colorName="#000000" start="6,1" stop="6,-1"/>
58 <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
59 <lineStyle kind="LINEBEFORE" colorName="#000000" start="7,1" stop="7,-1"/>
60 <lineStyle kind="LINEAFTER" colorName="#000000" start="7,1" stop="7,-1"/>
61 <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
62 <blockBackground colorName="#ffcc99" start="0,0" stop="0,-1"/>
63 <blockBackground colorName="#ffcc99" start="1,0" stop="1,-1"/>
64 <blockBackground colorName="#ffcc99" start="2,0" stop="2,-1"/>
65 <blockBackground colorName="#ffcc99" start="3,0" stop="3,-1"/>
66 <blockBackground colorName="#ffcc99" start="4,0" stop="4,-1"/>
67 <blockBackground colorName="#ffcc99" start="5,0" stop="5,-1"/>
68 <blockBackground colorName="#ffcc99" start="6,0" stop="6,-1"/>
69 <blockBackground colorName="#ffcc99" start="7,0" stop="7,-1"/>
70 <blockBackground colorName="#ffffff" start="0,1" stop="0,-1"/>
71 <blockBackground colorName="#ffffff" start="1,1" stop="1,-1"/>
72 <blockBackground colorName="#ffffff" start="2,1" stop="2,-1"/>
73 <blockBackground colorName="#ffffff" start="3,1" stop="3,-1"/>
74 <blockBackground colorName="#ffffff" start="4,1" stop="4,-1"/>
75 <blockBackground colorName="#ffffff" start="5,1" stop="5,-1"/>
76 <blockBackground colorName="#ffffff" start="6,1" stop="6,-1"/>
77 <blockBackground colorName="#ffffff" start="7,1" stop="7,-1"/>
78 </blockTableStyle>
79 <initialize>
80 <paraStyle name="all" alignment="justify"/>
81 </initialize>
82 <paraStyle name="P1" fontName="Times-Roman" alignment="RIGHT"/>
83 <paraStyle name="P2" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER"/>
84 <paraStyle name="P3" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT"/>
85 <paraStyle name="P4" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT"/>
86 <paraStyle name="P5" fontName="Helvetica" fontSize="12.0" leading="15" alignment="LEFT"/>
87 <paraStyle name="P6" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
88 <paraStyle name="P7" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT"/>
89 <paraStyle name="P8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER"/>
90 <paraStyle name="P9" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT"/>
91 <paraStyle name="P10" fontName="Helvetica" fontSize="12.0" leading="15" alignment="LEFT"/>
92 <paraStyle name="P11" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
93 <paraStyle name="P12" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica" fontSize="10.0" leading="13" alignment="RIGHT"/>
94 <paraStyle name="Standard" fontName="Times-Roman"/>
95 <paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
96 <paraStyle name="Text body" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
97 <paraStyle name="List" fontName="Times-Roman" spaceBefore="0.0" spaceAfter="6.0"/>
98 <paraStyle name="Caption" fontName="Times-Roman" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
99 <paraStyle name="Index" fontName="Times-Roman"/>
100 <paraStyle name="Table Contents" fontName="Times-Roman"/>
101 <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/>
102 <paraStyle name="Footer" fontName="Times-Roman"/>
103 <paraStyle name="MP1" fontName="Times-Roman" alignment="RIGHT"/>
104 </stylesheet>
105 <images/>
106 <story>
107 <para style="P7">[[ repeatIn(objects, 'o') ]]</para>
108 <blockTable colWidths="249.0,249.0" style="Table2">
109 <tr>
110 <td>
111 <para style="P10">
112 <font face="Times-Roman" size="10.0">[[ get_company(o) ]]</font>
113 </para>
114 </td>
115 <td>
116 <para style="P12">
117 <font face="Times-Roman">REGISTRO IVA</font>
118 </para>
119 <para style="P12">
120 <font face="Times-Roman">ACQUISTI</font>
121 </para>
122 </td>
123 </tr>
124 </blockTable>
125 <para style="P7">
126 <font color="white"> </font>
127 </para>
128 <para style="P11">[[ o.name ]] </para>
129 <para style="P7">
130 <font color="white"> </font>
131 </para>
132 <blockTable colWidths="39.0,50.0,92.0,45.0,54.0,76.0,69.0,74.0" repeatRows="1" style="Table1">
133 <tr>
134 <td>
135 <para style="P8">Periodo</para>
136 </td>
137 <td>
138 <para style="P8">Protocollo</para>
139 </td>
140 <td>
141 <para style="P8">Fornitore</para>
142 </td>
143 <td>
144 <para style="P8">Numero</para>
145 </td>
146 <td>
147 <para style="P8">Data fattura</para>
148 </td>
149 <td>
150 <para style="P8">Aliquota</para>
151 </td>
152 <td>
153 <para style="P8">Imponibile</para>
154 </td>
155 <td>
156 <para style="P8">Imposta</para>
157 </td>
158 </tr>
159 <tr>
160 <td>
161 <para style="P2">[[ repeatIn(get_lines(o), 'line') ]]</para>
162 <para style="P2">[[ line['periodo'] ]]</para>
163 </td>
164 <td>
165 <para style="P2">[[ line['protocollo'] ]]</para>
166 </td>
167 <td>
168 <para style="P2">[[ line['causale'] ]]</para>
169 </td>
170 <td>
171 <para style="P2">[[ line['numero'] ]]</para>
172 </td>
173 <td>
174 <para style="P2">[[ line['data_doc'] ]]</para>
175 </td>
176 <td>
177 <para style="P3">[[ line['aliquota'] ]]</para>
178 </td>
179 <td>
180 <para style="P4">[[ line['imponibile'] ]]</para>
181 </td>
182 <td>
183 <para style="P4">[[ line['imposta'] ]]</para>
184 </td>
185 </tr>
186 </blockTable>
187 <para style="P5">
188 <font color="white"> </font>
189 </para>
190 <para style="P6">
191 <font color="white"> </font>
192 </para>
193 </story>
194</document>
195
1960
=== removed file 'l10n_it/report/libroIVA_debito.sxw'
197Binary files l10n_it/report/libroIVA_debito.sxw 2011-01-14 00:11:01 +0000 and l10n_it/report/libroIVA_debito.sxw 1970-01-01 00:00:00 +0000 differ1Binary files l10n_it/report/libroIVA_debito.sxw 2011-01-14 00:11:01 +0000 and l10n_it/report/libroIVA_debito.sxw 1970-01-01 00:00:00 +0000 differ
=== removed file 'l10n_it/report/normalized_oo2rml.xsl'
--- l10n_it/report/normalized_oo2rml.xsl 2011-01-14 00:11:01 +0000
+++ l10n_it/report/normalized_oo2rml.xsl 1970-01-01 00:00:00 +0000
@@ -1,696 +0,0 @@
1<?xml version="1.0" encoding="utf-8"?>
2<xsl:stylesheet
3 version="1.0"
4 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
5 xmlns:fo="http://www.w3.org/1999/XSL/Format"
6 xmlns:office="http://openoffice.org/2000/office"
7 xmlns:style="http://openoffice.org/2000/style"
8 xmlns:text="http://openoffice.org/2000/text"
9 xmlns:table="http://openoffice.org/2000/table"
10 xmlns:draw="http://openoffice.org/2000/drawing"
11 xmlns:xlink="http://www.w3.org/1999/xlink"
12 xmlns:number="http://openoffice.org/2000/datastyle"
13 xmlns:svg="http://www.w3.org/2000/svg"
14 xmlns:chart="http://openoffice.org/2000/chart"
15 xmlns:dr3d="http://openoffice.org/2000/dr3d"
16 xmlns:math="http://www.w3.org/1998/Math/MathML"
17 xmlns:form="http://openoffice.org/2000/form"
18 xmlns:script="http://openoffice.org/2000/script"
19 office:class="text" office:version="1.0"
20 exclude-result-prefixes = "xsl fo office style text table draw xlink number svg chart dr3d math form script">
21
22 <!--TODO's: indent, picture cache (trml2pdf) -->
23
24<xsl:output method="xml" indent="yes" />
25<xsl:strip-space elements="*"/>
26
27<xsl:key name="text_style" match="style:style[@style:family='text']" use="@style:name" />
28<xsl:key name="page_break_before" match="style:style[@style:family='paragraph' and ./style:properties/@fo:break-before='page']" use="@style:name" />
29<xsl:key name="page_break_after" match="style:style[@style:family='paragraph' and ./style:properties/@fo:break-after='page']" use="@style:name" />
30<xsl:key name="table_column_style" match="style:style[@style:family='table-column']" use="@style:name" />
31<xsl:key name="table_cell_style" match="style:style[@style:family='table-cell']" use="@style:name" />
32<xsl:key name="paragraph_style" match="style:style[@style:family='paragraph']" use="@style:name" />
33
34<xsl:template match="office:document-content">
35 <document filename="test.pdf">
36 <xsl:apply-templates select="office:automatic-styles" />
37 <xsl:apply-templates select="office:body" />
38 </document>
39</xsl:template>
40
41<xsl:template name="page_size">
42 <xsl:attribute name="pageSize">
43 <xsl:text>(</xsl:text>
44 <xsl:value-of select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-width" />
45 <xsl:text>,</xsl:text>
46 <xsl:value-of select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-height" />
47 <xsl:text>)</xsl:text>
48 </xsl:attribute>
49</xsl:template>
50
51<xsl:template name="fixed_frame">
52 <xsl:for-each select="//draw:text-box">
53 <frame>
54 <xsl:attribute name="id"><xsl:value-of select="./@draw:name" /></xsl:attribute>
55 <xsl:attribute name="x1"><xsl:value-of select="./@svg:x" /></xsl:attribute>
56 <xsl:attribute name="y1">
57 <xsl:value-of
58 select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-height - ./@svg:y - ./@fo:min-height" />
59 </xsl:attribute>
60 <xsl:attribute name="width">
61 <xsl:value-of select="./@svg:width" />
62 </xsl:attribute>
63 <xsl:attribute name="height">
64 <xsl:value-of select="./@fo:min-height" />
65 </xsl:attribute>
66 </frame>
67 </xsl:for-each>
68</xsl:template>
69
70<xsl:template name="margin_sizes">
71 <xsl:variable name="margin_left" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-left" />
72 <xsl:variable name="margin_right" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-right" />
73 <xsl:variable name="margin_top" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-top" />
74 <xsl:variable name="margin_bottom" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-bottom" />
75 <xsl:variable name="page_width" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-width" />
76 <xsl:variable name="page_height" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-height" />
77 <xsl:attribute name="x1"><xsl:value-of select="$margin_left" /></xsl:attribute>
78 <xsl:attribute name="y1"><xsl:value-of select="$margin_bottom" /></xsl:attribute>
79 <xsl:attribute name="width"><xsl:value-of select="$page_width - $margin_left - $margin_right"/></xsl:attribute>
80 <xsl:attribute name="height"><xsl:value-of select="$page_height - $margin_bottom - $margin_top"/></xsl:attribute>
81</xsl:template>
82
83<xsl:template name="text_width">
84 <!-- You need this for the workaround to make primitive outlines-->
85 <xsl:variable name="margin_left" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-left" />
86 <xsl:variable name="margin_right" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:margin-right" />
87 <xsl:variable name="page_width" select="//transferredfromstylesxml/style:page-master[1]/style:properties/@fo:page-width" />
88 <xsl:value-of select="$page_width - $margin_left - $margin_right - 18"/>
89</xsl:template>
90
91
92
93<xsl:template match="office:automatic-styles">
94 <!--<template pageSize="(21cm, 29.7cm)" leftMargin="1.0cm" rightMargin="2.0cm" topMargin="1.0cm" bottomMargin="1.0cm" title="Test" author="Martin Simon" allowSplitting="20">-->
95 <template pageSize="(21cm, 29.7cm)" title="Test" author="Martin Simon" allowSplitting="20">
96 <xsl:call-template name="page_size" />
97 <pageTemplate id="first">
98 <xsl:call-template name="fixed_frame" />
99 <frame id="first" x1="2cm" y1="2cm" width="17cm" height="26cm">
100 <xsl:call-template name="margin_sizes" />
101 </frame>
102 </pageTemplate>
103 </template>
104 <stylesheet>
105 <!--A table style to simulate primitive outlines -till the <addOutline> tag is implemented in trml2pdf -->
106 <blockTableStyle id="Standard_Outline">
107 <blockAlignment value="LEFT"/>
108 <blockValign value="TOP"/>
109 </blockTableStyle>
110 <!--use two standard table grid styles like PyOpenOffice "Old Way": with and without a grid-->
111 <!--TODO insert table cell colors here, not within the <td> tag - otherwise
112 it will not work with flowables as cell content-->
113 <xsl:call-template name="make_blocktablestyle" />
114 <initialize>
115 <paraStyle name="all" alignment="justify" />
116 </initialize>
117 <xsl:apply-templates select="style:style" />
118 </stylesheet>
119</xsl:template>
120
121<xsl:template name="make_blocktablestyle">
122 <xsl:for-each select="//table:table">
123 <xsl:variable name="test">
124 <xsl:value-of select="./@table:name" />
125 </xsl:variable>
126 <xsl:if test="not(boolean(count(preceding-sibling::table:table[@table:name=$test])))">
127 <!--Test if this is the first table with this style, nested tables not counted-->
128 <blockTableStyle id="{@table:name}">
129 <xsl:if test=".//draw:image">
130 <blockTopPadding value="0"/>
131 <blockBottomPadding value="0"/>
132 </xsl:if>
133 <blockAlignment value="LEFT" />
134 <blockValign value="TOP" />
135 <xsl:call-template name="make_linestyle" />
136 <xsl:call-template name="make_tablebackground" />
137 </blockTableStyle>
138 </xsl:if>
139 </xsl:for-each>
140</xsl:template>
141
142<xsl:template name="make_linestyle">
143 <xsl:for-each select=".//table:table-row">
144 <xsl:variable name="row" select="position() - 1"/>
145 <xsl:for-each select=".//table:table-cell">
146 <xsl:variable name="col" select="position() - 1"/>
147 <xsl:variable name="linebefore">
148 <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-left"/>
149 </xsl:variable>
150 <xsl:if test="not($linebefore='') and not($linebefore='none')">
151 <xsl:variable name="colorname">
152 <xsl:value-of select="substring-after($linebefore,'#')"/>
153 </xsl:variable>
154 <lineStyle kind="LINEBEFORE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
155 </xsl:if>
156 <xsl:variable name="lineafter">
157 <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-right"/>
158 </xsl:variable>
159 <xsl:if test="not($lineafter='') and not($lineafter='none')">
160 <xsl:variable name="colorname">
161 <xsl:value-of select="substring-after($lineafter,'#')"/>
162 </xsl:variable>
163 <lineStyle kind="LINEAFTER" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
164 </xsl:if>
165 <xsl:variable name="lineabove">
166 <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-top"/>
167 </xsl:variable>
168 <xsl:if test="not($lineabove='') and not($lineabove='none')">
169 <xsl:variable name="colorname">
170 <xsl:value-of select="substring-after($lineabove,'#')"/>
171 </xsl:variable>
172 <lineStyle kind="LINEABOVE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},{$row}"/>
173 </xsl:if>
174 <xsl:variable name="linebelow">
175 <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border-bottom"/>
176 </xsl:variable>
177 <xsl:if test="not($linebelow='') and not($linebelow='none')">
178 <xsl:variable name="colorname">
179 <xsl:value-of select="substring-after($linebelow,'#')"/>
180 </xsl:variable>
181 <lineStyle kind="LINEBELOW" colorName="#{$colorname}" start="{$col},{-1}" stop="{$col},{-1}"/>
182 </xsl:if>
183 <xsl:variable name="grid">
184 <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:border"/>
185 </xsl:variable>
186 <xsl:if test="not($grid='') and not($grid='none')">
187 <xsl:variable name="colorname">
188 <xsl:value-of select="substring-after($grid,'#')"/>
189 </xsl:variable>
190 <!-- Don't use grid because we don't need a line between each rows -->
191 <lineStyle kind="LINEBEFORE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
192 <lineStyle kind="LINEAFTER" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},-1"/>
193 <lineStyle kind="LINEABOVE" colorName="#{$colorname}" start="{$col},{$row}" stop="{$col},{$row}"/>
194 <lineStyle kind="LINEBELOW" colorName="#{$colorname}" start="{$col},{-1}" stop="{$col},{-1}"/>
195 </xsl:if>
196 </xsl:for-each>
197 </xsl:for-each>
198</xsl:template>
199
200<!-- Was needed to simulate bulleted lists:
201<xsl:template match="text:ordered-list|text:unordered-list">
202 <xsl:variable name = "text_width">
203 <xsl:call-template name="text_width" />
204 </xsl:variable>
205 <blockTable style="Standard_Outline" colWidths="18,{$text_width}">
206 <xsl:apply-templates match="text:list-item" />
207</blockTable>
208</xsl:template>
209
210<xsl:template match="text:list-item">
211 <tr>
212 <td><para><font face="Helvetica-Bold" size="10">*</font></para></td>
213 <td>
214 <xsl:apply-templates />
215 </td>
216 </tr>
217</xsl:template>
218
219-->
220
221
222<xsl:template match="office:body">
223 <story>
224 <xsl:apply-templates />
225 <xsl:for-each select="//draw:text-box">
226 <currentFrame>
227 <xsl:attribute name="name">
228 <xsl:value-of select="./@draw:name" />
229 </xsl:attribute>
230 </currentFrame>
231 <xsl:apply-templates>
232 <xsl:with-param name="skip_draw" select="0" />
233 </xsl:apply-templates>
234 <frameEnd />
235 </xsl:for-each>
236 <xsl:for-each select="//text:ordered-list">
237 <para><seqReset id="{//text:ordered-list/@text:style-name}"/></para>
238 </xsl:for-each>
239 </story>
240</xsl:template>
241
242<xsl:template match="table:table">
243 <blockTable>
244 <xsl:attribute name="colWidths">
245 <xsl:call-template name="make_columns" />
246 </xsl:attribute>
247 <xsl:call-template name="make_tableheaders" />
248 <xsl:attribute name="style">
249 <xsl:value-of select="@table:name" />
250 </xsl:attribute>
251 <xsl:apply-templates />
252 </blockTable>
253</xsl:template>
254
255<xsl:template name="make_tableheaders">
256 <xsl:if test="boolean(count(table:table-header-rows))">
257 <xsl:attribute name="repeatRows">1</xsl:attribute>
258 </xsl:if>
259</xsl:template>
260
261<xsl:template name="make_tablebackground">
262 <xsl:for-each select=".//table:table-row">
263 <!--Be careful when there are table:table-header-rows as
264 parent node of table:table-row -->
265 <xsl:variable name="row" select="position() - 1" />
266 <xsl:for-each select="./table:table-cell">
267 <xsl:variable name="col" select="position() - 1" />
268 <xsl:variable name="background">
269 <xsl:value-of select="key('table_cell_style',@table:style-name)/style:properties/@fo:background-color" />
270 </xsl:variable>
271 <xsl:if test="not($background='') and boolean(key('table_cell_style',@table:style-name)/style:properties/@fo:background-color) and starts-with($background,'#')">
272 <!--only RGB hexcolors are accepted -->
273 <blockBackground colorName="{$background}" start="{$col},{$row}" stop="{$col},-1" />
274 </xsl:if>
275 </xsl:for-each>
276 </xsl:for-each>
277</xsl:template>
278
279<xsl:template name="make_columns">
280 <xsl:variable name="columns" >
281 <xsl:for-each select="table:table-column">
282 <xsl:value-of select="key('table_column_style',@table:style-name)/style:properties/@style:column-width" />
283 <xsl:text>,</xsl:text>
284 </xsl:for-each>
285 </xsl:variable>
286 <xsl:value-of select="substring($columns,1,string-length($columns) - 1)" />
287 <!--strip the last comma-->
288</xsl:template>
289
290<xsl:template match="table:table-row">
291 <tr>
292 <xsl:apply-templates />
293 </tr>
294</xsl:template>
295
296<xsl:template match="table:table-cell">
297 <td>
298 <xsl:apply-templates />
299 </td>
300</xsl:template>
301
302<xsl:template match="text:section">
303 <section>
304 <xsl:apply-templates />
305 </section>
306</xsl:template>
307
308
309<xsl:template match="text:span">
310 <font>
311 <xsl:call-template name="make_fontnames_span" />
312 <xsl:call-template name="make_fontsize_span" />
313 <xsl:apply-templates />
314 </font>
315</xsl:template>
316
317<xsl:template name="make_fontsize_span">
318 <xsl:variable name ="fontsize">
319 <xsl:value-of select="key('text_style',@text:style-name)/style:properties/@fo:font-size" />
320 </xsl:variable>
321 <xsl:if test="not($fontsize='') and boolean(key('text_style',@text:style-name)/style:properties/@fo:font-size)" >
322 <xsl:attribute name="size">
323 <xsl:value-of select="$fontsize" />
324 </xsl:attribute>
325 </xsl:if>
326</xsl:template>
327
328<xsl:template name="make_fontnames_span">
329 <xsl:attribute name="face">
330 <xsl:call-template name="make_fontnames">
331 <xsl:with-param name="fontName" select="key('text_style',@text:style-name)/style:properties/@style:font-name" />
332 <xsl:with-param name="fontWeight" select="key('text_style',@text:style-name)/style:properties/@fo:font-weight" />
333 <xsl:with-param name="fontStyle" select="key('text_style',@text:style-name)/style:properties/@fo:font-style" />
334 </xsl:call-template>
335 </xsl:attribute>
336</xsl:template>
337
338<xsl:template name="make_image">
339 <illustration height="{.//draw:image/@svg:height}" width="{.//draw:image/@svg:width}">
340 <image x="0" y="0" file="{substring-after(.//draw:image/@xlink:href,'#Pictures/')}" height="{.//draw:image/@svg:height}" width="{.//draw:image/@svg:width}" />
341 </illustration>
342</xsl:template>
343
344<xsl:template name="empty_paragraph">
345 <xsl:if test="not(boolean(count(descendant::node())))">
346 <xsl:call-template name="distance_point">
347 <xsl:with-param name="background" select="key('paragraph_style',@text:style-name)/style:properties/@fo:background-color" />
348 </xsl:call-template>
349 </xsl:if>
350</xsl:template>
351
352<xsl:template name="distance_point">
353 <xsl:param name="background" />
354 <xsl:param name="tab_stop"></xsl:param>
355 <xsl:variable name="local_back">
356 <xsl:choose>
357 <xsl:when test="not(boolean($background)) or not(contains($background,'#'))">
358 <!-- Do not accept OO colors like "transparent", only hex-colors -->
359 <xsl:text>white</xsl:text>
360 </xsl:when>
361 <xsl:otherwise>
362 <xsl:value-of select="$background" />
363 </xsl:otherwise>
364 </xsl:choose>
365 </xsl:variable>
366 <font color="{$local_back}">
367 <xsl:text> </xsl:text>
368 <xsl:if test="boolean($tab_stop)">
369 <!-- simulate a tabstop with white/background-color points -->
370 <xsl:text>.........</xsl:text>
371 </xsl:if>
372 </font>
373</xsl:template>
374
375<xsl:template match="text:ordered-list">
376 <xsl:apply-templates />
377
378 <!-- Reset the counter. seqreset is not a trml2pdf tag, but a Platypus Intra Paragraph Markup,
379 so it needs a dummy paragraph to enclose it -->
380</xsl:template>
381
382<xsl:template name="make_listitem">
383 <xsl:if test="(name(..)='text:list-item')">
384 <xsl:attribute name="leftIndent">15</xsl:attribute>
385 <xsl:attribute name="bulletIndent">0</xsl:attribute>
386 <xsl:choose>
387 <xsl:when test="(name(../..)='text:unordered-list')">
388 <xsl:variable name="fontsize">
389 <xsl:value-of select="number(key('paragraph_style',@text:style-name)/style:properties/@fo:font-size)" />
390 </xsl:variable>
391 <xsl:choose>
392 <xsl:when test="$fontsize='NaN'">
393 <!-- you should exclude non-numerical values for bulletFontSize. <== Sometimes the preprocessing went wrong.-->
394 <!--use a default bullet font size-->
395 <xsl:attribute name="bulletFontSize">6</xsl:attribute>
396 </xsl:when>
397 <xsl:otherwise>
398 <xsl:attribute name="bulletFontSize"><xsl:value-of select="floor(($fontsize div 2) + 1)" /></xsl:attribute>
399 </xsl:otherwise>
400 </xsl:choose>
401 <xsl:attribute name="bulletFontName">ZapfDingbats</xsl:attribute>
402 <xsl:attribute name="bulletText">l</xsl:attribute>
403 </xsl:when>
404 <xsl:otherwise>
405 <!-- Generate the numbers for an ordered list -->
406 <xsl:variable name="size">
407 <xsl:value-of select="key('paragraph_style',@text:style-name)/style:properties/@fo:font-size" />
408 </xsl:variable>
409 <!-- For ordered lists we use the bullet tag from Platypus Intra Paragraph Markup -->
410 <bullet>
411 <xsl:if test="not($size='') and boolean(key('paragraph_style',@text:style-name)/style:properties/@fo:font-size)">
412 <xsl:attribute name="size">
413 <!-- adapt the fontsize to the fontsize of the current paragraph -->
414 <xsl:value-of select="$size" />
415 </xsl:attribute>
416 </xsl:if>
417 <seq id="{../../@text:style-name}"/>.</bullet>
418
419 </xsl:otherwise>
420 </xsl:choose>
421 </xsl:if>
422</xsl:template>
423
424<xsl:template match="text:drop-down">
425 <xsl:value-of select="text:label[2]/@text:value" />
426</xsl:template>
427
428
429<xsl:template match="text:p|text:h">
430 <xsl:param name="skip_draw" select="1" />
431 <xsl:if test="boolean(key('page_break_before',@text:style-name))" >
432 <pageBreak />
433 </xsl:if>
434 <xsl:choose>
435 <xsl:when test="boolean(.//draw:image)">
436 <xsl:call-template name="make_image" />
437 </xsl:when>
438 <xsl:when test="boolean(name(..) = 'draw:text-box') and boolean($skip_draw)">
439 </xsl:when>
440 <xsl:otherwise>
441 <para>
442 <xsl:attribute name="style">
443 <xsl:value-of select="@text:style-name" />
444 </xsl:attribute>
445 <xsl:call-template name="make_listitem" />
446 <xsl:apply-templates />
447 <xsl:call-template name="empty_paragraph" />
448 </para>
449 </xsl:otherwise>
450 </xsl:choose>
451 <xsl:if test="boolean(key('page_break_after',@text:style-name))" >
452 <pageBreak />
453 </xsl:if>
454</xsl:template>
455
456<xsl:template match="text:p/text:tab-stop">
457 <!-- simulate a tabstop -->
458 <xsl:call-template name="distance_point">
459 <xsl:with-param name="background" select="key('paragraph_style',@text:style-name)/style:properties/@fo:background-color" />
460 <xsl:with-param name="tab_stop">yes</xsl:with-param>
461 </xsl:call-template>
462</xsl:template>
463
464<!-- experimental - switched off
465<xsl:template match="text:h">
466 <para>
467 <xsl:attribute name="style">
468 <xsl:value-of select="@text:style-name" />
469 </xsl:attribute>
470 <xsl:call-template name="make_number" />
471 <xsl:apply-templates />
472 <xsl:call-template name="empty_paragraph" />
473 </para>
474</xsl:template>
475
476<xsl:template name="make_number">
477 <xsl:choose>
478 <xsl:when test="@text:level='1'">
479 <xsl:number format="1. " />
480 </xsl:when>
481 <xsl:when test="@text:level='2'">
482 <xsl:number count="text:h[@text:level='1']|text:h[text:level='2']" level="any" format="1.1." />
483 </xsl:when>
484 </xsl:choose>
485</xsl:template>
486
487-->
488
489<xsl:template match="style:style[@style:family='paragraph']">
490 <paraStyle>
491 <xsl:attribute name="name">
492 <xsl:value-of select="@style:name" />
493 </xsl:attribute>
494 <xsl:call-template name="make_indent_paragraph" />
495 <xsl:call-template name="make_fontnames_paragraph" />
496 <xsl:call-template name="make_fontsize" />
497 <!--<xsl:call-template name="make_parent" /> not necessary -
498 parent styles processed by PyOpenOffice -->
499 <xsl:call-template name="make_alignment" />
500 <xsl:call-template name="make_background" />
501 <xsl:call-template name="make_space_beforeafter" />
502 <xsl:call-template name="make_fontcolor" />
503 </paraStyle>
504</xsl:template>
505
506<xsl:template name="make_indent_paragraph">
507 <xsl:variable name="right_indent"><xsl:value-of select="style:properties/@fo:margin-right" /></xsl:variable>
508 <xsl:variable name="left_indent"><xsl:value-of select="style:properties/@fo:margin-left" /></xsl:variable>
509 <xsl:if test="not($right_indent='') and boolean(style:properties/@fo:margin-right)">
510 <xsl:attribute name="rightIndent">
511 <xsl:value-of select="$right_indent" />
512 </xsl:attribute>
513 </xsl:if>
514 <xsl:if test="not($left_indent='') and boolean(style:properties/@fo:margin-left)">
515 <xsl:attribute name="leftIndent">
516 <xsl:value-of select="$left_indent" />
517 </xsl:attribute>
518 </xsl:if>
519</xsl:template>
520
521<xsl:template name="make_background">
522 <xsl:variable name="background">
523 <xsl:value-of select="style:properties/@fo:background-color" />
524 </xsl:variable>
525 <xsl:if test="not($background='') and boolean(style:properties/@fo:background-color) and starts-with($background,'#')" >
526 <xsl:attribute name="backColor">
527 <xsl:value-of select="$background" />
528 </xsl:attribute>
529 </xsl:if>
530</xsl:template>
531
532<xsl:template name="make_space_beforeafter">
533 <xsl:variable name="before">
534 <xsl:value-of select="style:properties/@fo:margin-top" />
535 </xsl:variable>
536 <xsl:variable name="after">
537 <xsl:value-of select="style:properties/@fo:margin-bottom" />
538 </xsl:variable>
539 <xsl:if test="not($before='') and boolean(style:properties/@fo:margin-top)" >
540 <xsl:attribute name="spaceBefore">
541 <xsl:value-of select="$before" />
542 </xsl:attribute>
543 </xsl:if>
544 <xsl:if test="not($after='') and boolean(style:properties/@fo:margin-bottom)" >
545 <xsl:attribute name="spaceAfter">
546 <xsl:value-of select="$after" />
547 </xsl:attribute>
548 </xsl:if>
549</xsl:template>
550
551<xsl:template name="make_fontsize">
552 <xsl:variable name="fontSize">
553 <xsl:value-of select="style:properties/@fo:font-size" />
554 </xsl:variable>
555 <xsl:if test="not($fontSize='') and boolean(style:properties/@fo:font-size)">
556 <xsl:attribute name="fontSize">
557 <xsl:value-of select="$fontSize" />
558 </xsl:attribute>
559 <xsl:attribute name="leading">
560 <xsl:value-of select="$fontSize + floor($fontSize div 5) + 1" />
561 <!--use a standard leading related to the font size -->
562 </xsl:attribute>
563 </xsl:if>
564</xsl:template>
565
566<!--this template is not needed anymore for "normalized" sxw files -->
567<xsl:template name="make_parent">
568 <xsl:variable name="parent">
569 <xsl:value-of select="@style:parent-style-name" />
570 </xsl:variable>
571 <xsl:if test="not($parent='') and boolean(@style:parent-style-name)">
572 <xsl:attribute name="parent">
573 <xsl:value-of select="$parent" />
574 </xsl:attribute>
575 </xsl:if>
576</xsl:template>
577
578<xsl:template name="make_alignment">
579 <xsl:variable name="alignment">
580 <xsl:value-of select="style:properties/@fo:text-align" />
581 </xsl:variable>
582 <xsl:if test="not($alignment='') and boolean(style:properties/@fo:text-align)">
583 <xsl:choose>
584 <xsl:when test="$alignment='start'">
585 <xsl:attribute name="alignment">LEFT</xsl:attribute>
586 </xsl:when>
587 <xsl:when test="$alignment='center'">
588 <xsl:attribute name="alignment">CENTER</xsl:attribute>
589 </xsl:when>
590 <xsl:when test="$alignment='end'">
591 <xsl:attribute name="alignment">RIGHT</xsl:attribute>
592 </xsl:when>
593 <xsl:when test="$alignment='justify'">
594 <xsl:attribute name="alignment">JUSTIFY</xsl:attribute>
595 </xsl:when>
596 </xsl:choose>
597 </xsl:if>
598</xsl:template>
599
600<xsl:template name="make_fontnames_paragraph">
601 <xsl:attribute name="fontName">
602 <xsl:call-template name="make_fontnames">
603 <xsl:with-param name="fontName" select="style:properties/@style:font-name" />
604 <xsl:with-param name="fontWeight" select="style:properties/@fo:font-weight" />
605 <xsl:with-param name="fontStyle" select="style:properties/@fo:font-style" />
606 </xsl:call-template>
607 </xsl:attribute>
608</xsl:template>
609
610<xsl:template name="make_fontnames">
611 <!--much too verbose, needs improvement-->
612<xsl:param name="fontName" />
613<xsl:param name="fontWeight" />
614<xsl:param name="fontStyle" />
615<xsl:choose>
616<xsl:when test="not($fontName='') and boolean($fontName)">
617 <xsl:choose>
618 <xsl:when test="contains($fontName,'Courier')">
619 <xsl:choose>
620 <xsl:when test="($fontWeight='bold') and ($fontStyle='italic')">
621 <xsl:text>Courier-BoldOblique</xsl:text>
622 </xsl:when>
623 <xsl:when test="($fontWeight='bold') and not ($fontStyle='italic')">
624 <xsl:text>Courier-Bold</xsl:text>
625 </xsl:when>
626 <xsl:when test="not($fontWeight='bold') and ($fontStyle='italic')">
627 <xsl:text>Courier-Oblique</xsl:text>
628 </xsl:when>
629 <xsl:otherwise>
630 <xsl:text>Courier</xsl:text>
631 </xsl:otherwise>
632 </xsl:choose>
633 </xsl:when>
634 <xsl:when test="contains($fontName,'Helvetica') or contains($fontName,'Arial') or contains($fontName,'Sans')">
635 <xsl:choose>
636 <xsl:when test="($fontWeight='bold') and ($fontStyle='italic')">
637 <xsl:text>Helvetica-BoldOblique</xsl:text>
638 </xsl:when>
639 <xsl:when test="($fontWeight='bold') and not ($fontStyle='italic')">
640 <xsl:text>Helvetica-Bold</xsl:text>
641 </xsl:when>
642 <xsl:when test="not($fontWeight='bold') and ($fontStyle='italic')">
643 <xsl:text>Helvetica-Oblique</xsl:text>
644 </xsl:when>
645 <xsl:otherwise>
646 <xsl:text>Helvetica</xsl:text>
647 </xsl:otherwise>
648 </xsl:choose>
649 </xsl:when>
650 <xsl:otherwise>
651 <xsl:choose>
652 <xsl:when test="($fontWeight='bold') and ($fontStyle='italic')">
653 <xsl:text>Times-BoldItalic</xsl:text>
654 </xsl:when>
655 <xsl:when test="($fontWeight='bold') and not ($fontStyle='italic')">
656 <xsl:text>Times-Bold</xsl:text>
657 </xsl:when>
658 <xsl:when test="not($fontWeight='bold') and ($fontStyle='italic')">
659 <xsl:text>Times-Italic</xsl:text>
660 </xsl:when>
661 <xsl:otherwise>
662 <xsl:text>Times-Roman</xsl:text>
663 </xsl:otherwise>
664 </xsl:choose>
665 </xsl:otherwise>
666 </xsl:choose>
667</xsl:when>
668<xsl:otherwise>
669 <!--Use this as default -->
670 <xsl:text>Times-Roman</xsl:text>
671</xsl:otherwise>
672</xsl:choose>
673</xsl:template>
674<xsl:template name="make_fontcolor">
675 <xsl:variable name="textColor">
676 <xsl:value-of select="style:properties/@fo:color"/>
677 </xsl:variable>
678 <xsl:if test="not($textColor='') and boolean(style:properties/@fo:color)">
679 <xsl:attribute name="textColor">
680 <xsl:value-of select="$textColor" />
681 </xsl:attribute>
682 </xsl:if>
683</xsl:template>
684
685<!--
686This stylesheet is part of:
687PyOpenOffice Version 0.4
688Copyright (C) 2005: Martin Simon
689Homepage: www.bezirksreiter.de
690
691GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999
692-->
693
694</xsl:stylesheet>
695
696
6970
=== removed directory 'l10n_it/security'
=== removed file 'l10n_it/security/ir.model.access.csv'
--- l10n_it/security/ir.model.access.csv 2011-01-14 00:11:01 +0000
+++ l10n_it/security/ir.model.access.csv 1970-01-01 00:00:00 +0000
@@ -1,3 +0,0 @@
1"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
2"access_l10n_it_report_manager","l10n_it.report account manager","model_account_report_libroiva","account.group_account_manager",1,1,1,1
3"access_l10n_it_report_user","l10n_it_report account user","model_account_report_libroiva","account.group_account_user",1,1,1,1

Subscribers

People subscribed via source and target branches

to all changes: