IM Fixed Deal Detail

In Scope

Technical: IM_FIXED_DEAL_DETAIL | ID: OR-IM-IM_FIXED_DEAL_DETAIL-IM_FIXED_DEAL_DETAIL

Stores invoice matching data for IM fixed deal detail in Oracle Retail Invoice Matching. Used to support operational processing, integration, and reporting within the Oracle Retail application landscape.

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_FIXED_DEAL_DETAIL

Field Definitions(5)

Rules & Considerations(24)

constraint

validation

Sample Load Data(4)

_scenario	DEPTR	DOC_IDRPK	SEQ_NORPK	LOCATIONR	LOC_TYPER	CLASS	INCOME	SUBCLASS	CREATED_BY	CREATION_DATE	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	1	1	1	1	SAMPLE	1	1.0000	1	SAMPLE	2026-01-01	SAMPLE	2026-01-01	1
default	1003	1000000003	4	3	IM Fix	1103	12.5000	1113	APP_USER_ID	2026-01-03	APP_USER_ID	2026-01-03	1000000003
default	1005	1000000005	6	5	IM Fix	1105	14.0000	1115	USERENV	2026-01-05	USERENV	2026-01-05	1000000005

Example values from field definitions

DEPTR: 1
DOC_IDRPK: 1
SEQ_NORPK: 1
LOCATIONR: 1
LOC_TYPER: SAMPLE
CLASS: 1
INCOME: 1.0000
SUBCLASS: 1
CREATED_BY: SAMPLE
CREATION_DATE: 2026-01-01
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

DEPTR: 1003
DOC_IDRPK: 1000000003
SEQ_NORPK: 4
LOCATIONR: 3
LOC_TYPER: IM Fix
CLASS: 1103
INCOME: 12.5000
SUBCLASS: 1113
CREATED_BY: APP_USER_ID
CREATION_DATE: 2026-01-03
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003