https://doc-en-mirror.openflyers.com/index.php?action=history&feed=atom&title=Accounting-export-template-CielXimport 2026-05-01T19:44:06Z Revision history for this page on the wiki MediaWiki 1.39.6 https://doc-en-mirror.openflyers.com/index.php?title=Accounting-export-template-CielXimport&diff=275&oldid=prev 2016-07-18T09:13:52Z

<p>Text replacement - &quot;[[Accounting_export_template_list|&quot; to &quot;[[Accounting-export-template-list|&quot;</p> <p><b>New page</b></p><div>=Introduction=<br /> This page described the [[Accounting-export-template-list|accounting export template]] Ximport for Ciel software.<br /> <br /> =Output file description=<br /> <br /> * Encoding charset: cp850<br /> * Fields:<br /> {| class=&quot;wikitable&quot;<br /> !Name!!Length (in character)!!OpenFlyers filling<br /> |-<br /> |Flow number||5||Filled with prepended zeros to match length<br /> |-<br /> |Accounting journal||2||Export code<br /> |-<br /> |Accounting date||8||Format is YYYYMMDD<br /> |-<br /> |Due date||8||8 spaces<br /> |-<br /> |Voucher number||12||12 spaces<br /> |-<br /> |Account||11||Export account. Filled with appended spaces to match length<br /> |-<br /> |Description||25||Filled with appended spaces to match length<br /> |-<br /> |Amount||13||Number with 2 digits after the decimal separator and filled with prepended zeros to match length<br /> |-<br /> |Debit/credit||1||C for credit, D for debit<br /> |-<br /> |Reconciliation number||12||12 spaces<br /> |-<br /> |Analytic/Budget code||6||6 spaces<br /> |-<br /> |Name of the account||34||Filled with appended spaces to match length<br /> |-<br /> |Euro||1||ignored<br /> |}<br /> <br /> =Example of output file=<br /> <br /> &lt;pre&gt; 67VT20140101 411000 Pilote CHRISTIAN CHRISTIA0000000099.00D <br /> 67VT20140101 706BVOI Solo FBVOI 0000000099.00C <br /> 69VT20140101 411000 Pilote l‚onore LONORE 0000000051.00D <br /> 69VT20140101 706BVOI Solo FBVOI 0000000051.00C <br /> 71VT20140101 411000 Pilote Nadine NADINE 0000000051.00D <br /> 71VT20140101 706BVOI Solo FBVOI 0000000051.00C <br /> 73VT20140102 411000 Pilote l‚onore LONORE 0000000408.00D <br /> 73VT20140102 706BVOI Solo FBVOI 0000000408.00C <br /> 75VT20140103 411000 Pilote Christophe LARATTE0000000099.00D <br /> 75VT20140103 706BVOI Solo FBVOI 0000000099.00C <br /> 77VT20140103 411000 Pilote Marie-France MARIE0000000124.00D <br /> 77VT20140103 706BVOI Solo FBVOI 0000000124.00C <br /> 79VT20140105 411000 Pilote Erwan ERWAN 0000000099.00D <br /> 79VT20140105 706BVOI Solo FBVOI 0000000099.00C <br /> 343VT20140101 411000 Pilote Susie SUSIE 0000000159.00D <br /> 343VT20140101 706GNNB Solo FGNNB 0000000159.00C <br /> 459VT20140101 411000 Pilote Thomas THOMAS 0000000138.00D <br /> 459VT20140101 706GIKI Solo FGIKI 0000000138.00C <br /> 461VT20140101 411000 Pilote firstTest4 lastTes0000000110.00D <br /> 461VT20140101 706GIKI Solo FGIKI 0000000110.00C <br /> 463VT20140101 411000 Pilote Thomas THOMAS 0000000069.00D <br /> 463VT20140101 706GIKI Solo FGIKI 0000000069.00C <br /> 465VT20140101 411000 Pilote Richard RICHARD 0000000207.00D <br /> 465VT20140101 706GIKI Solo FGIKI 0000000207.00C <br /> 467VT20140102 411000 Pilote Briac BRIAC 0000000345.00D <br /> 467VT20140102 706GIKI Solo FGIKI 0000000345.00C <br /> 469VT20140103 411000 Pilote firstTest5 lastTes0000000138.00D <br /> 469VT20140103 706GIKI Solo FGIKI 0000000138.00C <br /> 471VT20140103 411000 Pilote firstTest6 lastTes0000000138.00D <br /> 471VT20140103 706GIKI Solo FGIKI 0000000138.00C <br /> 473VT20140105 411000 Pilote tom TOM 0000000110.00D <br /> 473VT20140105 706GIKI Solo FGIKI 0000000110.00C <br /> &lt;/pre&gt;</div>

imported>Jcheng