api_sales

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
contact_id	Integer	Identifier of the contact relation
sale	String	Name or description of the sale
progress_phase	String	Current progress phase of the sale
status	String	Current status of the sale
start_date	Date	Start date of the sale
end_date	Date	End date of the sale
potential_revenue	Numeric	Potential revenue for the sale
win_likelihood	Numeric	Likelihood of winning the sale (percentage)

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