Uni Micro
The Uni Micro file export is according to their standard.
Export configuration
Configuration of export is to be done following the standard configuration.
Uni Micro has 2 additional field to be configured:
Include project
Include department
Select what is needed to be included in the file.
File
The file produced is a DAT file that use "," (comma) as separator. The file contains lines for different data types, customers, vouchers, invoices and invoice lines. Invoice/invoice lines are grouped together by invoice.
Data type | Field | Value |
Customers | Line type | 30 |
Customers | Account number | |
Customers | Name | |
Customers | Address | |
Customers | Address2 | |
Customers | Postal code | |
Customers | Postal place | |
Customers | Balance last year | |
Customers | Giro number | |
Customers | Days credit | |
Customers | Chain number | |
Customers | Category | |
Customers | Economic category | |
Customers | Phone | |
Customers | Fax | |
Customers | BLANK | |
Customers | Turnover | |
Customers | Discount | |
Customers | Fax | |
Customers | VAT | |
Customers | Country code | |
Customers | Country | |
Customers | VAT code | |
Vouchers | Line type | 60 |
Vouchers | Voucher number | |
Vouchers | Date | |
Vouchers | Account number | |
Vouchers | Department | |
Vouchers | Project | |
Vouchers | VAT code | |
Vouchers | Text | |
Vouchers | Amount | |
Vouchers | Operator (Signature) | |
Vouchers | BLANK | |
Vouchers | BLANK | |
Vouchers | BLANK | |
Vouchers | BLANK | |
Vouchers | Period | |
Vouchers | Invoice number | |
Vouchers | Due date | |
Vouchers | Currency | |
Vouchers | Currency amount | |
Vouchers | Function/Responsibility (dim3) | |
Vouchers | Area (dim4) | |
Invoices | Line type | 80 |
Invoices | Invoice number | |
Invoices | Customer number | |
Invoices | Status | |
Invoices | Total sum | |
Invoices | Paid sum | |
Invoices | Credited/Additional invoice sum | |
Invoices | VAT sum | |
Invoices | Number of reminders | |
Invoices | Salesperson numbers | |
Invoices | Sum contribution margin | |
Invoices | Name | |
Invoices | Address | |
Invoices | Address2 | |
Invoices | Postal numbers | |
Invoices | Postal place | |
Invoices | Reference | |
Invoices | Paid date | |
Invoices | Invoice date | |
Invoices | Due date | |
Invoices | BLANK | |
Invoices | BLANK | |
Invoices | Requisition | |
Invoices | Factoring | |
Invoices | Direct debit status | |
Invoices | Project (dim1) | |
Invoices | Department (dim2) | |
Invoices | Function/Responsible (dim3) | |
Invoices | Area (dim4) | |
InvoiceLines | Line type | 81 |
InvoiceLines | Customer number | |
InvoiceLines | Item number | |
InvoiceLines | Count | |
InvoiceLines | Price | |
InvoiceLines | Discount | |
InvoiceLines | Account number | |
InvoiceLines | VAT code | |
InvoiceLines | Item text |
Format
Date format:
Vouchers: DDMMYY
Invoices: DD.MM.YYYY
Decimal separator: . (period)
Last updated