IM Cn Detail Match His

In Scope

Technical: IM_CN_DETAIL_MATCH_HIS | ID: OR-IM-IM_CN_DETAIL_MATCH_HIS-IM_CN_DETAIL_MATCH_HIS

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

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_CN_DETAIL_MATCH_HIS

Field Definitions(5)

Rules & Considerations(20)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	DOC_IDRPK	MATCH_IDRPK	CREATED_BYR	CREATION_DATE	REASON_CODE_ID	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	SAMPLE	1	1	SAMPLE	2026-01-01	SAMPLE	SAMPLE	2026-01-01	1
default	IM Cn Detail Match His-00	1000000003	1000000003	APP_USER_ID	2026-01-03	ALT-IM_CN-002	APP_USER_ID	2026-01-03	1000000003
default	IM Cn Detail Match His-00	1000000005	1000000005	USERENV	2026-01-05	EDGE-IM_CN-003	USERENV	2026-01-05	1000000005

Example values from field definitions

ITEMR: SAMPLE
DOC_IDRPK: 1
MATCH_IDRPK: 1
CREATED_BYR: SAMPLE
CREATION_DATE: 2026-01-01
REASON_CODE_ID: SAMPLE
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

ITEMR: IM Cn Detail Match His-00
DOC_IDRPK: 1000000003
MATCH_IDRPK: 1000000003
CREATED_BYR: APP_USER_ID
CREATION_DATE: 2026-01-03
REASON_CODE_ID: ALT-IM_CN-002
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003