IM Match Document History

In Scope

Technical: IM_MATCH_DOC_HIST | ID: OR-IM-IM_MATCH_DOC_HIST-IM_MATCH_DOCUMENT_HISTORY

Stores historical records for IM match doc hist 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_MATCH_DOC_HIST

Field Definitions(5)

Rules & Considerations(28)

constraint

validation

Sample Load Data(4)

_scenario	DOC_REFRPK	DOC_TYPERPK	POOL_KEYRPK	SUPPLIERRPK	PROCESS_IDRPK	CONFIG_ID	CREATED_BY	MATCH_LEVEL	CREATION_DATE	SUPPLIER_GROUP	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	1	SAMPLE	SAMPLE	1	1	1	SAMPLE	SAMPLE	2026-01-01	1	SAMPLE	2026-01-01	1
default	3	IM Match Doc Hist-002-ALT	ALT-IM_MATCH-002	3	1000000003	1000000003	APP_USER_ID	IM Match Doc Hist-002-ALT	2026-01-03	203	APP_USER_ID	2026-01-03	1000000003
default	5	IM Match Doc Hist-003-EDGE	EDGE-IM_MATCH-003	5	1000000005	1000000005	USERENV	IM Match Doc Hist-003-EDGE	2026-01-05	205	USERENV	2026-01-05	1000000005

Example values from field definitions

DOC_REFRPK: 1
DOC_TYPERPK: SAMPLE
POOL_KEYRPK: SAMPLE
SUPPLIERRPK: 1
PROCESS_IDRPK: 1
CONFIG_ID: 1
CREATED_BY: SAMPLE
MATCH_LEVEL: SAMPLE
CREATION_DATE: 2026-01-01
SUPPLIER_GROUP: 1
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

DOC_REFRPK: 3
DOC_TYPERPK: IM Match Doc Hist-002-ALT
POOL_KEYRPK: ALT-IM_MATCH-002
SUPPLIERRPK: 3
PROCESS_IDRPK: 1000000003
CONFIG_ID: 1000000003
CREATED_BY: APP_USER_ID
MATCH_LEVEL: IM Match Doc Hist-002-ALT
CREATION_DATE: 2026-01-03
SUPPLIER_GROUP: 203
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003