IM Match Quantity Variance History

In Scope

Technical: IM_MATCH_QTY_VAR_HIST | ID: OR-IM-IM_MATCH_QTY_VAR_HIST-IM_MATCH_QUANTITY_VARIANCE_HISTORY

Stores historical records for IM match qty var 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_QTY_VAR_HIST

Field Definitions(5)

Rules & Considerations(21)

validation

constraint

Sample Load Data(4)

_scenario	QTYR	UNIT_COSTR	PROCESS_IDR	MATCH_POOL_RESULT_IDR	DISC_ID	CREATED_BY	CREATION_DATE	LAST_UPDATED_BY	LAST_UPDATE_DATE	WITHIN_TOLERANCE	OBJECT_VERSION_ID	UNIT_COST_SRC_TYPE
Example values from field definitions	1.0000	1.0000	1	1	1	SAMPLE	2026-01-01	SAMPLE	2026-01-01	S	1	SAMPLE
default	12.5000	12.5000	1000000003	1000000003	1000000003	APP_USER_ID	2026-01-03	APP_USER_ID	2026-01-03	I	1000000003	IM Match Qty Var Hist-002-ALT
default	14.0000	14.0000	1000000005	1000000005	1000000005	USERENV	2026-01-05	USERENV	2026-01-05	I	1000000005	IM Match Qty Var Hist-003-EDGE

Example values from field definitions

QTYR: 1.0000
UNIT_COSTR: 1.0000
PROCESS_IDR: 1
MATCH_POOL_RESULT_IDR: 1
DISC_ID: 1
CREATED_BY: SAMPLE
CREATION_DATE: 2026-01-01
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
WITHIN_TOLERANCE: S
OBJECT_VERSION_ID: 1
UNIT_COST_SRC_TYPE: SAMPLE

default

QTYR: 12.5000
UNIT_COSTR: 12.5000
PROCESS_IDR: 1000000003
MATCH_POOL_RESULT_IDR: 1000000003
DISC_ID: 1000000003
CREATED_BY: APP_USER_ID
CREATION_DATE: 2026-01-03
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
WITHIN_TOLERANCE: I
OBJECT_VERSION_ID: 1000000003
UNIT_COST_SRC_TYPE: IM Match Qty Var Hist-002-ALT