invantive documentation
Forum di supporto InvantiveAccedi / Registrati

bi_dossieritems_salesforecast: AFAS Profit itgen_aoe_bi_dossieritems_salesforecast

read only REST

  • Catalogo: AfasOnline
  • Schema: GetConnector
  • Etichetta: itgen_aoe_bi_dossieritems_salesforecast

È possibile solo recuperare i dati.

Bi_Dossieritems_SalesForecast

Codice sorgente dell'API

  • Punto finale: /connectors/Bi_Dossieritems_SalesForecast
  • Metadati: metainfo/get/Bi_Dossieritems_SalesForecast

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 353
Righe di scansione completa al minuto 65,100
Numero di righe di Query al minuto 169

Il risultato può essere memorizzato nella memoria cache sul client.

Colonne della tabella

Di seguito sono riportate le colonne della tabella bi_dossieritems_salesforecast. 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
sfc_accountmanager_sp int32 Accountmanager SP fetched only when named, SFC_Accountmanager_SP
sfc_afgehandeld char Afgehandeld SFC fetched only when named, SFC_Afgehandeld
sfc_begindatum datetime Begindatum fetched only when named, SFC_Begindatum
sfc_datum_afgehandeld datetime Datum afgehandeld SFC fetched only when named, SFC_Datum_afgehandeld
sfc_direct_contact int32 Direct contact fetched only when named, SFC_Direct_contact
sfc_doelgroep varchar2(50) Doelgroep fetched only when named, SFC_Doelgroep
sfc_dossieritem int32 Dossieritem fetched only when named, SFC_Dossieritem
sfc_einddatum datetime Einddatum fetched only when named, SFC_Einddatum
sfc_id_reacties int32 Id_reacties fetched only when named, SFC_Id_reacties
sfc_indirect_contact int32 Indirect contact fetched only when named, SFC_Indirect_contact
sfc_instuurdatum datetime Instuurdatum fetched only when named, SFC_Instuurdatum
sfc_instuurdatum_reacties datetime Instuurdatum_reacties fetched only when named, SFC_Instuurdatum_reacties
sfc_instuurder_reactie varchar2(80) Instuurder_reactie fetched only when named, SFC_Instuurder_reactie
sfc_klant_forecast_profiel_plaats varchar2(50) Klant_forecast_profiel_plaats fetched only when named, SFC_Klant_forecast_profiel_plaats
sfc_klantforecast_profiel varchar2(255) Klantforecast profiel fetched only when named, SFC_Klantforecast_profiel
sfc_klantforecast_profiel_nr varchar2(15) Klantforecast profiel nr fetched only when named, SFC_Klantforecast_profiel_nr
sfc_klantpiramide_2023 varchar2(50) Klantpiramide 2023 fetched only when named, SFC_Klantpiramide_2023
sfc_klantpiramide_doel_2024 varchar2(50) Klantpiramide doel fetched only when named, SFC_Klantpiramide_doel_2024
sfc_klantstrategie_2024 varchar2(50) Klantstrategie fetched only when named, SFC_Klantstrategie_2024
sfc_klarnt_forecast_profiel_pc varchar2(15) Klarnt_forecast_profiel_pc fetched only when named, SFC_Klarnt_forecast_profiel_pc
sfc_laatst_gewijzigde_veld datetime Laatst gewijzigde veld SFC fetched only when named, SFC_Laatst_gewijzigde_veld
sfc_naam_accountm varchar2(255) Naam accountmanager fetched only when named, SFC_Naam_accountm
sfc_omzet_2023 number Omzet 2023 fetched only when named, SFC_Omzet_2023
sfc_omzet_2024_tot_nu number Omzet 2024 fetched only when named, SFC_Omzet_2024_tot_nu
sfc_omzetpotentieel number Omzetpotentieel fetched only when named, SFC_Omzetpotentieel
sfc_onderbouwing_verwachting varchar2 Onderbouwing verwachting fetched only when named, SFC_Onderbouwing_verwachting
sfc_onderwerp varchar2(255) Onderwerp SFC fetched only when named, SFC_Onderwerp
sfc_reacties_omschr varchar2 Reacties omschr fetched only when named, SFC_Reacties_omschr
sfc_servicepartn_contractlev varchar2(50) Servicepartn/Contractlev fetched only when named, SFC_Servicepartn_Contractlev
sfc_status_wf varchar2(100) Status WF SFC fetched only when named, SFC_Status_WF
sfc_verantw varchar2(80) Verantwoordelijk fetched only when named, SFC_Verantw
sfc_verwachte_omzet_2024 number Verwachte omzet 2024 fetched only when named, SFC_Verwachte_omzet_2024
sfc_voortgang_salesforecast varchar2(100) Voortgang salesforecast fetched only when named, SFC_Voortgang_salesforecast