Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Simplicate API Data Model

Navigation: Schema: Sales > Tables

SalesCustomFields: Simplicate Sales Custom Fields

Contents Previous Home Next More

Fetches all sales

Catalog: Simplicate

Schema: Sales

Label: Sales Custom Fields

This is a read-only table function. The Simplicate API may not support changing the data or the Invantive SQL driver for Simplicate does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Simplicate API.

Select Simplicate API URL: /sales/sales

Insert Simplicate API URL: /sales/sales

Update Simplicate API URL: /sales/sales

Delete Simplicate API URL: /sales/sales

Field Selection Method: NotRequired

Base Path: data[*].custom_fields[*]

Select Simplicate API Operation: get /sales/sales

Table Function Columns

The columns of the table function SalesCustomFields are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

chance_to_score

string

 

 

contact_family_name_prefix

string

 

 

contact_family_name

string

 

 

contact_first_name

string

 

 

contact_id_1

string

 

 

contact_id

string

 

 

contact_person_id

string

 

 

contact_work_email

string

 

 

contact_work_function

string

 

 

contact_work_mobile

string

 

 

contact_work_phone

string

 

 

created_at

string

Created at

 

created

string

Created

 

custom_field_group_id

string

 

 

custom_field_group_model_id

string

 

 

custom_field_group_model_label

string

 

 

custom_field_group_name

string

 

 

custom_field_group_position

string

 

 

custom_field_group_type

string

 

 

expected_closing_date

string

 

 

expected_revenue

float

 

 

filterable

boolean

 

 

id_1

string

 

 

id

string

ID

 

label

string

Label

 

lost_to_competitor_id

string

 

 

lost_to_competitor_name

string

 

 

modified

string

Modified

 

my_organization_profile_id

string

 

 

name

string

Name

 

note

string

Note

 

organization_id_1

string

 

 

organization_id

string

Organization ID

 

organization_name

string

Organization Name

 

person_full_name

string

 

 

person_id_1

string

 

 

person_id

string

Person ID

 

position

int64

 

 

progress_chance_to_score

float

 

 

progress_color

string

 

 

progress_id

string

 

 

progress_label

string

 

 

progress_position

int64

 

 

reason_id

string

 

 

reason_name

string

 

 

render_type

string

 

 

responsible_employee_amount

float

 

 

responsible_employee_declarable

string

 

 

responsible_employee_employee_id

string

 

 

responsible_employee_id

string

 

 

responsible_employee_name

string

 

 

responsible_employee_person_id

string

 

 

responsible_employee_tariff

float

 

 

searchable

boolean

Searchable

 

separate_invoice_recipient_contact_id

string

 

 

separate_invoice_recipient_contact_organization_id

string

 

 

separate_invoice_recipient_contact_organization_name

string

 

 

separate_invoice_recipient_contact_person_full_name

string

 

 

separate_invoice_recipient_contact_person_id

string

 

 

separate_invoice_recipient_is_separate_invoice_recipient

boolean

 

 

separate_invoice_recipient_organization_id

string

 

 

separate_invoice_recipient_organization_name

string

 

 

separate_invoice_recipient_person_full_name

string

 

 

separate_invoice_recipient_person_id

string

 

 

simplicate_url

string

Simplicate URL

 

source_id

string

 

 

source_name

string

 

 

start_date

string

Start Date

 

status_id

string

 

 

status_label

string

 

 

status_updated_at

string

 

 

subject

string

 

 

timeline_email_address

string

 

 

type

string

Type

 

updated_at

string

Updated at

 

value_type

string

Value Type

 

value

string

Value

 

 

06-04-2021 14:59 Version 20.1.393-BETA+3152