Json Object

This documentation is outdated

The most complete and up-to-date documentation is the one of Banana Accounting Plus: Try it now

In this article

Invoice Json Object

Data structure you can access through the report:

{
    "billing_info": {
        "payment_term": "",
        "total_amount_vat_exclusive": "500.00",
        "total_amount_vat_exclusive_before_discount": "500.00",
        "total_amount_vat_inclusive": "540.00",
        "total_amount_vat_inclusive_before_discount": "540.00",
        "total_categories": [
        ],
        "total_discount_percent": "",
        "total_discount_vat_exclusive": "",
        "total_discount_vat_inclusive": "",
        "total_rounding_difference": "",
        "total_to_pay": "540.00",
        "total_vat_amount": "40.00",
        "total_vat_amount_before_discount": "40.00",
        "total_vat_codes": [
        ],
        "total_vat_rates": [
            {
                "total_amount_vat_exclusive": "500.00",
                "total_amount_vat_inclusive": "540.00",
                "total_vat_amount": "40.00",
                "vat_rate": "8.00"
            }
        ]
    },
    "customer_info": {
        "address1": "Viale Stazione 11",
        "address2": "", 
        "address3": "", 
        "balance": "102.60", 
        "balance_base_currency": "102.60", 
        "business_name": "Rossi SA",
        "city": "Bellinzona",
        "country": "Switzerland", 
        "country_code": "CH", 
        "courtesy": "Signor", 
        "currency": "CHF", 
        "date_birth": "1999-10-06", 
        "email": "info@test.com", 
        "first_name": "Andrea", 
        "lang": "it",
        "last_name": "Rossi",
        "mobile": "0033608405", 
        "number": "1100",
        "origin_row": "26",
        "origin_table": "Accounts",
        "postal_code": "6500",
        "vat_number": "1234"
    },
    "document_info": {
        "currency": "CHF",
        "date": "20160101",
        "decimals_amounts": 2,
        "description": "",
        "doc_type": "10", 
        "locale": "it",
        "number": "201710",
        "origin_row": "1",
        "origin_table": "Transactions",
        "printed": "1", 
        "rounding_total": "0.05",
        "type": "invoice"
    },
    "items": [
        {
            "account_assignment": "3000",
            "description": "Prodotto A",
            "details": "",
            "index": "0",
            "item_type": "item",
            "mesure_unit": "",
            "number": "",
            "origin_row": "1",
            "origin_table": "Transactions",
            "quantity": "1",
            "total_amount_vat_exclusive": "500.00",
            "total_amount_vat_inclusive": "540.00",
            "total_vat_amount": "40.00",
            "unit_price": {
                "amount_vat_inclusive": "540.00",
                "calculated_amount_vat_exclusive": "500.00",
                "calculated_amount_vat_inclusive": "540.00",
                "calculated_vat_amount": "40.00",
                "currency": "CHF",
                "vat_code": "V80",
                "vat_rate": "8.00"
            }
        }
    ],
    "note": [
            {
                "date": "2017-04-24",
                "description": "commande=AWO-003530",
                "origin_row": "968",
                "origin_table": "Transactions"
            }
    ],
    "parameters": {
        "ccpaid":"1",
        "orderNo":"5440004/44",
        "myKey":"MyValue"
    },
    "payment_info": {
        "date_expected": "2017-05-24", 
        "due_date": "20160131",
        "due_days": "240",
        "due_period": "0_>90",
        "last_reminder": "",
        "last_reminder_date": "",
        "payment_date": ""
    },
    "shipping_info": {
         "address1": "26, lotissement Bellevue",
         "address2": "street2",
         "address3": "street3",
         "business_name": "Company",
         "city": "Clairac",
         "country": "FR",
         "different_shipping_address": true,
         "first_name": "Carla",
         "last_name": "Francine",
         "postal_code": "47320"
    },
    "supplier_info": {
        "address1": "Indirizzo 1",
        "address2": "Indirizzo 2",
        "business_name": "Società",
        "city": "Loc",
        "courtesy": "Signor",
        "email": "info@myweb",
        "fax": "+419100000", 
        "first_name": "Nome",
        "fiscal_number": "222",
        "last_name": "Cognome",
        "phone": "+419100000", 
        "postal_code": "CAP",
        "state": "Suisse", 
        "vat_number": "1111", 
        "web": "http://www.myweb"
    }
    "transactions": [
        {
            "balance": "-219.30",
            "balance_base_currency": "",
            "currency": "CHF",
            "date": "20170430",
            "description": "Paiement CERAT DES ALPES* 50 ml - Réf. AL07010",
            "origin_row": "1006",
            "origin_table": "Transactions"
        }
    ],
    "type": "invoice",
    "version": "1.0"
}

 

 

Share this article: Twitter | Facebook | LinkedIn | Email