Data Cache Data Model

imc_action

char

Action

☐

Code of triggering action in source system where 'U' stands for 'Update', 'D' for 'Delete' and 'I' for 'Insert'.

imc_appl_partition_c

string(100)

Partition

☐

Unique textual identifier of the partition within the data container.

imc_cnt

decimal

Count

☑

Number of messages in this statistical group.

imc_created_at

string(60)

Created 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.

imc_created_by

string(60)

Created by

☑

Who created the record.

imc_data_container_id

string(240)

Data Container ID

☐

Unique textual identifier of the data container.

imc_date_created

datetime

Created at

☑

The system time in UTC at which the record was created. This value will never change after creation of the record.

imc_date_modified

datetime

Updated at

☑

The system time in UTC at which the record was last updated. This value will change for every mutation of the record.

imc_date_received_first

datetime

Date Received First

☑

First receipt moment at Customer Service.

imc_date_received_last

datetime

Date Received Last

☑

Last receipt moment at Customer Service.

imc_download_cnt

decimal

Download Count

☑

Number of downloads in this statistical group.

imc_id

decimal

ID

☑

Unique identifier.

imc_modified_at

string(60)

Updated 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.

imc_modified_by

string(60)

Updated by

☑

The name of the user in the users table whom last updated the record. This value will change for every update of the record.

imc_object_entity

string(240)

Object Entity

☐

Name of the object entity in the source system.

imc_orig_system_group

string(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.

imc_orig_system_reference

string(240)

Original System Reference

☐

Reference for identifying the record on the system from which it originated.

imc_provider_name

string(240)

Provider Name

☐

Name of the Invantive connector for which the message was received.

imc_session_created

string(240)

Session Created

☑

The ID of the session which created the record. This value will not change after insert.

imc_session_modified

string(240)

Session Updated

☑

The ID of the session which last updated the record.

imc_subobject_entity

string(240)

Subobject Entity

☐

Sub-object, such as line with header.

imc_transaction_created

string(240)

Transaction Created

☑

The ID of the transaction which created the record.

imc_transaction_modified

string(240)

Transaction Updated

☑

The ID of the transaction which last updated the record.