dc_incoming_messages: Data Cache Incoming Messages
read only
- Catalogue :
Cache - Schéma :
Invantive - Clés primaires :
ime_id - Label: Incoming Messages
Trickle loading events received from Customer Service for seeding new tables on basis of deltas.
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table dc_incoming_messages sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | 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 |
Identifiant du client de l'Application | ID client OAuth de l'application. | ||
ime_ |
varchar2 |
Partition | Unique textual identifier of the partition within the data container. | ||
ime_ |
varchar2 |
Créé dans | 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 |
Crée par | Qui a établi ce record ? | ||
ime_ |
varchar2 |
Clé de message du Customer Service | Customer Service Message Key. | ||
ime_ |
decimal |
Code de référence du Customer Service | Customer Service ID. | ||
ime_ |
varchar2 |
ID du conteneur de données | Unique textual identifier of the data container. | ||
ime_ |
datetime |
Créé le | The system time in UTC at which the record was created.This value will never change after creation of the record. | ||
ime_ |
datetime |
Date de téléchargement | Date/time at which the message was downloaded from Customer Service. | ||
ime_ |
datetime |
Date de transmission | Moment at which the message was processed. | ||
ime_ |
datetime |
Mise à jour à | The system time in UTC at which the record was last updated.This value will change for every mutation of the record. | ||
ime_ |
datetime |
Date de l'événement | Occurrence at the originating server (UTC). | ||
ime_ |
datetime |
Date de l'événement - Heure locale du serveur | Occurrence at the originating server (server local time). | ||
ime_ |
datetime |
Date de réception | 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 |
Adresse IP de l'expéditeur externe | Internet-side IP-address of the message sender. | ||
ime_ |
varchar2 |
IUID | Invantive User ID.A physical person can have multiple IUIDs. | ||
ime_ |
varchar2 |
Code du contrat de licence | Code of the Invantive license contract for which the message was registered. | ||
ime_ |
varchar2 |
Clé de message | A unique ID of the message as presented by the sender. | ||
ime_ |
varchar2 |
Mis à jour dans | 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 |
Mise à jour par | 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 |
Entité objet | Name of the object entity in the source system. | ||
ime_ |
varchar2 |
Clé d'objet | Unique identifier of the object entity in the source system. | ||
ime_ |
varchar2 |
URL de l'objet | Browser URL to display the object in the source system. | ||
ime_ |
varchar2 |
Groupe de système d'origine | 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 |
Référence système originale | Référence permettant d'identifier l'enregistrement dans le système d'où il provient. | ||
ime_ |
varchar2 |
Nom du fournisseur | Name of the Invantive connector for which the message was received. | ||
ime_ |
varchar2 |
URL de réception | URL on which the request was received including query string. | ||
ime_ |
varchar2 |
Session Créé | The ID of the session which created the record.This value will not change after insert. | ||
ime_ |
varchar2 |
Session ID | Unique ID of the Invantive session that registered the message. | ||
ime_ |
varchar2 |
Session mise à jour | L'identifiant de la session qui a effectué la dernière mise à jour de l'enregistrement. | ||
ime_ |
varchar2 |
Entité de sous-objet | Sub-object, such as line with header. | ||
ime_ |
varchar2 |
Clé de sous-objet | Unique identifier of the sub-object entity in the source system. | ||
ime_ |
varchar2 |
Nom complet et qualifié de la table | Full name of the target table. | ||
ime_ |
varchar2 |
Texte de la charge utile | Full contents of the payload received by a HTTP POST. | ||
ime_ |
varchar2 |
Transaction créée | The ID of the transaction which created the record. | ||
ime_ |
varchar2 |
Transaction mise à jour | The ID of the transaction which last updated the record. | ||
ime_ |
varchar2 |
Type | Currently always 'WEBHOOK'. | ||
ime_ |
varchar2 |
Verbe HTTP | HTTP verb used to register the message. |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :