Difference between revisions of "Accounting export template CegidEcrexcel"
(Created page with "=Introduction= This page described the accounting export template CEGID - ECREXCEL. =Output file description= * Encoding charset: UTF-8 *...") |
(→Output file description) |
||
(5 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
=Introduction= | =Introduction= | ||
This page described the [[Accounting-export-template-list|accounting export template]] CEGID - ECREXCEL. | This page described the [[Accounting-export-template-list|accounting export template]] CEGID - ECREXCEL. | ||
+ | |||
+ | =Default Journal= | ||
+ | ODS | ||
=Output file description= | =Output file description= | ||
Line 9: | Line 12: | ||
!Name!!Length (in character)!!Description | !Name!!Length (in character)!!Description | ||
|- | |- | ||
− | | | + | |Accounting journal||3||OpenFlyers export code |
− | + | ||
− | + | ||
|- | |- | ||
|Date||||Format is DD/MM/YYYY | |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= | =Example of output file= | ||
− | <pre> | + | <pre>VTE;12/07/2013;411;0189;67;Principal DUPOND DUPOND;99.17; |
− | + | VTE;12/07/2013;706;;68;Heures de vol F-XXX1;81.67; | |
− | + | VTE;12/07/2013;706;;69;Instruction Vol ;17.50; | |
− | + | VTE;13/07/2013;411;0021;70;Principal JEAN JEAN;81.67; | |
− | + | VTE;13/07/2013;706;;71;Heures de vol F-XXX2;70.00; | |
− | + | VTE;13/07/2013;706;;72;Instruction Vol;11.67; | |
− | + | VTE;13/07/2013;411;0021;73;Principal JEAN JEAN;80.00; | |
− | + | VTE;13/07/2013;706;;74;Heures de vol F-F-XXX2;80.00; | |
− | + | VTE;13/07/2013;706;;77;Heures de vol F-F-XXX2;70.00; | |
− | + | VTE;13/07/2013;411;EXTERNE;78;pilotes heures de vol;70.00; | |
− | + | VTE;14/07/2013;411;0079;83;Principal DUBOIS DUBOIS;77.92; | |
− | + | VTE;14/07/2013;706;;84;Heures de vol F-XXX1;64.17; | |
− | + | VTE;14/07/2013;706;;85;Instruction Vol;13.75;</pre> | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | </pre> | + |
Latest revision as of 20:43, 17 November 2019
Introduction
This page described the accounting export template CEGID - ECREXCEL.
Default Journal
ODS
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
VTE;12/07/2013;411;0189;67;Principal DUPOND DUPOND;99.17; VTE;12/07/2013;706;;68;Heures de vol F-XXX1;81.67; VTE;12/07/2013;706;;69;Instruction Vol ;17.50; VTE;13/07/2013;411;0021;70;Principal JEAN JEAN;81.67; VTE;13/07/2013;706;;71;Heures de vol F-XXX2;70.00; VTE;13/07/2013;706;;72;Instruction Vol;11.67; VTE;13/07/2013;411;0021;73;Principal JEAN JEAN;80.00; VTE;13/07/2013;706;;74;Heures de vol F-F-XXX2;80.00; VTE;13/07/2013;706;;77;Heures de vol F-F-XXX2;70.00; VTE;13/07/2013;411;EXTERNE;78;pilotes heures de vol;70.00; VTE;14/07/2013;411;0079;83;Principal DUBOIS DUBOIS;77.92; VTE;14/07/2013;706;;84;Heures de vol F-XXX1;64.17; VTE;14/07/2013;706;;85;Instruction Vol;13.75;