Difference between revisions of "Accounting export template Oxygene"
(Created page with "=Introduction= This page described the accounting export template Oxygène. =Output file description= * Encoding charset: ISO-8859-15 * F...") |
(→Output file description) |
||
Line 15: | Line 15: | ||
|CODAGE|||| | |CODAGE|||| | ||
|- | |- | ||
− | |NUMJL|||| | + | |NUMJL||||Text 70 |
|- | |- | ||
− | |MONNAIE_IDENT|||| | + | |MONNAIE_IDENT||||Text EUR |
|- | |- | ||
− | |NUMCP|||| | + | |NUMCP||||Export account |
|- | |- | ||
|COURS|||| | |COURS|||| | ||
Line 25: | Line 25: | ||
|CSECT|||| | |CSECT|||| | ||
|- | |- | ||
− | |DTOPE|||| | + | |DTOPE||||Date using YYYYMMDD format |
|- | |- | ||
|NPIEC|||| | |NPIEC|||| | ||
|- | |- | ||
− | |LIBEC|||| | + | |LIBEC||||VOL |
|- | |- | ||
− | |MTDEB|||| | + | |MTDEB||||Debit |
|- | |- | ||
− | |MTCRE|||| | + | |MTCRE||||Credit |
|- | |- | ||
|RELET|||| | |RELET|||| | ||
Line 45: | Line 45: | ||
|CR1|||| | |CR1|||| | ||
|- | |- | ||
− | |DE1|||| | + | |DE1||||Text 0 |
|- | |- | ||
|ME1|||| | |ME1|||| | ||
Line 53: | Line 53: | ||
|CR2|||| | |CR2|||| | ||
|- | |- | ||
− | |DE2|||| | + | |DE2||||Text 0 |
|- | |- | ||
|ME2|||| | |ME2|||| | ||
Line 61: | Line 61: | ||
|CR3|||| | |CR3|||| | ||
|- | |- | ||
− | |DE3|||| | + | |DE3||||Text 0 |
|- | |- | ||
|ME3|||| | |ME3|||| | ||
Line 69: | Line 69: | ||
|CR4|||| | |CR4|||| | ||
|- | |- | ||
− | |DE4|||| | + | |DE4||||Text 0 |
|- | |- | ||
|ME4|||| | |ME4|||| | ||
Line 77: | Line 77: | ||
|CR5|||| | |CR5|||| | ||
|- | |- | ||
− | |DE5|||| | + | |DE5||||Text 0 |
|- | |- | ||
|ME5|||| | |ME5|||| |
Latest revision as of 10:18, 27 April 2017
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