IM Document Detail Comments

In Scope

Technical: IM_DOC_DETAIL_COMMENTS | ID: OR-IM-IM_DOC_DETAIL_COMMENTS-IM_DOCUMENT_DETAIL_COMMENTS

Stores free-text comments or annotations associated with IM doc detail comments in Oracle Retail Invoice Matching. Used to retain supporting context for review, approval, investigation, or downstream display.

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_DOC_DETAIL_COMMENTS

Field Definitions(5)

Rules & Considerations(29)

validation

constraint

Sample Load Data(4)

_scenario	TEXTR	COMMENT_IDRPK	CREATED_BYR	COMMENT_TYPER	CREATION_DATER	ITEM	DOC_ID	REASON_CODE_ID	LAST_UPDATED_BY	DISCREPANCY_TYPE	LAST_UPDATE_DATE	DEBIT_REASON_CODE	OBJECT_VERSION_ID
Example values from field definitions	SAMPLE	1	SAMPLE	SAMPLE	2026-01-01	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	2026-01-01	SAMPLE	1
default	IM Doc Detail Comments-002-ALT	1000000003	APP_USER_ID	IM Doc	2026-01-03	IM Doc Detail Comments-00	1000000003	ALT-IM_DOC-002	APP_USER_ID	IM Doc	2026-01-03	ALT-IM_DOC-002	1000000003
default	IM Doc Detail Comments-003-EDGE	1000000005	USERENV	IM Doc	2026-01-05	IM Doc Detail Comments-00	1000000005	EDGE-IM_DOC-003	USERENV	IM Doc	2026-01-05	EDGE-IM_DOC-003	1000000005

Example values from field definitions

TEXTR: SAMPLE
COMMENT_IDRPK: 1
CREATED_BYR: SAMPLE
COMMENT_TYPER: SAMPLE
CREATION_DATER: 2026-01-01
ITEM: SAMPLE
DOC_ID: 1
REASON_CODE_ID: SAMPLE
LAST_UPDATED_BY: SAMPLE
DISCREPANCY_TYPE: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
DEBIT_REASON_CODE: SAMPLE
OBJECT_VERSION_ID: 1

default

TEXTR: IM Doc Detail Comments-002-ALT
COMMENT_IDRPK: 1000000003
CREATED_BYR: APP_USER_ID
COMMENT_TYPER: IM Doc
CREATION_DATER: 2026-01-03
ITEM: IM Doc Detail Comments-00
DOC_ID: 1000000003
REASON_CODE_ID: ALT-IM_DOC-002
LAST_UPDATED_BY: APP_USER_ID
DISCREPANCY_TYPE: IM Doc
LAST_UPDATE_DATE: 2026-01-03
DEBIT_REASON_CODE: ALT-IM_DOC-002
OBJECT_VERSION_ID: 1000000003