Opportunities: Exact Online Verkoopkansen |
Catalogus: ExactOnlineREST
Schema: CRM
Primaire Sleutels: ID
Label: Verkoopkansen
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel Opportunities worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
Account |
guid |
Account |
☐ |
Lead to which the opportunity applies. |
Accountant |
guid |
Accountant |
☐ |
Accountant linked to the opportunity. |
AccountantCode |
string |
Accountantcode |
☐ |
Code of the Accountant. |
AccountantName |
string(50) |
Accountant Naam |
☐ |
Name of the Accountant. |
AccountCode |
string(18) |
Account Code |
☐ |
Code of Account. |
AccountName |
string(50) |
Accountnaam |
☐ |
Name of account. |
ActionDate |
datetime |
Actie Datum |
☐ |
Indicates the date before/on the NextAction is supposed to be done. |
AmountDC |
double |
Bedrag Administratie Munteenheid |
☐ |
Amount in the default currency of the company. AmountDC = AmountFC * RateFC. |
AmountDCWeighted |
double |
Gewogen Bedrag Administratiemunteenheid |
☑ |
Opportunity weighted amount in division currency. |
AmountFC |
double |
Bedrag Vreemde Valuta |
☐ |
Amount in the currency of the transaction. |
AmountFCWeighted |
double |
Gewogen Bedrag Vreemde Valuta |
☑ |
Opportunity weighted amount in foreign currency. |
Campaign |
guid |
Campagne |
☐ |
Reference to the campaign opportunity is related to. |
CampaignDescription |
string |
Campagneomschrijving |
☐ |
Description of Campaign. |
Channel |
int16 |
Kanaal |
☐ |
Reference to the channel opportunity is related to. |
ChannelDescription |
string |
Kanaalomschrijving |
☐ |
Description of Channel. |
CloseDate |
datetime |
Datum Gesloten |
☐ |
The date when the opportunity is expected to be closed. |
Contact |
guid |
Contactpersoon |
☐ |
|
ContactFullName |
string |
Contactpersoon Volledige Naam |
☐ |
|
Created |
datetime |
Gemaakt |
☐ |
Creation date. |
CreatedUtc |
datetime |
Aangemaakt (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Aanmaker |
☐ |
User ID of creator. |
CreatorFullName |
string(240) |
Aanmaker Volledige Naam |
☐ |
Name of the creator. |
Currency |
string(30) |
Valuta |
☐ |
Currency code. |
CustomField |
string |
{res:itgen_eol_customfield} |
☐ |
|
Division |
int32 |
Divisie |
☐ |
Division code. |
DivisionCompanyCoCNumber |
string(60) |
Divisie Kamer van Koophandel Nummer |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Divisie IBAN Nummer |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Divisie Bedrijfsnaam |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Divisie RSIN Nummer |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Divisie BTW Nummer |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Divisie Loonbelastingnummer |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Divisie Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administratie Naam |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Naam Abonnementhouder |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Abonnementhoudernummer |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Divisie Korte Naam |
☑ |
Short name of the Exact Online division. |
ID |
guid |
ID |
☑ |
Primary key. |
LeadSource |
guid |
Lead Bron |
☐ |
The source of the lead/opportunity. |
LeadSourceDescription |
string |
Lead Bron Omschrijving |
☐ |
Description of LeadSource. |
Modified |
datetime |
Gewijzigd |
☐ |
Last modified date. |
ModifiedUtc |
datetime |
Gewijzigd (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Wijziger |
☐ |
User ID of modifier. |
ModifierFullName |
string(240) |
Gewijzigd Volledige Naam |
☐ |
Name of modifier. |
Name |
string |
Naam |
☐ |
Name of the opportunity. |
NextAction |
string |
Volgende Actie |
☐ |
Indicates what follow up action is to be undertaken to move the opportunity towards a deal. Is used in combination with ActionDate. |
Notes |
string |
Notities |
☐ |
Notes of the opportunity. |
Number |
int32 |
Number |
☑ |
|
OpportunityDepartmentCode |
int16 |
{res:itgen_eol_opportunitydepartmentcode} |
☐ |
|
OpportunityDepartmentDescription |
string |
{res:itgen_eol_opportunitydepartmentdescription} |
☐ |
|
OpportunityStage |
guid |
Verkoopkans Fase |
☐ |
The stage of the opportunity. This is a list defined by the user. |
OpportunityStageDescription |
string |
Verkoopkans Fase Omschrijving |
☐ |
Description of OpportunityStage. |
OpportunityStatus |
int32 |
Opportunity Status |
☐ |
Status: 1=Open, 2=Closed won, 3=Closed lost. |
OpportunityType |
int16 |
Verkoopkans Type |
☐ |
Code of Opportunity Type. |
OpportunityTypeDescription |
string(240) |
Verkoopkans Type Omschrijving |
☐ |
Description of Opportunity Type. |
Owner |
guid |
Eigenaar |
☐ |
The resource who owns the opportunity and is responsible to close the opportunity (either won or lost). |
OwnerFullName |
string(240) |
Eigenaar Volledige Naam |
☐ |
Name of Owner. |
Probability |
double |
Waarschijnlijkheid |
☐ |
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 |
☐ |
Reference to project. |
ProjectCode |
string(20) |
Projectcode |
☐ |
Code of Project. |
ProjectDescription |
string(60) |
Projectomschrijving |
☐ |
Description of Project. |
RateFC |
double |
Wisselkoers Vreemde Valuta |
☐ |
Exchange rate from original to division currency. |
ReasonCode |
guid |
Redencode |
☐ |
Indicates the reason why the opportunity was lost. |
ReasonCodeDescription |
string |
Redencode Omschrijving |
☐ |
Description of ReasonCode. |
Reseller |
guid |
Wederverkoper |
☐ |
Reseller linked to the opportunity. |
ResellerCode |
string(18) |
Wederverkoper Code |
☐ |
Code of the Reseller. |
ResellerName |
string(50) |
Wederverkoper Naam |
☐ |
Name of the Reseller. |
SalesType |
guid |
Verkoopsoort |
☐ |
Reference to Sales type. |
SalesTypeDescription |
string(240) |
Verkoop Type Omschrijving |
☐ |
Description of SalesType. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455