IM Rwo Shipment History

In Scope

Technical: IM_RWO_SHIPMENT_HIST | ID: OR-IM-IM_RWO_SHIPMENT_HIST-IM_RWO_SHIPMENT_HISTORY

Stores historical records for IM rwo shipment 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_SHIPMENT_HIST

Field Definitions(5)

Rules & Considerations(19)

validation

constraint

Sample Load Data(4)

_scenario	SHIPMENTRPK	STATUS_CODER	TO_LOC	ORDER_NO	CREATED_BY	TO_LOC_TYPE	RECEIVE_DATE	CREATION_DATE	ORDER_SUPPLIER	LAST_UPDATED_BY	LAST_UPDATE_DATE	INVC_MATCH_STATUS	OBJECT_VERSION_ID	ORDER_CURRENCY_CODE
Example values from field definitions	1	S	1	1	SAMPLE	S	2026-01-01	2026-01-01	1	SAMPLE	2026-01-01	S	1	SAM
default	3	A	3	4	APP_USER_ID	I	2026-01-03	2026-01-03	3	APP_USER_ID	2026-01-03	P	1000000003	ALT
default	5	E	5	6	USERENV	I	2026-01-05	2026-01-05	5	USERENV	2026-01-05	A	1000000005	EDG

Example values from field definitions

SHIPMENTRPK: 1
STATUS_CODER: S
TO_LOC: 1
ORDER_NO: 1
CREATED_BY: SAMPLE
TO_LOC_TYPE: S
RECEIVE_DATE: 2026-01-01
CREATION_DATE: 2026-01-01
ORDER_SUPPLIER: 1
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
INVC_MATCH_STATUS: S
OBJECT_VERSION_ID: 1
ORDER_CURRENCY_CODE: SAM

default

SHIPMENTRPK: 3
STATUS_CODER: A
TO_LOC: 3
ORDER_NO: 4
CREATED_BY: APP_USER_ID
TO_LOC_TYPE: I
RECEIVE_DATE: 2026-01-03
CREATION_DATE: 2026-01-03
ORDER_SUPPLIER: 3
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
INVC_MATCH_STATUS: P
OBJECT_VERSION_ID: 1000000003
ORDER_CURRENCY_CODE: ALT