Skip to main content
The Invoices Data Model represents an itemized record of goods sold or services provided to a customer. This unified model simplifies handling invoice-related information across different accounting platforms.
  • Unified invoice properties: Essential invoice details like document number, due date, currency, status, and total amounts are standardized across different accounting platforms
  • Linked entities: Invoices can be associated with contacts, line items, payments, and sales orders, providing a complete view of the invoicing process and related transactions
  • Flexible status tracking: The model supports a range of invoice statuses, such as draft, submitted, partially paid, and overdue, for better organisation and reporting

Attributes

Invoices Attributes

PropertyTypeDescription
rootfi_idintegerUnique identifier assigned by Commenda for this invoice
rootfi_created_atstringTimestamp when this record was created in Commenda’s system (ISO 8601)
rootfi_updated_atstringTimestamp when this record was last updated in Commenda’s system (ISO 8601)
rootfi_integration_typeenum
platform_idstringUnique identifier for this invoice in the source accounting platform
contact_idstringThe contact ID of the invoice
currency_idenumISO 4217 currency code
currency_ratedoubleThe currency rate of the invoice
document_numberstringThe document number of the invoice
posted_datestringThe posted date of the invoice
due_datestringThe due date of the invoice
statusenumThe status of the invoice
sub_totaldoubleThe sub total of the invoice
tax_amountdoubleThe tax amount of the invoice
total_discountdoubleThe total discount of the invoice
shipping_amountdouble
total_amountdoubleThe total amount of the invoice
amount_paiddouble
amount_refundeddouble
amount_crediteddouble
amount_duedoubleThe amount due of the invoice
memostringThe memo or notes of the invoice
subscription_idstring
payment_linkstring
payment_link_expires_atstring
transaction_idsarray
order_idsarray
sales_order_idsarrayThe sales order IDs associated with the invoice
created_atstring
updated_atstringThe date and time the invoice was last updated

Status Enum Values

ValueDescription
DRAFTInvoice is in draft status and has not been finalized
SUBMITTEDInvoice has been submitted but not yet paid
PARTIALLY_PAIDInvoice has received partial payment
PAIDInvoice has been fully paid
OVERDUEInvoice has passed its due date without payment
VOIDInvoice has been voided or canceled
UNKNOWNStatus cannot be determined from the platform

Expandable Attributes

Use the expand query parameter to include related objects:
  • expand=line_items — includes the related Line Items object(s).
  • expand=addresses — includes the related Addresses object(s).
  • expand=documents — includes the related Documents object(s).

Properties Supported

Fields accepted when creating or updating a record:
PropertyTypeDescription
platform_idstringUnique identifier for this invoice in the source accounting platform
contact_idstringThe contact ID of the invoice
currency_idenumISO 4217 currency code
currency_ratedoubleThe currency rate of the invoice
document_numberstringThe document number of the invoice
posted_datestringThe posted date of the invoice
due_datestringThe due date of the invoice
statusenumThe status of the invoice
sub_totaldoubleThe sub total of the invoice
tax_amountdoubleThe tax amount of the invoice
total_discountdoubleThe total discount of the invoice
shipping_amountdouble
total_amountdoubleThe total amount of the invoice
amount_paiddouble
amount_refundeddouble
amount_crediteddouble
amount_duedoubleThe amount due of the invoice
memostringThe memo or notes of the invoice
subscription_idstring
payment_linkstring
payment_link_expires_atstring
transaction_idsarray
order_idsarray
sales_order_idsarrayThe sales order IDs associated with the invoice
created_atstring
updated_atstringThe date and time the invoice was last updated