Opportunities: Exact Online Opportunities
insert update delete per partition webhook REST
- Catalogus:
ExactOnlineREST - Schema:
CRM - Primaire sleutels:
ID - Label: Opportunities
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
Wijzigingen worden doorgegeven via het webhook-onderwerp Opportunities.
API-bron
- Eindpunt:
/api/v1/{division}/crm/Opportunities - Metagegevens:
/api/v1/{division}/crm/$metadata
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 5 |
| Aantal rijen per minuut bij volledige scan | 7,200 |
| Aantal rijen per minuut in een Query | 300 |
| Aantal rijen per minuut schrijven | 300 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel Opportunities worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | 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 |
Accountnaam | filters on the platform, writable | Name of account. | |
Accountant |
guid |
Accountant | filters on the platform, writable | Accountant linked to the opportunity. | |
Accountant |
varchar2 |
Accountantcode | filters on the platform, writable | Code of the Accountant. | |
Accountant |
varchar2 |
Accountant Naam | filters on the platform, writable | Name of the Accountant. | |
Action |
datetime |
Actie Datum | filters on the platform, writable | Indicates the date before/on the NextAction is supposed to be done. | |
Amount |
double |
Bedrag Administratie Munteenheid | filters on the platform, writable | Amount in the default currency of the company.AmountDC = AmountFC * RateFC. | |
Amount |
double |
Gewogen Bedrag Administratiemunteenheid | writable | Opportunity weighted amount in division currency. | |
Amount |
double |
Bedrag Vreemde Valuta | filters on the platform, writable | Amount in the currency of the transaction. | |
Amount |
double |
Gewogen Bedrag Vreemde Valuta | 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 |
Campagneomschrijving | 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 |
Kanaalomschrijving | filters on the platform, writable | Description of Channel. | |
Close |
datetime |
Datum Gesloten | 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 |
Contactpersoon Volledige Naam | filters op het platform | ||
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Aangemaakt (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Aanmaker Volledige Naam | filters on the platform, writable | Name of the creator. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | Currency code. | |
Custom |
varchar2 |
Aangepast Veld | filters on the platform, writable | ||
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Divisie Kamer van Koophandel Nummer | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Divisie IBAN Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisie Bedrijfsnaam | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Divisie RSIN Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Divisie BTW Nummer | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Divisie Loonbelastingnummer | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Divisie Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administratie Naam | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Naam Abonnementhouder | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnementhoudernummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Divisie Korte Naam | writable | Short name of the Exact Online division. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Lead |
guid |
Lead Bron | filters on the platform, writable | The source of the lead/opportunity. | |
Lead |
varchar2 |
Leadbron Omschrijving | filters on the platform, writable | Description of LeadSource. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Gewijzigd (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Gewijzigd Volledige Naam | filters on the platform, writable | Name of modifier. | |
Name |
varchar2 |
Name | filters on the platform, writable | Name of the opportunity. | |
Next |
varchar2 |
Volgende Actie | 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 |
Verkoopkans Fase | filters on the platform, writable | The stage of the opportunity.This is a list defined by the user. | |
Opportunity |
varchar2 |
Verkoopkans Fase Omschrijving | 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 |
Verkoopkans Type | filters on the platform, writable | Code of Opportunity Type. | |
Opportunity |
varchar2 |
Verkoopkans Type Omschrijving | 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 |
Eigenaar Volledige Naam | 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 |
Projectcode | filters on the platform, writable | Code of Project. | |
Project |
varchar2 |
Projectomschrijving | filters on the platform, writable | Description of Project. | |
RateFC |
double |
Wisselkoers Vreemde Valuta | filters on the platform, writable | Exchange rate from original to division currency. | |
Reason |
guid |
Redencode | filters on the platform, writable | Indicates the reason why the opportunity was lost. | |
Reason |
varchar2 |
Redencode Omschrijving | filters on the platform, writable | Description of ReasonCode. | |
Reseller |
guid |
Reseller | filters on the platform, writable | Reseller linked to the opportunity. | |
Reseller |
varchar2 |
Wederverkoper Code | filters on the platform, writable | Code of the Reseller. | |
Reseller |
varchar2 |
Wederverkoper Naam | filters on the platform, writable | Name of the Reseller. | |
Sales |
guid |
Verkoopsoort | filters on the platform, writable | Reference to Sales type. | |
Sales |
varchar2 |
Verkoop Type Omschrijving | filters on the platform, writable | Description of SalesType. |
Toetsen
| Key | Column | Verwijst naar | 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 |
Geciteerd door
- 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
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: