dc_incoming_messages: Data Cache Incoming Messages
read only
- Katalog:
Cache - Schema:
Invantive - Primärschlüssel:
ime_id - Label: Incoming Messages
Trickle loading events received from Customer Service for seeding new tables on basis of deltas.
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle dc_incoming_messages sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | 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 |
Anwendung Client-ID | OAuth Client ID der Anwendung. | ||
ime_ |
varchar2 |
Partition | Unique textual identifier of the partition within the data container. | ||
ime_ |
varchar2 |
Erstellt in | 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 |
Erstellt durch | Wer hat den Datensatz erstellt. | ||
ime_ |
varchar2 |
Customer Service Nachrichtenschlüssel | Customer Service Message Key. | ||
ime_ |
decimal |
Customer Service Referenzschlüssel | Customer Service ID. | ||
ime_ |
varchar2 |
Datenkontainer ID | Unique textual identifier of the data container. | ||
ime_ |
datetime |
Erstellt bei | The system time in UTC at which the record was created.This value will never change after creation of the record. | ||
ime_ |
datetime |
Datum herunterladen | Date/time at which the message was downloaded from Customer Service. | ||
ime_ |
datetime |
Datum der Weiterleitung | Moment at which the message was processed. | ||
ime_ |
datetime |
Aktualisiert am | The system time in UTC at which the record was last updated.This value will change for every mutation of the record. | ||
ime_ |
datetime |
Datum des Auftretens | Occurrence at the originating server (UTC). | ||
ime_ |
datetime |
Datum des Auftretens Ortszeit des Servers | Occurrence at the originating server (server local time). | ||
ime_ |
datetime |
Empfangsdatum | 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 |
IP-Adresse des externen Absenders | Internet-side IP-address of the message sender. | ||
ime_ |
varchar2 |
IUID | Invantive User ID.A physical person can have multiple IUIDs. | ||
ime_ |
varchar2 |
Lizenzvertragscode | Code of the Invantive license contract for which the message was registered. | ||
ime_ |
varchar2 |
Nachrichtschlüssel | A unique ID of the message as presented by the sender. | ||
ime_ |
varchar2 |
Aktualisiert in | 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 |
Aktualisiert von | 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 |
Objekt Entität | Name of the object entity in the source system. | ||
ime_ |
varchar2 |
Objektschlüssel | Unique identifier of the object entity in the source system. | ||
ime_ |
varchar2 |
Objekt URL | Browser URL to display the object in the source system. | ||
ime_ |
varchar2 |
Original System Gruppe | 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 |
Ursprünglicher Systembezug | Referenz zur Identifikation des Datensatzes auf dem System, von dem er stamm. | ||
ime_ |
varchar2 |
Anbietername | Name of the Invantive connector for which the message was received. | ||
ime_ |
varchar2 |
Empfangs-URL | URL on which the request was received including query string. | ||
ime_ |
varchar2 |
Session erstellt | 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 |
Sitzung aktualisiert | Die ID der Session, die den Datensatz zuletzt aktualisierte. | ||
ime_ |
varchar2 |
Unterobjekt-Entität | Sub-object, such as line with header. | ||
ime_ |
varchar2 |
Unterobjektschlüssel | Unique identifier of the sub-object entity in the source system. | ||
ime_ |
varchar2 |
Vollständiger qualifizierter Tabellenname | Full name of the target table. | ||
ime_ |
varchar2 |
Text der Nutzlast | Full contents of the payload received by a HTTP POST. | ||
ime_ |
varchar2 |
Verhandlung angelegt | The ID of the transaction which created the record. | ||
ime_ |
varchar2 |
Verhandlung aktualisiert | The ID of the transaction which last updated the record. | ||
ime_ |
varchar2 |
Type | Currently always 'WEBHOOK'. | ||
ime_ |
varchar2 |
HTTP-Verb | HTTP verb used to register the message. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: