CustomerCooperations: Exact Online Customer Cooperations
insert update delete REST
- Catálogo:
ExactOnlineREST - Esquema:
Workflow - Llaves Primarias:
ID - Label: Customer Cooperations
Permite recuperar y modificar datos utilizando insert, update y delete.
Fuente de la API
- Punto final:
/api/v1/beta/{division}/workflow/CustomerCooperations - Metadatos:
/api/v1/beta/{division}/workflow/$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 CustomerCooperations. 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 | Exact Online customer ID of the accountant. | |
Account |
varchar2 |
Código de la Cuenta | writable | ||
Account |
varchar2 |
Nombre de la Cuenta | writable | Name of account. | |
Amount |
double |
Amount | writable | ||
Amount |
double |
Importe real | writable | ||
Amount |
double |
Cantidad Moneda Extranjera | writable | ||
Amount |
double |
Importe en moneda extranjera Real | writable | ||
Approved |
datetime |
Approved | writable | ||
Approver |
guid |
Approver | writable | ||
Approver |
varchar2 |
Nombre Completo del Aprobador | writable | ||
Buildup |
char |
Build-up | writable | ||
Campaign |
guid |
Campaign | writable | ||
Contact |
guid |
Contact | writable | ||
Contact |
varchar2 |
Nombre y apellidos de contacto | writable | ||
Context |
guid |
ID de contexto | filters on the platform, writable | ||
Context |
int32 |
Tipo de contexto | filters on the platform, writable | ||
Created |
datetime |
Created | writable | Creation date. | |
Created |
datetime |
Creado | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Nombre Completo del Creador | writable | Name of creator. | |
Currency |
varchar2 |
Currency | writable | Code of Currency. | |
Currency |
varchar2 |
itgen_eol_currencyactual | writable | Code of actual currency. | |
Days |
double |
itgen_eol_days | writable | ||
Days |
double |
itgen_eol_daysactual | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | ||
Division |
int32 |
Division | writable | ||
Division |
int64 |
itgen_eol_divisionhid | filters on the platform, writable | ||
Division |
varchar2 |
Nombre de la Adminisración | writable | Name of the division.Name is derived from the description and may be inaccurate. | |
Document |
guid |
Document | writable | ||
Employee |
guid |
Employee | writable | ||
End |
datetime |
Fecha Final | writable | ||
End |
datetime |
Fecha de finalización real | writable | ||
Error |
int32 |
ID del registro de errores | writable | ||
Financial |
guid |
Asiento contable | writable | ||
Free |
char |
Campo booleano libre n.º 1 | writable | ||
Free |
char |
Campo booleano libre n.º 2 | writable | ||
Free |
char |
Campo booleano libre n.º 3 | writable | ||
Free |
char |
Campo booleano libre n.º 4 | writable | ||
Free |
char |
Campo booleano libre n.º 5 | writable | ||
Free |
datetime |
Campo de fecha libre n.º 1 | writable | ||
Free |
datetime |
Campo de fecha libre n.º 2 | writable | ||
Free |
datetime |
Campo de fecha libre n.º 3 | writable | ||
Free |
datetime |
Campo de fecha libre n.º 4 | writable | ||
Free |
datetime |
Campo de fecha libre n.º 5 | writable | ||
Free |
guid |
Campo GUID libre 1 | writable | ||
Free |
guid |
Campo GUID libre 2 | writable | ||
Free |
guid |
Campo GUID libre 3 | writable | ||
Free |
guid |
Campo GUID libre 4 | writable | ||
Free |
guid |
Campo GUID libre 5 | writable | ||
Free |
guid |
Campo GUID libre 6 | writable | ||
Free |
guid |
Campo GUID libre 7 | writable | ||
Free |
guid |
Campo GUID libre 8 | writable | ||
Free |
guid |
Campo GUID libre 9 | writable | ||
Free |
guid |
Campo GUID libre 10 | writable | ||
Free |
int32 |
Campo de números enteros libre 1 | writable | ||
Free |
int32 |
Campo de números enteros libre 2 | writable | ||
Free |
int32 |
Campo de números enteros libre 3 | writable | ||
Free |
int32 |
Campo de números enteros libre 4 | writable | ||
Free |
int32 |
Campo de números enteros libre 5 | writable | ||
Free |
double |
Campo de número libre n.º 1 | writable | ||
Free |
double |
Campo de número libre n.º 2 | writable | ||
Free |
double |
Campo de número libre n.º 3 | writable | ||
Free |
double |
Campo de número libre n.º 4 | writable | ||
Free |
double |
Campo de número libre n.º 5 | writable | ||
Free |
varchar2 |
Campo de texto libre n.º 1 | writable | ||
Free |
varchar2 |
Campo de texto libre n.º 2 | writable | ||
Free |
varchar2 |
Campo de texto libre n.º 3 | writable | ||
Free |
varchar2 |
Campo de texto libre n.º 4 | writable | ||
Free |
varchar2 |
Campo de texto libre n.º 5 | writable | ||
Free |
varchar2 |
Campo de texto libre n.º 6 | writable | ||
Free |
varchar2 |
Campo de texto libre n.º 7 | writable | ||
Free |
varchar2 |
Campo de texto libre n.º 8 | writable | ||
Free |
varchar2 |
Campo de texto libre n.º 9 | writable | ||
Free |
varchar2 |
Campo de texto libre n.º 10 | writable | ||
Free |
varchar2 |
Campo de Texto Libre 11 | writable | ||
Free |
varchar2 |
Campo de Texto Libre 12 | writable | ||
Free |
varchar2 |
itgen_eol_freetextfield_13 | writable | ||
Free |
varchar2 |
Campo de Texto Libre 14 | writable | ||
Free |
varchar2 |
Campo de Texto Libre 15 | writable | ||
HID |
int32 |
HID | writable | ||
Help |
guid |
Archivo de Ayuda | writable | ||
Help |
guid |
Elemento de ayuda | writable | ||
Hours |
double |
Hours | writable | ||
Hours |
double |
Horas reales | writable | ||
ID |
guid |
ID | filters on the platform, writable | ||
In |
char |
En el flujo de trabajo | writable | ||
IsRead |
char |
Está leído | writable | ||
Item |
varchar2 |
Código de artículo 1 | writable | ||
Item |
varchar2 |
Descripción del artículo 1 | writable | Description of Item. | |
Item |
guid |
N.º de artículo: 1 | writable | ||
Item |
guid |
N.º de artículo: 2 | writable | ||
Item_1 |
guid |
Punto 1 | writable | ||
Item_2 |
guid |
Punto 2 | writable | ||
Lead |
guid |
Lead | writable | ||
Location |
varchar2 |
Location | writable | ||
Modified |
datetime |
Modified | writable | Last modified date. | |
Modified |
datetime |
Modificado (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Multiple |
varchar2 |
Columna de entradas múltiples | writable | ||
Multiple |
guid |
Identificador de entradas múltiples | writable | ||
Opportunity |
guid |
Opportunity | writable | ||
Opportunity |
varchar2 |
itgen_eol_opportunitydescription | writable | ||
Payroll |
guid |
Componente de la Nómina | writable | ||
Payroll |
int32 |
Período de la Nómina | writable | ||
Payroll |
int32 |
Año de la Nómina | writable | ||
Priority |
int32 |
Priority | writable | ||
Processed |
datetime |
Processed | writable | ||
Processor |
guid |
Processor | writable | ||
Project |
guid |
Project | writable | ||
Project |
varchar2 |
Descripción del Proyecto | writable | ||
Quantity |
double |
Cantidad real: 1 | writable | ||
Quantity |
double |
Cantidad real: 2 | writable | ||
Quantity_ |
double |
Cantidad: 1 | writable | ||
Quantity_ |
double |
Cantidad: 2 | writable | ||
Realized |
datetime |
Realized | writable | ||
Realizer |
guid |
Realizer | writable | ||
Reminder |
int16 |
Reminder | writable | ||
Request |
varchar2 |
Solicitar Comentarios | filters on the platform, writable | ||
Resubmit |
int16 |
Estado de la nueva presentación | writable | ||
Security |
int32 |
Nivel de Seguridad | writable | ||
Start |
datetime |
Fecha Inicial | filters on the platform, writable | ||
Start |
datetime |
Fecha de inicio real | writable | ||
Status |
int16 |
Status | filters on the platform, writable | ||
Status |
datetime |
Se ha modificado el estado | writable | ||
Sub |
int32 |
Estado secundario | writable | ||
Subscription |
varchar2 |
Nombre del Propietario de la Suscripción | writable | Name of the subscription owner.Name is derived from the description and may be inaccurate. | |
Task |
int32 |
Subtipo de tarea | writable | ||
Type |
guid |
Type | filters on the platform, writable | ||
Type |
varchar2 |
Descripción del Tipo | writable | ||
Type |
int32 |
Introduce el ID de persona | filters on the platform, writable | ||
User |
varchar2 |
Nombre completo del usuario | writable | ||
User |
int32 |
ID de usuario humano | writable | ||
UserID |
guid |
Identificación de Usuario | writable | ||
Workflow |
varchar2 |
Comentarios sobre el flujo de trabajo | writable | ||
XBRL |
guid |
Documento XBRL | writable | ||
Your |
varchar2 |
Su Referencia | filters on the platform, writable | Your reference. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Customer |
Account |
Accounts.ID |
Key | |
Customer |
Creator |
Users. |
Key | |
Customer |
Currency |
Currencies.Code |
Key | |
Customer |
Modifier |
Users. |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: