invantive documentation
Forum di supporto InvantiveAccedi / Registrati

OpportunitiesRead: Exact Online Opportunities (Read-only)

read only per partition REST

  • Catalogo: ExactOnlineREST
  • Schema: CRM
  • Chiavi primarie: ID
  • Label: Opportunities (Read-only)

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/Opportunities
  • 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 OpportunitiesRead. 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.
AccountCode varchar2(18) Codice conto filters on the platform, writable Code of Account.
AccountName varchar2(50) Nome dell'account filters on the platform, writable Name of account.
Accountant guid Accountant filters on the platform, writable Accountant linked to the opportunity.
AccountantCode varchar2 Codice contabile filters on the platform, writable Code of the Accountant.
AccountantName varchar2(50) Nome del contabile filters on the platform, writable Name of the Accountant.
ActionDate datetime Data dell'azione filters on the platform, writable Indicates the date before/on the NextAction is supposed to be done.
AmountDC double Valuta della divisione degli importi filters on the platform, writable Amount in the default currency of the company.AmountDC = AmountFC * RateFC.
AmountFC double Importo in valuta estera filters on the platform, writable Amount in the currency of the transaction.
Campaign guid Campaign filters on the platform, writable Reference to the campaign opportunity is related to.
CampaignDescription 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.
ChannelDescription varchar2 Descrizione del canale filters on the platform, writable Description of Channel.
CloseDate datetime Data chiusa filters on the platform, writable The date when the opportunity is expected to be closed.
Contact guid Contact filters on the platform, writable
ContactFullName varchar2 Nome e cognome del contatto filtri sulla piattaforma
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Creato writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Nome completo del creatore filters on the platform, writable Name of the creator.
Currency varchar2(30) Currency filters on the platform, writable Currency code.
CustomField varchar2 Campo personalizzato filtri sulla piattaforma
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Numero di iscrizione alla Camera di Commercio della Divisione writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Codice IBAN della divisione writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Divisione - Nome dell'azienda writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Numero di divisione RSIN writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Partita IVA della divisione writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Codice fiscale salariale della divisione writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Etichetta della divisione writable Label of the Exact Online division.
DivisionName varchar2(50) Nome dell'amministrazione writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Nome del titolare dell'abbonamento writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Numero di abbonato writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Nome abbreviato della divisione writable Short name of the Exact Online division.
ID guid ID filters on the platform, writable Primary key.
LeadSource guid Database di origine del cliente potenziale filters on the platform, writable The source of the lead/opportunity.
LeadSourceDescription varchar2 Descrizione della fonte principale filters on the platform, writable Description of LeadSource.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modificato (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Nome completo modificato filters on the platform, writable Name of modifier.
Name varchar2 Name filters on the platform, writable Name of the opportunity.
NextAction 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
OpportunityDepartmentCode int16 itgen_eol_opportunitydepartmentcode filters on the platform, writable
OpportunityDepartmentDescription varchar2 itgen_eol_opportunitydepartmentdescription filters on the platform, writable
OpportunityStage guid Fase delle opportunità filters on the platform, writable The stage of the opportunity.This is a list defined by the user.
OpportunityStageDescription varchar2 Descrizione della fase di opportunità filters on the platform, writable Description of OpportunityStage.
OpportunityStatus int32 Stato dell'opportunità filters on the platform, writable Status: 1=Open, 2=Closed won, 3=Closed lost.
OpportunityType int16 Tipo di opportunità filters on the platform, writable Code of Opportunity Type.
OpportunityTypeDescription varchar2(240) 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).
OwnerFullName varchar2(240) 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.
ProjectCode varchar2(20) Codice del progetto filters on the platform, writable Code of Project.
ProjectDescription varchar2(60) 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.
ReasonCode guid Codice motivo filters on the platform, writable Indicates the reason why the opportunity was lost.
ReasonCodeDescription 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.
ResellerCode varchar2(18) Codice rivenditore filters on the platform, writable Code of the Reseller.
ResellerName varchar2(50) Nome del rivenditore filters on the platform, writable Name of the Reseller.
SalesType guid Tipo di vendita filters on the platform, writable Reference to Sales type.
SalesTypeDescription varchar2(240) Tipo di vendita Descrizione filters on the platform, writable Description of SalesType.

Chiavi

Key Column Si riferisce a Kind Description
OpportunitiesRead_Account_Accounts_fk Account Accounts.ID Key
OpportunitiesRead_Accountant_Accounts_fk Accountant Accounts.ID Key
OpportunitiesRead_Creator_Users_fk Creator Users.UserID Key
OpportunitiesRead_Currency_Currencies_fk Currency Currencies.Code Key
OpportunitiesRead_LeadSource_LeadSources_fk LeadSource LeadSources.ID Key
OpportunitiesRead_Modifier_Users_fk Modifier Users.UserID Key
OpportunitiesRead_OpportunityStage_OpportunityStages_fk OpportunityStage OpportunityStages.ID Key
OpportunitiesRead_Owner_Users_fk Owner Users.UserID Key
OpportunitiesRead_Project_Projects_fk Project Projects.ID Key
OpportunitiesRead_ReasonCode_ReasonCodes_fk ReasonCode ReasonCodes.ID Key
OpportunitiesRead_Reseller_Accounts_fk Reseller Accounts.ID Key
OpportunitiesRead_SalesType_SalesTypes_fk SalesType SalesTypes.ID Key

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: