Difference between revisions of "Accounting export template CielRimport"

Jump to: navigation, search
m (Example of output file)
Line 1: Line 1:
 +
=Output file description=
 +
 +
* Encoding charset: ISO-8859-15
 +
* Field character separator: Tab
 +
* Fields:
 +
{| class="wikitable"
 +
!Name!!Length (in character)!!Description
 +
|-
 +
|Flow number||6||Filled with appended zeros to match length
 +
|-
 +
|Export code
 +
|-
 +
|Date||||Format is DD/MM/YYYY
 +
|-
 +
|Export account||13||Filled with prepended spaces to match length
 +
|-
 +
|Description||35||Filled with prepended spaces to match length
 +
|-
 +
|Amount||||Number with 2 digits after the decimal separator
 +
|-
 +
|C or D||||C for credit, D for debit
 +
|}
 +
 
=Example of output file=
 
=Example of output file=
  
The encoding charset is: ISO-8859-15
 
 
<pre>000067 VT 01/01/2014 411000      Pilote CHRISTIAN CHRISTIAN        99.00 D B                                                    
 
<pre>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                                                    
 
000067 VT 01/01/2014 706BVOI      Solo FBVOI                        99.00 C B                                                    

Revision as of 11:06, 6 May 2014

Output file description

  • Encoding charset: ISO-8859-15
  • Field character separator: Tab
  • Fields:
Name Length (in character) Description
Flow number 6 Filled with appended zeros to match length
Export code
Date Format is DD/MM/YYYY
Export account 13 Filled with prepended spaces to match length
Description 35 Filled with prepended spaces to match length
Amount Number with 2 digits after the decimal separator
C or D C for credit, D for debit

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