HostingOpportunities: Exact Online Hosting Opportunities
insert update delete per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
CRM - Primärschlüssel:
ID - Label: Hosting Opportunities
Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.
Mit insert, update und delete können Daten abgerufen und geändert werden.
Änderungen werden über das Webhook-Thema HostingOpportunities übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/crm/HostingOpportunities - Metadaten:
/api/v1/{division}/crm/$metadata
Leistungsmerkmale
| Characteristic | Value |
|---|---|
| Durchschnittliche Zugriffsverzögerung (ms) | 5 |
| Anzahl der Vollscan-Zeilen pro Minute | 7,200 |
| Anzahl der Query-Zeilen pro Minute | 300 |
| Zeilen pro Minute schreiben | 300 |
Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.
Tabellenspalten
Die Spalten der Tabelle HostingOpportunities sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Account |
guid |
Account | filters on the platform, writable | Lead to which the opportunity applies. | |
Account |
varchar2 |
Konto Code | filters on the platform, writable | Code of Account. | |
Account |
varchar2 |
Konto Name | filters on the platform, writable | Name of Account. | |
Accountant |
guid |
Accountant | filters on the platform, writable | Accountant linked to the opportunity. | |
Accountant |
varchar2 |
Buchhaltercode | filters on the platform, writable | Code of the Accountant. | |
Accountant |
varchar2 |
Buchhaltername | filters on the platform, writable | Name of the Accountant. | |
Action |
datetime |
Aktionsdatum | filters on the platform, writable | Indicates the date before/on the NextAction is supposed to be done. | |
Amount |
double |
Betrag Sparte Währung | filters on the platform, writable | Amount in the default currency of the company.AmountDC = AmountFC * RateFC. | |
Amount |
double |
Summe Fremdwährung | filters on the platform, writable | Amount in the currency of the transaction. | |
Back |
datetime |
itgen_eol_backtoleaddevelopment | filters on the platform, writable | Indicate the date back to lead development. | |
Campaign |
guid |
Campaign | filters on the platform, writable | Reference to the campaign opportunity is related to. | |
Campaign |
varchar2 |
Beschreibung der Kampagne | 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 |
Kanalbeschreibung | filters on the platform, writable | Description of Channel. | |
Close |
datetime |
Datum abgeschlossen | filters on the platform, writable | The date when the opportunity is expected to be closed. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Angelegt | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Ersteller vollständiger Name | filters on the platform, writable | Name of the creator. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | Currency code. | |
Customer |
varchar2 |
itgen_eol_customerdemandsdescription | filters on the platform, writable | Description related to customer demand. | |
Decision |
varchar2 |
itgen_eol_decisionmakingunitname | filters on the platform, writable | DMU fields-Unit Name. | |
Decision |
varchar2 |
itgen_eol_decisionmakingunitrole | filters on the platform, writable | DMU fields- Unit Role. | |
Decision |
varchar2 |
Entscheidungszeitraum | filters on the platform, writable | Description of the time frame. | |
Dispatch |
datetime |
itgen_eol_dispatchtosales | filters on the platform, writable | Indicate the date when dispatch to sales. | |
Division |
int32 |
Abteilung ID | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Nummer der Handelskammer des Bezirks | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Abteilung IBAN-Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Geschäftsbereich Firmenname | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Abteilung RSIN-Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Umsatzsteuer-Identifikationsnummer der Abteilung | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Nummer der Lohnsteuerabteilung | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Abteilungsbezeichnung | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Verwaltung Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Name des Abonnenten | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnentennummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Kurzbezeichnung der Abteilung | writable | Short name of the Exact Online division. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Is |
int16 |
Ist der zugehörige Preis | filters on the platform, writable | Aware of associated prices. | |
Is |
int16 |
itgen_eol_iscustomerdemandsmeet | filters on the platform, writable | Standard product solves customer demands. | |
Lead |
guid |
Hauptentwickler | filters on the platform, writable | Name of the lead developer. | |
Lead |
guid |
Lead-Quelle | filters on the platform, writable | The source of the lead/opportunity. | |
Lead |
varchar2 |
Beschreibung der Lead-Quelle | filters on the platform, writable | Description of LeadSource. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Geändert (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Geänderter vollständiger Name | filters on the platform, writable | Name of the last modifier. | |
Name |
varchar2 |
Name | filters on the platform, writable | Name of the opportunity. | |
Next |
varchar2 |
Nächste Aktion | 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 | Code of Opportunity Department. | |
Opportunity |
varchar2 |
itgen_eol_opportunitydepartmentdescription | filters on the platform, writable | Description of Opportunity Department. | |
Opportunity |
guid |
Verkaufschance Phase | filters on the platform, writable | The stage of the opportunity.This is a list defined by the user. | |
Opportunity |
varchar2 |
Beschreibung der Opportunity-Phase | filters on the platform, writable | Description of OpportunityStage. | |
Opportunity |
int32 |
Verkaufschance Status | filters on the platform, writable | Status: 1=Open, 2=Closed won, 3=Closed lost. | |
Opportunity |
int16 |
Art der Gelegenheit | filters on the platform, writable | Code of Opportunity Type. | |
Opportunity |
varchar2 |
Art der Gelegenheit – Beschreibung | 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 |
Vollständiger Name des Eigentümers | 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 |
Projekt | filters on the platform, writable | Code of Project. | |
Project |
varchar2 |
Projektbeschreibung | filters on the platform, writable | Description of Project. | |
RateFC |
double |
Fremdwährungskurs | filters on the platform, writable | Exchange rate from original to division currency. | |
Reason |
varchar2 |
Grund Zurück | filters on the platform, writable | Indicate the reason back. | |
Reason |
guid |
Ursachencode | filters on the platform, writable | Indicates the reason why the opportunity was lost. | |
Reason |
varchar2 |
Fehlercode Beschreibung | filters on the platform, writable | Description of ReasonCode. | |
Reseller |
guid |
Reseller | filters on the platform, writable | Reseller linked to the opportunity. | |
Reseller |
varchar2 |
Wiederverkäufer Code | filters on the platform, writable | Code of the Reseller. | |
Reseller |
varchar2 |
Wiederverkäufer Name | filters on the platform, writable | Name of the Reseller. | |
Sales |
guid |
Verkaufstyp | filters on the platform, writable | Reference to Sales type. | |
Sales |
varchar2 |
Verkaufsart – Beschreibung | filters on the platform, writable | Description of SalesType. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Hosting |
Account |
Accounts.ID |
Key | |
Hosting |
Accountant |
Accounts.ID |
Key | |
Hosting |
Creator |
Users. |
Key | |
Hosting |
Currency |
Currencies.Code |
Key | |
Hosting |
Lead |
LeadSources.ID |
Key | |
Hosting |
Modifier |
Users. |
Key | |
Hosting |
Opportunity |
OpportunityStages.ID |
Key | |
Hosting |
Owner |
Users. |
Key | |
Hosting |
Project |
Projects.ID |
Key | |
Hosting |
Reason |
ReasonCodes.ID |
Key | |
Hosting |
Reseller |
Accounts.ID |
Key | |
Hosting |
Sales |
SalesTypes.ID |
Key |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: