MDRUGB

Specificații de format de fișier

Ghidul dezvoltatorului / Import / Export date / Specificații de format de fișier
Schimbat: 04.03.2024 17:15

1) Cont de plată

1.1) Specificarea câmpurilor din fișierele de cont exportate/importate.

* - câmp obligatoriu

Numele coloanei Descrierea câmpului Tipul de date Interval de valori și comentariu
Number * Account number String Any string up to 50 characters long
Status Status String Allowed statuses: "draft", "actual". When importing an invoice, the status is always reset to "draft"
Date * Invoice date Date Official invoice date
Due On * Valid until Date Invoice expiration date
Amount * Amount payable Float
 > 0.00 and <= 10,000,000.00
Currency Account currency String Always "MDL"
Buyer * Name (name) of the payer String
Buyer IDNO IDNO code (IDNP) of the payer String 7 or 13 digits
Buyer TVA TVA code of the payer String 7 digits
Buyer E-Mai * Contact e-mail of the payer String Correct email address (e-mail)
Buyer Phone Contact phone number of the payer String International telephone number - 16 digits
TVA Calc * VAT calculation method String
TVA Rate * VAT rate Floating point number Rate in %
TVA Amount VAT amount Floating point number > 0.00 and <= 2,000,000.00
wTVA Amount Amount without VAT Floating point number > 0.00 and <= 8,000,000.00
Language Invoice language String "ro", "ru" or "en"
Item * Internal serial number of the product/service Integer
 From "0" and further in order
Code * Product/service code visible on the invoice String Now: from "1" and further in order.
Name * Product/service name String Arbitrary string up to 255 characters
UnitPrice * Unit price of a good/service Floating point number > 0.00 and <= 1,000,000.00
Quantity * Number of goods/services Integer From 1 to 1,000,000
UnitOfMeasure * Unit String Arbitrary string up to 20 characters ("pieces", "pcs", etc.)
TotalPrice * Total per line Floating point number > 0.00 and <= 10,000,000.00

1.2) Structura fișierului JSON al cont: 

{
    "0": {
        "Number": "",
        "Status": "",
        "Date": "",
        "Due On": "",
        "Amount": "0.00",
        "Currency": "",
        "Buyer": "",
        "Buyer IDNO": "",
        "Buyer TVA": "",
        "Buyer E-Mail": "",
        "Buyer Phone": "",
        "TVA Calc": "",
        "TVA Rate": "0.00",
        "TVA Amount": "0.00",
        "wTVA Amount": "0.00",
        "Language": "",
        "Items": {
            "0": {
                "Code": 1,
                "Name": "",
                "UnitPrice": "0.00",
                "Quantity": 0,
                "UnitOfMeasure": "",
                "TotalPrice": "0.00"
            },
            "1": {
                "Code": 2,
                "Name": "",
                "UnitPrice": "0.00",
                "Quantity": 0,
                "UnitOfMeasure": "",
                "TotalPrice": "0.00"
            }
        }
    }
}

2) Card de client (plătitor)

2.1) Specificarea câmpurilor din fișierele client exportate/importate.

* - câmp obligatoriu

Numele coloanei Descrierea câmpului
 Tipul de date Interval de valori și comentariu
IDNO IDNO code (IDNP) of the client String 7 or 13 digits
TVA Customer TVA code String 7 digits
Short Caption * Client short name String Arbitrary string up to 255 characters
Registered Name Client's full name String Arbitrary string up to 255 characters
Type Type of company
 String Arbitrary string 1 character ("J"- legal, "I" - individual, "F" - person)
Org. form Legal form of the company String Arbitrary string up to 20 characters ("SRL", "SA", "PF" etc.)
First Name * Contact name of client or individual
 String Arbitrary string up to 100 characters
Last Name * Contact name of client or individual String Arbitrary string up to 100 characters
E-Mail * Contact e-mail of the client String Arbitrary string up to 100 characters
Phone Customer contact number String Arbitrary string up to 20 characters
Postal Address * Client's legal address
 String Arbitrary string up to 255 characters
Language Preferred invoicing language String "ro", "ru" or "en"

2.2) Structura JSON a fișierului cardului client:

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


Anterior