RPM Item Location Thread Ws History

In Scope

Technical: RPM_ITEM_LOC_THREAD_WS_HIST | ID: OR-PRC-RPM_ITEM_LOC_THREAD_WS_HIST-RPM_ITEM_LOCATION_THREAD_WS_HISTORY

This is a workspace table to thread the data for new item loc to be processed.

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

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: RPM_ITEM_LOC_THREAD_WS_HIST

Field Definitions(29)

Rules & Considerations(27)

Sample Load Data(4)

_scenario	ID	LOC	DEPT	ITEM	CLASS	DIFF_1	DIFF_2	DIFF_3	DIFF_4	STATUS	SUBCLASS	THREAD_NUM	ITEM_PARENT	MULTI_UNITS	SELLING_UOM	PURCHASE_TYPE	EFFECTIVE_DATE	MAX_HIER_LEVEL	NIL_PROCESS_ID	ZONE_NODE_TYPE	EXECUTED_CLR_ID	PRICING_CONTROL	CREATE_DATE_TIME	PRIMARY_SUPPLIER	ROUNDING_RULE_ID	MULTI_UNIT_RETAIL	SELLING_UNIT_RETAIL	MULTI_UNIT_SELLING_UOM	SELLING_RETAIL_CURRENCY
Example values from field definitions	1	1	1	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	1	1	SAMPLE	1.0000	SAMP	1	2026-01-01	SA	1	1	1	S	2026-01-01	1	1	1.0000	1.0000	SAMP	SAM

Example values from field definitions

ID: 1
LOC: 1
DEPT: 1
ITEM: SAMPLE
CLASS: 1
DIFF_1: SAMPLE
DIFF_2: SAMPLE
DIFF_3: SAMPLE
DIFF_4: SAMPLE
STATUS: S
SUBCLASS: 1
THREAD_NUM: 1
ITEM_PARENT: SAMPLE
MULTI_UNITS: 1.0000
SELLING_UOM: SAMP
PURCHASE_TYPE: 1
EFFECTIVE_DATE: 2026-01-01
MAX_HIER_LEVEL: SA
NIL_PROCESS_ID: 1
ZONE_NODE_TYPE: 1
EXECUTED_CLR_ID: 1
PRICING_CONTROL: S
CREATE_DATE_TIME: 2026-01-01
PRIMARY_SUPPLIER: 1
ROUNDING_RULE_ID: 1
MULTI_UNIT_RETAIL: 1.0000
SELLING_UNIT_RETAIL: 1.0000
MULTI_UNIT_SELLING_UOM: SAMP
SELLING_RETAIL_CURRENCY: SAM

Rule Validation Summary

Source Rule Count: 32
Governed Rule Count: 27