IM Invoice Detail Allowance

In Scope

Technical: IM_INVOICE_DETAIL_ALLOWANCE | ID: OR-IM-IM_INVOICE_DETAIL_ALLOWANCE-IM_INVOICE_DETAIL_ALLOWANCE

Stores invoice matching data for IM invoice detail allowance 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_INVOICE_DETAIL_ALLOWANCE

Field Definitions(5)

Rules & Considerations(22)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	DOC_IDRPK	CREATED_BYR	ALLOWANCE_CODER	ALLOWANCE_AMOUNTR	SEQ_NO	CREATION_DATE	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	SAMPLE	1	SAMPLE	SAMPLE	1.0000	1	2026-01-01	SAMPLE	2026-01-01	1
default	IM Invoice Detail Allowan	1000000003	APP_USER_ID	ALT-IM	12.5000	4	2026-01-03	APP_USER_ID	2026-01-03	1000000003
default	IM Invoice Detail Allowan	1000000005	USERENV	EDGE-I	14.0000	6	2026-01-05	USERENV	2026-01-05	1000000005

Example values from field definitions

ITEMR: SAMPLE
DOC_IDRPK: 1
CREATED_BYR: SAMPLE
ALLOWANCE_CODER: SAMPLE
ALLOWANCE_AMOUNTR: 1.0000
SEQ_NO: 1
CREATION_DATE: 2026-01-01
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

ITEMR: IM Invoice Detail Allowan
DOC_IDRPK: 1000000003
CREATED_BYR: APP_USER_ID
ALLOWANCE_CODER: ALT-IM
ALLOWANCE_AMOUNTR: 12.5000
SEQ_NO: 4
CREATION_DATE: 2026-01-03
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003