Difference between revisions of "Accounting export template SageCoala"
m (Created page with "<xml><?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="text" media-type="text/plain" ...") |
m (Text replacement - "[[Accounting_export_template_list|" to "[[Accounting-export-template-list|") |
||
(6 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | + | =Introduction= | |
− | + | This page described the [[Accounting-export-template-list|accounting export template]] Sage Coala. | |
− | + | ||
− | + | ||
− | + | ||
− | + | =Output file description= | |
− | + | ||
− | + | ||
− | + | * Encoding charset: UTF-8 | |
− | + | * Field character separator: ; | |
− | + | * Decimal separator: , | |
− | + | * Fields: | |
− | + | {| class="wikitable" | |
− | + | !Name!!Length (in character)!!Description | |
− | + | |- | |
− | + | |Date||||Format is DD/MM/YYYY | |
− | + | |- | |
− | + | |Export code|||| | |
− | + | |- | |
− | + | |Flow number|||| | |
− | + | |- | |
+ | |Export account|||| | ||
+ | |- | ||
+ | |Debit||||Number with 2 digits after the decimal separator | ||
+ | |- | ||
+ | |Credit||||Number with 2 digits after the decimal separator | ||
+ | |- | ||
+ | |Description||50||Filled with appended spaces to match length and character ''',''' is removed | ||
+ | |- | ||
+ | |Flow number|||| | ||
+ | |- | ||
+ | |Character E|||| | ||
+ | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | =Example of output file= | |
− | + | ||
− | + | <pre>01/01/2014;VT;67;411000;99,00;0,00;Pilote CHRISTIAN CHRISTIAN ;67;E | |
− | + | 01/01/2014;VT;67;706BVOI;0,00;99,00;Solo FBVOI ;67;E | |
− | + | 01/01/2014;VT;69;411000;51,00;0,00;Pilote Éléonore ÉLÉONORE ;69;E | |
− | + | 01/01/2014;VT;69;706BVOI;0,00;51,00;Solo FBVOI ;69;E | |
− | + | 01/01/2014;VT;71;411000;51,00;0,00;Pilote Nadine NADINE ;71;E | |
− | + | 01/01/2014;VT;71;706BVOI;0,00;51,00;Solo FBVOI ;71;E | |
− | + | 02/01/2014;VT;73;411000;408,00;0,00;Pilote Éléonore ÉLÉONORE ;73;E | |
+ | 02/01/2014;VT;73;706BVOI;0,00;408,00;Solo FBVOI ;73;E | ||
+ | 03/01/2014;VT;75;411000;99,00;0,00;Pilote Christophe LARATTE ;75;E | ||
+ | 03/01/2014;VT;75;706BVOI;0,00;99,00;Solo FBVOI ;75;E | ||
+ | 03/01/2014;VT;77;411000;124,00;0,00;Pilote Marie-France MARIE-FRANCE ;77;E | ||
+ | 03/01/2014;VT;77;706BVOI;0,00;124,00;Solo FBVOI ;77;E | ||
+ | 05/01/2014;VT;79;411000;99,00;0,00;Pilote Erwan ERWAN ;79;E | ||
+ | 05/01/2014;VT;79;706BVOI;0,00;99,00;Solo FBVOI ;79;E | ||
+ | 01/01/2014;VT;343;411000;159,00;0,00;Pilote Susie SUSIE ;343;E | ||
+ | 01/01/2014;VT;343;706GNNB;0,00;159,00;Solo FGNNB ;343;E | ||
+ | 01/01/2014;VT;459;411000;138,00;0,00;Pilote Thomas THOMAS ;459;E | ||
+ | 01/01/2014;VT;459;706GIKI;0,00;138,00;Solo FGIKI ;459;E | ||
+ | 01/01/2014;VT;461;411000;110,00;0,00;Pilote firstTest4 lastTest4 ;461;E | ||
+ | 01/01/2014;VT;461;706GIKI;0,00;110,00;Solo FGIKI ;461;E | ||
+ | 01/01/2014;VT;463;411000;69,00;0,00;Pilote Thomas THOMAS ;463;E | ||
+ | 01/01/2014;VT;463;706GIKI;0,00;69,00;Solo FGIKI ;463;E | ||
+ | 01/01/2014;VT;465;411000;207,00;0,00;Pilote Richard RICHARD ;465;E | ||
+ | 01/01/2014;VT;465;706GIKI;0,00;207,00;Solo FGIKI ;465;E | ||
+ | 02/01/2014;VT;467;411000;345,00;0,00;Pilote Briac BRIAC ;467;E | ||
+ | 02/01/2014;VT;467;706GIKI;0,00;345,00;Solo FGIKI ;467;E | ||
+ | 03/01/2014;VT;469;411000;138,00;0,00;Pilote firstTest5 lastTest5 ;469;E | ||
+ | 03/01/2014;VT;469;706GIKI;0,00;138,00;Solo FGIKI ;469;E | ||
+ | 03/01/2014;VT;471;411000;138,00;0,00;Pilote firstTest6 lastTest6 ;471;E | ||
+ | 03/01/2014;VT;471;706GIKI;0,00;138,00;Solo FGIKI ;471;E | ||
+ | 05/01/2014;VT;473;411000;110,00;0,00;Pilote tom TOM ;473;E | ||
+ | 05/01/2014;VT;473;706GIKI;0,00;110,00;Solo FGIKI ;473;E | ||
+ | |||
+ | </pre> |
Latest revision as of 11:13, 18 July 2016
Introduction
This page described the accounting export template Sage Coala.
Output file description
- Encoding charset: UTF-8
- Field character separator: ;
- Decimal separator: ,
- Fields:
Name | Length (in character) | Description |
---|---|---|
Date | Format is DD/MM/YYYY | |
Export code | ||
Flow number | ||
Export account | ||
Debit | Number with 2 digits after the decimal separator | |
Credit | Number with 2 digits after the decimal separator | |
Description | 50 | Filled with appended spaces to match length and character , is removed |
Flow number | ||
Character E |
Example of output file
01/01/2014;VT;67;411000;99,00;0,00;Pilote CHRISTIAN CHRISTIAN ;67;E 01/01/2014;VT;67;706BVOI;0,00;99,00;Solo FBVOI ;67;E 01/01/2014;VT;69;411000;51,00;0,00;Pilote Éléonore ÉLÉONORE ;69;E 01/01/2014;VT;69;706BVOI;0,00;51,00;Solo FBVOI ;69;E 01/01/2014;VT;71;411000;51,00;0,00;Pilote Nadine NADINE ;71;E 01/01/2014;VT;71;706BVOI;0,00;51,00;Solo FBVOI ;71;E 02/01/2014;VT;73;411000;408,00;0,00;Pilote Éléonore ÉLÉONORE ;73;E 02/01/2014;VT;73;706BVOI;0,00;408,00;Solo FBVOI ;73;E 03/01/2014;VT;75;411000;99,00;0,00;Pilote Christophe LARATTE ;75;E 03/01/2014;VT;75;706BVOI;0,00;99,00;Solo FBVOI ;75;E 03/01/2014;VT;77;411000;124,00;0,00;Pilote Marie-France MARIE-FRANCE ;77;E 03/01/2014;VT;77;706BVOI;0,00;124,00;Solo FBVOI ;77;E 05/01/2014;VT;79;411000;99,00;0,00;Pilote Erwan ERWAN ;79;E 05/01/2014;VT;79;706BVOI;0,00;99,00;Solo FBVOI ;79;E 01/01/2014;VT;343;411000;159,00;0,00;Pilote Susie SUSIE ;343;E 01/01/2014;VT;343;706GNNB;0,00;159,00;Solo FGNNB ;343;E 01/01/2014;VT;459;411000;138,00;0,00;Pilote Thomas THOMAS ;459;E 01/01/2014;VT;459;706GIKI;0,00;138,00;Solo FGIKI ;459;E 01/01/2014;VT;461;411000;110,00;0,00;Pilote firstTest4 lastTest4 ;461;E 01/01/2014;VT;461;706GIKI;0,00;110,00;Solo FGIKI ;461;E 01/01/2014;VT;463;411000;69,00;0,00;Pilote Thomas THOMAS ;463;E 01/01/2014;VT;463;706GIKI;0,00;69,00;Solo FGIKI ;463;E 01/01/2014;VT;465;411000;207,00;0,00;Pilote Richard RICHARD ;465;E 01/01/2014;VT;465;706GIKI;0,00;207,00;Solo FGIKI ;465;E 02/01/2014;VT;467;411000;345,00;0,00;Pilote Briac BRIAC ;467;E 02/01/2014;VT;467;706GIKI;0,00;345,00;Solo FGIKI ;467;E 03/01/2014;VT;469;411000;138,00;0,00;Pilote firstTest5 lastTest5 ;469;E 03/01/2014;VT;469;706GIKI;0,00;138,00;Solo FGIKI ;469;E 03/01/2014;VT;471;411000;138,00;0,00;Pilote firstTest6 lastTest6 ;471;E 03/01/2014;VT;471;706GIKI;0,00;138,00;Solo FGIKI ;471;E 05/01/2014;VT;473;411000;110,00;0,00;Pilote tom TOM ;473;E 05/01/2014;VT;473;706GIKI;0,00;110,00;Solo FGIKI ;473;E