invantive documentation
Invantive SupportforenAnmelden / Eintragen

HostingOpportunitiesRead: Exact Online Hosting Opportunities

read only per partition 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.

Es können nur Daten abgerufen werden.

API-Quelle

  • Endpunkt: /api/v1/{division}/read/crm/HostingOpportunities
  • Metadaten: /api/v1/{division}/read/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 HostingOpportunitiesRead 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.
AccountCode varchar2 Konto Code filters on the platform, writable Code of Account.
AccountName varchar2 Konto Name filters on the platform, writable Name of Account.
Accountant guid Accountant filters on the platform, writable Accountant linked to the opportunity.
AccountantCode varchar2 Buchhaltercode filters on the platform, writable Code of the Accountant.
AccountantName varchar2 Buchhaltername filters on the platform, writable Name of the Accountant.
ActionDate datetime Aktionsdatum filters on the platform, writable Indicates the date before/on the NextAction is supposed to be done.
AmountDC double Betrag Sparte Währung filters on the platform, writable Amount in the default currency of the company.AmountDC = AmountFC * RateFC.
AmountFC double Summe Fremdwährung filters on the platform, writable Amount in the currency of the transaction.
BackToLeadDevelopment 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.
CampaignDescription 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.
ChannelDescription varchar2 Kanalbeschreibung filters on the platform, writable Description of Channel.
CloseDate 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.
CreatedUtc datetime Angelegt writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2 Ersteller vollständiger Name filters on the platform, writable Name of the creator.
Currency varchar2 Currency filters on the platform, writable Currency code.
CustomerDemandsDescription varchar2 itgen_eol_customerdemandsdescription filters on the platform, writable Description related to customer demand.
DecisionMakingUnitName varchar2 itgen_eol_decisionmakingunitname filters on the platform, writable DMU fields-Unit Name.
DecisionMakingUnitRole varchar2 itgen_eol_decisionmakingunitrole filters on the platform, writable DMU fields- Unit Role.
DecisionTimeframe varchar2 Entscheidungszeitraum filters on the platform, writable Description of the time frame.
DispatchToSales 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.
DivisionCompanyCoCNumber varchar2(60) Nummer der Handelskammer des Bezirks writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Abteilung IBAN-Nummer writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Geschäftsbereich Firmenname writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Abteilung RSIN-Nummer writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Umsatzsteuer-Identifikationsnummer der Abteilung writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Nummer der Lohnsteuerabteilung writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Abteilungsbezeichnung writable Label of the Exact Online division.
DivisionName varchar2(50) Verwaltung Name writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Name des Abonnenten writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Abonnentennummer writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Kurzbezeichnung der Abteilung writable Short name of the Exact Online division.
ID guid ID filters on the platform, writable Primary key.
IsAssociatedPrice int16 Ist der zugehörige Preis filters on the platform, writable Aware of associated prices.
IsCustomerDemandsMeet int16 itgen_eol_iscustomerdemandsmeet filters on the platform, writable Standard product solves customer demands.
LeadDeveloper guid Hauptentwickler filters on the platform, writable Name of the lead developer.
LeadSource guid Lead-Quelle filters on the platform, writable The source of the lead/opportunity.
LeadSourceDescription varchar2 Beschreibung der Lead-Quelle filters on the platform, writable Description of LeadSource.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Geändert (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName 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.
NextAction 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 Filter auf der Plattform
OpportunityDepartmentCode int16 itgen_eol_opportunitydepartmentcode filters on the platform, writable Code of Opportunity Department.
OpportunityDepartmentDescription varchar2 itgen_eol_opportunitydepartmentdescription filters on the platform, writable Description of Opportunity Department.
OpportunityStage guid Verkaufschance Phase filters on the platform, writable The stage of the opportunity.This is a list defined by the user.
OpportunityStageDescription varchar2 Beschreibung der Opportunity-Phase filters on the platform, writable Description of OpportunityStage.
OpportunityStatus int32 Verkaufschance Status filters on the platform, writable Status: 1=Open, 2=Closed won, 3=Closed lost.
OpportunityType int16 Art der Gelegenheit filters on the platform, writable Code of Opportunity Type.
OpportunityTypeDescription 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).
OwnerFullName 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.
ProjectCode varchar2 Projekt filters on the platform, writable Code of Project.
ProjectDescription 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.
ReasonBack varchar2 Grund Zurück filters on the platform, writable Indicate the reason back.
ReasonCode guid Ursachencode filters on the platform, writable Indicates the reason why the opportunity was lost.
ReasonCodeDescription varchar2 Fehlercode Beschreibung filters on the platform, writable Description of ReasonCode.
Reseller guid Reseller filters on the platform, writable Reseller linked to the opportunity.
ResellerCode varchar2 Wiederverkäufer Code filters on the platform, writable Code of the Reseller.
ResellerName varchar2 Wiederverkäufer Name filters on the platform, writable Name of the Reseller.
SalesType guid Verkaufstyp filters on the platform, writable Reference to Sales type.
SalesTypeDescription varchar2 Verkaufsart – Beschreibung filters on the platform, writable Description of SalesType.

Tasten

Key Column Bezieht sich auf Kind Description
HostingOpportunitiesRead_Account_Accounts_fk Account Accounts.ID Key
HostingOpportunitiesRead_Accountant_Accounts_fk Accountant Accounts.ID Key
HostingOpportunitiesRead_Creator_Users_fk Creator Users.UserID Key
HostingOpportunitiesRead_Currency_Currencies_fk Currency Currencies.Code Key
HostingOpportunitiesRead_LeadSource_LeadSources_fk LeadSource LeadSources.ID Key
HostingOpportunitiesRead_Modifier_Users_fk Modifier Users.UserID Key
HostingOpportunitiesRead_OpportunityStage_OpportunityStages_fk OpportunityStage OpportunityStages.ID Key
HostingOpportunitiesRead_Owner_Users_fk Owner Users.UserID Key
HostingOpportunitiesRead_Project_Projects_fk Project Projects.ID Key
HostingOpportunitiesRead_ReasonCode_ReasonCodes_fk ReasonCode ReasonCodes.ID Key
HostingOpportunitiesRead_Reseller_Accounts_fk Reseller Accounts.ID Key
HostingOpportunitiesRead_SalesType_SalesTypes_fk SalesType 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: