IM Detail Match Cn Dtl History

In Scope

Technical: IM_DETAIL_MATCH_CN_DTL_HIST | ID: OR-IM-IM_DETAIL_MATCH_CN_DTL_HIST-IM_DETAIL_MATCH_CN_DTL_HISTORY

Stores historical records for IM detail match cn dtl hist in Oracle Retail Invoice Matching, preserving prior states, events, or transaction outcomes over time. Used for auditability, reporting, reconciliation, and...

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_DETAIL_MATCH_CN_DTL_HIST

Field Definitions(5)

Rules & Considerations(17)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	DOC_IDR	DOC_TYPER	MATCH_IDRPK	CREATED_BYR	CREATION_DATE	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	SAMPLE	1	SAMPLE	1	SAMPLE	2026-01-01	SAMPLE	2026-01-01	1
default	IM Detail Match Cn Dtl Hi	1000000003	IM Det	1000000003	IM Detail Match Cn Dtl Hist-002-ALT	2026-01-03	2026-01-02-ALT	2026-01-03	1000000003
default	IM Detail Match Cn Dtl Hi	1000000005	IM Det	1000000005	IM Detail Match Cn Dtl Hist-003-EDGE	2026-01-05	2026-01-03-EDGE	2026-01-05	1000000005

Example values from field definitions

ITEMR: SAMPLE
DOC_IDR: 1
DOC_TYPER: SAMPLE
MATCH_IDRPK: 1
CREATED_BYR: SAMPLE
CREATION_DATE: 2026-01-01
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

ITEMR: IM Detail Match Cn Dtl Hi
DOC_IDR: 1000000003
DOC_TYPER: IM Det
MATCH_IDRPK: 1000000003
CREATED_BYR: IM Detail Match Cn Dtl Hist-002-ALT
CREATION_DATE: 2026-01-03
LAST_UPDATED_BY: 2026-01-02-ALT
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003