invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

OpportunitiesRead: Exact Online Opportunities (Read-only)

read only per partition REST

  • Catalogue : ExactOnlineREST
  • Schéma : CRM
  • Clés primaires : ID
  • Label: Opportunities (Read-only)

Les données de cette table sont partitionnées en fonction de la valeur de la colonne Division.

Permet uniquement de récupérer des données.

Source de l'API

  • Point de terminaison : /api/v1/{division}/read/crm/Opportunities
  • Métadonnées : /api/v1/{division}/read/crm/$metadata

Caractéristiques de performance

Characteristic Value
Latence moyenne d'accès (ms) 5
Nombre de lignes par minute en mode de balayage complet 7,200
Nombre de lignes de requêtes ponctuelles par minute 300
Nombre d'enregistrements écrits par minute 300

Le résultat peut être mis en cache côté client.

Colonnes de table

Les colonnes de la table OpportunitiesRead sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
Account guid Account filters on the platform, writable Lead to which the opportunity applies.
AccountCode varchar2(18) Code du compte filters on the platform, writable Code of Account.
AccountName varchar2(50) Nom du compte filters on the platform, writable Name of account.
Accountant guid Accountant filters on the platform, writable Accountant linked to the opportunity.
AccountantCode varchar2 Code comptable filters on the platform, writable Code of the Accountant.
AccountantName varchar2(50) Nom du comptable filters on the platform, writable Name of the Accountant.
ActionDate datetime Date de l'action filters on the platform, writable Indicates the date before/on the NextAction is supposed to be done.
AmountDC double Montant Division Devise filters on the platform, writable Amount in the default currency of the company.AmountDC = AmountFC * RateFC.
AmountFC double Montant en devise étrangère 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 Description de la campagne 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 Description du canal filters on the platform, writable Description of Channel.
CloseDate datetime Date de clôture 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 Nom complet de la personne à contacter filtres disponibles sur la plateforme
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Créé writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Nom complet de l'auteur filters on the platform, writable Name of the creator.
Currency varchar2(30) Currency filters on the platform, writable Currency code.
CustomField varchar2 Champ personnalisé filtres disponibles sur la plateforme
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Numéro d'enregistrement à la Chambre de commerce de la division writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Numéro IBAN de la division writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Division - Nom de l'entreprise writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Numéro de division RSIN writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Numéro de TVA de la division writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Numéro d'identification fiscale de la division writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Étiquette de division writable Label of the Exact Online division.
DivisionName varchar2(50) Nom de l'administration writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Nom du titulaire de l'abonnement writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Numéro d'abonné writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Nom abrégé de la division writable Short name of the Exact Online division.
ID guid ID filters on the platform, writable Primary key.
LeadSource guid Source Principale filters on the platform, writable The source of the lead/opportunity.
LeadSourceDescription varchar2 Description de la source de prospects filters on the platform, writable Description of LeadSource.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modifié (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Nom complet modifié filters on the platform, writable Name of modifier.
Name varchar2 Name filters on the platform, writable Name of the opportunity.
NextAction varchar2 Prochaine action 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 filtres disponibles sur la plateforme
OpportunityDepartmentCode int16 itgen_eol_opportunitydepartmentcode filters on the platform, writable
OpportunityDepartmentDescription varchar2 itgen_eol_opportunitydepartmentdescription filters on the platform, writable
OpportunityStage guid Étape d'opportunité filters on the platform, writable The stage of the opportunity.This is a list defined by the user.
OpportunityStageDescription varchar2 Description de l'étape « Opportunité » filters on the platform, writable Description of OpportunityStage.
OpportunityStatus int32 Statut de l'opportunité filters on the platform, writable Status: 1=Open, 2=Closed won, 3=Closed lost.
OpportunityType int16 Type d'opportunité filters on the platform, writable Code of Opportunity Type.
OpportunityTypeDescription varchar2(240) Description du type d'opportunité 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) Nom complet du propriétaire 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) Code de projet filters on the platform, writable Code of Project.
ProjectDescription varchar2(60) Description du projet filters on the platform, writable Description of Project.
RateFC double Cours des devises étrangères filters on the platform, writable Exchange rate from original to division currency.
ReasonCode guid Code de motif filters on the platform, writable Indicates the reason why the opportunity was lost.
ReasonCodeDescription varchar2 Code de motif Description filters on the platform, writable Description of ReasonCode.
Reseller guid Reseller filters on the platform, writable Reseller linked to the opportunity.
ResellerCode varchar2(18) Code revendeur filters on the platform, writable Code of the Reseller.
ResellerName varchar2(50) Nom du revendeur filters on the platform, writable Name of the Reseller.
SalesType guid Type de vente filters on the platform, writable Reference to Sales type.
SalesTypeDescription varchar2(240) Type de vente - Description filters on the platform, writable Description of SalesType.

Clés

Key Column Se réfère à 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

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :