Difference between revisions of "Accounting export template CielRimport"
m (→Example of output file) |
|||
Line 1: | Line 1: | ||
+ | =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 appended zeros to match length | ||
+ | |- | ||
+ | |Export code | ||
+ | |- | ||
+ | |Date||||Format is DD/MM/YYYY | ||
+ | |- | ||
+ | |Export account||13||Filled with prepended spaces to match length | ||
+ | |- | ||
+ | |Description||35||Filled with prepended spaces to match length | ||
+ | |- | ||
+ | |Amount||||Number with 2 digits after the decimal separator | ||
+ | |- | ||
+ | |C or D||||C for credit, D for debit | ||
+ | |} | ||
+ | |||
=Example of output file= | =Example of output file= | ||
− | |||
<pre>000067 VT 01/01/2014 411000 Pilote CHRISTIAN CHRISTIAN 99.00 D B | <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 | 000067 VT 01/01/2014 706BVOI Solo FBVOI 99.00 C B |
Revision as of 11:06, 6 May 2014
Output file description
- Encoding charset: ISO-8859-15
- Field character separator: Tab
- Fields:
Name | Length (in character) | Description |
---|---|---|
Flow number | 6 | Filled with appended zeros to match length |
Export code | ||
Date | Format is DD/MM/YYYY | |
Export account | 13 | Filled with prepended spaces to match length |
Description | 35 | Filled with prepended spaces to match length |
Amount | Number with 2 digits after the decimal separator | |
C or D | C for credit, D for debit |
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