dc_my_incoming_messages: Data Cache My Incoming Messages
read only
- Catalogue :
Cache - Schéma :
Invantive - Clés primaires :
mie_id - Label: My Incoming Messages
Events received from Customer Service for custom business processes.
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table dc_my_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 |
|---|---|---|---|---|---|
mie_ |
char |
Action | Code of triggering action in source system where 'U' stands for 'Update', 'D' for 'Delete' and 'I' for 'Insert'. | ||
mie_ |
varchar2 |
Identifiant du client de l'Application | ID client OAuth de l'application. | ||
mie_ |
varchar2 |
Partition | Unique textual identifier of the partition within the data container. | ||
mie_ |
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. | ||
mie_ |
varchar2 |
Crée par | Qui a établi ce record ? | ||
mie_ |
varchar2 |
Clé de message du Customer Service | Customer Service Message Key. | ||
mie_ |
decimal |
Code de référence du Customer Service | Customer Service ID. | ||
mie_ |
varchar2 |
ID du conteneur de données | Unique textual identifier of the data container. | ||
mie_ |
datetime |
Créé le | The system time in UTC at which the record was created.This value will never change after creation of the record. | ||
mie_ |
datetime |
Date de téléchargement | Date/time at which the message was downloaded from Customer Service. | ||
mie_ |
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. | ||
mie_ |
datetime |
Date de l'événement | Occurrence at the originating server (UTC). | ||
mie_ |
datetime |
Date de l'événement - Heure locale du serveur | Occurrence at the originating server (server local time). | ||
mie_ |
datetime |
Date de réception | Receipt moment at Customer Service. | ||
mie_ |
varchar2 |
Description | Description of the event in human-readable language. | ||
mie_ |
char |
Forwarded | Whether it was processed. | ||
mie_id |
decimal |
ID | Unique identifier. | ||
mie_ |
varchar2 |
IIID | Invantive Installation ID. | ||
mie_ |
varchar2 |
Adresse IP de l'expéditeur externe | Internet-side IP-address of the message sender. | ||
mie_ |
varchar2 |
IUID | Invantive User ID.A physical person can have multiple IUIDs. | ||
mie_ |
varchar2 |
Code du contrat de licence | Code of the Invantive license contract for which the message was registered. | ||
mie_ |
varchar2 |
Clé de message | A unique ID of the message as presented by the sender. | ||
mie_ |
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. | ||
mie_ |
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. | ||
mie_ |
varchar2 |
Entité objet | Name of the object entity in the source system. | ||
mie_ |
varchar2 |
Clé d'objet | Unique identifier of the object entity in the source system. | ||
mie_ |
varchar2 |
URL de l'objet | Browser URL to display the object in the source system. | ||
mie_ |
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. | ||
mie_ |
varchar2 |
Référence système originale | Référence permettant d'identifier l'enregistrement dans le système d'où il provient. | ||
mie_ |
varchar2 |
Nom du fournisseur | Name of the Invantive connector for which the message was received. | ||
mie_ |
varchar2 |
URL de réception | URL on which the request was received including query string. | ||
mie_ |
varchar2 |
Session Créé | The ID of the session which created the record.This value will not change after insert. | ||
mie_ |
varchar2 |
Session ID | Unique ID of the Invantive session that registered the message. | ||
mie_ |
varchar2 |
Session mise à jour | L'identifiant de la session qui a effectué la dernière mise à jour de l'enregistrement. | ||
mie_ |
varchar2 |
Entité de sous-objet | Sub-object, such as line with header. | ||
mie_ |
varchar2 |
Clé de sous-objet | Unique identifier of the sub-object entity in the source system. | ||
mie_ |
varchar2 |
Texte de la charge utile | Full contents of the payload received by a HTTP POST. | ||
mie_ |
varchar2 |
Transaction créée | The ID of the transaction which created the record. | ||
mie_ |
varchar2 |
Transaction mise à jour | The ID of the transaction which last updated the record. | ||
mie_ |
varchar2 |
Type | Currently always 'WEBHOOK'. | ||
mie_ |
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 :