Difference between revisions of "Accounting export template Ebp2012"

Jump to: navigation, search
m (Output file description)
Line 1: Line 1:
 +
=Introduction=
 +
This page described the [[Accounting_export_template_list|accounting export template]] EBP 2010.
 +
 
=Output file description=
 
=Output file description=
  

Revision as of 09:58, 16 March 2015

Introduction

This page described the accounting export template EBP 2010.

Output file description

  • Encoding charset: ISO-8859-15
  • Field character separator: ,
  • Fields:
Name Length (in character) Description
Flow number
Date Format is DDMMYY
Export code
Export account Character , is removed
Nothing
Flow number 3 Escaped with character " and OF added at the beginning
Amount Number 2 digits after the decimal separator
Character C or D C for credit, D for debit
Date Format is DDMMYYYY
Nothing
Nothing

Example of output file

67,010114,VE,411000,,"Pilote CHRISTIAN CHRISTIAN ","OF067",99.00,D,,
67,010114,VE,706BVOI,,"Solo FBVOI ","OF067",99.00,C,,
69,010114,VE,411000,,"Pilote Éléonore ÉLÉONORE ","OF069",51.00,D,,
69,010114,VE,706BVOI,,"Solo FBVOI ","OF069",51.00,C,,
71,010114,VE,411000,,"Pilote Nadine NADINE ","OF071",51.00,D,,
71,010114,VE,706BVOI,,"Solo FBVOI ","OF071",51.00,C,,
73,020114,VE,411000,,"Pilote Éléonore ÉLÉONORE ","OF073",408.00,D,,
73,020114,VE,706BVOI,,"Solo FBVOI ","OF073",408.00,C,,
75,030114,VE,411000,,"Pilote Christophe LARATTE ","OF075",99.00,D,,
75,030114,VE,706BVOI,,"Solo FBVOI ","OF075",99.00,C,,
77,030114,VE,411000,,"Pilote Marie-France MARIE-FRANCE ","OF077",124.00,D,,
77,030114,VE,706BVOI,,"Solo FBVOI ","OF077",124.00,C,,
79,050114,VE,411000,,"Pilote Erwan ERWAN ","OF079",99.00,D,,
79,050114,VE,706BVOI,,"Solo FBVOI ","OF079",99.00,C,,
343,010114,VE,411000,,"Pilote Susie SUSIE ","OF343",159.00,D,,
343,010114,VE,706GNNB,,"Solo FGNNB ","OF343",159.00,C,,
459,010114,VE,411000,,"Pilote Thomas THOMAS ","OF459",138.00,D,,
459,010114,VE,706GIKI,,"Solo FGIKI ","OF459",138.00,C,,
461,010114,VE,411000,,"Pilote firstTest4 lastTest4 ","OF461",110.00,D,,
461,010114,VE,706GIKI,,"Solo FGIKI ","OF461",110.00,C,,
463,010114,VE,411000,,"Pilote Thomas THOMAS ","OF463",69.00,D,,
463,010114,VE,706GIKI,,"Solo FGIKI ","OF463",69.00,C,,
465,010114,VE,411000,,"Pilote Richard RICHARD ","OF465",207.00,D,,
465,010114,VE,706GIKI,,"Solo FGIKI ","OF465",207.00,C,,
467,020114,VE,411000,,"Pilote Briac BRIAC ","OF467",345.00,D,,
467,020114,VE,706GIKI,,"Solo FGIKI ","OF467",345.00,C,,
469,030114,VE,411000,,"Pilote firstTest5 lastTest5 ","OF469",138.00,D,,
469,030114,VE,706GIKI,,"Solo FGIKI ","OF469",138.00,C,,
471,030114,VE,411000,,"Pilote firstTest6 lastTest6 ","OF471",138.00,D,,
471,030114,VE,706GIKI,,"Solo FGIKI ","OF471",138.00,C,,
473,050114,VE,411000,,"Pilote tom TOM ","OF473",110.00,D,,
473,050114,VE,706GIKI,,"Solo FGIKI ","OF473",110.00,C,,