Opportunities: Exact Online Opportunities
insert update delete per partition webhook REST
- Catalog:
ExactOnlineREST - Schema:
CRM - Primary Keys:
ID - Label: Opportunities
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert, update and delete.
Changes arrive through the webhook topic Opportunities.
API Source
- Endpoint:
/api/v1/{division}/crm/Opportunities - Metadata:
/api/v1/{division}/crm/$metadata
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 7,200 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |
The result can be cached on the client.
Table Columns
The columns of the table Opportunities are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Account |
guid |
Account | filters on the platform, writable | Lead to which the opportunity applies. | |
Account |
varchar2 |
Account Code | filters on the platform, writable | Code of Account. | |
Account |
varchar2 |
Account Name | filters on the platform, writable | Name of account. | |
Accountant |
guid |
Accountant | filters on the platform, writable | Accountant linked to the opportunity. | |
Accountant |
varchar2 |
Accountant Code | filters on the platform, writable | Code of the Accountant. | |
Accountant |
varchar2 |
Accountant Name | filters on the platform, writable | Name of the Accountant. | |
Action |
datetime |
Action Date | filters on the platform, writable | Indicates the date before/on the NextAction is supposed to be done. | |
Amount |
double |
Amount Division Currency | filters on the platform, writable | Amount in the default currency of the company. AmountDC = AmountFC * RateFC. | |
Amount |
double |
Amount Division Currency Weighted | writable | Opportunity weighted amount in division currency. | |
Amount |
double |
Amount Foreign Currency | filters on the platform, writable | Amount in the currency of the transaction. | |
Amount |
double |
Amount Foreign Currency Weighted | writable | Opportunity weighted amount in foreign currency. | |
Campaign |
guid |
Campaign | filters on the platform, writable | Reference to the campaign opportunity is related to. | |
Campaign |
varchar2 |
Campaign Description | filters on the platform, writable | Description of Campaign. | |
Channel |
int16 |
Channel | filters on the platform, writable | Reference to the channel opportunity is related to. | |
Channel |
varchar2 |
Channel Description | filters on the platform, writable | Description of Channel. | |
Close |
datetime |
Date Closed | filters on the platform, writable | The date when the opportunity is expected to be closed. | |
Contact |
guid |
Contact | filters on the platform, writable | ||
Contact |
varchar2 |
Contact Full Name | filters on the platform | ||
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Created (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Creator Full Name | filters on the platform, writable | Name of the creator. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | Currency code. | |
Custom |
varchar2 |
Custom Field | filters on the platform, writable | ||
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Division Chamber of Commerce Number | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Division IBAN Number | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division Company Name | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Division RSIN Number | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Division VAT Number | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Division Wage Tax Number | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Division Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administration Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Subscription Holder Name | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Subscription Holder Number | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Division Short Name | writable | Short name of the Exact Online division. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Lead |
guid |
Lead Source | filters on the platform, writable | The source of the lead/opportunity. | |
Lead |
varchar2 |
Lead Source Description | filters on the platform, writable | Description of LeadSource. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modified (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Modified Full Name | filters on the platform, writable | Name of modifier. | |
Name |
varchar2 |
Name | filters on the platform, writable | Name of the opportunity. | |
Next |
varchar2 |
Next Action | filters on the platform, writable | Indicates what follow up action is to be undertaken to move the opportunity towards a deal. Is used in combination with ActionDate. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Notes of the opportunity. | |
Number |
int32 |
Number | filters on the platform, writable | ||
Opportunity |
int16 |
itgen_eol_opportunitydepartmentcode | filters on the platform, writable | ||
Opportunity |
varchar2 |
itgen_eol_opportunitydepartmentdescription | filters on the platform, writable | ||
Opportunity |
guid |
Opportunity Stage | filters on the platform, writable | The stage of the opportunity. This is a list defined by the user. | |
Opportunity |
varchar2 |
Opportunity Stage Description | filters on the platform, writable | Description of OpportunityStage. | |
Opportunity |
int32 |
Opportunity Status | filters on the platform, writable | Status: 1=Open, 2=Closed won, 3=Closed lost. | |
Opportunity |
int16 |
Opportunity Type | filters on the platform, writable | Code of Opportunity Type. | |
Opportunity |
varchar2 |
Opportunity Type Description | filters on the platform, writable | Description of Opportunity Type. | |
Owner |
guid |
Owner | filters on the platform, writable | The resource who owns the opportunity and is responsible to close the opportunity (either won or lost). | |
Owner |
varchar2 |
Owner Full Name | filters on the platform, writable | Name of Owner. | |
Probability |
double |
Probability | filters on the platform, writable | The chance that the opportunity will be closed and won. The default for the probability depends on the default from the opportunity stage. | |
Project |
guid |
Project | filters on the platform, writable | Reference to project. | |
Project |
varchar2 |
Project Code | filters on the platform, writable | Code of Project. | |
Project |
varchar2 |
Project Description | filters on the platform, writable | Description of Project. | |
RateFC |
double |
Rate Foreign Currency | filters on the platform, writable | Exchange rate from original to division currency. | |
Reason |
guid |
Reason Code | filters on the platform, writable | Indicates the reason why the opportunity was lost. | |
Reason |
varchar2 |
Reason Code Description | filters on the platform, writable | Description of ReasonCode. | |
Reseller |
guid |
Reseller | filters on the platform, writable | Reseller linked to the opportunity. | |
Reseller |
varchar2 |
Reseller Code | filters on the platform, writable | Code of the Reseller. | |
Reseller |
varchar2 |
Reseller Name | filters on the platform, writable | Name of the Reseller. | |
Sales |
guid |
Sales Type | filters on the platform, writable | Reference to Sales type. | |
Sales |
varchar2 |
Sales Type Description | filters on the platform, writable | Description of SalesType. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Opportunities_ |
Account |
Accounts.ID |
Key | |
Opportunities_ |
Accountant |
Accounts.ID |
Key | |
Opportunities_ |
Creator |
Users. |
Key | |
Opportunities_ |
Currency |
Currencies.Code |
Key | |
Opportunities_ |
Lead |
LeadSources.ID |
Key | |
Opportunities_ |
Modifier |
Users. |
Key | |
Opportunities_ |
Opportunity |
OpportunityStages.ID |
Key | |
Opportunities_ |
Owner |
Users. |
Key | |
Opportunities_ |
Project |
Projects.ID |
Key | |
Opportunities_ |
Reason |
ReasonCodes.ID |
Key | |
Opportunities_ |
Reseller |
Accounts.ID |
Key | |
Opportunities_ |
Sales |
SalesTypes.ID |
Key |
Referenced By
- CommunicationNotes
Opportunity(Key) - Events
Opportunity(Key) - Tasks
Opportunity(Key) - CrmDocuments
Opportunity(Key) - OpportunityContactsRead
Opportunity(Key) - Quotations
Opportunity(Key) - QuotationsBulk
Opportunity(Key) - Documents
Opportunity(Key) - DocumentsBulk
Opportunity(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: