RPM Oi Clr Pend Apprv Day
In ScopeTechnical: RPM_OI_CLR_PEND_APPRV_DAY | ID: OR-PRC-RPM_OI_CLR_PEND_APPRV_DAY-RPM_OI_CLR_PEND_APPRV_DAY
Stores the count of unapproved clearances that are scheduled to be effective in next 7 days.
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_OI_CLR_PEND_APPRV_DAY
Field Definitions(5)
Rules & Considerations(20)
validation
constraint
Sample Load Data(4)
| _scenario | SESSION_IDRPK | EFFECTIVE_DATER | CLEARANCE_GROUP_IDR | CLEARANCE_GROUP_DESCR | CLEARANCE_GROUP_DISPLAY_IDR | CONFLICT_IND | RESET_WITH_CONFLICT | MARKDOWN_WITH_CONFLICT | RESET_WITHOUT_CONFLICT | MARKDOWN_WITHOUT_CONFLICT |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 2026-01-01 | 1 | SAMPLE | SAMPLE | 1 | 1 | 1 | 1 | 1 |
| default | 1000000003 | 2026-01-03 | 1000000003 | RPM Oi Clr Pend Apprv Day-002-ALT | ALT-RPM_OI-002 | 3 | 3 | 3 | 3 | 3 |
| default | 1000000005 | 2026-01-05 | 1000000005 | RPM Oi Clr Pend Apprv Day-003-EDGE | EDGE-RPM_OI-003 | 5 | 5 | 5 | 5 | 5 |
Example values from field definitions
- SESSION_IDRPK
- 1
- EFFECTIVE_DATER
- 2026-01-01
- CLEARANCE_GROUP_IDR
- 1
- CLEARANCE_GROUP_DESCR
- SAMPLE
- CLEARANCE_GROUP_DISPLAY_IDR
- SAMPLE
- CONFLICT_IND
- 1
- RESET_WITH_CONFLICT
- 1
- MARKDOWN_WITH_CONFLICT
- 1
- RESET_WITHOUT_CONFLICT
- 1
- MARKDOWN_WITHOUT_CONFLICT
- 1
default
- SESSION_IDRPK
- 1000000003
- EFFECTIVE_DATER
- 2026-01-03
- CLEARANCE_GROUP_IDR
- 1000000003
- CLEARANCE_GROUP_DESCR
- RPM Oi Clr Pend Apprv Day-002-ALT
- CLEARANCE_GROUP_DISPLAY_IDR
- ALT-RPM_OI-002
- CONFLICT_IND
- 3
- RESET_WITH_CONFLICT
- 3
- MARKDOWN_WITH_CONFLICT
- 3
- RESET_WITHOUT_CONFLICT
- 3
- MARKDOWN_WITHOUT_CONFLICT
- 3
default
- SESSION_IDRPK
- 1000000005
- EFFECTIVE_DATER
- 2026-01-05
- CLEARANCE_GROUP_IDR
- 1000000005
- CLEARANCE_GROUP_DESCR
- RPM Oi Clr Pend Apprv Day-003-EDGE
- CLEARANCE_GROUP_DISPLAY_IDR
- EDGE-RPM_OI-003
- CONFLICT_IND
- 5
- RESET_WITH_CONFLICT
- 5
- MARKDOWN_WITH_CONFLICT
- 5
- RESET_WITHOUT_CONFLICT
- 5
- MARKDOWN_WITHOUT_CONFLICT
- 5
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 20