Accounting export template Quadratus
Jump to navigation
Jump to search
Introduction
This page described the accounting export template Quadratus.
Output file description
- Encoding charset: ISO-8859-15
- Field character separator: Tab
- Fields:
| Name | Length (in character) | Description |
|---|---|---|
| Character M | ||
| Export account | 8 | Filled with appended spaces to match length |
| Export code | ||
| Text 000 | ||
| Date | Format is DDMMYY | |
| Export account | 13 | Filled with appended spaces to match length |
| 1 space | ||
| 20 spaces | ||
| Description | 35 | Filled with appended spaces to match length |
| Text C+ or D+ | C+ for credit, D+ for debit | |
| Amount | 12 | Number multiplied by 100 and filled with prepended zeros to match length |
| 8 spaces | ||
| 6 spaces | ||
| 2 spaces | ||
| 3 spaces | ||
| 5 spaces | ||
| Customer bill id | 10 | Filled with appended spaces to match length |
| 10 spaces | ||
| Flow id | 8 | Filled with prepended zeros to match length |
| EUR | ||
| Export code | ||
| 1 space | ||
| O1D if it's a VAT account entry otherwise 3 spaces | ||
| Comment | 30 | Filled with appended spaces to match length |
| AF if it's a VAT account entry otherwise 2 spaces | ||
| Description | 10 | Filled with appended spaces to match length |
| 10 spaces | ||
| Character + | ||
| Amount | 12 | Number multiplied by 100 and filled with prepended zeros to match length |
| 12 spaces | ||
| 10 spaces | ||
| 28 spaces |
Example of output file
M411000 VT000010114 D+000000009900 34 00000067EURVT Pilote CHR +000000009900 M706BVOI VT000010114 C+000000009900 34 00000067EURVT Solo FBVOI +000000009900 M411000 VT000010114 D+000000005100 35 00000069EURVT Pilote Élé +000000005100 M706BVOI VT000010114 C+000000005100 35 00000069EURVT Solo FBVOI +000000005100 M411000 VT000010114 D+000000005100 36 00000071EURVT Pilote Nad +000000005100 M706BVOI VT000010114 C+000000005100 36 00000071EURVT Solo FBVOI +000000005100 M411000 VT000020114 D+000000040800 37 00000073EURVT Pilote Élé +000000040800 M706BVOI VT000020114 C+000000040800 37 00000073EURVT Solo FBVOI +000000040800 M411000 VT000030114 D+000000009900 38 00000075EURVT Pilote Chr +000000009900 M706BVOI VT000030114 C+000000009900 38 00000075EURVT Solo FBVOI +000000009900 M411000 VT000030114 D+000000012400 39 00000077EURVT Pilote Mar +000000012400 M706BVOI VT000030114 C+000000012400 39 00000077EURVT Solo FBVOI +000000012400 M411000 VT000050114 D+000000009900 40 00000079EURVT Pilote Erw +000000009900 M706BVOI VT000050114 C+000000009900 40 00000079EURVT Solo FBVOI +000000009900 M411000 VT000010114 D+000000015900 172 00000343EURVT Pilote Sus +000000015900 M706GNNB VT000010114 C+000000015900 172 00000343EURVT Solo FGNNB +000000015900 M411000 VT000010114 D+000000013800 230 00000459EURVT Pilote Tho +000000013800 M706GIKI VT000010114 C+000000013800 230 00000459EURVT Solo FGIKI +000000013800 M411000 VT000010114 D+000000011000 231 00000461EURVT Pilote fir +000000011000 M706GIKI VT000010114 C+000000011000 231 00000461EURVT Solo FGIKI +000000011000 M411000 VT000010114 D+000000006900 232 00000463EURVT Pilote Tho +000000006900 M706GIKI VT000010114 C+000000006900 232 00000463EURVT Solo FGIKI +000000006900 M411000 VT000010114 D+000000020700 233 00000465EURVT Pilote Ric +000000020700 M706GIKI VT000010114 C+000000020700 233 00000465EURVT Solo FGIKI +000000020700 M411000 VT000020114 D+000000034500 234 00000467EURVT Pilote Bri +000000034500 M706GIKI VT000020114 C+000000034500 234 00000467EURVT Solo FGIKI +000000034500 M411000 VT000030114 D+000000013800 235 00000469EURVT Pilote fir +000000013800 M706GIKI VT000030114 C+000000013800 235 00000469EURVT Solo FGIKI +000000013800 M411000 VT000030114 D+000000013800 236 00000471EURVT Pilote fir +000000013800 M706GIKI VT000030114 C+000000013800 236 00000471EURVT Solo FGIKI +000000013800 M411000 VT000050114 D+000000011000 237 00000473EURVT Pilote tom +000000011000 M706GIKI VT000050114 C+000000011000 237 00000473EURVT Solo FGIKI +000000011000