RPM Pe Expl Helper (GTT)
Out of ScopeTechnical: RPM_PE_EXPL_HELPER_GTT | ID: OR-PRC-RPM_PE_EXPL_HELPER_GTT-RPM_PE_EXPL_HELPER_GTT
Helper GTT for price event explosion.
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
- gtt
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_PE_EXPL_HELPER_GTT
Field Definitions(5)
Rules & Considerations(31)
constraint
validation
Sample Load Data(4)
| _scenario | PRICE_EVENT_KEY_1R | PRICE_EVENT_KEY_2R | PRICE_EVENT_KEY_3R | PRICE_EVENT_KEY_4R | ITEM | DIFF_ID | ZONE_ID | LOCATION | LOC_NAME | DIFF_DESC | ITEM_DESC | ZONE_NAME | ITEM_LEVEL | TRAN_LEVEL | GENERATED_BY | IL_OWNED_IND | ORIGINAL_ITEM | PURCHASE_TYPE | ORIGINAL_PE_ID | ZONE_NODE_TYPE | ZONE_DISPLAY_ID | NEED_EXPLODE_IND | ORIGINAL_DIFF_ID | ORIGINAL_ZONE_ID | PRIMARY_SUPPLIER |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | S | 1 | SAMPLE | 1 | 1 | 1 | 1 | 1 | SAMPLE | 1 | 1 |
| default | 3 | 3 | 3 | 3 | RPM Pe Expl Helper Gtt-00 | ALT-RPM_PE | 1000000003 | 3 | RPM Pe Expl Helper Gtt Secondary | RPM Pe Expl Helper Gtt-002-ALT | RPM Pe Expl Helper Gtt-002-ALT | RPM Pe Expl Helper Gtt Secondary | 3 | 3 | S | 3 | RPM Pe Expl Helper Gtt-00 | 1 | 1000000003 | 3 | 1000000003 | 3 | ALT-RPM_PE | 1000000003 | 3 |
| default | 5 | 5 | 5 | 5 | RPM Pe Expl Helper Gtt-00 | EDGE-RPM_P | 1000000005 | 5 | RPM Pe Expl Helper Gtt Core | RPM Pe Expl Helper Gtt-003-EDGE | RPM Pe Expl Helper Gtt-003-EDGE | RPM Pe Expl Helper Gtt Core | 5 | 5 | S | 5 | RPM Pe Expl Helper Gtt-00 | 0 | 1000000005 | 5 | 1000000005 | 5 | EDGE-RPM_P | 1000000005 | 5 |
Example values from field definitions
- PRICE_EVENT_KEY_1R
- 1
- PRICE_EVENT_KEY_2R
- 1
- PRICE_EVENT_KEY_3R
- 1
- PRICE_EVENT_KEY_4R
- 1
- ITEM
- SAMPLE
- DIFF_ID
- SAMPLE
- ZONE_ID
- 1
- LOCATION
- 1
- LOC_NAME
- SAMPLE
- DIFF_DESC
- SAMPLE
- ITEM_DESC
- SAMPLE
- ZONE_NAME
- SAMPLE
- ITEM_LEVEL
- 1
- TRAN_LEVEL
- 1
- GENERATED_BY
- S
- IL_OWNED_IND
- 1
- ORIGINAL_ITEM
- SAMPLE
- PURCHASE_TYPE
- 1
- ORIGINAL_PE_ID
- 1
- ZONE_NODE_TYPE
- 1
- ZONE_DISPLAY_ID
- 1
- NEED_EXPLODE_IND
- 1
- ORIGINAL_DIFF_ID
- SAMPLE
- ORIGINAL_ZONE_ID
- 1
- PRIMARY_SUPPLIER
- 1
default
- PRICE_EVENT_KEY_1R
- 3
- PRICE_EVENT_KEY_2R
- 3
- PRICE_EVENT_KEY_3R
- 3
- PRICE_EVENT_KEY_4R
- 3
- ITEM
- RPM Pe Expl Helper Gtt-00
- DIFF_ID
- ALT-RPM_PE
- ZONE_ID
- 1000000003
- LOCATION
- 3
- LOC_NAME
- RPM Pe Expl Helper Gtt Secondary
- DIFF_DESC
- RPM Pe Expl Helper Gtt-002-ALT
- ITEM_DESC
- RPM Pe Expl Helper Gtt-002-ALT
- ZONE_NAME
- RPM Pe Expl Helper Gtt Secondary
- ITEM_LEVEL
- 3
- TRAN_LEVEL
- 3
- GENERATED_BY
- S
- IL_OWNED_IND
- 3
- ORIGINAL_ITEM
- RPM Pe Expl Helper Gtt-00
- PURCHASE_TYPE
- 1
- ORIGINAL_PE_ID
- 1000000003
- ZONE_NODE_TYPE
- 3
- ZONE_DISPLAY_ID
- 1000000003
- NEED_EXPLODE_IND
- 3
- ORIGINAL_DIFF_ID
- ALT-RPM_PE
- ORIGINAL_ZONE_ID
- 1000000003
- PRIMARY_SUPPLIER
- 3
default
- PRICE_EVENT_KEY_1R
- 5
- PRICE_EVENT_KEY_2R
- 5
- PRICE_EVENT_KEY_3R
- 5
- PRICE_EVENT_KEY_4R
- 5
- ITEM
- RPM Pe Expl Helper Gtt-00
- DIFF_ID
- EDGE-RPM_P
- ZONE_ID
- 1000000005
- LOCATION
- 5
- LOC_NAME
- RPM Pe Expl Helper Gtt Core
- DIFF_DESC
- RPM Pe Expl Helper Gtt-003-EDGE
- ITEM_DESC
- RPM Pe Expl Helper Gtt-003-EDGE
- ZONE_NAME
- RPM Pe Expl Helper Gtt Core
- ITEM_LEVEL
- 5
- TRAN_LEVEL
- 5
- GENERATED_BY
- S
- IL_OWNED_IND
- 5
- ORIGINAL_ITEM
- RPM Pe Expl Helper Gtt-00
- PURCHASE_TYPE
- 0
- ORIGINAL_PE_ID
- 1000000005
- ZONE_NODE_TYPE
- 5
- ZONE_DISPLAY_ID
- 1000000005
- NEED_EXPLODE_IND
- 5
- ORIGINAL_DIFF_ID
- EDGE-RPM_P
- ORIGINAL_ZONE_ID
- 1000000005
- PRIMARY_SUPPLIER
- 5
Rule Validation Summary
- Source Rule Count
- 36
- Governed Rule Count
- 31