RPM Stage Ilrt Hist

In Scope

Technical: RPM_STAGE_ILRT_HIST | ID: OR-RPCS-RPM_STAGE_ILRT_HIST

Helper history table that holds new item location data.

See how this object fits into Pricing & Promotions

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity
Medium
Sequencing
Stage 2
Typical Sources
ERPLegacy

Target Structure

Load Approach
Table
Target Objects
RPM_STAGE_ILRT_HIST

Field Definitions(33)

Rules & Considerations(71)

Sample Load Data(4)

default

LOC
1
DEPT
1001
ITEM
RPM Stage Ilrt Hist-001
CLASS
1101
DIFF_1
RPM Stage Ilrt Hist-001
DIFF_2
RPM Stage Ilrt Hist-001
DIFF_3
RPM Stage Ilrt Hist-001
DIFF_4
RPM Stage Ilrt Hist-001
LOC_TYPE
RPM Stage Ilrt Hist-001
SUBCLASS
1111
ITEM_LEVEL
1
PROCESS_ID
1000000001
TRAN_LEVEL
1
ITEM_PARENT
RPM Stage Ilrt Hist-001
MULTI_UNITS
11.0000
REASON_CODE
STD-RPM_STAGE-001
SELLING_UOM
RPM Stage Ilrt Hist-001
CLEARANCE_ID
1000000001
CLEARANCE_IND
Y
CURRENCY_CODE
STD-RPM_STAGE-001
PURCHASE_TYPE
0
EFFECTIVE_DATE
2026-01-01
PRICING_CONTROL
RPM Stage Ilrt Hist-001
CLEARANCE_RETAIL
11.0000
CREATE_DATE_TIME
2026-01-01
PRIMARY_SUPPLIER
1
ROUNDING_RULE_ID
1000000001
MULTI_UNIT_RETAIL
11.0000
CLEAR_MARKDOWN_NBR
RPM Stage Ilrt Hist-001
SELLING_UNIT_RETAIL
11.0000
CLEARANCE_DISPLAY_ID
STD-RPM_STAGE-001
MULTI_UNIT_SELLING_UOM
RPM Stage Ilrt Hist-001
STAGE_ITEM_LOC_RETAIL_ID
1000000001
RPM Stage Ilrt Hist | undefined | Oracle Retail