Difference between revisions of "Accounting export template CielRimport"
(→Output file description) |
(→Output file description) |
||
Line 15: | Line 15: | ||
|Export account||13||Filled with prepended spaces to match length | |Export account||13||Filled with prepended spaces to match length | ||
|- | |- | ||
− | |Description||35||Filled with | + | |Description||35||Filled with appended spaces to match length |
|- | |- | ||
|Amount||||Number with 2 digits after the decimal separator | |Amount||||Number with 2 digits after the decimal separator | ||
|- | |- | ||
− | |C or D||||C for credit, D for debit | + | |Character C or D||||C for credit, D for debit |
+ | |- | ||
+ | |Character B|||| | ||
+ | |- | ||
+ | |Comments||50||Filled with appended spaces to match length | ||
|} | |} | ||
Revision as of 12:07, 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 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