https://doc-en.openflyers.com/index.php?action=history&feed=atom&title=Accounting-export-template-CegidEcrexcel
Accounting export template CegidEcrexcel - Revision history
2026-04-30T12:27:33Z
Revision history for this page on the wiki
MediaWiki 1.39.6
https://doc-en.openflyers.com/index.php?title=Accounting-export-template-CegidEcrexcel&diff=305&oldid=prev
imported>Claratte: /* Output file description */
2019-11-17T18:43:43Z
<p><span dir="auto"><span class="autocomment">Output file description</span></span></p>
<p><b>New page</b></p><div>=Introduction=<br />
This page described the [[Accounting-export-template-list|accounting export template]] CEGID - ECREXCEL.<br />
<br />
=Default Journal=<br />
ODS<br />
<br />
=Output file description=<br />
* Encoding charset: UTF-8<br />
* Field character separator: ;<br />
* Fields:<br />
{| class="wikitable"<br />
!Name!!Length (in character)!!Description<br />
|-<br />
|Accounting journal||3||OpenFlyers export code <br />
|-<br />
|Date||||Format is DD/MM/YYYY<br />
|-<br />
|General export account||17||The first three starting characters of the export account<br />
|-<br />
|Auxiliary export account||17||For a "411" export account, it's the characters following it. Otherwise, an empty string<br />
|-<br />
|Flow id||35||<br />
|-<br />
|Description||35||<br />
|-<br />
|Debit||20||<br />
|-<br />
|Credit||20||<br />
|}<br />
<br />
=Example of output file=<br />
<br />
<pre>VTE;12/07/2013;411;0189;67;Principal DUPOND DUPOND;99.17;<br />
VTE;12/07/2013;706;;68;Heures de vol F-XXX1;81.67;<br />
VTE;12/07/2013;706;;69;Instruction Vol ;17.50;<br />
VTE;13/07/2013;411;0021;70;Principal JEAN JEAN;81.67;<br />
VTE;13/07/2013;706;;71;Heures de vol F-XXX2;70.00;<br />
VTE;13/07/2013;706;;72;Instruction Vol;11.67;<br />
VTE;13/07/2013;411;0021;73;Principal JEAN JEAN;80.00;<br />
VTE;13/07/2013;706;;74;Heures de vol F-F-XXX2;80.00;<br />
VTE;13/07/2013;706;;77;Heures de vol F-F-XXX2;70.00;<br />
VTE;13/07/2013;411;EXTERNE;78;pilotes heures de vol;70.00;<br />
VTE;14/07/2013;411;0079;83;Principal DUBOIS DUBOIS;77.92;<br />
VTE;14/07/2013;706;;84;Heures de vol F-XXX1;64.17;<br />
VTE;14/07/2013;706;;85;Instruction Vol;13.75;</pre></div>
imported>Claratte