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"
}