HostingOpportunitiesRead: Exact Online Hosting Opportunities
read only per partition REST
- Catalogo:
ExactOnlineREST - Schema:
CRM - Chiavi primarie:
ID - Label: Hosting Opportunities
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile solo recuperare i dati.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/read/crm/HostingOpportunities - Metadati:
/api/v1/{division}/read/crm/$metadata
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 5 |
| Righe di scansione completa al minuto | 7,200 |
| Numero di righe di Query al minuto | 300 |
| Scrittura di righe al minuto | 300 |
Il risultato può essere memorizzato nella memoria cache sul client.
Colonne della tabella
Di seguito sono riportate le colonne della tabella HostingOpportunitiesRead. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Account |
guid |
Account | filters on the platform, writable | Lead to which the opportunity applies. | |
Account |
varchar2 |
Codice conto | filters on the platform, writable | Code of Account. | |
Account |
varchar2 |
Nome dell'account | filters on the platform, writable | Name of Account. | |
Accountant |
guid |
Accountant | filters on the platform, writable | Accountant linked to the opportunity. | |
Accountant |
varchar2 |
Codice contabile | filters on the platform, writable | Code of the Accountant. | |
Accountant |
varchar2 |
Nome del contabile | filters on the platform, writable | Name of the Accountant. | |
Action |
datetime |
Data dell'azione | filters on the platform, writable | Indicates the date before/on the NextAction is supposed to be done. | |
Amount |
double |
Valuta della divisione degli importi | filters on the platform, writable | Amount in the default currency of the company.AmountDC = AmountFC * RateFC. | |
Amount |
double |
Importo in valuta estera | 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 |
Descrizione della campagna | 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 |
Descrizione del canale | filters on the platform, writable | Description of Channel. | |
Close |
datetime |
Data chiusa | 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 |
Creato | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nome completo del creatore | 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 |
Tempistica della decisione | 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 |
ID dell'azienda | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Numero di iscrizione alla Camera di Commercio della Divisione | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Codice IBAN della divisione | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisione - Nome dell'azienda | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numero di divisione RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Partita IVA della divisione | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Codice fiscale salariale della divisione | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etichetta della divisione | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nome dell'amministrazione | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nome del titolare dell'abbonamento | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numero di abbonato | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nome abbreviato della divisione | writable | Short name of the Exact Online division. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Is |
int16 |
Prezzo associato | 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 |
Sviluppatore capo | filters on the platform, writable | Name of the lead developer. | |
Lead |
guid |
Database di origine del cliente potenziale | filters on the platform, writable | The source of the lead/opportunity. | |
Lead |
varchar2 |
Descrizione della fonte principale | filters on the platform, writable | Description of LeadSource. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificato (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nome completo modificato | filters on the platform, writable | Name of the last modifier. | |
Name |
varchar2 |
Name | filters on the platform, writable | Name of the opportunity. | |
Next |
varchar2 |
Azione successiva | 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 | filtri sulla piattaforma | ||
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 |
Fase delle opportunità | filters on the platform, writable | The stage of the opportunity.This is a list defined by the user. | |
Opportunity |
varchar2 |
Descrizione della fase di opportunità | filters on the platform, writable | Description of OpportunityStage. | |
Opportunity |
int32 |
Stato dell'opportunità | filters on the platform, writable | Status: 1=Open, 2=Closed won, 3=Closed lost. | |
Opportunity |
int16 |
Tipo di opportunità | filters on the platform, writable | Code of Opportunity Type. | |
Opportunity |
varchar2 |
Tipo di opportunità - Descrizione | 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 |
Nome e cognome del proprietario | 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 |
Codice del progetto | filters on the platform, writable | Code of Project. | |
Project |
varchar2 |
Descrizione del progetto | filters on the platform, writable | Description of Project. | |
RateFC |
double |
Tasso di cambio valuta estera | filters on the platform, writable | Exchange rate from original to division currency. | |
Reason |
varchar2 |
Motivo Indietro | filters on the platform, writable | Indicate the reason back. | |
Reason |
guid |
Codice motivo | filters on the platform, writable | Indicates the reason why the opportunity was lost. | |
Reason |
varchar2 |
Codice motivo Descrizione | filters on the platform, writable | Description of ReasonCode. | |
Reseller |
guid |
Reseller | filters on the platform, writable | Reseller linked to the opportunity. | |
Reseller |
varchar2 |
Codice rivenditore | filters on the platform, writable | Code of the Reseller. | |
Reseller |
varchar2 |
Nome del rivenditore | filters on the platform, writable | Name of the Reseller. | |
Sales |
guid |
Tipo di vendita | filters on the platform, writable | Reference to Sales type. | |
Sales |
varchar2 |
Tipo di vendita Descrizione | filters on the platform, writable | Description of SalesType. |
Chiavi
| Key | Column | Si riferisce a | 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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: