IM Match Cost Variance

In Scope

Technical: IM_MATCH_COST_VAR | ID: OR-IM-IM_MATCH_COST_VAR-IM_MATCH_COST_VARIANCE

Stores invoice matching detail for IM match cost var 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_COST_VAR

Field Definitions(5)

Rules & Considerations(23)

validation

constraint

Sample Load Data(4)

_scenario	AMOUNTR	QUANTITYR	PROCESS_IDRPK	MATCH_POOL_RESULT_IDRPK	DISC_ID	CREATED_BY	QTY_SRC_TYPE	CREATION_DATE	LAST_UPDATED_BY	LAST_UPDATE_DATE	WITHIN_TOLERANCE	OBJECT_VERSION_ID
Example values from field definitions	1.0000	1.0000	1	1	1	SAMPLE	SAMPLE	2026-01-01	SAMPLE	2026-01-01	S	1
default	12.5000	12.5000	1000000003	1000000003	1000000003	APP_USER_ID	IM Match Cost Var-002-ALT	2026-01-03	APP_USER_ID	2026-01-03	I	1000000003
default	14.0000	14.0000	1000000005	1000000005	1000000005	USERENV	IM Match Cost Var-003-EDGE	2026-01-05	USERENV	2026-01-05	I	1000000005

Example values from field definitions

AMOUNTR: 1.0000
QUANTITYR: 1.0000
PROCESS_IDRPK: 1
MATCH_POOL_RESULT_IDRPK: 1
DISC_ID: 1
CREATED_BY: SAMPLE
QTY_SRC_TYPE: SAMPLE
CREATION_DATE: 2026-01-01
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
WITHIN_TOLERANCE: S
OBJECT_VERSION_ID: 1

default

AMOUNTR: 12.5000
QUANTITYR: 12.5000
PROCESS_IDRPK: 1000000003
MATCH_POOL_RESULT_IDRPK: 1000000003
DISC_ID: 1000000003
CREATED_BY: APP_USER_ID
QTY_SRC_TYPE: IM Match Cost Var-002-ALT
CREATION_DATE: 2026-01-03
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
WITHIN_TOLERANCE: I
OBJECT_VERSION_ID: 1000000003