[IMP] add an index on account_move_line(date, id)
[odoo/odoo.git] / addons / account / data / configurable_account_chart.xml
1 <?xml version="1.0" encoding="utf-8"?>
2 <openerp>
3     <data noupdate="1">
4         <!-- Types -->
5         <record model="account.account.type" id="account_type_income_view1">
6             <field name="name">Income View</field>
7             <field name="code">view</field>
8             <field name="report_type">income</field>
9         </record>
10         <record model="account.account.type" id="account_type_expense_view1">
11             <field name="name">Expense View</field>
12             <field name="code">expense</field>
13             <field name="report_type">expense</field>
14         </record>
15         <record model="account.account.type" id="account_type_asset_view1">
16             <field name="name">Asset View</field>
17             <field name="code">asset</field>
18             <field name="report_type">asset</field>
19         </record>
20         <record model="account.account.type" id="account_type_liability_view1">
21             <field name="name">Liability View</field>
22             <field name="code">liability</field>
23             <field name="report_type">liability</field>
24         </record>
25         <record model="account.account.type" id="conf_account_type_tax">
26           <field name="name">Tax</field>
27           <field name="code">tax</field>
28           <field name="close_method">unreconciled</field>
29           <field name="report_type">expense</field>
30         </record>
31         <record model="account.account.type" id="conf_account_type_equity">
32           <field name="name">Equity</field>
33           <field name="code">equity</field>
34           <field name="close_method">balance</field>
35           <field name="report_type">liability</field>
36         </record>
37         <record model="account.account.type" id="conf_account_type_chk">
38           <field name="name">Check</field>
39           <field name="code">check</field>
40           <field name="close_method">balance</field>
41           <field name="report_type">asset</field>
42         </record>
43
44         <!-- Account Templates-->
45         <record id="conf_chart0" model="account.account.template">
46             <field name="code">0</field>
47             <field name="name">Configurable Account Chart</field>
48             <field name="type">view</field>
49             <field name="user_type" ref="data_account_type_view"/>
50         </record>
51
52            <!-- Balance Sheet -->
53
54         <record id="conf_bal" model="account.account.template">
55             <field name="code">1</field>
56             <field name="name">Balance Sheet</field>
57             <field ref="conf_chart0" name="parent_id"/>
58             <field name="type">view</field>
59             <field name="user_type" ref="data_account_type_view"/>
60         </record>
61
62             <record id="conf_fas" model="account.account.template">
63                 <field name="code">10</field>
64                 <field name="name">Fixed Assets</field>
65                 <field ref="conf_bal" name="parent_id"/>
66                 <field name="type">view</field>
67                 <field name="user_type" ref="account_type_asset_view1"/>
68             </record>
69
70                 <record id="conf_xfa" model="account.account.template">
71                     <field name="code">100</field>
72                     <field name="name">Fixed Asset Account</field>
73                     <field ref="conf_fas" name="parent_id"/>
74                     <field name="type">other</field>
75                     <field name="user_type" ref="account_type_asset_view1"/>
76                 </record>
77
78             <record id="conf_nca" model="account.account.template">
79                 <field name="code">11</field>
80                 <field name="name">Net Current Assets</field>
81                 <field ref="conf_bal" name="parent_id"/>
82                 <field name="type">view</field>
83                 <field name="user_type" ref="account_type_asset_view1"/>
84             </record>
85
86                 <record id="conf_cas" model="account.account.template">
87                     <field name="code">110</field>
88                     <field name="name">Current Assets</field>
89                     <field ref="conf_nca" name="parent_id"/>
90                     <field name="type">view</field>
91                     <field name="user_type" ref="account_type_asset_view1"/>
92                 </record>
93
94                     <record id="conf_stk" model="account.account.template">
95                         <field name="code">1101</field>
96                         <field name="name">Purchased Stocks</field>
97                         <field ref="conf_cas" name="parent_id"/>
98                         <field name="type">other</field>
99                         <field name="user_type" ref="data_account_type_asset"/>
100                     </record>
101
102                     <record id="conf_a_recv" model="account.account.template">
103                         <field name="code">1102</field>
104                         <field name="name">Debtors</field>
105                         <field ref="conf_cas" name="parent_id"/>
106                         <field name="type">receivable</field>
107                         <field eval="True" name="reconcile"/>
108                         <field name="user_type" ref="data_account_type_receivable"/>
109                     </record>
110
111                     <record id="conf_ova" model="account.account.template">
112                         <field name="code">1103</field>
113                         <field name="name">Tax Paid</field>
114                         <field ref="conf_cas" name="parent_id"/>
115                         <field name="type">other</field>
116                         <field name="user_type" ref="data_account_type_asset"/>
117                     </record>
118
119                     <record id="conf_bnk" model="account.account.template">
120                         <field name="code">1104</field>
121                         <field name="name">Bank Current Account</field>
122                         <field ref="conf_cas" name="parent_id"/>
123                         <field name="type">view</field>
124                         <field name="user_type" ref="account_type_asset_view1"/>
125                     </record>
126
127                     <record id="conf_o_income" model="account.account.template">
128                         <field name="code">1106</field>
129                         <field name="name">Opening Income Account</field>
130                         <field ref="conf_cas" name="parent_id"/>
131                         <field name="type">other</field>
132                         <field name="user_type" ref="data_account_type_income"/>
133                     </record>
134
135                 <record id="conf_cli" model="account.account.template">
136                     <field name="code">12</field>
137                     <field name="name">Current Liabilities</field>
138                     <field ref="conf_bal" name="parent_id"/>
139                     <field name="type">view</field>
140                     <field name="user_type" ref="account_type_liability_view1"/>
141                 </record>
142
143                     <record id="conf_a_pay" model="account.account.template">
144                         <field name="code">120</field>
145                         <field name="name">Creditors</field>
146                         <field ref="conf_cli" name="parent_id"/>
147                         <field name="type">payable</field>
148                         <field eval="True" name="reconcile"/>
149                         <field name="user_type" ref="data_account_type_payable"/>
150                     </record>
151
152                     <record id="conf_iva" model="account.account.template">
153                         <field name="code">121</field>
154                         <field name="name">Tax Received</field>
155                         <field ref="conf_cli" name="parent_id"/>
156                         <field name="type">other</field>
157                         <field name="user_type" ref="data_account_type_liability"/>
158                     </record>
159
160                     <record id="conf_a_reserve_and_surplus" model="account.account.template">
161                         <field name="code">122</field>
162                         <field name="name">Reserve and Profit/Loss Account</field>
163                         <field ref="conf_cli" name="parent_id"/>
164                         <field name="type">other</field>
165                         <field eval="True" name="reconcile"/>
166                         <field name="user_type" ref="data_account_type_liability"/>
167                     </record>
168
169                     <record id="conf_o_expense" model="account.account.template">
170                         <field name="code">123</field>
171                         <field name="name">Opening Expense Account</field>
172                         <field ref="conf_cli" name="parent_id"/>
173                         <field name="type">other</field>
174                         <field name="user_type" ref="data_account_type_expense"/>
175                     </record>
176
177         <!-- Profit and Loss -->
178
179         <record id="conf_gpf" model="account.account.template">
180             <field name="code">2</field>
181             <field name="name">Profit and Loss</field>
182             <field ref="conf_chart0" name="parent_id"/>
183             <field name="type">view</field>
184             <field name="user_type" ref="data_account_type_view"/>
185         </record>
186
187             <record id="conf_rev" model="account.account.template">
188                 <field name="code">20</field>
189                 <field name="name">Revenue</field>
190                 <field ref="conf_gpf" name="parent_id"/>
191                 <field name="type">view</field>
192                 <field name="user_type" ref="account_type_income_view1"/>
193             </record>
194
195                 <record id="conf_a_sale" model="account.account.template">
196                     <field name="code">200</field>
197                     <field name="name">Product Sales</field>
198                     <field ref="conf_rev" name="parent_id"/>
199                     <field name="type">other</field>
200                     <field name="user_type" ref="data_account_type_income"/>
201                 </record>
202
203             <record id="conf_cos" model="account.account.template">
204                 <field name="code">21</field>
205                 <field name="name">Cost of Sales</field>
206                 <field ref="conf_gpf" name="parent_id"/>
207                 <field name="type">view</field>
208                 <field name="user_type" ref="account_type_income_view1"/>
209             </record>
210
211                 <record id="conf_cog" model="account.account.template">
212                     <field name="code">210</field>
213                     <field name="name">Cost of Goods Sold</field>
214                     <field ref="conf_cos" name="parent_id"/>
215                     <field name="type">other</field>
216                     <field name="user_type" ref="data_account_type_expense"/>
217                 </record>
218
219             <record id="conf_ovr" model="account.account.template">
220                 <field name="code">22</field>
221                 <field name="name">Overheads</field>
222                 <field ref="conf_gpf" name="parent_id"/>
223                 <field name="type">view</field>
224                 <field name="user_type" ref="account_type_expense_view1"/>
225             </record>
226
227                 <record id="conf_a_expense" model="account.account.template">
228                     <field name="code">220</field>
229                     <field name="name">Expenses</field>
230                     <field ref="conf_ovr" name="parent_id"/>
231                     <field name="type">other</field>
232                     <field name="user_type" ref="data_account_type_expense"/>
233                 </record>
234
235                 <record id="conf_a_salary_expense" model="account.account.template">
236                     <field name="code">221</field>
237                     <field name="name">Salary Expenses</field>
238                     <field ref="conf_ovr" name="parent_id"/>
239                     <field name="type">other</field>
240                     <field name="user_type" ref="data_account_type_expense"/>
241                 </record>
242
243         <!-- Taxes -->
244         <!-- TAX Code Definitions -->
245
246         <!-- Invoiced TAX -->
247
248         <record id="tax_code_chart_root" model="account.tax.code.template">
249             <field name="name">Plan Fees </field>
250         </record>
251
252             <record id="tax_code_balance_net" model="account.tax.code.template">
253                 <field name="name">Tax Balance to Pay</field>
254                 <field name="parent_id" ref="tax_code_chart_root"/>
255             </record>
256
257             <!-- Input TAX -->
258             <record id="tax_code_input" model="account.tax.code.template">
259                 <field name="name">Tax Received</field>
260                 <field name="parent_id" ref="tax_code_balance_net"/>
261                 <field eval="-1" name="sign"/>
262             </record>
263
264                 <record id="tax_code_input_S" model="account.tax.code.template">
265                     <field name="name">Tax Received Rate S (15%)</field>
266                     <field name="parent_id" ref="tax_code_input"/>
267                 </record>
268
269                 <record id="tax_code_input_R" model="account.tax.code.template">
270                     <field name="name">Tax Received Rate R (5%)</field>
271                     <field name="parent_id" ref="tax_code_input"/>
272                 </record>
273
274                 <record id="tax_code_input_X" model="account.tax.code.template">
275                     <field name="name">Tax Received Rate X (Exempt)</field>
276                     <field name="parent_id" ref="tax_code_input"/>
277                 </record>
278
279                 <record id="tax_code_input_O" model="account.tax.code.template">
280                     <field name="name">Tax Received Rate O (Out of scope)</field>
281                     <field name="parent_id" ref="tax_code_input"/>
282                 </record>
283
284             <!-- Output TAX -->
285
286             <record id="tax_code_output" model="account.tax.code.template">
287                 <field name="name">Tax Paid</field>
288                 <field name="parent_id" ref="tax_code_balance_net"/>
289             </record>
290
291                 <record id="tax_code_output_S" model="account.tax.code.template">
292                     <field name="name">Tax Paid Rate S (15%)</field>
293                     <field name="parent_id" ref="tax_code_output"/>
294                 </record>
295
296                 <record id="tax_code_output_R" model="account.tax.code.template">
297                     <field name="name">Tax Paid Rate R (5%)</field>
298                     <field name="parent_id" ref="tax_code_output"/>
299                 </record>
300
301                 <record id="tax_code_output_X" model="account.tax.code.template">
302                     <field name="name">Tax Paid Rate X (Exempt)</field>
303                     <field name="parent_id" ref="tax_code_output"/>
304                 </record>
305
306                 <record id="tax_code_output_O" model="account.tax.code.template">
307                     <field name="name">Tax Paid Rate O (Out of scope)</field>
308                     <field name="parent_id" ref="tax_code_output"/>
309                 </record>
310
311
312             <!-- Invoiced Base of TAX -->
313
314             <!-- Purchases -->
315
316             <record id="tax_code_base_net" model="account.tax.code.template">
317                 <field name="name">Tax Bases</field>
318                 <field name="parent_id" ref="tax_code_chart_root"/>
319             </record>
320
321                 <record id="tax_code_base_purchases" model="account.tax.code.template">
322                     <field name="name">Taxable Purchases Base</field>
323                     <field name="parent_id" ref="tax_code_base_net"/>
324                 </record>
325
326                     <record id="tax_code_purch_S" model="account.tax.code.template">
327                         <field name="name">Taxable Purchases Rated S (15%)</field>
328                         <field name="parent_id" ref="tax_code_base_purchases"/>
329                     </record>
330
331                     <record id="tax_code_purch_R" model="account.tax.code.template">
332                         <field name="name">Taxable Purchases Rated R (5%)</field>
333                         <field name="parent_id" ref="tax_code_base_purchases"/>
334                     </record>
335
336                     <record id="tax_code_purch_X" model="account.tax.code.template">
337                         <field name="name">Taxable Purchases Type X (Exempt)</field>
338                         <field name="parent_id" ref="tax_code_base_purchases"/>
339                     </record>
340
341                     <record id="tax_code_purch_O" model="account.tax.code.template">
342                         <field name="name">Taxable Purchases Type O (Out of scope)</field>
343                         <field name="parent_id" ref="tax_code_base_purchases"/>
344                     </record>
345
346                 <!-- Sales -->
347
348                 <record id="tax_code_base_sales" model="account.tax.code.template">
349                     <field name="name">Base of Taxable Sales</field>
350                     <field name="parent_id" ref="tax_code_base_net"/>
351                 </record>
352
353                     <record id="tax_code_sales_S" model="account.tax.code.template">
354                         <field name="name">Taxable Sales Rated S (15%)</field>
355                         <field name="parent_id" ref="tax_code_base_sales"/>
356                     </record>
357
358                     <record id="tax_code_sales_R" model="account.tax.code.template">
359                         <field name="name">Taxable Sales Rated R (5%)</field>
360                         <field name="parent_id" ref="tax_code_base_sales"/>
361                     </record>
362
363                     <record id="tax_code_sales_X" model="account.tax.code.template">
364                         <field name="name">Taxable Sales Type X (Exempt)</field>
365                         <field name="parent_id" ref="tax_code_base_sales"/>
366                     </record>
367
368                     <record id="tax_code_sales_O" model="account.tax.code.template">
369                         <field name="name">Taxable Sales Type O (Out of scope)</field>
370                         <field name="parent_id" ref="tax_code_base_sales"/>
371                     </record>
372
373         <record id="configurable_chart_template" model="account.chart.template">
374             <field name="name">Configurable Account Chart Template</field>
375             <field name="account_root_id" ref="conf_chart0"/>
376             <field name="tax_code_root_id" ref="tax_code_chart_root"/>
377             <field name="bank_account_view_id" ref="conf_bnk"/>
378             <field name="property_account_receivable" ref="conf_a_recv"/>
379             <field name="property_account_payable" ref="conf_a_pay"/>
380             <field name="property_account_expense_categ" ref="conf_a_expense"/>
381             <field name="property_account_income_categ" ref="conf_a_sale"/>
382             <field name="property_account_income_opening" ref="conf_o_income"/>
383             <field name="property_account_expense_opening" ref="conf_o_expense"/>
384             <field name="complete_tax_set" eval="False"/>
385         </record>
386
387          <!-- VAT Codes -->
388         <!-- Purchases + Output VAT -->
389
390         <record id="otaxs" model="account.tax.template">
391             <field name="chart_template_id" ref="configurable_chart_template"/>
392             <field name="name">OTAX S</field>
393             <field eval="0.15" name="amount"/>
394             <field name="type">percent</field>
395             <field name="account_collected_id" ref="conf_ova"/>
396             <field name="account_paid_id" ref="conf_ova"/>
397             <field name="base_code_id" ref="tax_code_purch_S"/>
398             <field name="tax_code_id" ref="tax_code_output_S"/>
399             <field name="ref_base_code_id" ref="tax_code_purch_S"/>
400             <field name="ref_tax_code_id" ref="tax_code_output_S"/>
401             <field name="type_tax_use">purchase</field>
402         </record>
403
404         <record id="otaxr" model="account.tax.template">
405             <field name="chart_template_id" ref="configurable_chart_template"/>
406             <field name="name">OTAX R</field>
407             <field eval="0.05" name="amount"/>
408             <field name="type">percent</field>
409             <field name="account_collected_id" ref="conf_ova"/>
410             <field name="account_paid_id" ref="conf_ova"/>
411             <field name="base_code_id" ref="tax_code_purch_R"/>
412             <field name="tax_code_id" ref="tax_code_output_R"/>
413             <field name="ref_base_code_id" ref="tax_code_purch_R"/>
414             <field name="ref_tax_code_id" ref="tax_code_output_R"/>
415             <field name="type_tax_use">purchase</field>
416         </record>
417
418         <record id="otaxx" model="account.tax.template">
419             <field name="chart_template_id" ref="configurable_chart_template"/>
420             <field name="name">OTAX X</field>
421             <field eval="0.0" name="amount"/>
422             <field name="type">percent</field>
423             <field name="account_collected_id" ref="conf_ova"/>
424             <field name="account_paid_id" ref="conf_ova"/>
425             <field name="base_code_id" ref="tax_code_purch_X"/>
426             <field name="tax_code_id" ref="tax_code_output_X"/>
427             <field name="ref_base_code_id" ref="tax_code_purch_X"/>
428             <field name="ref_tax_code_id" ref="tax_code_output_X"/>
429             <field name="type_tax_use">purchase</field>
430         </record>
431
432         <record id="otaxo" model="account.tax.template">
433             <field name="chart_template_id" ref="configurable_chart_template"/>
434             <field name="name">OTAX O</field>
435             <field eval="0.0" name="amount"/>
436             <field name="type">percent</field>
437             <field name="account_collected_id" ref="conf_ova"/>
438             <field name="account_paid_id" ref="conf_ova"/>
439             <field name="base_code_id" ref="tax_code_purch_O"/>
440             <field name="tax_code_id" ref="tax_code_output_O"/>
441             <field name="ref_base_code_id" ref="tax_code_purch_O"/>
442             <field name="ref_tax_code_id" ref="tax_code_output_O"/>
443             <field name="type_tax_use">purchase</field>
444         </record>
445
446         <!-- Sales + Input VAT -->
447
448         <record id="itaxs" model="account.tax.template">
449             <field name="chart_template_id" ref="configurable_chart_template"/>
450             <field name="name">ITAX S</field>
451             <field eval="0.15" name="amount"/>
452             <field name="type">percent</field>
453             <field name="account_collected_id" ref="conf_iva"/>
454             <field name="account_paid_id" ref="conf_iva"/>
455             <field name="base_code_id" ref="tax_code_sales_S"/>
456             <field name="tax_code_id" ref="tax_code_input_S"/>
457             <field name="ref_base_code_id" ref="tax_code_sales_S"/>
458             <field name="ref_tax_code_id" ref="tax_code_input_S"/>
459             <field name="type_tax_use">sale</field>
460         </record>
461
462         <record id="itaxr" model="account.tax.template">
463             <field name="chart_template_id" ref="configurable_chart_template"/>
464             <field name="name">ITAX R</field>
465             <field eval="0.05" name="amount"/>
466             <field name="type">percent</field>
467             <field name="account_collected_id" ref="conf_iva"/>
468             <field name="account_paid_id" ref="conf_iva"/>
469             <field name="base_code_id" ref="tax_code_sales_R"/>
470             <field name="tax_code_id" ref="tax_code_input_R"/>
471             <field name="ref_base_code_id" ref="tax_code_sales_R"/>
472             <field name="ref_tax_code_id" ref="tax_code_input_R"/>
473             <field name="type_tax_use">sale</field>
474         </record>
475
476         <record id="itaxx" model="account.tax.template">
477             <field name="chart_template_id" ref="configurable_chart_template"/>
478             <field name="name">ITAX X</field>
479             <field eval="0.0" name="amount"/>
480             <field name="type">percent</field>
481             <field name="account_collected_id" ref="conf_iva"/>
482             <field name="account_paid_id" ref="conf_iva"/>
483             <field name="base_code_id" ref="tax_code_sales_X"/>
484             <field name="tax_code_id" ref="tax_code_input_X"/>
485             <field name="ref_base_code_id" ref="tax_code_sales_X"/>
486             <field name="ref_tax_code_id" ref="tax_code_input_X"/>
487             <field name="type_tax_use">sale</field>
488         </record>
489
490         <record id="itaxo" model="account.tax.template">
491             <field name="chart_template_id" ref="configurable_chart_template"/>
492             <field name="name">ITAX O</field>
493             <field eval="0.0" name="amount"/>
494             <field name="type">percent</field>
495             <field name="account_collected_id" ref="conf_iva"/>
496             <field name="account_paid_id" ref="conf_iva"/>
497             <field name="base_code_id" ref="tax_code_sales_O"/>
498             <field name="tax_code_id" ref="tax_code_input_O"/>
499             <field name="ref_base_code_id" ref="tax_code_sales_O"/>
500             <field name="ref_tax_code_id" ref="tax_code_input_O"/>
501             <field name="type_tax_use">sale</field>
502         </record>
503
504
505
506         <!-- = = = = = = = = = = = = = = = -->
507          <!-- Fiscal Mapping Templates     -->
508         <!-- = = = = = = = = = = = = = = = -->
509
510
511         <record id="fiscal_position_normal_taxes_template1" model="account.fiscal.position.template">
512             <field name="name">Normal Taxes</field>
513             <field name="chart_template_id" ref="configurable_chart_template"/>
514         </record>
515
516         <record id="fiscal_position_tax_exempt_template2" model="account.fiscal.position.template">
517             <field name="name">Tax Exempt</field>
518             <field name="chart_template_id" ref="configurable_chart_template"/>
519         </record>
520
521         <!-- = = = = = = = = = = = = = = = -->
522         <!-- Fiscal Position Tax Templates -->
523         <!-- = = = = = = = = = = = = = = = -->
524
525
526         <record id="fiscal_position_normal_taxes" model="account.fiscal.position.tax.template">
527             <field name="position_id" ref="fiscal_position_normal_taxes_template1"/>
528             <field name="tax_src_id" ref="itaxs"/>
529             <field name="tax_dest_id" ref="otaxs"/>
530         </record>
531
532         <record id="fiscal_position_tax_exempt" model="account.fiscal.position.tax.template">
533             <field name="position_id" ref="fiscal_position_tax_exempt_template2"/>
534             <field name="tax_src_id" ref="itaxx"/>
535             <field name="tax_dest_id" ref="otaxx"/>
536         </record>
537
538
539         <!--  Assigned Default Taxes For Different Account -->
540
541         <record id="conf_a_sale" model="account.account.template">
542             <field name="tax_ids" eval="[(6,0,[ref('itaxs')])]"/>
543         </record>
544
545         <record id="conf_a_expense" model="account.account.template">
546             <field name="tax_ids" eval="[(6,0,[ref('otaxs')])]"/>
547         </record>
548
549         <record id="action_wizard_multi_chart_todo" model="ir.actions.todo">
550             <field name="name">Set Your Accounting Options</field>
551             <field name="action_id" ref="account.action_wizard_multi_chart"/>
552             <field name="type">automatic</field>
553         </record>
554
555
556     </data>
557 </openerp>