MA!N data interface (basic)

Last updated: July 14, 2022

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

FieldDescriptionReq.Remark
Admin IDAdministration open invoiceNoCharacter (20) field
Customer codeCustomer code open invoiceYesCharacter (20) field
Invoice codeNumber of the invoiceYesCharacter (20) field
DateDate of the invoiceYesDate field
CurrencyInvoice currencyNoCharacter (20) field
RateExchange rateNoNumber with 6 decimals
AmountInvoice amountYesNumber with 2 decimals
Open amountOpen amountYesNumber with 2 decimals
Due dateInvoice due dateNoDate field. MA!N can calculate this too.
DescriptionAdditional information like purchase orderNoCharacter (100) field

Customers

FieldDescriptionReq.Remark
Admin IDAdministration ID (code)NoCharacter (20) field
Customer IDCustomer acocunt numberYesCharacter (20) field
NameCustomer nameYesCharacter (50) field
AddressCustomer addressYesCharacter (50) field
Postal codeCustomer postal codeYesCharacter (20) field
CityCityYesCharacter (50) field
PhoneCustomer phone numberNoCharacter (20) field
EmailCustomer emailNoCharacter (50) field
ContactMain customer contactNoCharacter (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.

TypeDescriptionRemark
CSVComma Seperated ValuesFields are separated by a separator (for example, comma or a TAB).
TXTText fileField have fixed width.
XML
ExcelMicrosoft Excel file
DBFDatabase format

Other formats are possible.