[IMP]: improve bank and cash statement
[odoo/odoo.git] / addons / account / data / account_data2.xml
1 <?xml version="1.0" encoding="utf-8"?>
2 <openerp>
3     <data noupdate="1">
4
5         <!--
6         Payment term
7         -->
8         <record id="account_payment_term" model="account.payment.term">
9             <field name="name">30 Days End of Month</field>
10         </record>
11         <record id="account_payment_term_line" model="account.payment.term.line">
12             <field name="name">30 Days End of Month</field>
13             <field name="value">balance</field>
14             <field eval="30" name="days"/>
15             <field eval="-1" name="days2"/>
16             <field eval="account_payment_term" name="payment_id"/>
17         </record>
18
19         <!--
20         Account Journal View
21         -->
22         <record id="account_journal_bank_view" model="account.journal.view">
23             <field name="name">Bank/Cash Journal View</field>
24         </record>
25         <record id="bank_col1" model="account.journal.column">
26             <field name="view_id" ref="account_journal_bank_view"/>
27             <field name="name">Date</field>
28             <field name="field">date</field>
29             <field eval="True" name="required"/>
30             <field eval="1" name="sequence"/>
31         </record>
32         <record id="bank_col2" model="account.journal.column">
33             <field name="view_id" ref="account_journal_bank_view"/>
34             <field name="name">N. Piece</field>
35             <field name="field">move_id</field>
36             <field eval="False" name="required"/>
37             <field eval="2" name="sequence"/>
38         </record>
39         <record id="bank_col7" model="account.journal.column">
40             <field name="view_id" ref="account_journal_bank_view"/>
41             <field name="name">Name</field>
42             <field name="field">name</field>
43             <field eval="3" name="sequence"/>
44             <field eval="True" name="required"/>
45         </record>
46         <record id="bank_col4" model="account.journal.column">
47             <field name="view_id" ref="account_journal_bank_view"/>
48             <field name="name">Statement</field>
49             <field name="field">statement_id</field>
50             <field eval="4" name="sequence"/>
51         </record>
52         <record id="bank_col6" model="account.journal.column">
53             <field name="view_id" ref="account_journal_bank_view"/>
54             <field name="name">Partner</field>
55             <field name="field">partner_id</field>
56             <field eval="5" name="sequence"/>
57         </record>
58         <record id="bank_col5" model="account.journal.column">
59             <field name="view_id" ref="account_journal_bank_view"/>
60             <field name="name">Account</field>
61             <field name="field">account_id</field>
62             <field eval="True" name="required"/>
63             <field eval="6" name="sequence"/>
64         </record>
65         <record id="bank_col9" model="account.journal.column">
66             <field name="view_id" ref="account_journal_bank_view"/>
67             <field name="name">Debit</field>
68             <field name="field">debit</field>
69             <field eval="10" name="sequence"/>
70         </record>
71         <record id="bank_col10" model="account.journal.column">
72             <field name="view_id" ref="account_journal_bank_view"/>
73             <field name="name">Credit</field>
74             <field name="field">credit</field>
75             <field eval="11" name="sequence"/>
76         </record>
77         <record id="bank_col3" model="account.journal.column">
78             <field name="view_id" ref="account_journal_bank_view"/>
79             <field name="name">Ref</field>
80             <field name="field">ref</field>
81             <field eval="7" name="sequence"/>
82         </record>
83         <record id="bank_col23" model="account.journal.column">
84             <field name="view_id" ref="account_journal_bank_view"/>
85             <field name="name">State</field>
86             <field name="field">state</field>
87             <field eval="14" name="sequence"/>
88         </record>
89
90         <record id="account_journal_bank_view_multi" model="account.journal.view">
91             <field name="name">Bank/Cash Journal (Multi-Currency) View</field>
92         </record>
93         <record id="bank_col1_multi" model="account.journal.column">
94             <field name="view_id" ref="account_journal_bank_view_multi"/>
95             <field name="name">Date</field>
96             <field name="field">date</field>
97             <field eval="True" name="required"/>
98             <field eval="1" name="sequence"/>
99         </record>
100         <record id="bank_col2_multi" model="account.journal.column">
101             <field name="view_id" ref="account_journal_bank_view_multi"/>
102             <field name="name">N. Piece</field>
103             <field name="field">move_id</field>
104             <field eval="False" name="required"/>
105             <field eval="2" name="sequence"/>
106         </record>
107         <record id="bank_col7_multi" model="account.journal.column">
108             <field name="view_id" ref="account_journal_bank_view_multi"/>
109             <field name="name">Name</field>
110             <field name="field">name</field>
111             <field eval="3" name="sequence"/>
112             <field eval="True" name="required"/>
113         </record>
114         <record id="bank_col4_multi" model="account.journal.column">
115             <field name="view_id" ref="account_journal_bank_view_multi"/>
116             <field name="name">Statement</field>
117             <field name="field">statement_id</field>
118             <field eval="4" name="sequence"/>
119         </record>
120         <record id="bank_col6_multi" model="account.journal.column">
121             <field name="view_id" ref="account_journal_bank_view_multi"/>
122             <field name="name">Partner</field>
123             <field name="field">partner_id</field>
124             <field eval="5" name="sequence"/>
125         </record>
126         <record id="bank_col5_multi" model="account.journal.column">
127             <field name="view_id" ref="account_journal_bank_view_multi"/>
128             <field name="name">Account</field>
129             <field name="field">account_id</field>
130             <field eval="True" name="required"/>
131             <field eval="6" name="sequence"/>
132         </record>
133         <record id="bank_col17_multi" model="account.journal.column">
134             <field name="view_id" ref="account_journal_bank_view_multi"/>
135             <field name="name">Currency Amt.</field>
136             <field name="field">amount_currency</field>
137             <field eval="8" name="sequence"/>
138         </record>
139         <record id="bank_col18_multi" model="account.journal.column">
140             <field name="view_id" ref="account_journal_bank_view_multi"/>
141             <field name="name">Currency</field>
142             <field name="field">currency_id</field>
143             <field eval="9" name="sequence"/>
144         </record>
145         <record id="bank_col9_multi" model="account.journal.column">
146             <field name="view_id" ref="account_journal_bank_view_multi"/>
147             <field name="name">Debit</field>
148             <field name="field">debit</field>
149             <field eval="10" name="sequence"/>
150         </record>
151         <record id="bank_col10_multi" model="account.journal.column">
152             <field name="view_id" ref="account_journal_bank_view_multi"/>
153             <field name="name">Credit</field>
154             <field name="field">credit</field>
155             <field eval="11" name="sequence"/>
156         </record>
157         <record id="bank_col3_multi" model="account.journal.column">
158             <field name="view_id" ref="account_journal_bank_view_multi"/>
159             <field name="name">Ref</field>
160             <field name="field">ref</field>
161             <field eval="7" name="sequence"/>
162         </record>
163         <record id="bank_col23_multi" model="account.journal.column">
164             <field name="view_id" ref="account_journal_bank_view_multi"/>
165             <field name="name">State</field>
166             <field name="field">state</field>
167             <field eval="16" name="sequence"/>
168         </record>
169
170
171         <record id="account_journal_view" model="account.journal.view">
172             <field name="name">Journal View</field>
173         </record>
174         <record id="journal_col1" model="account.journal.column">
175             <field name="view_id" ref="account_journal_view"/>
176             <field name="name">Date</field>
177             <field name="field">date</field>
178             <field eval="True" name="required"/>
179             <field eval="1" name="sequence"/>
180         </record>
181         <record id="journal_col2" model="account.journal.column">
182             <field name="view_id" ref="account_journal_view"/>
183             <field name="name">N. Piece</field>
184             <field name="field">move_id</field>
185             <field eval="False" name="required"/>
186             <field eval="2" name="sequence"/>
187         </record>
188         <record id="journal_col3" model="account.journal.column">
189             <field name="view_id" ref="account_journal_view"/>
190             <field name="name">Ref</field>
191             <field name="field">ref</field>
192             <field eval="3" name="sequence"/>
193         </record>
194         <record id="journal_col5" model="account.journal.column">
195             <field name="view_id" ref="account_journal_view"/>
196             <field name="name">Partner</field>
197             <field name="field">partner_id</field>
198             <field eval="4" name="sequence"/>
199         </record>
200         <record id="journal_col4" model="account.journal.column">
201             <field name="view_id" ref="account_journal_view"/>
202             <field name="name">Account</field>
203             <field name="field">account_id</field>
204             <field eval="True" name="required"/>
205             <field eval="5" name="sequence"/>
206         </record>
207         <record id="journal_col6" model="account.journal.column">
208             <field name="view_id" ref="account_journal_view"/>
209             <field name="name">Name</field>
210             <field name="field">name</field>
211             <field eval="6" name="sequence"/>
212             <field eval="True" name="required"/>
213         </record>
214         <record id="journal_col8" model="account.journal.column">
215             <field name="view_id" ref="account_journal_view"/>
216             <field name="name">Debit</field>
217             <field name="field">debit</field>
218             <field eval="8" name="sequence"/>
219         </record>
220         <record id="journal_col9" model="account.journal.column">
221             <field name="view_id" ref="account_journal_view"/>
222             <field name="name">Credit</field>
223             <field name="field">credit</field>
224             <field eval="9" name="sequence"/>
225         </record>
226         <record id="journal_col11" model="account.journal.column">
227             <field name="view_id" ref="account_journal_view"/>
228             <field name="name">Analytic Account</field>
229             <field name="field">analytic_account_id</field>
230             <field eval="11" name="sequence"/>
231         </record>
232         <record id="journal_col24" model="account.journal.column">
233             <field name="view_id" ref="account_journal_view"/>
234             <field name="name">State</field>
235             <field name="field">state</field>
236             <field eval="14" name="sequence"/>
237         </record>
238         
239         
240         <record id="account_sp_journal_view" model="account.journal.view">
241             <field name="name">Sale/Purchase Journal View</field>
242         </record>
243         <record id="sp_journal_col1" model="account.journal.column">
244             <field name="view_id" ref="account_sp_journal_view"/>
245             <field name="name">Date</field>
246             <field name="field">date</field>
247             <field eval="True" name="required"/>
248             <field eval="1" name="sequence"/>
249         </record>
250         <record id="sp_journal_col2" model="account.journal.column">
251             <field name="view_id" ref="account_sp_journal_view"/>
252             <field name="name">N. Piece</field>
253             <field name="field">move_id</field>
254             <field eval="False" name="required"/>
255             <field eval="2" name="sequence"/>
256         </record>
257         <record id="sp_journal_col3" model="account.journal.column">
258             <field name="view_id" ref="account_sp_journal_view"/>
259             <field name="name">Ref</field>
260             <field name="field">ref</field>
261             <field eval="3" name="sequence"/>
262         </record>
263         <record id="sp_journal_col4" model="account.journal.column">
264             <field name="view_id" ref="account_sp_journal_view"/>
265             <field name="name">Account</field>
266             <field name="field">account_id</field>
267             <field eval="True" name="required"/>
268             <field eval="5" name="sequence"/>
269         </record>
270         <record id="sp_journal_col5" model="account.journal.column">
271             <field name="view_id" ref="account_sp_journal_view"/>
272             <field name="name">Partner</field>
273             <field name="field">partner_id</field>
274             <field eval="4" name="sequence"/>
275         </record>
276         <record id="sp_journal_col6" model="account.journal.column">
277             <field name="view_id" ref="account_sp_journal_view"/>
278             <field name="name">Name</field>
279             <field name="field">name</field>
280             <field eval="6" name="sequence"/>
281             <field eval="True" name="required"/>
282         </record>
283         <record id="sp_journal_col7" model="account.journal.column">
284             <field name="view_id" ref="account_sp_journal_view"/>
285             <field name="name">Maturity Date</field>
286             <field name="field">date_maturity</field>
287             <field eval="7" name="sequence"/>
288         </record>
289         <record id="sp_journal_col8" model="account.journal.column">
290             <field name="view_id" ref="account_sp_journal_view"/>
291             <field name="name">Debit</field>
292             <field name="field">debit</field>
293             <field eval="8" name="sequence"/>
294         </record>
295         <record id="sp_journal_col9" model="account.journal.column">
296             <field name="view_id" ref="account_sp_journal_view"/>
297             <field name="name">Credit</field>
298             <field name="field">credit</field>
299             <field eval="9" name="sequence"/>
300         </record>
301         <record id="sp_journal_col10" model="account.journal.column">
302             <field name="view_id" ref="account_sp_journal_view"/>
303             <field name="name">Tax</field>
304             <field name="field">account_tax_id</field>
305             <field eval="10" name="sequence"/>
306         </record>
307         <record id="sp_journal_col11" model="account.journal.column">
308             <field name="view_id" ref="account_sp_journal_view"/>
309             <field name="name">Analytic Account</field>
310             <field name="field">analytic_account_id</field>
311             <field eval="11" name="sequence"/>
312         </record>
313         <record id="sp_journal_col25" model="account.journal.column">
314             <field name="view_id" ref="account_sp_journal_view"/>
315             <field name="name">Tax Acc.</field>
316             <field name="field">tax_code_id</field>
317             <field eval="12" name="sequence"/>
318         </record>
319         <record id="sp_journal_col26" model="account.journal.column">
320             <field name="view_id" ref="account_sp_journal_view"/>
321             <field name="name">Tax</field>
322             <field name="field">tax_amount</field>
323             <field eval="13" name="sequence"/>
324         </record>
325         <record id="sp_journal_col24" model="account.journal.column">
326             <field name="view_id" ref="account_sp_journal_view"/>
327             <field name="name">State</field>
328             <field name="field">state</field>
329             <field eval="14" name="sequence"/>
330         </record>
331         
332         <record id="account_sp_refund_journal_view" model="account.journal.view">
333             <field name="name">Sale/Purchase Refund Journal View</field>
334         </record>
335         <record id="sp_refund_journal_col1" model="account.journal.column">
336             <field name="view_id" ref="account_sp_refund_journal_view"/>
337             <field name="name">Date</field>
338             <field name="field">date</field>
339             <field eval="True" name="required"/>
340             <field eval="1" name="sequence"/>
341         </record>
342         <record id="sp_refund_journal_col2" model="account.journal.column">
343             <field name="view_id" ref="account_sp_refund_journal_view"/>
344             <field name="name">N. Piece</field>
345             <field name="field">move_id</field>
346             <field eval="False" name="required"/>
347             <field eval="2" name="sequence"/>
348         </record>
349         <record id="sp_refund_journal_col3" model="account.journal.column">
350             <field name="view_id" ref="account_sp_refund_journal_view"/>
351             <field name="name">Ref</field>
352             <field name="field">ref</field>
353             <field eval="3" name="sequence"/>
354         </record>
355         <record id="sp_refund_journal_col4" model="account.journal.column">
356             <field name="view_id" ref="account_sp_refund_journal_view"/>
357             <field name="name">Account</field>
358             <field name="field">account_id</field>
359             <field eval="True" name="required"/>
360             <field eval="5" name="sequence"/>
361         </record>
362         <record id="sp_refund_journal_col5" model="account.journal.column">
363             <field name="view_id" ref="account_sp_refund_journal_view"/>
364             <field name="name">Partner</field>
365             <field name="field">partner_id</field>
366             <field eval="4" name="sequence"/>
367         </record>
368         <record id="sp_refund_journal_col6" model="account.journal.column">
369             <field name="view_id" ref="account_sp_refund_journal_view"/>
370             <field name="name">Name</field>
371             <field name="field">name</field>
372             <field eval="6" name="sequence"/>
373             <field eval="True" name="required"/>
374         </record>
375         <record id="sp_refund_journal_col7" model="account.journal.column">
376             <field name="view_id" ref="account_sp_refund_journal_view"/>
377             <field name="name">Maturity Date</field>
378             <field name="field">date_maturity</field>
379             <field eval="7" name="sequence"/>
380         </record>
381         <record id="sp_refund_journal_col8" model="account.journal.column">
382             <field name="view_id" ref="account_sp_refund_journal_view"/>
383             <field name="name">Debit</field>
384             <field name="field">debit</field>
385             <field eval="8" name="sequence"/>
386         </record>
387         <record id="sp_refund_journal_col9" model="account.journal.column">
388             <field name="view_id" ref="account_sp_refund_journal_view"/>
389             <field name="name">Credit</field>
390             <field name="field">credit</field>
391             <field eval="9" name="sequence"/>
392         </record>
393         <record id="sp_refund_journal_col10" model="account.journal.column">
394             <field name="view_id" ref="account_sp_refund_journal_view"/>
395             <field name="name">Tax</field>
396             <field name="field">account_tax_id</field>
397             <field eval="10" name="sequence"/>
398         </record>
399         <record id="sp_refund_journal_col11" model="account.journal.column">
400             <field name="view_id" ref="account_sp_refund_journal_view"/>
401             <field name="name">Analytic Account</field>
402             <field name="field">analytic_account_id</field>
403             <field eval="11" name="sequence"/>
404         </record>
405         <record id="sp_refund_journal_col25" model="account.journal.column">
406             <field name="view_id" ref="account_sp_refund_journal_view"/>
407             <field name="name">Tax Acc.</field>
408             <field name="field">tax_code_id</field>
409             <field eval="12" name="sequence"/>
410         </record>
411         <record id="sp_refund_journal_col26" model="account.journal.column">
412             <field name="view_id" ref="account_sp_refund_journal_view"/>
413             <field name="name">Tax</field>
414             <field name="field">tax_amount</field>
415             <field eval="13" name="sequence"/>
416         </record>
417         <record id="sp_refund_journal_col24" model="account.journal.column">
418             <field name="view_id" ref="account_sp_refund_journal_view"/>
419             <field name="name">State</field>
420             <field name="field">state</field>
421             <field eval="14" name="sequence"/>
422         </record>
423         <!--
424         Account Journal Sequences
425         -->
426
427         <record id="sequence_journal_type" model="ir.sequence.type">
428             <field name="name">Account Journal</field>
429             <field name="code">account.journal</field>
430         </record>
431         <record id="sequence_journal" model="ir.sequence">
432             <field name="name">Account Journal</field>
433             <field name="code">account.journal</field>
434             <field name="prefix"/>
435         </record>
436         <record id="sequence_sale_journal" model="ir.sequence">
437             <field name="name">Sale Journal</field>
438             <field name="code">account.journal</field>
439             <field name="prefix"/>
440         </record>
441         <record id="sequence_purchase_journal" model="ir.sequence">
442             <field name="name">Purchase Journal</field>
443             <field name="code">account.journal</field>
444             <field name="prefix"/>
445         </record>
446
447         <!--
448         Account Statement Sequences
449         -->
450
451         <record id="sequence_reconcile" model="ir.sequence.type">
452             <field name="name">Account reconcile sequence</field>
453             <field name="code">account.reconcile</field>
454         </record>
455         <record id="sequence_reconcile_seq" model="ir.sequence">
456             <field name="name">Account reconcile sequence</field>
457             <field name="code">account.reconcile</field>
458             <field name="prefix">A</field>
459             <field eval="1" name="number_next"/>
460             <field eval="1" name="number_increment"/>
461         </record>
462
463         <record id="sequence_statement_type" model="ir.sequence.type">
464             <field name="name">Bank Statement</field>
465             <field name="code">account.bank.statement</field>
466         </record>
467         <record id="sequence_statement" model="ir.sequence">
468             <field name="name">Account Bank Statement</field>
469             <field name="code">account.bank.statement</field>
470             <field name="prefix">St. %(month)s/%(day)s/</field>
471             <field eval="0" name="number_next"/>
472             <field eval="1" name="number_increment"/>
473         </record>
474         
475         <record id="cash_sequence_statement_type" model="ir.sequence.type">
476             <field name="name">Cash Statement</field>
477             <field name="code">account.cash.statement</field>
478         </record>
479         <record id="cash_sequence_statement" model="ir.sequence">
480             <field name="name">Account Cash Statement</field>
481             <field name="code">account.cash.statement</field>
482             <field name="prefix">Cr. %(month)s/%(day)s/</field>
483             <field eval="0" name="number_next"/>
484             <field eval="1" name="number_increment"/>
485         </record>
486     </data>
487 </openerp>