https://doc-en-mirror.openflyers.com/index.php?action=history&feed=atom&title=Accounting-export-template-CsvWithPointDecimal 2026-05-01T17:30:27Z Revision history for this page on the wiki MediaWiki 1.39.6 https://doc-en-mirror.openflyers.com/index.php?title=Accounting-export-template-CsvWithPointDecimal&diff=311&oldid=prev 2017-02-17T14:13:34Z

<p><span dir="auto"><span class="autocomment">Introduction</span></span></p> <p><b>New page</b></p><div>=Introduction=<br /> This page describes the generic [[Accounting-export-template-list|accounting export template]] CSV with point.<br /> <br /> Following characters are removed in the export file :<br /> * &amp;<br /> * &lt;<br /> * &gt;<br /> * ;<br /> <br /> =Output file description=<br /> <br /> * Decimal separator: .<br /> * Encoding charset: UTF-8<br /> * Field character separator: ;<br /> * Fields: <br /> {| class=&quot;wikitable&quot;<br /> !Name!!Length (in character)!!Description<br /> |-<br /> |Flow number||6||Filled with prepended zeros to match length<br /> |-<br /> |Export code||||<br /> |-<br /> |Date||||Format is YYYYMMDD<br /> |-<br /> |Export account||||<br /> |-<br /> |Description||25||Filled with appended spaces to match length<br /> |-<br /> |Amount||8||Number with 2 digits after the decimal separator and filled with prepended zeros to match length<br /> |-<br /> |Character C or D||||C for credit, D for debit<br /> |-<br /> |}<br /> <br /> =Example of output file=<br /> <br /> &lt;pre&gt;000067;VT;20140101;411000;Pilote CHRISTIAN CHRISTIA;00099.00;D<br /> 000067;VT;20140101;706BVOI;Solo FBVOI ;00099.00;C<br /> 000069;VT;20140101;411000;Pilote Éléonore ÉLÉONORE ;00051.00;D<br /> 000069;VT;20140101;706BVOI;Solo FBVOI ;00051.00;C<br /> 000071;VT;20140101;411000;Pilote Nadine NADINE ;00051.00;D<br /> 000071;VT;20140101;706BVOI;Solo FBVOI ;00051.00;C<br /> 000073;VT;20140102;411000;Pilote Éléonore ÉLÉONORE ;00408.00;D<br /> 000073;VT;20140102;706BVOI;Solo FBVOI ;00408.00;C<br /> 000075;VT;20140103;411000;Pilote Christophe LARATTE;00099.00;D<br /> 000075;VT;20140103;706BVOI;Solo FBVOI ;00099.00;C<br /> 000077;VT;20140103;411000;Pilote Marie-France MARIE;00124.00;D<br /> 000077;VT;20140103;706BVOI;Solo FBVOI ;00124.00;C<br /> 000079;VT;20140105;411000;Pilote Erwan ERWAN ;00099.00;D<br /> 000079;VT;20140105;706BVOI;Solo FBVOI ;00099.00;C<br /> 000343;VT;20140101;411000;Pilote Susie SUSIE ;00159.00;D<br /> 000343;VT;20140101;706GNNB;Solo FGNNB ;00159.00;C<br /> 000459;VT;20140101;411000;Pilote Thomas THOMAS ;00138.00;D<br /> 000459;VT;20140101;706GIKI;Solo FGIKI ;00138.00;C<br /> 000461;VT;20140101;411000;Pilote firstTest4 lastTes;00110.00;D<br /> 000461;VT;20140101;706GIKI;Solo FGIKI ;00110.00;C<br /> 000463;VT;20140101;411000;Pilote Thomas THOMAS ;00069.00;D<br /> 000463;VT;20140101;706GIKI;Solo FGIKI ;00069.00;C<br /> 000465;VT;20140101;411000;Pilote Richard RICHARD ;00207.00;D<br /> 000465;VT;20140101;706GIKI;Solo FGIKI ;00207.00;C<br /> 000467;VT;20140102;411000;Pilote Briac BRIAC ;00345.00;D<br /> 000467;VT;20140102;706GIKI;Solo FGIKI ;00345.00;C<br /> 000469;VT;20140103;411000;Pilote firstTest5 lastTes;00138.00;D<br /> 000469;VT;20140103;706GIKI;Solo FGIKI ;00138.00;C<br /> 000471;VT;20140103;411000;Pilote firstTest6 lastTes;00138.00;D<br /> 000471;VT;20140103;706GIKI;Solo FGIKI ;00138.00;C<br /> 000473;VT;20140105;411000;Pilote tom TOM ;00110.00;D<br /> 000473;VT;20140105;706GIKI;Solo FGIKI ;00110.00;C&lt;/pre&gt;</div>

imported>Jcheng