IM Inventory Document

In Scope

Technical: IM_INV_DOCUMENT | ID: OR-IM-IM_INV_DOCUMENT-IM_INVENTORY_DOCUMENT

Stores document-related data for IM inv document in Oracle Retail Invoice Matching, supporting creation, validation, matching, or downstream processing of business documents used in invoice matching.

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_INV_DOCUMENT

Field Definitions(5)

Rules & Considerations(16)

validation

constraint

Sample Load Data(4)

_scenario	INV_IDRPK	CREATED_BYR	REF_DOC_IDRPK	CREATION_DATER	LAST_UPDATED_BYR	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	1	SAMPLE	1	2026-01-01	SAMPLE	2026-01-01	1
default	1000000003	APP_USER_ID	1000000003	2026-01-03	APP_USER_ID	2026-01-03	1000000003
default	1000000005	USERENV	1000000005	2026-01-05	USERENV	2026-01-05	1000000005

Example values from field definitions

INV_IDRPK: 1
CREATED_BYR: SAMPLE
REF_DOC_IDRPK: 1
CREATION_DATER: 2026-01-01
LAST_UPDATED_BYR: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

INV_IDRPK: 1000000003
CREATED_BYR: APP_USER_ID
REF_DOC_IDRPK: 1000000003
CREATION_DATER: 2026-01-03
LAST_UPDATED_BYR: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003