Accounting export template Ebp2012

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.	OpenFlyers account description
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		Ignored by OpenFlyers
Currency (optional ISO Code)		Ignored by OpenFlyers

Journal VCC

Les écritures sont mises dans les journaux suivants.

• "6":"AC"
• "7":"VE"
• "51":"BQ"
• "53":"CA"

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