HostingOpportunities: Exact Online Hosting Verkoopkansen |
Catalogus: ExactOnlineREST
Schema: CRM
Primaire Sleutels: ID
Label: Hosting 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 HostingOpportunities 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 |
Accountant Naam |
☐ |
Name of the Accountant. |
AccountCode |
string |
Account Code |
☐ |
Code of Account. |
AccountName |
string |
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. |
AmountFC |
double |
Bedrag Vreemde Valuta |
☐ |
Amount in the currency of the transaction. |
BackToLeadDevelopment |
datetime |
{res:itgen_eol_backtoleaddevelopment} |
☐ |
Indicate the date back to lead development. |
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. |
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 |
Valuta |
☐ |
Currency code. |
CustomerDemandsDescription |
string |
{res:itgen_eol_customerdemandsdescription} |
☐ |
Description related to customer demand. |
DecisionMakingUnitName |
string |
{res:itgen_eol_decisionmakingunitname} |
☐ |
DMU fields-Unit Name. |
DecisionMakingUnitRole |
string |
{res:itgen_eol_decisionmakingunitrole} |
☐ |
DMU fields- Unit Role. |
DecisionTimeframe |
string |
Besluittijdschema |
☐ |
Description of the time frame. |
DispatchToSales |
datetime |
{res:itgen_eol_dispatchtosales} |
☐ |
Indicate the date when dispatch to sales. |
Division |
int32 |
Divisie ID |
☑ |
Unique number of the Exact Online division. |
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. |
IsAssociatedPrice |
int16 |
Is Gekoppelde Prijs |
☐ |
Aware of associated prices. |
IsCustomerDemandsMeet |
int16 |
{res:itgen_eol_iscustomerdemandsmeet} |
☐ |
Standard product solves customer demands. |
LeadDeveloper |
guid |
Hoofdontwikkelaar |
☐ |
Name of the lead developer. |
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 the last 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} |
☐ |
Code of Opportunity Department. |
OpportunityDepartmentDescription |
string |
{res:itgen_eol_opportunitydepartmentdescription} |
☐ |
Description of Opportunity Department. |
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 |
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 |
Projectcode |
☐ |
Code of Project. |
ProjectDescription |
string |
Projectomschrijving |
☐ |
Description of Project. |
RateFC |
double |
Wisselkoers Vreemde Valuta |
☐ |
Exchange rate from original to division currency. |
ReasonBack |
string |
Reden Terug |
☐ |
Indicate the reason back. |
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 |
Wederverkoper Code |
☐ |
Code of the Reseller. |
ResellerName |
string |
Wederverkoper Naam |
☐ |
Name of the Reseller. |
SalesType |
guid |
Verkoopsoort |
☐ |
Reference to Sales type. |
SalesTypeDescription |
string |
Verkoop Type Omschrijving |
☐ |
Description of SalesType. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455