https://doc-en-mirror.openflyers.com/index.php?action=history&feed=atom&title=Accounting-export-template-Sage 2026-05-01T20:19:59Z Revision history for this page on the wiki MediaWiki 1.39.6 https://doc-en-mirror.openflyers.com/index.php?title=Accounting-export-template-Sage&diff=270&oldid=prev 2017-11-15T16:04:17Z

<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]] Sage.<br /> <br /> =Output file description=<br /> <br /> * Encoding charset: ISO-8859-15<br /> * Field character separator: Tab<br /> * First line contains client structure name<br /> * Fields:<br /> {| class=&quot;wikitable&quot;<br /> !Name!!Length (in character)!!Description<br /> |-<br /> |Export code||||<br /> |-<br /> |||||1 space<br /> |-<br /> |Date||||Format is DDMMYY<br /> |-<br /> |||||2 spaces<br /> |-<br /> |Export account||13||Filled with appended spaces to match length<br /> |-<br /> |||||1 space<br /> |-<br /> |||||13 spaces<br /> |-<br /> |id||13||Filled with appended spaces to match length<br /> |-<br /> |Description||25||Filled with appended spaces to match length<br /> |-<br /> |||||1 space<br /> |-<br /> |||||6 spaces<br /> |-<br /> |Character C or D||||C for credit, D for debit<br /> |-<br /> |Amount||20||Number with 20 digits before the decimal separator and 2 digits after<br /> |-<br /> |Character N||||<br /> |-<br /> |Flow id||7||Filled with prepended zeros to match length<br /> |-<br /> |||||26 spaces<br /> |}<br /> <br /> =Example of output file=<br /> <br /> &lt;pre&gt;demo<br /> VT 010114 411000 67 Pilote CHRISTIAN CHRISTIA D 99.00N0000067 <br /> VT 010114 706BVOI 68 Solo FBVOI C 99.00N0000067 <br /> VT 010114 411000 69 Pilote Éléonore ÉLÉONORE D 51.00N0000069 <br /> VT 010114 706BVOI 70 Solo FBVOI C 51.00N0000069 <br /> VT 010114 411000 71 Pilote Nadine NADINE D 51.00N0000071 <br /> VT 010114 706BVOI 72 Solo FBVOI C 51.00N0000071 <br /> VT 020114 411000 73 Pilote Éléonore ÉLÉONORE D 408.00N0000073 <br /> VT 020114 706BVOI 74 Solo FBVOI C 408.00N0000073 <br /> VT 030114 411000 75 Pilote Christophe LARATTE D 99.00N0000075 <br /> VT 030114 706BVOI 76 Solo FBVOI C 99.00N0000075 <br /> VT 030114 411000 77 Pilote Marie-France MARIE D 124.00N0000077 <br /> VT 030114 706BVOI 78 Solo FBVOI C 124.00N0000077 <br /> VT 050114 411000 79 Pilote Erwan ERWAN D 99.00N0000079 <br /> VT 050114 706BVOI 80 Solo FBVOI C 99.00N0000079 <br /> VT 010114 411000 343 Pilote Susie SUSIE D 159.00N0000343 <br /> VT 010114 706GNNB 344 Solo FGNNB C 159.00N0000343 <br /> VT 010114 411000 459 Pilote Thomas THOMAS D 138.00N0000459 <br /> VT 010114 706GIKI 460 Solo FGIKI C 138.00N0000459 <br /> VT 010114 411000 461 Pilote firstTest4 lastTes D 110.00N0000461 <br /> VT 010114 706GIKI 462 Solo FGIKI C 110.00N0000461 <br /> VT 010114 411000 463 Pilote Thomas THOMAS D 69.00N0000463 <br /> VT 010114 706GIKI 464 Solo FGIKI C 69.00N0000463 <br /> VT 010114 411000 465 Pilote Richard RICHARD D 207.00N0000465 <br /> VT 010114 706GIKI 466 Solo FGIKI C 207.00N0000465 <br /> VT 020114 411000 467 Pilote Briac BRIAC D 345.00N0000467 <br /> VT 020114 706GIKI 468 Solo FGIKI C 345.00N0000467 <br /> VT 030114 411000 469 Pilote firstTest5 lastTes D 138.00N0000469 <br /> VT 030114 706GIKI 470 Solo FGIKI C 138.00N0000469 <br /> VT 030114 411000 471 Pilote firstTest6 lastTes D 138.00N0000471 <br /> VT 030114 706GIKI 472 Solo FGIKI C 138.00N0000471 <br /> VT 050114 411000 473 Pilote tom TOM D 110.00N0000473 <br /> VT 050114 706GIKI 474 Solo FGIKI C 110.00N0000473 <br /> &lt;/pre&gt;</div>

imported>Jcheng