IM Rwo Shipsku History

In Scope

Technical: IM_RWO_SHIPSKU_HIST | ID: OR-IM-IM_RWO_SHIPSKU_HIST-IM_RWO_SHIPSKU_HISTORY

Stores historical records for IM rwo shipsku hist in Oracle Retail Invoice Matching, preserving prior states, events, or transaction outcomes over time. Used for auditability, reporting, reconciliation, and traceability of...

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_RWO_SHIPSKU_HIST

Field Definitions(5)

Rules & Considerations(17)

validation

constraint

Sample Load Data(4)

_scenario	ITEMRPK	SHIPMENTRPK	UNIT_COSTR	CREATED_BYR	QTY_RECEIVED	CREATION_DATE	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	SAMPLE	1	1.0000	SAMPLE	1.0000	2026-01-01	SAMPLE	2026-01-01	1
default	IM Rwo Shipsku Hist-002-A	3	12.5000	APP_USER_ID	12.5000	2026-01-03	APP_USER_ID	2026-01-03	1000000003
default	IM Rwo Shipsku Hist-003-E	5	14.0000	USERENV	14.0000	2026-01-05	USERENV	2026-01-05	1000000005

Example values from field definitions

ITEMRPK: SAMPLE
SHIPMENTRPK: 1
UNIT_COSTR: 1.0000
CREATED_BYR: SAMPLE
QTY_RECEIVED: 1.0000
CREATION_DATE: 2026-01-01
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

ITEMRPK: IM Rwo Shipsku Hist-002-A
SHIPMENTRPK: 3
UNIT_COSTR: 12.5000
CREATED_BYR: APP_USER_ID
QTY_RECEIVED: 12.5000
CREATION_DATE: 2026-01-03
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003