IM Summary Match History

In Scope

Technical: IM_SUMMARY_MATCH_HISTORY | ID: OR-IM-IM_SUMMARY_MATCH_HISTORY-IM_SUMMARY_MATCH_HISTORY

Stores historical records for IM summary match history in Oracle Retail Invoice Matching, preserving prior states, events, or transaction outcomes over time. Used for auditability, reporting, reconciliation, and traceability of...

See how this object fits into Invoice Matching

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: IM_SUMMARY_MATCH_HISTORY

Field Definitions(5)

Rules & Considerations(15)

validation

constraint

Sample Load Data(4)

_scenario	MATCH_IDRPK	CREATED_BYR	EXACT_MATCHR	AUTO_MATCHEDR	CREATION_DATER	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	1	SAMPLE	S	S	2026-01-01	SAMPLE	2026-01-01	1
default	1000000003	APP_USER_ID	I	I	2026-01-03	APP_USER_ID	2026-01-03	1000000003
default	1000000005	USERENV	I	I	2026-01-05	USERENV	2026-01-05	1000000005

Example values from field definitions

MATCH_IDRPK: 1
CREATED_BYR: SAMPLE
EXACT_MATCHR: S
AUTO_MATCHEDR: S
CREATION_DATER: 2026-01-01
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

MATCH_IDRPK: 1000000003
CREATED_BYR: APP_USER_ID
EXACT_MATCHR: I
AUTO_MATCHEDR: I
CREATION_DATER: 2026-01-03
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003