Invoice HTML and JSON templates

Your are here:
< Back

How to use Invoice fields in invoice templates

Available fields

 

  • Field name in json
  • ?
  • ?
  • ?
  • InvoiceLine.ArticleId
  • InvoiceLine.TaxInclusiveAmount
  • InvoiceLine.Title
  • InvoiceLine.TotalAmountExcl
  • InvoiceLine.Quantity
  • InvoiceLine.?
  • InvoiceLine.TotalAmountIncl
  • AccountingSupplierParty.PartyName.Party. Name
  • AccountingSupplierParty.PartyName.Party.
  • AccountingSupplierParty.PartyName.Party.
  • AccountingSupplierParty.PartyName.Party.
  • ID
  • IssueDate
  • TaxInclusiveAmount
  • Field ID to be used in HTML template
  • INVOICE_TOTAL_EXCL_VALUE
  • INVOICE_TAX_PERCENTAGE
  • INVOICE_TAX_AMOUNT
  • IL_ARTICLEID
  • INVOICE_TOTAL_INCL_VALUE
  • IL_NAME
  • IL_PRICE
  • IL_QUANTITY
  • IL_VATAMOUNT
  • IL_TOTAL
  • DEB_NAME
  • DEB_FULLSTREET
  • DEB_FULLPLACE
  • DEB_EMAIL
  • INVOICE_ID
  • INVOICE_ISSUEDATE:dd-MM-yyyy
  • INVOICE_TOTAL_INCL_VALUE

HTML Template

In HTML document you use the fields as described below:

JSON Template

In JSON document you use the fields as described below:

{
“ID”: “1056789”,
“Country”: “NL”,
“IssueDate”: “2021-04-03”,
“DueDate”: “2021-05-03”,
“Payment”: [
{
“ID”: “1056789”,
“Iban”: “NL03 RABO 0384130380”,
“AccountName”: “Top Bakkers B.V.”,
“BIC”: “RABONL2U”
},
{
“ID”: “1056789”,
“Iban”: “NL86 INGB 0005699453”,
“AccountName”: “Top Bakkers B.V.”,
“BIC”: “INGBNL2A”
}
],
“OrderReference”: {
“Id”: null,
“OrderTypeCode”: null,
“CustomerReference”: null,
“SalesOrderID”: null
},
“LegalMonetaryTotal”: {
“TaxExclusiveAmount”: 5.82,
“TaxInclusiveAmount”: 6.34
},
“AccountingSupplierParty”: {
“Party”: {
“PartyName”: {
“Name”: “Top Bakkers B.V.”
},
“PostalAddress”: {
“StreetName”: “Saba 10”,
“PostalZone”: “7302 BH”,
“CityName”: “Apeldoorn”,
“BuildingNumber”: null,
“Postbox”: null
},
“PartyIdentification”: {
“ID”: “8710261901009”,
“RegistrationInstance”: “GLN”
},
“PartyLegalEntity”: {
“CompanyID”: “08113907”,
“RegistrationInstance”: “KvK”
},
“TaxIdentification”: {
“ID”: “NL811668411B01”,
“name”: null
},
“Contact”: {
“Name”: “Top Bakkers – Administratie”,
“Email”: “administratie@topbakkers.nl”,
“Telephone”: “+31 555 998 223”
}
},
“AccountingCustomerParty”: {
“Party”: {
“PartyName”: {
“Name”: “Huuskes inzake DC-leveringen Enschede”
},
“PostalAddress”: {
“StreetName”: “Postbus 6107”,
“PostalZone”: “7503 GC”,
“CityName”: “ENSCHEDE”,
“BuildingNumber”: null,
“Postbox”: null
},
“PartyIdentification”: {
“ID”: “36820”
},
“PartyLegalEntity”: {
“CompanyID”: “”,
“RegistrationInstance”: “KvK”
},
“TaxIdentification”: {
“ID”: “”,
“name”: null
}
}
},
“Delivery”: {
“Party”: {
“PartyName”: {
“Name”: “Erasplaats 114 EZO”
},
“PostalAddress”: {
“StreetName”: “Erasplaats 114”,
“PostalZone”: “5046 LA”,
“CityName”: “Tilburg”,
“BuildingNumber”: null,
“Postbox”: null
},
“PartyIdentification”: {
“ID”: “4301535”
},
“PartyLegalEntity”: {
“CompanyID”: “”,
“RegistrationInstance”: “KvK”
},
“TaxIdentification”: {
“ID”: “”,
“name”: null
}
}
},
“SupplierParty”: {
“Party”: {
“PartyName”: {
“Name”: “Top Bakker Sellink B.V.”
},
“PostalAddress”: {
“StreetName”: “Geldereschweg 1”,
“PostalZone”: “7104 AM”,
“CityName”: “MEDDO”,
“BuildingNumber”: null,
“Postbox”: null
},
“PartyIdentification”: {
“ID”: “67580”
},
“PartyLegalEntity”: {
“CompanyID”: “08011131”
}
}
},
“InvoiceLine”:[
{
“OrderReference”: null,
“ArticleId”: “SE09014”,
“Position”: 1.0,
“Title”: “Krat Huuskes”,
“Description”: “TB780000 – Regionaal assortiment hoog bruto”,
“TaxPercentage”: 21.00,
“TaxDefinition”: “”,
“TotalAmountExcl”: 0.00,
“TotalAmountIncl”: null,
“Quantity”: 1.00,
“BaseAmount”: 1.0,
“DetailSpecification”: [
{
“Name”: “VR”,
“Quantity”: 1.00,
“OrderReference”: “1207830”,
“ReductionPercentage”: 0,
“ReductionCurrency”: null
}
]
}
,
{
“OrderReference”: null,
“ArticleId”: “TB140542”,
“Position”: 2.0,
“Title”: “Paasbrood haantjes Monopack 1x”,
“Description”: “TB140542 – Paasbrood haantjes Monopack 1x”,
“TaxPercentage”: 9.00,
“TaxDefinition”: “”,
“TotalAmountExcl”: 7.28,
“TotalAmountIncl”: null,
“Quantity”: 8.00,
“BaseAmount”: 1.0,
“DetailSpecification”: [
{
“Name”: “VR”,
“Quantity”: 8.00,
“OrderReference”: “1207830”,
“ReductionPercentage”: 0,
“ReductionCurrency”: null
}
]
}
,
{
“OrderReference”: null,
“ArticleId”: “Z4”,
“Position”: 3.0,
“Title”: “Staffelkorting: 20,0%”,
“Description”: “Z4 – Staffelkorting”,
“TaxPercentage”: 9.00,
“TaxDefinition”: “”,
“TotalAmountExcl”: -1.46,
“TotalAmountIncl”: null,
“Quantity”: 1.00,
“BaseAmount”: 1.0}
]
}
}

Articles
Copyright - Ublion is powered by Get Data Insight - www.getdatainsight.com