---
title: "dc_incoming_messages (Data Cache)"
description: "Incoming Messages"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/invantivedatareplicator/Cache.Invantive.dc_incoming_messages
original: https://documentation.invantive.eu/en/datamodels/invantivedatareplicator/Cache.Invantive.dc_incoming_messages
updated: 2023-08-17T08:37:05Z
license: https://documentation.invantive.eu/en/
---

# dc_incoming_messages: Data Cache Incoming Messages

`read only`

- Catalog: `Cache`
- Schema: `Invantive`
- Primary Keys: `ime_id`
- Label: Incoming Messages

Trickle loading events received from Customer Service for seeding new tables on basis of deltas.

Can only retrieve data.

## Table Columns

The columns of the table `dc_incoming_messages` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ime_action` | `char` | Action | [ ] |  | Code of triggering action in source system where 'U' stands for 'Update', 'D' for 'Delete' and 'I' for 'Insert'. |
| `ime_appl_client_id` | `varchar2(240)` | Application Client ID | [ ] |  | OAuth client ID of the application. |
| `ime_appl_partition_c` | `varchar2(100)` | Partition | [ ] |  | Unique textual identifier of the partition within the data container. |
| `ime_created_at` | `varchar2(60)` | Created in | [x] |  | 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_created_by` | `varchar2(60)` | Created by | [x] |  | Who created the record. |
| `ime_cs_message_key` | `varchar2` | Customer Service Message Key | [x] |  | Customer Service Message Key. |
| `ime_cs_ref_key` | `decimal` | Customer Service Reference Key | [x] |  | Customer Service ID. |
| `ime_data_container_id` | `varchar2(240)` | Data Container ID | [ ] |  | Unique textual identifier of the data container. |
| `ime_date_created` | `datetime` | Created at | [x] |  | The system time in UTC at which the record was created. This value will never change after creation of the record. |
| `ime_date_downloaded` | `datetime` | Download Date | [x] |  | Date/time at which the message was downloaded from Customer Service. |
| `ime_date_forwarded` | `datetime` | Date Forwarded | [ ] |  | Moment at which the message was processed. |
| `ime_date_modified` | `datetime` | Updated at | [x] |  | The system time in UTC at which the record was last updated. This value will change for every mutation of the record. |
| `ime_date_occurred` | `datetime` | Date Occurred | [ ] |  | Occurrence at the originating server (UTC). |
| `ime_date_occurred_server_local` | `datetime` | Date Occurred Server Local Time | [ ] |  | Occurrence at the originating server (server local time). |
| `ime_date_received` | `datetime` | Date Received | [x] |  | Receipt moment at Customer Service. |
| `ime_description` | `varchar2(240)` | Description | [ ] |  | Description of the event in human-readable language. |
| `ime_forwarded_flag` | `char` | Forwarded | [x] |  | Whether the message was processed. |
| `ime_id` | `decimal` | ID | [x] |  | Unique identifier. |
| `ime_iiid` | `varchar2(240)` | IIID | [ ] |  | Invantive Installation ID. |
| `ime_ip_address_external_sender` | `varchar2(240)` | IP Address External Sender | [x] |  | Internet-side IP-address of the message sender. |
| `ime_iuid` | `varchar2(240)` | IUID | [ ] |  | Invantive User ID. A physical person can have multiple IUIDs. |
| `ime_license_contract_code` | `varchar2(240)` | License Contract Code | [ ] |  | Code of the Invantive license contract for which the message was registered. |
| `ime_message_key` | `varchar2(240)` | Message Key | [ ] |  | A unique ID of the message as presented by the sender. |
| `ime_modified_at` | `varchar2(60)` | Updated in | [x] |  | 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_modified_by` | `varchar2(60)` | Updated by | [x] |  | 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_object_entity` | `varchar2(240)` | Object Entity | [ ] |  | Name of the object entity in the source system. |
| `ime_object_key` | `varchar2(240)` | Object Key | [ ] |  | Unique identifier of the object entity in the source system. |
| `ime_object_url` | `varchar2(2000)` | Object URL | [ ] |  | Browser URL to display the object in the source system. |
| `ime_orig_system_group` | `varchar2(240)` | Original System Group | [ ] |  | 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_orig_system_reference` | `varchar2(240)` | Original System Reference | [ ] |  | Reference for identifying the record on the system from which it originated. |
| `ime_provider_name` | `varchar2(240)` | Provider Name | [ ] |  | Name of the Invantive connector for which the message was received. |
| `ime_receiving_url` | `varchar2(2000)` | Receiving URL | [x] |  | URL on which the request was received including query string. |
| `ime_session_created` | `varchar2(240)` | Session Created | [x] |  | The ID of the session which created the record. This value will not change after insert. |
| `ime_session_id` | `varchar2(240)` | Session ID | [ ] |  | Unique ID of the Invantive session that registered the message. |
| `ime_session_modified` | `varchar2(240)` | Session Updated | [x] |  | The ID of the session which last updated the record. |
| `ime_subobject_entity` | `varchar2(240)` | Subobject Entity | [ ] |  | Sub-object, such as line with header. |
| `ime_subobject_key` | `varchar2(240)` | Subobject Key | [ ] |  | Unique identifier of the sub-object entity in the source system. |
| `ime_table_full_qualified_name` | `varchar2(240)` | Full Qualified Table Name | [ ] |  | Full name of the target table. |
| `ime_text_payload` | `varchar2` | Text of Payload | [ ] |  | Full contents of the payload received by a HTTP POST. |
| `ime_transaction_created` | `varchar2(240)` | Transaction Created | [x] |  | The ID of the transaction which created the record. |
| `ime_transaction_modified` | `varchar2(240)` | Transaction Updated | [x] |  | The ID of the transaction which last updated the record. |
| `ime_type` | `varchar2(30)` | Type | [x] |  | Currently always 'WEBHOOK'. |
| `ime_verb` | `varchar2(30)` | HTTP Verb | [ ] |  | HTTP verb used to register the message. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Data Cache](/en/release-notes/drivers?driver=data-cache)

