IM Match Pool Item History

In Scope

Technical: IM_MATCH_POOL_ITEM_HIST | ID: OR-IM-IM_MATCH_POOL_ITEM_HIST-IM_MATCH_POOL_ITEM_HISTORY

Stores historical records for IM match pool item hist 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_MATCH_POOL_ITEM_HIST

Field Definitions(5)

Rules & Considerations(25)

validation

constraint

Sample Load Data(4)

_scenario	DOC_IDR	DOC_TYPER	MATCH_SIDER	PROCESS_IDR	MATCH_POOL_RESULT_IDR	QTY	ITEM	UNIT_COST	CREATED_BY	REASON_CODE	CREATION_DATE	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	1	SAMPLE	SAM	1	1	1.0000	SAMPLE	1.0000	SAMPLE	SAMPLE	2026-01-01	SAMPLE	2026-01-01	1
default	1000000003	IM Match Pool Item Hist-002-AL	IM	1000000003	1000000003	12.5000	IM Match Pool Item Hist-0	12.5000	APP_USER_ID	ALT-IM_MATCH-002	2026-01-03	APP_USER_ID	2026-01-03	1000000003
default	1000000005	IM Match Pool Item Hist-003-ED	IM	1000000005	1000000005	14.0000	IM Match Pool Item Hist-0	14.0000	USERENV	EDGE-IM_MATCH-003	2026-01-05	USERENV	2026-01-05	1000000005

Example values from field definitions

DOC_IDR: 1
DOC_TYPER: SAMPLE
MATCH_SIDER: SAM
PROCESS_IDR: 1
MATCH_POOL_RESULT_IDR: 1
QTY: 1.0000
ITEM: SAMPLE
UNIT_COST: 1.0000
CREATED_BY: SAMPLE
REASON_CODE: SAMPLE
CREATION_DATE: 2026-01-01
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

DOC_IDR: 1000000003
DOC_TYPER: IM Match Pool Item Hist-002-AL
MATCH_SIDER: IM
PROCESS_IDR: 1000000003
MATCH_POOL_RESULT_IDR: 1000000003
QTY: 12.5000
ITEM: IM Match Pool Item Hist-0
UNIT_COST: 12.5000
CREATED_BY: APP_USER_ID
REASON_CODE: ALT-IM_MATCH-002
CREATION_DATE: 2026-01-03
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003