IM Receipt Item Posting Stage

In Scope

Technical: IM_RECEIPT_ITEM_POSTING_STAGE | ID: OR-IM-IM_RECEIPT_ITEM_POSTING_STAGE-IM_RECEIPT_ITEM_POSTING_STAGE

Staging table used to load, validate, and track inbound invoice matching data for Oracle Retail Invoice Matching before it is processed into core operational tables. It typically supports interface status,...

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_RECEIPT_ITEM_POSTING_STAGE

Field Definitions(5)

Rules & Considerations(18)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	SEQ_NORPK	SHIPMENTR	QTY_POSTEDR	CREATE_DATER	CREATED_BY	CREATION_DATE	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	SAMPLE	1	1	1.0000	2026-01-01	SAMPLE	2026-01-01	SAMPLE	2026-01-01	1
default	IM Receipt Item Posting S	4	3	12.5000	2026-01-03	APP_USER_ID	2026-01-03	APP_USER_ID	2026-01-03	1000000003
default	IM Receipt Item Posting S	6	5	14.0000	2026-01-05	USERENV	2026-01-05	USERENV	2026-01-05	1000000005

Example values from field definitions

ITEMR: SAMPLE
SEQ_NORPK: 1
SHIPMENTR: 1
QTY_POSTEDR: 1.0000
CREATE_DATER: 2026-01-01
CREATED_BY: SAMPLE
CREATION_DATE: 2026-01-01
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

ITEMR: IM Receipt Item Posting S
SEQ_NORPK: 4
SHIPMENTR: 3
QTY_POSTEDR: 12.5000
CREATE_DATER: 2026-01-03
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