RPM Item Loc Thread Ws Hist
In ScopeTechnical: RPM_ITEM_LOC_THREAD_WS_HIST | ID: OR-RPCS-RPM_ITEM_LOC_THREAD_WS_HIST
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
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_ITEM_LOC_THREAD_WS_HIST
Field Definitions(29)
Rules & Considerations(63)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1 | 1001 | RPM Item Loc Thread Ws Hist-001 | 1101 | RPM Item Loc Thread Ws Hist-001 | RPM Item Loc Thread Ws Hist-001 | RPM Item Loc Thread Ws Hist-001 | RPM Item Loc Thread Ws Hist-001 | ACTIVE | 1111 | 2 | RPM Item Loc Thread Ws Hist-001 | 11.0000 | RPM Item Loc Thread Ws Hist-001 | 0 | 2026-01-01 | RPM Item Loc Thread Ws Hist-001 | 1000000001 | 0 | 1000000001 | RPM Item Loc Thread Ws Hist-001 | 2026-01-01 | 1 | 1000000001 | 11.0000 | 11.0000 | RPM Item Loc Thread Ws Hist-001 | RPM Item Loc Thread Ws Hist-001 |
default
- ID
- 1
- LOC
- 1
- DEPT
- 1001
- ITEM
- RPM Item Loc Thread Ws Hist-001
- CLASS
- 1101
- DIFF_1
- RPM Item Loc Thread Ws Hist-001
- DIFF_2
- RPM Item Loc Thread Ws Hist-001
- DIFF_3
- RPM Item Loc Thread Ws Hist-001
- DIFF_4
- RPM Item Loc Thread Ws Hist-001
- STATUS
- ACTIVE
- SUBCLASS
- 1111
- THREAD_NUM
- 2
- ITEM_PARENT
- RPM Item Loc Thread Ws Hist-001
- MULTI_UNITS
- 11.0000
- SELLING_UOM
- RPM Item Loc Thread Ws Hist-001
- PURCHASE_TYPE
- 0
- EFFECTIVE_DATE
- 2026-01-01
- MAX_HIER_LEVEL
- RPM Item Loc Thread Ws Hist-001
- NIL_PROCESS_ID
- 1000000001
- ZONE_NODE_TYPE
- 0
- EXECUTED_CLR_ID
- 1000000001
- PRICING_CONTROL
- RPM Item Loc Thread Ws Hist-001
- CREATE_DATE_TIME
- 2026-01-01
- PRIMARY_SUPPLIER
- 1
- ROUNDING_RULE_ID
- 1000000001
- MULTI_UNIT_RETAIL
- 11.0000
- SELLING_UNIT_RETAIL
- 11.0000
- MULTI_UNIT_SELLING_UOM
- RPM Item Loc Thread Ws Hist-001
- SELLING_RETAIL_CURRENCY
- RPM Item Loc Thread Ws Hist-001