Difference between revisions of "Accounting export template Ebp2012"

Jump to: navigation, search
(Introduction)
(Output file description)
Line 6: Line 6:
 
* Encoding charset: ISO-8859-15
 
* Encoding charset: ISO-8859-15
 
* Field character separator: ,
 
* Field character separator: ,
 +
* End line separator: CR
 
* Fields:
 
* Fields:
 
{| class="wikitable"
 
{| class="wikitable"
!Name!!Length (in character)!!Description
+
!Name!!Length (in character)!!OpenFlyers filling
 
|-
 
|-
|Flow number||||
+
|Line||||OpenFlyers flow number. Ignored by EBP
 
|-
 
|-
|Date||||Format is DDMMYY
+
|Accounting date DDMMYY or DDMMYYYY||||Date formatted DDMMYY
 
|-
 
|-
|Export code||||
+
|Accounting journal||4 max.||OpenFlyers export code
 
|-
 
|-
|Export account||||Character ''',''' is removed
+
|Account number||15 max.||OpenFlyers Export account. Characters '','' are removed
 
|-
 
|-
|||||Nothing
+
|Automatic label||2||Ignored by OpenFlyers and ignored by EBP
 
|-
 
|-
|Flow number||3||Escaped with character '''"''' and '''OF''' added at the beginning
+
|Manual label quoted with character ''"''||40 max.||Ignored by OpenFlyers
 
|-
 
|-
|Amount||||Number 2 digits after the decimal separator
+
|Voucher number quoted with character ''"''||15 max.||OpenFlyers flow number prefixed with ''OF'' and quoted with character ''"''
 
|-
 
|-
|Character C or D||||C for credit, D for debit
+
|Amount||||Number 2 digits after the decimal separator. Point as decimal separator.
 
|-
 
|-
|Date||||Format is DDMMYYYY
+
|Debit/Credit||1||C for credit, D for debit
 
|-
 
|-
|||||Nothing
+
|Due date DDMMYY or DDMMYYYY||||Date formatted DDMMYYYY
|-
+
|||||Nothing
+
 
|-
 
|-
 +
|Currency (optional ISO Code)||||Ignored by OpenFlyers
 
|}
 
|}
  

Revision as of 11:31, 16 March 2015

Introduction

This page described the accounting export template EBP 2012.

Output file description

  • Encoding charset: ISO-8859-15
  • Field character separator: ,
  • End line separator: CR
  • Fields:
Name Length (in character) OpenFlyers filling
Line OpenFlyers flow number. Ignored by EBP
Accounting date DDMMYY or DDMMYYYY Date formatted DDMMYY
Accounting journal 4 max. OpenFlyers export code
Account number 15 max. OpenFlyers Export account. Characters , are removed
Automatic label 2 Ignored by OpenFlyers and ignored by EBP
Manual label quoted with character " 40 max. Ignored by OpenFlyers
Voucher number quoted with character " 15 max. OpenFlyers flow number prefixed with OF and quoted with character "
Amount Number 2 digits after the decimal separator. Point as decimal separator.
Debit/Credit 1 C for credit, D for debit
Due date DDMMYY or DDMMYYYY Date formatted DDMMYYYY
Currency (optional ISO Code) Ignored by OpenFlyers

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,,