IM Detail Match Receipt History

In Scope

Technical: IM_DETAIL_MATCH_RCPT_HISTORY | ID: OR-IM-IM_DETAIL_MATCH_RCPT_HISTORY-IM_DETAIL_MATCH_RECEIPT_HISTORY

Stores historical records for IM detail match rcpt history 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_DETAIL_MATCH_RCPT_HISTORY

Field Definitions(5)

Rules & Considerations(17)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	MATCH_IDRPK	SHIPMENTR	CREATED_BYR	CREATION_DATER	LAST_UPDATED_BY	SUBSTITUTE_ITEM	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 Detail Match Rcpt Hist	1000000003	3	APP_USER_ID	2026-01-03	APP_USER_ID	IM Detail Match Rcpt Hist	2026-01-03	1000000003
default	IM Detail Match Rcpt Hist	1000000005	5	USERENV	2026-01-05	USERENV	IM Detail Match Rcpt Hist	2026-01-05	1000000005

Example values from field definitions

ITEMR: SAMPLE
MATCH_IDRPK: 1
SHIPMENTR: 1
CREATED_BYR: SAMPLE
CREATION_DATER: 2026-01-01
LAST_UPDATED_BY: SAMPLE
SUBSTITUTE_ITEM: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

ITEMR: IM Detail Match Rcpt Hist
MATCH_IDRPK: 1000000003
SHIPMENTR: 3
CREATED_BYR: APP_USER_ID
CREATION_DATER: 2026-01-03
LAST_UPDATED_BY: APP_USER_ID
SUBSTITUTE_ITEM: IM Detail Match Rcpt Hist
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003