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
