RPM Item Location Thread Ws History
In ScopeTechnical: 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(5)
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 |
| default | 3 | 3 | 1003 | RPM Item Loc Thread Ws Hi | 1103 | RPM Item L | RPM Item L | RPM Item L | RPM Item L | P | 1113 | 4 | RPM Item Loc Thread Ws Hi | 12.5000 | RPM | 1 | 2026-01-03 | RP | 1000000003 | 0 | 1000000003 | R | 2026-01-03 | 3 | 1000000003 | 12.5000 | 12.5000 | RPM | RPM |
| default | 5 | 5 | 1005 | RPM Item Loc Thread Ws Hi | 1105 | RPM Item L | RPM Item L | RPM Item L | RPM Item L | A | 1115 | 6 | RPM Item Loc Thread Ws Hi | 14.0000 | RPM | 0 | 2026-01-05 | RP | 1000000005 | 0 | 1000000005 | R | 2026-01-05 | 5 | 1000000005 | 14.0000 | 14.0000 | RPM | RPM |
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
default
- ID
- 3
- LOC
- 3
- DEPT
- 1003
- ITEM
- RPM Item Loc Thread Ws Hi
- CLASS
- 1103
- DIFF_1
- RPM Item L
- DIFF_2
- RPM Item L
- DIFF_3
- RPM Item L
- DIFF_4
- RPM Item L
- STATUS
- P
- SUBCLASS
- 1113
- THREAD_NUM
- 4
- ITEM_PARENT
- RPM Item Loc Thread Ws Hi
- MULTI_UNITS
- 12.5000
- SELLING_UOM
- RPM
- PURCHASE_TYPE
- 1
- EFFECTIVE_DATE
- 2026-01-03
- MAX_HIER_LEVEL
- RP
- NIL_PROCESS_ID
- 1000000003
- ZONE_NODE_TYPE
- 0
- EXECUTED_CLR_ID
- 1000000003
- PRICING_CONTROL
- R
- CREATE_DATE_TIME
- 2026-01-03
- PRIMARY_SUPPLIER
- 3
- ROUNDING_RULE_ID
- 1000000003
- MULTI_UNIT_RETAIL
- 12.5000
- SELLING_UNIT_RETAIL
- 12.5000
- MULTI_UNIT_SELLING_UOM
- RPM
- SELLING_RETAIL_CURRENCY
- RPM
default
- ID
- 5
- LOC
- 5
- DEPT
- 1005
- ITEM
- RPM Item Loc Thread Ws Hi
- CLASS
- 1105
- DIFF_1
- RPM Item L
- DIFF_2
- RPM Item L
- DIFF_3
- RPM Item L
- DIFF_4
- RPM Item L
- STATUS
- A
- SUBCLASS
- 1115
- THREAD_NUM
- 6
- ITEM_PARENT
- RPM Item Loc Thread Ws Hi
- MULTI_UNITS
- 14.0000
- SELLING_UOM
- RPM
- PURCHASE_TYPE
- 0
- EFFECTIVE_DATE
- 2026-01-05
- MAX_HIER_LEVEL
- RP
- NIL_PROCESS_ID
- 1000000005
- ZONE_NODE_TYPE
- 0
- EXECUTED_CLR_ID
- 1000000005
- PRICING_CONTROL
- R
- CREATE_DATE_TIME
- 2026-01-05
- PRIMARY_SUPPLIER
- 5
- ROUNDING_RULE_ID
- 1000000005
- MULTI_UNIT_RETAIL
- 14.0000
- SELLING_UNIT_RETAIL
- 14.0000
- MULTI_UNIT_SELLING_UOM
- RPM
- SELLING_RETAIL_CURRENCY
- RPM
Rule Validation Summary
- Source Rule Count
- 32
- Governed Rule Count
- 27