api_sales

⚠️ Important: Some fields in this table will be deprecated on Wednesday, January 7th, 2025. Please review the Deprecated Fields section below and migrate to the recommended alternatives.

This table provides sales/opportunity data from Simplicate.

Description

The api_sales table exposes sales/opportunity entities from Simplicate's CRM module.

Fields

Field Name	Type	Description
sale_id	Integer	Unique identifier for the sale
sales_manager_id	Integer	Identifier of the responsible sales person (employee)
administration_id	Integer	Identifier of the administration
sale	String	Name or description of the sale

Deprecated Fields

⚠️ Deprecation Notice: The following fields will be deprecated on Wednesday, January 7th, 2025. Please migrate to the recommended alternatives.

Deprecated Field	Type	Recommended Alternative
key_sale_id	Integer	sale_id
key_sale_responsible_person_id	Integer	sales_manager_id
key_administration_id	Integer	administration_id
sale_name	String	sale

Related Tables

• api_administrations - Administration details via administration_id
• api_employees - Sales manager details via sales_manager_id
• api_sale_custom_fields - Custom fields via sale_id
• api_workflows - Workflows via linked_sales_id