Accounting export template CegidEcrexcel

Revision as of 10:33, 19 September 2016 by Jcheng (Talk | contribs) (Output file description)

Jump to: navigation, search

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 Filled with appended spaces to match length

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