dc_incoming_messages: Data Cache Incoming Messages
read only
- Catálogo:
Cache - Esquema:
Invantive - Llaves Primarias:
ime_id - Label: Incoming Messages
Trickle loading events received from Customer Service for seeding new tables on basis of deltas.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla dc_incoming_messages. 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 |
|---|---|---|---|---|---|
ime_ |
char |
Action | Code of triggering action in source system where 'U' stands for 'Update', 'D' for 'Delete' and 'I' for 'Insert'. | ||
ime_ |
varchar2 |
ID de cliente de la aplicación | ID de cliente OAuth de la aplicación. | ||
ime_ |
varchar2 |
Partition | Unique textual identifier of the partition within the data container. | ||
ime_ |
varchar2 |
Creado en | The code of the function in the modules table from within which the user created the record.This value will never change after creation of the record. | ||
ime_ |
varchar2 |
Creado por | Quién creo el registro. | ||
ime_ |
varchar2 |
Clave de mensaje de Customer Service | Customer Service Message Key. | ||
ime_ |
decimal |
Clave de referencia de Customer Service | Customer Service ID. | ||
ime_ |
varchar2 |
ID del Contenedor de Datos | Unique textual identifier of the data container. | ||
ime_ |
datetime |
Creado en | The system time in UTC at which the record was created.This value will never change after creation of the record. | ||
ime_ |
datetime |
Fecha de descarga | Date/time at which the message was downloaded from Customer Service. | ||
ime_ |
datetime |
Fecha de reenvío | Moment at which the message was processed. | ||
ime_ |
datetime |
Actualizado en | The system time in UTC at which the record was last updated.This value will change for every mutation of the record. | ||
ime_ |
datetime |
Fecha en que ocurrió | Occurrence at the originating server (UTC). | ||
ime_ |
datetime |
Fecha en que ocurrió Hora local del servidor | Occurrence at the originating server (server local time). | ||
ime_ |
datetime |
Fecha de recepción | Receipt moment at Customer Service. | ||
ime_ |
varchar2 |
Description | Description of the event in human-readable language. | ||
ime_ |
char |
Forwarded | Whether the message was processed. | ||
ime_id |
decimal |
ID | Unique identifier. | ||
ime_ |
varchar2 |
IIID | Invantive Installation ID. | ||
ime_ |
varchar2 |
Dirección IP: remitente externo | Internet-side IP-address of the message sender. | ||
ime_ |
varchar2 |
IUID | Invantive User ID.A physical person can have multiple IUIDs. | ||
ime_ |
varchar2 |
Código del Contrato de Licencia | Code of the Invantive license contract for which the message was registered. | ||
ime_ |
varchar2 |
Clave de Mensaje | A unique ID of the message as presented by the sender. | ||
ime_ |
varchar2 |
Actualizado en | The code of the function in the modules table from within which the user last updated the record.This value will change for every mutation of the record. | ||
ime_ |
varchar2 |
Actualizado por | The name of the user in the users table whom last updated the record.This value will change for every update of the record. | ||
ime_ |
varchar2 |
Entidad Objeto | Name of the object entity in the source system. | ||
ime_ |
varchar2 |
Clave de Objeto | Unique identifier of the object entity in the source system. | ||
ime_ |
varchar2 |
URL del Objeto | Browser URL to display the object in the source system. | ||
ime_ |
varchar2 |
Grupo del Sistema Original | Reference for identifying the group of records on the system from which it originated.It is commonly used to group records for later validation in an application control. | ||
ime_ |
varchar2 |
Referencia del Sistema Original | Referencia para identificar el registro en el sistema del que se originó. | ||
ime_ |
varchar2 |
Nombre del Proveedor | Name of the Invantive connector for which the message was received. | ||
ime_ |
varchar2 |
URL de recepción | URL on which the request was received including query string. | ||
ime_ |
varchar2 |
Sesión Creada | The ID of the session which created the record.This value will not change after insert. | ||
ime_ |
varchar2 |
Sesión-ID | Unique ID of the Invantive session that registered the message. | ||
ime_ |
varchar2 |
Sesión Actualizada | La identificación de la sesión que actualizó el registro por última vez. | ||
ime_ |
varchar2 |
Entidad del subobjeto | Sub-object, such as line with header. | ||
ime_ |
varchar2 |
Clave de subobjeto | Unique identifier of the sub-object entity in the source system. | ||
ime_ |
varchar2 |
Nombre completo de la tabla cualificada | Full name of the target table. | ||
ime_ |
varchar2 |
Texto de la carga útil | Full contents of the payload received by a HTTP POST. | ||
ime_ |
varchar2 |
Transacción Creada | The ID of the transaction which created the record. | ||
ime_ |
varchar2 |
Transacción Actualizada | The ID of the transaction which last updated the record. | ||
ime_ |
varchar2 |
Type | Currently always 'WEBHOOK'. | ||
ime_ |
varchar2 |
Verbo HTTP | HTTP verb used to register the message. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: