Difference between revisions of "Accounting export template CielRimport"
m |
m (Text replacement - "[[Accounting_export_template_list|" to "[[Accounting-export-template-list|") |
||
(10 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | + | =Introduction= | |
− | + | This page described the [[Accounting-export-template-list|accounting export template]] Rimport for Ciel software. | |
− | + | ||
− | + | ||
− | + | ||
− | + | =Output file description= | |
− | + | * Encoding charset: ISO-8859-15 | |
− | + | * Field character separator: Tab | |
+ | * Fields: | ||
+ | {| class="wikitable" | ||
+ | !Name!!Length (in character)!!Description | ||
+ | |- | ||
+ | |Flow number||6||Filled with prepended zeros to match length | ||
+ | |- | ||
+ | |Export code|||| | ||
+ | |- | ||
+ | |Date||||Format is DD/MM/YYYY | ||
+ | |- | ||
+ | |Export account||13||Filled with appended spaces to match length | ||
+ | |- | ||
+ | |Description||35||Filled with appended spaces to match length | ||
+ | |- | ||
+ | |Amount||||Number with 2 digits after the decimal separator | ||
+ | |- | ||
+ | |Character C or D||||C for credit, D for debit | ||
+ | |- | ||
+ | |Character B|||| | ||
+ | |- | ||
+ | |Comments||50||Filled with appended spaces to match length | ||
+ | |} | ||
− | + | =Example of output file= | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | <pre>000067 VT 01/01/2014 411000 Pilote CHRISTIAN CHRISTIAN 99.00 D B | |
− | + | 000067 VT 01/01/2014 706BVOI Solo FBVOI 99.00 C B | |
− | + | 000069 VT 01/01/2014 411000 Pilote Éléonore ÉLÉONORE 51.00 D B | |
− | + | 000069 VT 01/01/2014 706BVOI Solo FBVOI 51.00 C B | |
− | + | 000071 VT 01/01/2014 411000 Pilote Nadine NADINE 51.00 D B | |
− | + | 000071 VT 01/01/2014 706BVOI Solo FBVOI 51.00 C B | |
− | + | 000073 VT 02/01/2014 411000 Pilote Éléonore ÉLÉONORE 408.00 D B | |
− | + | 000073 VT 02/01/2014 706BVOI Solo FBVOI 408.00 C B | |
− | + | 000075 VT 03/01/2014 411000 Pilote Christophe LARATTE 99.00 D B | |
− | + | 000075 VT 03/01/2014 706BVOI Solo FBVOI 99.00 C B | |
− | + | 000077 VT 03/01/2014 411000 Pilote Marie-France MARIE-FRANCE 124.00 D B | |
− | + | 000077 VT 03/01/2014 706BVOI Solo FBVOI 124.00 C B | |
− | + | 000079 VT 05/01/2014 411000 Pilote Erwan ERWAN 99.00 D B | |
− | + | 000079 VT 05/01/2014 706BVOI Solo FBVOI 99.00 C B | |
− | + | 000343 VT 01/01/2014 411000 Pilote Susie SUSIE 159.00 D B | |
− | + | 000343 VT 01/01/2014 706GNNB Solo FGNNB 159.00 C B | |
− | + | 000459 VT 01/01/2014 411000 Pilote Thomas THOMAS 138.00 D B | |
− | + | 000459 VT 01/01/2014 706GIKI Solo FGIKI 138.00 C B | |
− | + | 000461 VT 01/01/2014 411000 Pilote firstTest4 lastTest4 110.00 D B | |
− | + | 000461 VT 01/01/2014 706GIKI Solo FGIKI 110.00 C B | |
− | + | 000463 VT 01/01/2014 411000 Pilote Thomas THOMAS 69.00 D B | |
− | + | 000463 VT 01/01/2014 706GIKI Solo FGIKI 69.00 C B | |
− | + | 000465 VT 01/01/2014 411000 Pilote Richard RICHARD 207.00 D B | |
− | + | 000465 VT 01/01/2014 706GIKI Solo FGIKI 207.00 C B | |
− | + | 000467 VT 02/01/2014 411000 Pilote Briac BRIAC 345.00 D B | |
− | + | 000467 VT 02/01/2014 706GIKI Solo FGIKI 345.00 C B | |
− | + | 000469 VT 03/01/2014 411000 Pilote firstTest5 lastTest5 138.00 D B | |
− | + | 000469 VT 03/01/2014 706GIKI Solo FGIKI 138.00 C B | |
− | + | 000471 VT 03/01/2014 411000 Pilote firstTest6 lastTest6 138.00 D B | |
− | + | 000471 VT 03/01/2014 706GIKI Solo FGIKI 138.00 C B | |
− | + | 000473 VT 05/01/2014 411000 Pilote tom TOM 110.00 D B | |
− | + | 000473 VT 05/01/2014 706GIKI Solo FGIKI 110.00 C B | |
− | + | </pre> | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + |
Latest revision as of 10:13, 18 July 2016
Introduction
This page described the accounting export template Rimport for Ciel software.
Output file description
- Encoding charset: ISO-8859-15
- Field character separator: Tab
- Fields:
Name | Length (in character) | Description |
---|---|---|
Flow number | 6 | Filled with prepended zeros to match length |
Export code | ||
Date | Format is DD/MM/YYYY | |
Export account | 13 | Filled with appended spaces to match length |
Description | 35 | Filled with appended spaces to match length |
Amount | Number with 2 digits after the decimal separator | |
Character C or D | C for credit, D for debit | |
Character B | ||
Comments | 50 | Filled with appended spaces to match length |
Example of output file
000067 VT 01/01/2014 411000 Pilote CHRISTIAN CHRISTIAN 99.00 D B 000067 VT 01/01/2014 706BVOI Solo FBVOI 99.00 C B 000069 VT 01/01/2014 411000 Pilote Éléonore ÉLÉONORE 51.00 D B 000069 VT 01/01/2014 706BVOI Solo FBVOI 51.00 C B 000071 VT 01/01/2014 411000 Pilote Nadine NADINE 51.00 D B 000071 VT 01/01/2014 706BVOI Solo FBVOI 51.00 C B 000073 VT 02/01/2014 411000 Pilote Éléonore ÉLÉONORE 408.00 D B 000073 VT 02/01/2014 706BVOI Solo FBVOI 408.00 C B 000075 VT 03/01/2014 411000 Pilote Christophe LARATTE 99.00 D B 000075 VT 03/01/2014 706BVOI Solo FBVOI 99.00 C B 000077 VT 03/01/2014 411000 Pilote Marie-France MARIE-FRANCE 124.00 D B 000077 VT 03/01/2014 706BVOI Solo FBVOI 124.00 C B 000079 VT 05/01/2014 411000 Pilote Erwan ERWAN 99.00 D B 000079 VT 05/01/2014 706BVOI Solo FBVOI 99.00 C B 000343 VT 01/01/2014 411000 Pilote Susie SUSIE 159.00 D B 000343 VT 01/01/2014 706GNNB Solo FGNNB 159.00 C B 000459 VT 01/01/2014 411000 Pilote Thomas THOMAS 138.00 D B 000459 VT 01/01/2014 706GIKI Solo FGIKI 138.00 C B 000461 VT 01/01/2014 411000 Pilote firstTest4 lastTest4 110.00 D B 000461 VT 01/01/2014 706GIKI Solo FGIKI 110.00 C B 000463 VT 01/01/2014 411000 Pilote Thomas THOMAS 69.00 D B 000463 VT 01/01/2014 706GIKI Solo FGIKI 69.00 C B 000465 VT 01/01/2014 411000 Pilote Richard RICHARD 207.00 D B 000465 VT 01/01/2014 706GIKI Solo FGIKI 207.00 C B 000467 VT 02/01/2014 411000 Pilote Briac BRIAC 345.00 D B 000467 VT 02/01/2014 706GIKI Solo FGIKI 345.00 C B 000469 VT 03/01/2014 411000 Pilote firstTest5 lastTest5 138.00 D B 000469 VT 03/01/2014 706GIKI Solo FGIKI 138.00 C B 000471 VT 03/01/2014 411000 Pilote firstTest6 lastTest6 138.00 D B 000471 VT 03/01/2014 706GIKI Solo FGIKI 138.00 C B 000473 VT 05/01/2014 411000 Pilote tom TOM 110.00 D B 000473 VT 05/01/2014 706GIKI Solo FGIKI 110.00 C B