Accounting export template Oxygene

From OpenFlyers Documentation
Revision as of 08:18, 27 April 2017 by imported>Jcheng (→‎Output file description)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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