Skip to main content
The Sales Orders Data Model represents a record of goods or services sold to a customer. This unified model standardizes information related to sales orders across various accounting platforms.
  • Unified sales order properties: Essential sales order information, such as contact ID, document number, dates, description, payment mode, and currency-related data, are standardized across different accounting platforms
  • Financial calculations: The model includes properties for total discount, tax amount, sub-total, and total amount, facilitating accurate financial reporting and analysis
  • Invoice associations: The invoices property links sales orders to their corresponding invoices, enabling seamless navigation and cross-referencing between the two data models

Attributes

Sales Orders Attributes

PropertyTypeDescription
rootfi_idintegerUnique identifier assigned by Commenda for this sales order
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 sales order in the source accounting platform
posted_datestringThe posted date of the sales order
delivery_datestringThe delivery date of the sales order
descriptionstringThe description of the sales order
document_numberstringThe document number of the sales order
currency_idenumISO 4217 currency code
currency_ratedoubleThe currency rate of the sales order
sub_totaldoubleThe sub total of the sales order
tax_amountdoubleThe tax amount of the sales order
total_discountdoubleThe total discount of the sales order
total_amountdoubleThe total amount of the sales order
payment_modestringThe payment mode of the sales order
statusenumThe status of the sales order
contact_idstringThe contact ID of the sales order
invoice_idsarrayThe invoice IDs associated with the sales order
updated_atstringThe date and time the sales order was last updated

Status Enum Values

ValueDescription
DRAFTSales order is in draft status and has not been finalized
SUBMITTEDSales order has been submitted but not yet paid
PARTIALLY_PAIDSales order has received partial payment
PAIDSales order has been fully paid
OVERDUESales order has passed its due date without payment
VOIDSales order 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=contact — includes the related Contact object(s).
  • expand=currency — includes the related Currency object(s).

Properties Supported

Fields accepted when creating or updating a record:
PropertyTypeDescription
platform_idstringUnique identifier for this sales order in the source accounting platform
posted_datestringThe posted date of the sales order
delivery_datestringThe delivery date of the sales order
descriptionstringThe description of the sales order
document_numberstringThe document number of the sales order
currency_idenumISO 4217 currency code
currency_ratedoubleThe currency rate of the sales order
sub_totaldoubleThe sub total of the sales order
tax_amountdoubleThe tax amount of the sales order
total_discountdoubleThe total discount of the sales order
total_amountdoubleThe total amount of the sales order
payment_modestringThe payment mode of the sales order
statusenumThe status of the sales order
contact_idstringThe contact ID of the sales order
invoice_idsarrayThe invoice IDs associated with the sales order
updated_atstringThe date and time the sales order was last updated