Difference between revisions of "Accounting export template CegidEcrexcel"
(→Output file description) |
(→Output file description) |
||
Line 23: | Line 23: | ||
|Debit||20|| | |Debit||20|| | ||
|- | |- | ||
− | |Credit||20|| | + | |Credit||20|| |
+ | |- | ||
|} | |} | ||
Revision as of 11:34, 19 September 2016
Introduction
This page described the accounting export template CEGID - ECREXCEL.
Output file description
- Encoding charset: UTF-8
- Field character separator: ;
- Fields:
Name | Length (in character) | Description |
---|---|---|
Accounting journal | 3 | OpenFlyers export code |
Date | Format is DD/MM/YYYY | |
General export account | 17 | The first three starting characters of the export account |
Auxiliary export account | 17 | For a "411" export account, it's the characters following it. Otherwise, an empty string |
Flow id | 35 | |
Description | 35 | |
Debit | 20 | |
Credit | 20 |
Example of output file
000067 VT 01/01/2014 411000 Pilote CHRISTIAN CHRISTIAN 99.00 D B 000067 VT 01/01/2014 706BVOI Solo FBVOI 99.00 C B 000069 VT 01/01/2014 411000 Pilote Éléonore ÉLÉONORE 51.00 D B 000069 VT 01/01/2014 706BVOI Solo FBVOI 51.00 C B 000071 VT 01/01/2014 411000 Pilote Nadine NADINE 51.00 D B 000071 VT 01/01/2014 706BVOI Solo FBVOI 51.00 C B 000073 VT 02/01/2014 411000 Pilote Éléonore ÉLÉONORE 408.00 D B 000073 VT 02/01/2014 706BVOI Solo FBVOI 408.00 C B 000075 VT 03/01/2014 411000 Pilote Christophe LARATTE 99.00 D B 000075 VT 03/01/2014 706BVOI Solo FBVOI 99.00 C B 000077 VT 03/01/2014 411000 Pilote Marie-France MARIE-FRANCE 124.00 D B 000077 VT 03/01/2014 706BVOI Solo FBVOI 124.00 C B 000079 VT 05/01/2014 411000 Pilote Erwan ERWAN 99.00 D B 000079 VT 05/01/2014 706BVOI Solo FBVOI 99.00 C B 000343 VT 01/01/2014 411000 Pilote Susie SUSIE 159.00 D B 000343 VT 01/01/2014 706GNNB Solo FGNNB 159.00 C B 000459 VT 01/01/2014 411000 Pilote Thomas THOMAS 138.00 D B 000459 VT 01/01/2014 706GIKI Solo FGIKI 138.00 C B 000461 VT 01/01/2014 411000 Pilote firstTest4 lastTest4 110.00 D B 000461 VT 01/01/2014 706GIKI Solo FGIKI 110.00 C B 000463 VT 01/01/2014 411000 Pilote Thomas THOMAS 69.00 D B 000463 VT 01/01/2014 706GIKI Solo FGIKI 69.00 C B 000465 VT 01/01/2014 411000 Pilote Richard RICHARD 207.00 D B 000465 VT 01/01/2014 706GIKI Solo FGIKI 207.00 C B 000467 VT 02/01/2014 411000 Pilote Briac BRIAC 345.00 D B 000467 VT 02/01/2014 706GIKI Solo FGIKI 345.00 C B 000469 VT 03/01/2014 411000 Pilote firstTest5 lastTest5 138.00 D B 000469 VT 03/01/2014 706GIKI Solo FGIKI 138.00 C B 000471 VT 03/01/2014 411000 Pilote firstTest6 lastTest6 138.00 D B 000471 VT 03/01/2014 706GIKI Solo FGIKI 138.00 C B 000473 VT 05/01/2014 411000 Pilote tom TOM 110.00 D B 000473 VT 05/01/2014 706GIKI Solo FGIKI 110.00 C B