MA!N data interface (basic)
For importing data, MA!N uses an import mapping. This indicates which data is offered and where it should be added in MA!N. It uses the data for calculating activities, aging and system proposals, among other things, and provides quick insight into the open portfolio.
Files
In most cases, the outstanding items and a debtor/customer file are imported into MA!N. It is also possible to import changes. Below is a summary of the most important data that can be read into MA!N: this is a selection.
Besides importing static files, MA!N also offers options for REST and realtime data-exchange.
Open invoices
Field | Description | Req. | Remark |
Admin ID | Administration open invoice | No | Character (20) field |
Customer code | Customer code open invoice | Yes | Character (20) field |
Invoice code | Number of the invoice | Yes | Character (20) field |
Date | Date of the invoice | Yes | Date field |
Currency | Invoice currency | No | Character (20) field |
Rate | Exchange rate | No | Number with 6 decimals |
Amount | Invoice amount | Yes | Number with 2 decimals |
Open amount | Open amount | Yes | Number with 2 decimals |
Due date | Invoice due date | No | Date field. MA!N can calculate this too. |
Description | Additional information like purchase order | No | Character (100) field |
Customers
Field | Description | Req. | Remark |
Admin ID | Administration ID (code) | No | Character (20) field |
Customer ID | Customer acocunt number | Yes | Character (20) field |
Name | Customer name | Yes | Character (50) field |
Address | Customer address | Yes | Character (50) field |
Postal code | Customer postal code | Yes | Character (20) field |
City | City | Yes | Character (50) field |
Phone | Customer phone number | No | Character (20) field |
Customer email | No | Character (50) field | |
Contact | Main customer contact | No | Character (50) field |
The import frequency depends on customer requirements. For the majority a daily import is sufficient. The fields mentioned are in random order and are a selection of the options. In case of additional fields in the file, MA!N can skip fields that are not required.
File format
MA!N is based on the Microsoft .Net platform. This enables the use of a wide range of file formats. The most commonly used are listed below.
Type | Description | Remark |
CSV | Comma Seperated Values | Fields are separated by a separator (for example, comma or a TAB). |
TXT | Text file | Field have fixed width. |
XML | ||
Excel | Microsoft Excel file | |
DBF | Database format |
Other formats are possible.