IM Match Pool Item

In Scope

Technical: IM_MATCH_POOL_ITEM | ID: OR-IM-IM_MATCH_POOL_ITEM-IM_MATCH_POOL_ITEM

Stores invoice matching detail for IM match pool item in Oracle Retail Invoice Matching, linking invoices, credit notes, receipts, purchase orders, or cost components used during match processing. It supports...

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

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-002-ALT	IM	1000000003	1000000003	12.5000	IM Match Pool Item-002-AL	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-003-EDGE	IM	1000000005	1000000005	14.0000	IM Match Pool Item-003-ED	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-002-ALT
MATCH_SIDER: IM
PROCESS_IDR: 1000000003
MATCH_POOL_RESULT_IDR: 1000000003
QTY: 12.5000
ITEM: IM Match Pool Item-002-AL
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