IM Match Pool Results History

In Scope

Technical: IM_MATCH_POOL_RESULTS_HIST | ID: OR-IM-IM_MATCH_POOL_RESULTS_HIST-IM_MATCH_POOL_RESULTS_HISTORY

Stores historical records for IM match pool results 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_RESULTS_HIST

Field Definitions(5)

Rules & Considerations(36)

validation

constraint

Sample Load Data(4)

_scenario	POOL_KEYR	SUPPLIERR	CONFIG_IDR	PROCESS_IDR	MATCH_POOL_RESULT_IDR	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 His	APP_USER_ID	I	1000000003	2026-01-03	IM Match Pool Results Hist-002-ALT	1000000003	I	IM Match Pool Results Hist-002	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 His	USERENV	I	1000000005	2026-01-05	IM Match Pool Results Hist-003-EDGE	1000000005	I	IM Match Pool Results Hist-003	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_IDR: 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_IDR: 1000000003
ITEM: IM Match Pool Results His
CREATED_BY: APP_USER_ID
IS_QTY_VWT: I
LHS_DOC_ID: 1000000003
MATCH_DATE: 2026-01-03
RESULT_TXT: IM Match Pool Results Hist-002-ALT
RHS_DOC_ID: 1000000003
IS_COST_VWT: I
MATCH_LEVEL: IM Match Pool Results Hist-002
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