dc_incoming_messages: Data Cache Incoming Messages
read only
- Catalogus:
Cache - Schema:
Invantive - Primaire sleutels:
ime_id - Label: Incoming Messages
Trickle loading events received from Customer Service for seeding new tables on basis of deltas.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel dc_incoming_messages worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | 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 |
Applicatie Client-ID | OAuth client ID van de applicatie. | ||
ime_ |
varchar2 |
Partition | Unique textual identifier of the partition within the data container. | ||
ime_ |
varchar2 |
Aangemaakt 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 |
Gemaakt door | Wie heeft het record aangemaakt. | ||
ime_ |
varchar2 |
Customer Service Berichtsleutel | Customer Service Message Key. | ||
ime_ |
decimal |
Klantenservice Referentie Sleutel | Customer Service ID. | ||
ime_ |
varchar2 |
Datacontainer ID | Unique textual identifier of the data container. | ||
ime_ |
datetime |
Aangemaakt op | The system time in UTC at which the record was created.This value will never change after creation of the record. | ||
ime_ |
datetime |
Downloaddatum | Date/time at which the message was downloaded from Customer Service. | ||
ime_ |
datetime |
Datum Doorgestuurd | Moment at which the message was processed. | ||
ime_ |
datetime |
Bijgewerkt op | 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 Gebeurd | Occurrence at the originating server (UTC). | ||
ime_ |
datetime |
Lokale Datumtijd Gebeurtenis Server | Occurrence at the originating server (server local time). | ||
ime_ |
datetime |
Datum Ontvangen | 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-Adres Externe Afzender | Internet-side IP-address of the message sender. | ||
ime_ |
varchar2 |
IUID | Invantive User ID.A physical person can have multiple IUIDs. | ||
ime_ |
varchar2 |
Licentiecontractcode | Code of the Invantive license contract for which the message was registered. | ||
ime_ |
varchar2 |
Berichtsleutel | A unique ID of the message as presented by the sender. | ||
ime_ |
varchar2 |
Bijgewerkt 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 |
Bijgewerkt door | 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 |
Objectentiteit | Name of the object entity in the source system. | ||
ime_ |
varchar2 |
Objectsleutel | Unique identifier of the object entity in the source system. | ||
ime_ |
varchar2 |
Object URL | Browser URL to display the object in the source system. | ||
ime_ |
varchar2 |
Oorspronkelijke Systeemgroep | 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 |
Oorspronkelijk Systeemreferentie | Referentie voor identificatie van de opname in het systeem vanwaar het is ontstaan. | ||
ime_ |
varchar2 |
Providernaam | Name of the Invantive connector for which the message was received. | ||
ime_ |
varchar2 |
Ontvangende URL | URL on which the request was received including query string. | ||
ime_ |
varchar2 |
Sessie Aangemaakt | The ID of the session which created the record.This value will not change after insert. | ||
ime_ |
varchar2 |
Sessie ID | Unique ID of the Invantive session that registered the message. | ||
ime_ |
varchar2 |
Sessie Bijgewerkt | De ID van de sessie die het record de laatste keer bijwerkte. | ||
ime_ |
varchar2 |
Subobject Entiteit | Sub-object, such as line with header. | ||
ime_ |
varchar2 |
Subobjectsleutel | Unique identifier of the sub-object entity in the source system. | ||
ime_ |
varchar2 |
Volledig Gekwalificeerde Tabelnaam | Full name of the target table. | ||
ime_ |
varchar2 |
Tekst bij de Nettolading | Full contents of the payload received by a HTTP POST. | ||
ime_ |
varchar2 |
Transactie Aangemaakt | The ID of the transaction which created the record. | ||
ime_ |
varchar2 |
Transactie Bijgewerkt | The ID of the transaction which last updated the record. | ||
ime_ |
varchar2 |
Type | Currently always 'WEBHOOK'. | ||
ime_ |
varchar2 |
HTTP Werkwoord | HTTP verb used to register the message. |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: