Difference between revisions of "Accounting export template Ebp2012"

Jump to: navigation, search
m (→‎Example of output file)
Line 1: Line 1:
 +
=Output file description=
 +
 +
* Encoding charset: ISO-8859-15
 +
* Field character separator: ,
 +
* Fields:
 +
{| class="wikitable"
 +
!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
 +
|-
 +
|||15||15 spaces escaped with character '''"'''
 +
|-
 +
|Amount||13||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=
 
=Example of output file=
  
−
The encoding charset is: ISO-8859-15
 
 
<pre>67,010114,VE,411000,,"Pilote CHRISTIAN CHRISTIAN ","OF067",99.00,D,,
 
<pre>67,010114,VE,411000,,"Pilote CHRISTIAN CHRISTIAN ","OF067",99.00,D,,
 
67,010114,VE,706BVOI,,"Solo FBVOI ","OF067",99.00,C,,
 
67,010114,VE,706BVOI,,"Solo FBVOI ","OF067",99.00,C,,

Revision as of 09:38, 7 May 2014

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
15 15 spaces escaped with character "
Amount 13 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,,