OpportunitiesRead: Exact Online Opportunities (Read-only)
read only per partition REST
- Catálogo:
ExactOnlineREST - Esquema:
CRM - Llaves Primarias:
ID - Label: Opportunities (Read-only)
Los datos de esta tabla están divididos por el valor de la columna Division.
Solo puede recuperar datos.
Fuente de la API
- Punto final:
/api/v1/{division}/read/crm/Opportunities - Metadatos:
/api/v1/{division}/read/crm/$metadata
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 5 |
| Número de filas escaneadas por minuto | 7,200 |
| Número de filas de queries puntuales por minuto | 300 |
| Escribir filas por minuto | 300 |
El resultado se puede almacenar en la Caché del cliente.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla OpportunitiesRead. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Account |
guid |
Account | filters on the platform, writable | Lead to which the opportunity applies. | |
Account |
varchar2 |
Código de la Cuenta | filters on the platform, writable | Code of Account. | |
Account |
varchar2 |
Nombre de la Cuenta | filters on the platform, writable | Name of account. | |
Accountant |
guid |
Accountant | filters on the platform, writable | Accountant linked to the opportunity. | |
Accountant |
varchar2 |
Código de contabilidad | filters on the platform, writable | Code of the Accountant. | |
Accountant |
varchar2 |
Nombre del contable | filters on the platform, writable | Name of the Accountant. | |
Action |
datetime |
Fecha de la Acción | filters on the platform, writable | Indicates the date before/on the NextAction is supposed to be done. | |
Amount |
double |
Importe División Moneda | filters on the platform, writable | Amount in the default currency of the company.AmountDC = AmountFC * RateFC. | |
Amount |
double |
Cantidad Moneda Extranjera | 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. | |
Campaign |
varchar2 |
Descripción de la campaña | filters on the platform, writable | Description of Campaign. | |
Channel |
int16 |
Channel | filters on the platform, writable | Reference to the channel opportunity is related to. | |
Channel |
varchar2 |
Descripción del canal | filters on the platform, writable | Description of Channel. | |
Close |
datetime |
Fecha de cierre | filters on the platform, writable | The date when the opportunity is expected to be closed. | |
Contact |
guid |
Contact | filters on the platform, writable | ||
Contact |
varchar2 |
Nombre y apellidos de contacto | filtros de la plataforma | ||
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Creado | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nombre Completo del Creador | filters on the platform, writable | Name of the creator. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | Currency code. | |
Custom |
varchar2 |
Campo personalizado | filtros de la plataforma | ||
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Número de la Cámara de Comercio de la División | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Número IBAN de la división | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
División: Nombre de la empresa | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Número de la división RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Número de IVA de la división | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Número de identificación fiscal de la división en materia de impuestos sobre los salarios | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etiqueta de división | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nombre de la Adminisración | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nombre del titular de la suscripción | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Número de titular de la suscripción | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nombre abreviado de la división | writable | Short name of the Exact Online division. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Lead |
guid |
Fuente de Contacto | filters on the platform, writable | The source of the lead/opportunity. | |
Lead |
varchar2 |
Descripción de la fuente de clientes potenciales | filters on the platform, writable | Description of LeadSource. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificado (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nombre completo modificado | filters on the platform, writable | Name of modifier. | |
Name |
varchar2 |
Name | filters on the platform, writable | Name of the opportunity. | |
Next |
varchar2 |
Próxima Acción | 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 | filtros de la plataforma | ||
Opportunity |
int16 |
itgen_eol_opportunitydepartmentcode | filters on the platform, writable | ||
Opportunity |
varchar2 |
itgen_eol_opportunitydepartmentdescription | filters on the platform, writable | ||
Opportunity |
guid |
Etapa de Oportunidad | filters on the platform, writable | The stage of the opportunity.This is a list defined by the user. | |
Opportunity |
varchar2 |
Descripción de la etapa de oportunidad | filters on the platform, writable | Description of OpportunityStage. | |
Opportunity |
int32 |
Estado de la Oportunidad | filters on the platform, writable | Status: 1=Open, 2=Closed won, 3=Closed lost. | |
Opportunity |
int16 |
Tipo de oportunidad | filters on the platform, writable | Code of Opportunity Type. | |
Opportunity |
varchar2 |
Tipo de oportunidad: Descripción | 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). | |
Owner |
varchar2 |
Nombre y apellidos del propietario | 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. | |
Project |
varchar2 |
Código de Proyecto | filters on the platform, writable | Code of Project. | |
Project |
varchar2 |
Descripción del Proyecto | filters on the platform, writable | Description of Project. | |
RateFC |
double |
Tasa de Moneda Extranjera | filters on the platform, writable | Exchange rate from original to division currency. | |
Reason |
guid |
Código de Motivo | filters on the platform, writable | Indicates the reason why the opportunity was lost. | |
Reason |
varchar2 |
Código de motivo Descripción | filters on the platform, writable | Description of ReasonCode. | |
Reseller |
guid |
Reseller | filters on the platform, writable | Reseller linked to the opportunity. | |
Reseller |
varchar2 |
Código del Revendedor | filters on the platform, writable | Code of the Reseller. | |
Reseller |
varchar2 |
Nombre del Revendedor | filters on the platform, writable | Name of the Reseller. | |
Sales |
guid |
Tipo de Ventas | filters on the platform, writable | Reference to Sales type. | |
Sales |
varchar2 |
Tipo de venta: Descripción | filters on the platform, writable | Description of SalesType. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Opportunities |
Account |
Accounts.ID |
Key | |
Opportunities |
Accountant |
Accounts.ID |
Key | |
Opportunities |
Creator |
Users. |
Key | |
Opportunities |
Currency |
Currencies.Code |
Key | |
Opportunities |
Lead |
LeadSources.ID |
Key | |
Opportunities |
Modifier |
Users. |
Key | |
Opportunities |
Opportunity |
OpportunityStages.ID |
Key | |
Opportunities |
Owner |
Users. |
Key | |
Opportunities |
Project |
Projects.ID |
Key | |
Opportunities |
Reason |
ReasonCodes.ID |
Key | |
Opportunities |
Reseller |
Accounts.ID |
Key | |
Opportunities |
Sales |
SalesTypes.ID |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: