Accounting export template CielRimport

Revision as of 09:13, 18 July 2016 by Jcheng (Talk | contribs) (Text replacement - "[[Accounting_export_template_list|" to "[[Accounting-export-template-list|")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Introduction

This page described the accounting export template Rimport for Ciel software.

Output file description

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