IM Match Pool Results

In Scope

Technical: IM_MATCH_POOL_RESULTS | ID: OR-IM-IM_MATCH_POOL_RESULTS-IM_MATCH_POOL_RESULTS

Stores invoice matching detail for IM match pool results 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_RESULTS

Field Definitions(5)

Rules & Considerations(37)

validation

constraint

Sample Load Data(4)

_scenario	POOL_KEYR	SUPPLIERR	CONFIG_IDR	PROCESS_IDR	MATCH_POOL_RESULT_IDRPK	ITEM	CREATED_BY	IS_QTY_VWT	LHS_DOC_ID	MATCH_DATE	RESULT_TXT	RHS_DOC_ID	IS_COST_VWT	MATCH_LEVEL	CREATION_DATE	LHS_TOTAL_QTY	RHS_TOTAL_QTY	TOTAL_QTY_VAR	LHS_TOTAL_COST	RHS_TOTAL_COST	TOTAL_COST_VAR	LAST_UPDATED_BY	LAST_UPDATE_DATE	QTY_VAR_FAVOR_OF	SUCCESS_MATCH_ID	COST_VAR_FAVOR_OF	OBJECT_VERSION_ID
Example values from field definitions	SAMPLE	1	1	1	1	SAMPLE	SAMPLE	S	1	2026-01-01	SAMPLE	1	S	SAMPLE	2026-01-01	1.0000	1.0000	1.0000	1.0000	1.0000	1.0000	SAMPLE	2026-01-01	SAMPLE	1	SAMPLE	1
default	ALT-IM_MATCH-002	3	1000000003	1000000003	1000000003	IM Match Pool Results-002	APP_USER_ID	I	1000000003	2026-01-03	IM Match Pool Results-002-ALT	1000000003	I	IM Match Pool Results-002-ALT	2026-01-03	12.5000	12.5000	12.5000	12.5000	12.5000	12.5000	APP_USER_ID	2026-01-03	IM Mat	1000000003	IM Mat	1000000003
default	EDGE-IM_MATCH-003	5	1000000005	1000000005	1000000005	IM Match Pool Results-003	USERENV	I	1000000005	2026-01-05	IM Match Pool Results-003-EDGE	1000000005	I	IM Match Pool Results-003-EDGE	2026-01-05	14.0000	14.0000	14.0000	14.0000	14.0000	14.0000	USERENV	2026-01-05	IM Mat	1000000005	IM Mat	1000000005

Example values from field definitions

POOL_KEYR: SAMPLE
SUPPLIERR: 1
CONFIG_IDR: 1
PROCESS_IDR: 1
MATCH_POOL_RESULT_IDRPK: 1
ITEM: SAMPLE
CREATED_BY: SAMPLE
IS_QTY_VWT: S
LHS_DOC_ID: 1
MATCH_DATE: 2026-01-01
RESULT_TXT: SAMPLE
RHS_DOC_ID: 1
IS_COST_VWT: S
MATCH_LEVEL: SAMPLE
CREATION_DATE: 2026-01-01
LHS_TOTAL_QTY: 1.0000
RHS_TOTAL_QTY: 1.0000
TOTAL_QTY_VAR: 1.0000
LHS_TOTAL_COST: 1.0000
RHS_TOTAL_COST: 1.0000
TOTAL_COST_VAR: 1.0000
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
QTY_VAR_FAVOR_OF: SAMPLE
SUCCESS_MATCH_ID: 1
COST_VAR_FAVOR_OF: SAMPLE
OBJECT_VERSION_ID: 1

default

POOL_KEYR: ALT-IM_MATCH-002
SUPPLIERR: 3
CONFIG_IDR: 1000000003
PROCESS_IDR: 1000000003
MATCH_POOL_RESULT_IDRPK: 1000000003
ITEM: IM Match Pool Results-002
CREATED_BY: APP_USER_ID
IS_QTY_VWT: I
LHS_DOC_ID: 1000000003
MATCH_DATE: 2026-01-03
RESULT_TXT: IM Match Pool Results-002-ALT
RHS_DOC_ID: 1000000003
IS_COST_VWT: I
MATCH_LEVEL: IM Match Pool Results-002-ALT
CREATION_DATE: 2026-01-03
LHS_TOTAL_QTY: 12.5000
RHS_TOTAL_QTY: 12.5000
TOTAL_QTY_VAR: 12.5000
LHS_TOTAL_COST: 12.5000
RHS_TOTAL_COST: 12.5000
TOTAL_COST_VAR: 12.5000
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
QTY_VAR_FAVOR_OF: IM Mat
SUCCESS_MATCH_ID: 1000000003
COST_VAR_FAVOR_OF: IM Mat
OBJECT_VERSION_ID: 1000000003