Accounting export template CsvDebitCreditWithCommaDecimal
Jump to navigation
Jump to search
Introduction
This page describes the generic accounting export template CSVDebitCredit with comma.
Following characters are removed in the export file :
- &
- <
- >
- ;
Output file description
- Decimal separator: ,
- Encoding charset: UTF-8
- 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 YYYYMMDD | |
| Export account | 13 | Filled with appended spaces to match length |
| Description | 35 | Filled with appended spaces to match length |
| Amount | 8 | Number 2 digits after the decimal separator and filled with prepended zeros to match length |
Example of output file
000067;VT;20140101;411000;Pilote CHRISTIAN CHRISTIAN ;00099,00; 000067;VT;20140101;706BVOI;Solo FBVOI ;;00099,00 000069;VT;20140101;411000;Pilote Éléonore ÉLÉONORE ;00051,00; 000069;VT;20140101;706BVOI;Solo FBVOI ;;00051,00 000071;VT;20140101;411000;Pilote Nadine NADINE ;00051,00; 000071;VT;20140101;706BVOI;Solo FBVOI ;;00051,00 000073;VT;20140102;411000;Pilote Éléonore ÉLÉONORE ;00408,00; 000073;VT;20140102;706BVOI;Solo FBVOI ;;00408,00 000075;VT;20140103;411000;Pilote Christophe LARATTE ;00099,00; 000075;VT;20140103;706BVOI;Solo FBVOI ;;00099,00 000077;VT;20140103;411000;Pilote Marie-France MARIE-FRANCE ;00124,00; 000077;VT;20140103;706BVOI;Solo FBVOI ;;00124,00 000079;VT;20140105;411000;Pilote Erwan ERWAN ;00099,00; 000079;VT;20140105;706BVOI;Solo FBVOI ;;00099,00 000343;VT;20140101;411000;Pilote Susie SUSIE ;00159,00; 000343;VT;20140101;706GNNB;Solo FGNNB ;;00159,00 000459;VT;20140101;411000;Pilote Thomas THOMAS ;00138,00; 000459;VT;20140101;706GIKI;Solo FGIKI ;;00138,00 000461;VT;20140101;411000;Pilote firstTest4 lastTest4 ;00110,00; 000461;VT;20140101;706GIKI;Solo FGIKI ;;00110,00 000463;VT;20140101;411000;Pilote Thomas THOMAS ;00069,00; 000463;VT;20140101;706GIKI;Solo FGIKI ;;00069,00 000465;VT;20140101;411000;Pilote Richard RICHARD ;00207,00; 000465;VT;20140101;706GIKI;Solo FGIKI ;;00207,00 000467;VT;20140102;411000;Pilote Briac BRIAC ;00345,00; 000467;VT;20140102;706GIKI;Solo FGIKI ;;00345,00 000469;VT;20140103;411000;Pilote firstTest5 lastTest5 ;00138,00; 000469;VT;20140103;706GIKI;Solo FGIKI ;;00138,00 000471;VT;20140103;411000;Pilote firstTest6 lastTest6 ;00138,00; 000471;VT;20140103;706GIKI;Solo FGIKI ;;00138,00 000473;VT;20140105;411000;Pilote tom TOM ;00110,00; 000473;VT;20140105;706GIKI;Solo FGIKI ;;00110,00