MDRUGB

File specification for batch import of payers

Developer Guide / Import / Export data / File specification for batch import of payers

File specification for batch import of clients

You can add from 1 to 100 customers in one import iteration.

1) Client template:
1.1) Specification of fields in imported client files for batch mode.

* - mandatory field

Column name Field description
Data type Value range and comment
IDNO IDNO (IDNP) code of the Client String 7 or 13 digits
TVA TVA Code of the Client String 7 digits
Short Caption * Client Short Name String Any string up to 255 characters
Registered Name
Client Registered Name String Any string up to 255 characters
Type Company type
String Arbitrary string 1 character ("J" - legal entity, "I" - entrepreneur, "F" - individual)
Org. form
Organizational form
String A custom string up to 20 characters ("SRL", "SA", "PF", etc.)
First Name * Contact name of the client or individual
String A custom string up to 100 characters
Last Name * Contact last name of the client or individual String Custom string up to 100 characters
E-Mail * Client's contact email String Custom string up to 100 characters
Phone Client's contact phone number String Custom string up to 20 characters
Postal Address * Legal customer address
String Any string up to 255 characters
Language Preferred invoice language String "ro", "ru" or "en"

2) Structure of the JSON file of the client card:

{
    "0": {
        "IDNO": "",
        "TVA": "",
        "Short Caption": "",
        "Registered Name": "",
        "Type": "",
        "Org. form": "",
        "First Name": "",
        "Last Name": "",
        "E-Mail": "",
        "Phone": "",
        "Postal Address": "",
        "Language": ""
    }
}
Changed: 24.10.2024 01:29