RPM Rfr Gtt Data Capture
Out of ScopeTechnical: RPM_RFR_GTT_DATA_CAPTURE | ID: OR-PRC-RPM_RFR_GTT_DATA_CAPTURE-RPM_RFR_GTT_DATA_CAPTURE
This table will hold data captured from the RPM_FUTURE_RETAIL_GTT table. New records will be created on this table when the system is configured to capture GTT data to assist with...
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_RFR_GTT_DATA_CAPTURE
Field Definitions(5)
Rules & Considerations(76)
validation
constraint
Sample Load Data(4)
| _scenario | BULK_CC_PE_IDR | THREAD_NUMBERR | PARENT_THREAD_NUMBERR | DT_TIMEYTIMESTAMP(6)116PRICE_EVENT_IDR | DEPT | ITEM | CLASS | DIFF_ID | DT_TIME | LOCATION | SUBCLASS | CLEAR_UOM | ACTION_DATE | MULTI_UNITS | PC_MSG_TYPE | SELLING_UOM | CHUNK_NUMBER | CLEARANCE_ID | CLEAR_RETAIL | TIMELINE_SEQ | CLEAR_MSG_TYPE | CUR_HIER_LEVEL | MAX_HIER_LEVEL | ORIGINAL_FR_ID | PC_CHANGE_TYPE | PC_MULTI_UNITS | PRICE_EVENT_ID | SELLING_RETAIL | ZONE_NODE_TYPE | CLEAR_START_IND | PRICE_CHANGE_ID | STEP_IDENTIFIER | CLEAR_MKDN_INDEX | FUTURE_RETAIL_ID | PC_CHANGE_AMOUNT | CLEAR_CHANGE_TYPE | MULTI_UNIT_RETAIL | PC_CHANGE_PERCENT | PC_CHANGE_CURRENCY | CLEAR_CHANGE_AMOUNT | PC_ROUNDING_RULE_ID | CLEARANCE_DISPLAY_ID | CLEAR_CHANGE_PERCENT | PC_MULTI_UNIT_IMPACT | PC_MULTI_UNIT_RETAIL | CLEAR_CHANGE_CURRENCY | CLEAR_RETAIL_CURRENCY | PC_CHANGE_SELLING_UOM | PC_SELLING_RETAIL_IND | CLEAR_ROUNDING_RULE_ID | MULTI_UNIT_SELLING_UOM | PC_EXCEPTION_PARENT_ID | PRICE_CHANGE_DISPLAY_ID | SELLING_RETAIL_CURRENCY | CLEAR_CHANGE_SELLING_UOM | CLEAR_EXCEPTION_PARENT_ID | PC_MULTI_UNIT_SELLING_UOM | MULTI_UNIT_RETAIL_CURRENCY | PC_MULTI_UNIT_RETAIL_CURRENCY | RFR_ROWIDNROWID1055ITEM_PARENT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | SAMPLE | 1 | SAMPLE | 2026-01-01 12:00:00 | 1 | 1 | SAMP | 2026-01-01 | 1.0000 | SAMPLE | SAMP | 1 | 1 | 1.0000 | 1 | SAMPLE | SA | SA | 1 | 1 | 1.0000 | 1 | 1.0000 | 1 | 1 | 1 | 1 | 1 | 1 | 1.0000 | 1 | 1.0000 | 1.0000 | SAM | 1.0000 | 1 | SAMPLE | 1.0000 | SA | 1.0000 | SAM | SAM | SAMP | 1 | 1 | SAMP | 1 | SAMPLE | SAM | SAMP | 1 | SAMP | SAM | SAM | SAMPLE |
| default | 1000000003 | 3 | 3 | 1000000003 | 1003 | RPM Rfr Gtt Data Capture- | 1103 | ALT-RPM_RF | — | 3 | 1113 | RPM | 2026-01-03 | 12.5000 | RPM Rfr Gtt Data Capture-002-A | RPM | 3 | 1000000003 | 12.5000 | 3 | RPM Rfr Gtt Data Capture-002-A | RP | RP | 1000000003 | 3 | 12.5000 | — | 12.5000 | 3 | 3 | 1000000003 | 3 | 3 | 1000000003 | 12.5000 | 3 | 12.5000 | 12.5000 | RPM | 12.5000 | 1000000003 | ALT-RPM_RFR-002 | 12.5000 | R | 12.5000 | RPM | RPM | RPM | 3 | 1000000003 | RPM | 1000000003 | ALT-RPM_RFR-002 | RPM | RPM | 1000000003 | RPM | RPM | RPM | RPM Rfr Gtt Data Capture- |
| default | 1000000005 | 5 | 5 | 1000000005 | 1005 | RPM Rfr Gtt Data Capture- | 1105 | EDGE-RPM_R | — | 5 | 1115 | RPM | 2026-01-05 | 14.0000 | RPM Rfr Gtt Data Capture-003-E | RPM | 5 | 1000000005 | 14.0000 | 5 | RPM Rfr Gtt Data Capture-003-E | RP | RP | 1000000005 | 5 | 14.0000 | — | 14.0000 | 5 | 5 | 1000000005 | 5 | 5 | 1000000005 | 14.0000 | 5 | 14.0000 | 14.0000 | RPM | 14.0000 | 1000000005 | EDGE-RPM_RFR-00 | 14.0000 | AU | 14.0000 | RPM | RPM | RPM | 5 | 1000000005 | RPM | 1000000005 | EDGE-RPM_RFR-00 | RPM | RPM | 1000000005 | RPM | RPM | RPM | RPM Rfr Gtt Data Capture- |
Example values from field definitions
- BULK_CC_PE_IDR
- 1
- THREAD_NUMBERR
- 1
- PARENT_THREAD_NUMBERR
- 1
- DT_TIMEYTIMESTAMP(6)116PRICE_EVENT_IDR
- 1
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- DIFF_ID
- SAMPLE
- DT_TIME
- 2026-01-01 12:00:00
- LOCATION
- 1
- SUBCLASS
- 1
- CLEAR_UOM
- SAMP
- ACTION_DATE
- 2026-01-01
- MULTI_UNITS
- 1.0000
- PC_MSG_TYPE
- SAMPLE
- SELLING_UOM
- SAMP
- CHUNK_NUMBER
- 1
- CLEARANCE_ID
- 1
- CLEAR_RETAIL
- 1.0000
- TIMELINE_SEQ
- 1
- CLEAR_MSG_TYPE
- SAMPLE
- CUR_HIER_LEVEL
- SA
- MAX_HIER_LEVEL
- SA
- ORIGINAL_FR_ID
- 1
- PC_CHANGE_TYPE
- 1
- PC_MULTI_UNITS
- 1.0000
- PRICE_EVENT_ID
- 1
- SELLING_RETAIL
- 1.0000
- ZONE_NODE_TYPE
- 1
- CLEAR_START_IND
- 1
- PRICE_CHANGE_ID
- 1
- STEP_IDENTIFIER
- 1
- CLEAR_MKDN_INDEX
- 1
- FUTURE_RETAIL_ID
- 1
- PC_CHANGE_AMOUNT
- 1.0000
- CLEAR_CHANGE_TYPE
- 1
- MULTI_UNIT_RETAIL
- 1.0000
- PC_CHANGE_PERCENT
- 1.0000
- PC_CHANGE_CURRENCY
- SAM
- CLEAR_CHANGE_AMOUNT
- 1.0000
- PC_ROUNDING_RULE_ID
- 1
- CLEARANCE_DISPLAY_ID
- SAMPLE
- CLEAR_CHANGE_PERCENT
- 1.0000
- PC_MULTI_UNIT_IMPACT
- SA
- PC_MULTI_UNIT_RETAIL
- 1.0000
- CLEAR_CHANGE_CURRENCY
- SAM
- CLEAR_RETAIL_CURRENCY
- SAM
- PC_CHANGE_SELLING_UOM
- SAMP
- PC_SELLING_RETAIL_IND
- 1
- CLEAR_ROUNDING_RULE_ID
- 1
- MULTI_UNIT_SELLING_UOM
- SAMP
- PC_EXCEPTION_PARENT_ID
- 1
- PRICE_CHANGE_DISPLAY_ID
- SAMPLE
- SELLING_RETAIL_CURRENCY
- SAM
- CLEAR_CHANGE_SELLING_UOM
- SAMP
- CLEAR_EXCEPTION_PARENT_ID
- 1
- PC_MULTI_UNIT_SELLING_UOM
- SAMP
- MULTI_UNIT_RETAIL_CURRENCY
- SAM
- PC_MULTI_UNIT_RETAIL_CURRENCY
- SAM
- RFR_ROWIDNROWID1055ITEM_PARENT
- SAMPLE
default
- BULK_CC_PE_IDR
- 1000000003
- THREAD_NUMBERR
- 3
- PARENT_THREAD_NUMBERR
- 3
- DT_TIMEYTIMESTAMP(6)116PRICE_EVENT_IDR
- 1000000003
- DEPT
- 1003
- ITEM
- RPM Rfr Gtt Data Capture-
- CLASS
- 1103
- DIFF_ID
- ALT-RPM_RF
- DT_TIME
- —
- LOCATION
- 3
- SUBCLASS
- 1113
- CLEAR_UOM
- RPM
- ACTION_DATE
- 2026-01-03
- MULTI_UNITS
- 12.5000
- PC_MSG_TYPE
- RPM Rfr Gtt Data Capture-002-A
- SELLING_UOM
- RPM
- CHUNK_NUMBER
- 3
- CLEARANCE_ID
- 1000000003
- CLEAR_RETAIL
- 12.5000
- TIMELINE_SEQ
- 3
- CLEAR_MSG_TYPE
- RPM Rfr Gtt Data Capture-002-A
- CUR_HIER_LEVEL
- RP
- MAX_HIER_LEVEL
- RP
- ORIGINAL_FR_ID
- 1000000003
- PC_CHANGE_TYPE
- 3
- PC_MULTI_UNITS
- 12.5000
- PRICE_EVENT_ID
- —
- SELLING_RETAIL
- 12.5000
- ZONE_NODE_TYPE
- 3
- CLEAR_START_IND
- 3
- PRICE_CHANGE_ID
- 1000000003
- STEP_IDENTIFIER
- 3
- CLEAR_MKDN_INDEX
- 3
- FUTURE_RETAIL_ID
- 1000000003
- PC_CHANGE_AMOUNT
- 12.5000
- CLEAR_CHANGE_TYPE
- 3
- MULTI_UNIT_RETAIL
- 12.5000
- PC_CHANGE_PERCENT
- 12.5000
- PC_CHANGE_CURRENCY
- RPM
- CLEAR_CHANGE_AMOUNT
- 12.5000
- PC_ROUNDING_RULE_ID
- 1000000003
- CLEARANCE_DISPLAY_ID
- ALT-RPM_RFR-002
- CLEAR_CHANGE_PERCENT
- 12.5000
- PC_MULTI_UNIT_IMPACT
- R
- PC_MULTI_UNIT_RETAIL
- 12.5000
- CLEAR_CHANGE_CURRENCY
- RPM
- CLEAR_RETAIL_CURRENCY
- RPM
- PC_CHANGE_SELLING_UOM
- RPM
- PC_SELLING_RETAIL_IND
- 3
- CLEAR_ROUNDING_RULE_ID
- 1000000003
- MULTI_UNIT_SELLING_UOM
- RPM
- PC_EXCEPTION_PARENT_ID
- 1000000003
- PRICE_CHANGE_DISPLAY_ID
- ALT-RPM_RFR-002
- SELLING_RETAIL_CURRENCY
- RPM
- CLEAR_CHANGE_SELLING_UOM
- RPM
- CLEAR_EXCEPTION_PARENT_ID
- 1000000003
- PC_MULTI_UNIT_SELLING_UOM
- RPM
- MULTI_UNIT_RETAIL_CURRENCY
- RPM
- PC_MULTI_UNIT_RETAIL_CURRENCY
- RPM
- RFR_ROWIDNROWID1055ITEM_PARENT
- RPM Rfr Gtt Data Capture-
default
- BULK_CC_PE_IDR
- 1000000005
- THREAD_NUMBERR
- 5
- PARENT_THREAD_NUMBERR
- 5
- DT_TIMEYTIMESTAMP(6)116PRICE_EVENT_IDR
- 1000000005
- DEPT
- 1005
- ITEM
- RPM Rfr Gtt Data Capture-
- CLASS
- 1105
- DIFF_ID
- EDGE-RPM_R
- DT_TIME
- —
- LOCATION
- 5
- SUBCLASS
- 1115
- CLEAR_UOM
- RPM
- ACTION_DATE
- 2026-01-05
- MULTI_UNITS
- 14.0000
- PC_MSG_TYPE
- RPM Rfr Gtt Data Capture-003-E
- SELLING_UOM
- RPM
- CHUNK_NUMBER
- 5
- CLEARANCE_ID
- 1000000005
- CLEAR_RETAIL
- 14.0000
- TIMELINE_SEQ
- 5
- CLEAR_MSG_TYPE
- RPM Rfr Gtt Data Capture-003-E
- CUR_HIER_LEVEL
- RP
- MAX_HIER_LEVEL
- RP
- ORIGINAL_FR_ID
- 1000000005
- PC_CHANGE_TYPE
- 5
- PC_MULTI_UNITS
- 14.0000
- PRICE_EVENT_ID
- —
- SELLING_RETAIL
- 14.0000
- ZONE_NODE_TYPE
- 5
- CLEAR_START_IND
- 5
- PRICE_CHANGE_ID
- 1000000005
- STEP_IDENTIFIER
- 5
- CLEAR_MKDN_INDEX
- 5
- FUTURE_RETAIL_ID
- 1000000005
- PC_CHANGE_AMOUNT
- 14.0000
- CLEAR_CHANGE_TYPE
- 5
- MULTI_UNIT_RETAIL
- 14.0000
- PC_CHANGE_PERCENT
- 14.0000
- PC_CHANGE_CURRENCY
- RPM
- CLEAR_CHANGE_AMOUNT
- 14.0000
- PC_ROUNDING_RULE_ID
- 1000000005
- CLEARANCE_DISPLAY_ID
- EDGE-RPM_RFR-00
- CLEAR_CHANGE_PERCENT
- 14.0000
- PC_MULTI_UNIT_IMPACT
- AU
- PC_MULTI_UNIT_RETAIL
- 14.0000
- CLEAR_CHANGE_CURRENCY
- RPM
- CLEAR_RETAIL_CURRENCY
- RPM
- PC_CHANGE_SELLING_UOM
- RPM
- PC_SELLING_RETAIL_IND
- 5
- CLEAR_ROUNDING_RULE_ID
- 1000000005
- MULTI_UNIT_SELLING_UOM
- RPM
- PC_EXCEPTION_PARENT_ID
- 1000000005
- PRICE_CHANGE_DISPLAY_ID
- EDGE-RPM_RFR-00
- SELLING_RETAIL_CURRENCY
- RPM
- CLEAR_CHANGE_SELLING_UOM
- RPM
- CLEAR_EXCEPTION_PARENT_ID
- 1000000005
- PC_MULTI_UNIT_SELLING_UOM
- RPM
- MULTI_UNIT_RETAIL_CURRENCY
- RPM
- PC_MULTI_UNIT_RETAIL_CURRENCY
- RPM
- RFR_ROWIDNROWID1055ITEM_PARENT
- RPM Rfr Gtt Data Capture-
Rule Validation Summary
- Source Rule Count
- 82
- Governed Rule Count
- 76