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