Accounting export template Oxygene

From OpenFlyers Documentation
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Introduction

This page described the accounting export template Oxygène.

Output file description

  • Encoding charset: ISO-8859-15
  • Field character separator: ;
  • Fields:
Name Length (in character) OpenFlyers filling
CODSOC
CODAGE
NUMJL Text 70
MONNAIE_IDENT Text EUR
NUMCP Export account
COURS
CSECT
DTOPE Date using YYYYMMDD format
NPIEC
LIBEC VOL
MTDEB Debit
MTCRE Credit
RELET
NIPIE
LIBAUTO
CB1
CR1
DE1 Text 0
ME1
CB2
CR2
DE2 Text 0
ME2
CB3
CR3
DE3 Text 0
ME3
CB4
CR4
DE4 Text 0
ME4
CB5
CR5
DE5 Text 0
ME5
EXTERNE

Example of output file

CODSOC;CODAGE;NUMJL;MONNAIE_IDENT;NUMCP;COURS;CSECT;DTOPE;NPIEC;LIBEC;MTDEB;MTCRE;RELET;NIPIE;LIBAUTO;CB1;CR1;DE1;ME1;CB2;CR2;DE2;ME2;CB3;CR3;DE3;ME3;CB4;CR4;DE4;ME4;CB5;CR5;DE5;ME5;EXTERNE
;;70;EUR;411TERRIER;;;20160723;;VOL;193.50;;;;;;;0;;;;0;;;;0;;;;0;;;;0
;;70;EUR;70611;;;20160723;;VOL;162.00;;;;;;;0;;;;0;;;;0;;;;0;;;;0
;;70;EUR;706200;;;20160723;;VOL;31.50;;;;;;;0;;;;0;;;;0;;;;0;;;;0
;;70;EUR;411TERRIER;;;20160723;;VOL;113.95;;;;;;;0;;;;0;;;;0;;;;0;;;;0
;;70;EUR;70611;;;20160723;;VOL;95.40;;;;;;;0;;;;0;;;;0;;;;0;;;;0
;;70;EUR;706200;;;20160723;;VOL;18.55;;;;;;;0;;;;0;;;;0;;;;0;;;;0