RPM Clearance Helper (GTT)
Out of ScopeTechnical: RPM_CLEARANCE_HELPER_GTT | ID: OR-PRC-RPM_CLEARANCE_HELPER_GTT-RPM_CLEARANCE_HELPER_GTT
Helper table for the clearance maintence. A copy of RPM_CLEARANCE with some additional helper columns.
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_CLEARANCE_HELPER_GTT
Field Definitions(5)
Rules & Considerations(59)
constraint
validation
Sample Load Data(4)
| _scenario | CLEARANCE_IDR | CLEARANCE_DISPLAY_IDR | ITEM | STATE | DIFF_ID | NEW_IND | ZONE_ID | LOCATION | CREATE_ID | APPROVAL_ID | CHANGE_TYPE | REASON_CODE | CONFLICT_IND | GENERATED_BY | MARKDOWN_NBR | APPROVAL_DATE | CHANGE_AMOUNT | ORIGINAL_ITEM | PURCHASE_TYPE | CHANGE_PERCENT | EFFECTIVE_DATE | LAST_UPDATE_ID | MASTER_BGE_IND | MASTER_SGE_IND | ZONE_NODE_TYPE | CHANGE_CURRENCY | CREATE_DATETIME | ORIGINAL_DIFF_ID | ORIGINAL_ZONE_ID | PARENT_RESET_IND | PRIMARY_SUPPLIER | ROUNDING_RULE_ID | OBJECT_VERSION_ID | CHANGE_SELLING_UOM | CLEARANCE_GROUP_ID | EXCEPTION_PARENT_ID | LAST_UPDATE_DATETIME | EXCEPTION_FROM_LOC_IND | LOC_EXC_CHILDREN_EXIST | EXCEPTION_FROM_ITEM_IND | ITEM_EXC_CHILDREN_EXIST | SYS_GENERATED_EXCLUSION | BATCH_GENERATED_EXCLUSION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | 1 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | S | SAMPLE | 2026-01-01 | 1.0000 | SAMPLE | 1 | 1.0000 | 2026-01-01 | SAMPLE | 1 | 1 | 1 | SAM | 2026-01-01 | SAMPLE | 1 | 1 | 1 | 1 | 1 | SAMP | 1 | 1 | 2026-01-01 | 1 | 1 | 1 | 1 | 1 | 1 |
| default | 1000000003 | ALT-RPM_CLEARA- | RPM Clearance Helper Gtt- | 3 | ALT-RPM_CL | 3 | 1000000003 | 3 | MDM_USER | ALT-RPM_CLEARA-002 | 1 | ALT-RP | 3 | S | RPM Cl | 2026-01-03 | 12.5000 | RPM Clearance Helper Gtt- | 1 | 12.5000 | 2026-01-03 | MDM_USER | 3 | 3 | 1 | RPM | 2026-01-03 | ALT-RPM_CL | 1000000003 | 3 | 3 | 1000000003 | 1000000003 | RPM | 1000000003 | 1000000003 | 2026-01-03 | 3 | 3 | 3 | 3 | 3 | 3 |
| default | 1000000005 | EDGE-RPM_CLEARA | RPM Clearance Helper Gtt- | 5 | EDGE-RPM_C | 5 | 1000000005 | 5 | BATCH_USER | EDGE-RPM_CLEARA-003 | 2 | EDGE-R | 5 | S | RPM Cl | 2026-01-05 | 14.0000 | RPM Clearance Helper Gtt- | 0 | 14.0000 | 2026-01-05 | BATCH_USER | 5 | 5 | 2 | RPM | 2026-01-05 | EDGE-RPM_C | 1000000005 | 5 | 5 | 1000000005 | 1000000005 | RPM | 1000000005 | 1000000005 | 2026-01-05 | 5 | 5 | 5 | 5 | 5 | 5 |
Example values from field definitions
- CLEARANCE_IDR
- 1
- CLEARANCE_DISPLAY_IDR
- SAMPLE
- ITEM
- SAMPLE
- STATE
- 1
- DIFF_ID
- SAMPLE
- NEW_IND
- 1
- ZONE_ID
- 1
- LOCATION
- 1
- CREATE_ID
- SAMPLE
- APPROVAL_ID
- SAMPLE
- CHANGE_TYPE
- 1
- REASON_CODE
- SAMPLE
- CONFLICT_IND
- 1
- GENERATED_BY
- S
- MARKDOWN_NBR
- SAMPLE
- APPROVAL_DATE
- 2026-01-01
- CHANGE_AMOUNT
- 1.0000
- ORIGINAL_ITEM
- SAMPLE
- PURCHASE_TYPE
- 1
- CHANGE_PERCENT
- 1.0000
- EFFECTIVE_DATE
- 2026-01-01
- LAST_UPDATE_ID
- SAMPLE
- MASTER_BGE_IND
- 1
- MASTER_SGE_IND
- 1
- ZONE_NODE_TYPE
- 1
- CHANGE_CURRENCY
- SAM
- CREATE_DATETIME
- 2026-01-01
- ORIGINAL_DIFF_ID
- SAMPLE
- ORIGINAL_ZONE_ID
- 1
- PARENT_RESET_IND
- 1
- PRIMARY_SUPPLIER
- 1
- ROUNDING_RULE_ID
- 1
- OBJECT_VERSION_ID
- 1
- CHANGE_SELLING_UOM
- SAMP
- CLEARANCE_GROUP_ID
- 1
- EXCEPTION_PARENT_ID
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
- EXCEPTION_FROM_LOC_IND
- 1
- LOC_EXC_CHILDREN_EXIST
- 1
- EXCEPTION_FROM_ITEM_IND
- 1
- ITEM_EXC_CHILDREN_EXIST
- 1
- SYS_GENERATED_EXCLUSION
- 1
- BATCH_GENERATED_EXCLUSION
- 1
default
- CLEARANCE_IDR
- 1000000003
- CLEARANCE_DISPLAY_IDR
- ALT-RPM_CLEARA-
- ITEM
- RPM Clearance Helper Gtt-
- STATE
- 3
- DIFF_ID
- ALT-RPM_CL
- NEW_IND
- 3
- ZONE_ID
- 1000000003
- LOCATION
- 3
- CREATE_ID
- MDM_USER
- APPROVAL_ID
- ALT-RPM_CLEARA-002
- CHANGE_TYPE
- 1
- REASON_CODE
- ALT-RP
- CONFLICT_IND
- 3
- GENERATED_BY
- S
- MARKDOWN_NBR
- RPM Cl
- APPROVAL_DATE
- 2026-01-03
- CHANGE_AMOUNT
- 12.5000
- ORIGINAL_ITEM
- RPM Clearance Helper Gtt-
- PURCHASE_TYPE
- 1
- CHANGE_PERCENT
- 12.5000
- EFFECTIVE_DATE
- 2026-01-03
- LAST_UPDATE_ID
- MDM_USER
- MASTER_BGE_IND
- 3
- MASTER_SGE_IND
- 3
- ZONE_NODE_TYPE
- 1
- CHANGE_CURRENCY
- RPM
- CREATE_DATETIME
- 2026-01-03
- ORIGINAL_DIFF_ID
- ALT-RPM_CL
- ORIGINAL_ZONE_ID
- 1000000003
- PARENT_RESET_IND
- 3
- PRIMARY_SUPPLIER
- 3
- ROUNDING_RULE_ID
- 1000000003
- OBJECT_VERSION_ID
- 1000000003
- CHANGE_SELLING_UOM
- RPM
- CLEARANCE_GROUP_ID
- 1000000003
- EXCEPTION_PARENT_ID
- 1000000003
- LAST_UPDATE_DATETIME
- 2026-01-03
- EXCEPTION_FROM_LOC_IND
- 3
- LOC_EXC_CHILDREN_EXIST
- 3
- EXCEPTION_FROM_ITEM_IND
- 3
- ITEM_EXC_CHILDREN_EXIST
- 3
- SYS_GENERATED_EXCLUSION
- 3
- BATCH_GENERATED_EXCLUSION
- 3
default
- CLEARANCE_IDR
- 1000000005
- CLEARANCE_DISPLAY_IDR
- EDGE-RPM_CLEARA
- ITEM
- RPM Clearance Helper Gtt-
- STATE
- 5
- DIFF_ID
- EDGE-RPM_C
- NEW_IND
- 5
- ZONE_ID
- 1000000005
- LOCATION
- 5
- CREATE_ID
- BATCH_USER
- APPROVAL_ID
- EDGE-RPM_CLEARA-003
- CHANGE_TYPE
- 2
- REASON_CODE
- EDGE-R
- CONFLICT_IND
- 5
- GENERATED_BY
- S
- MARKDOWN_NBR
- RPM Cl
- APPROVAL_DATE
- 2026-01-05
- CHANGE_AMOUNT
- 14.0000
- ORIGINAL_ITEM
- RPM Clearance Helper Gtt-
- PURCHASE_TYPE
- 0
- CHANGE_PERCENT
- 14.0000
- EFFECTIVE_DATE
- 2026-01-05
- LAST_UPDATE_ID
- BATCH_USER
- MASTER_BGE_IND
- 5
- MASTER_SGE_IND
- 5
- ZONE_NODE_TYPE
- 2
- CHANGE_CURRENCY
- RPM
- CREATE_DATETIME
- 2026-01-05
- ORIGINAL_DIFF_ID
- EDGE-RPM_C
- ORIGINAL_ZONE_ID
- 1000000005
- PARENT_RESET_IND
- 5
- PRIMARY_SUPPLIER
- 5
- ROUNDING_RULE_ID
- 1000000005
- OBJECT_VERSION_ID
- 1000000005
- CHANGE_SELLING_UOM
- RPM
- CLEARANCE_GROUP_ID
- 1000000005
- EXCEPTION_PARENT_ID
- 1000000005
- LAST_UPDATE_DATETIME
- 2026-01-05
- EXCEPTION_FROM_LOC_IND
- 5
- LOC_EXC_CHILDREN_EXIST
- 5
- EXCEPTION_FROM_ITEM_IND
- 5
- ITEM_EXC_CHILDREN_EXIST
- 5
- SYS_GENERATED_EXCLUSION
- 5
- BATCH_GENERATED_EXCLUSION
- 5
Rule Validation Summary
- Source Rule Count
- 68
- Governed Rule Count
- 59