RPM Service Clearance Bak
In ScopeTechnical: RPM_SVC_CLEARANCE_BAK | ID: OR-PRC-RPM_SVC_CLEARANCE_BAK-RPM_SERVICE_CLEARANCE_BAK
This table is used in purge operation as a backup table for rpm_svc_clearance.
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_SVC_CLEARANCE_BAK
Field Definitions(45)
Rules & Considerations(46)
validation
constraint
Sample Load Data(4)
| _scenario | ACTIONR | ROW_SEQR | CHUNK_IDR | PROCESS_IDR | ITEM | STATE | CC_REQ | SOURCE | DIFF_ID | LOCATION | ERROR_MSG | CHANGE_TYPE | REASON_CODE | SOURCE_FILE | START_STATE | CLEARANCE_ID | GENERATED_BY | IL_OWNED_IND | IL_RANGE_IND | MARKDOWN_NBR | CHANGE_AMOUNT | LOCATION_TYPE | NEW_GRP_BATCH | PURCHASE_TYPE | EFFECTIVE_DATE | PROCESS$STATUS | NEED_EXPLODE_IND | PRICE_EVENT_TYPE | PRIMARY_SUPPLIER | ROUNDING_RULE_ID | LOCATION_CURRENCY | START_CHANGE_TYPE | CLEARANCE_GROUP_ID | START_CHANGE_AMOUNT | CLEARANCE_DISPLAY_ID | CLEARANCE_GROUP_DESC | LOCATION_INTERNAL_ID | START_CHANGE_PERCENT | START_EFFECTIVE_DATE | START_CHANGE_CURRENCY | START_ROUNDING_RULE_ID | UPDATED_EFFECTIVE_DATE | START_CHANGE_SELLING_UOM | ROUNDING_RULE_ID_INTERNAL | CLEARANCE_GROUP_DISPLAY_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | S | 1 | 1 | SAMPLE | 1.0000 | SAMPLE | 1 | 1 | 2026-01-01 | SAMPLE | 1 | SAM | 1 | SAMPLE | SAM | 1 | 1 | 1.0000 | SAMPLE | SAMPLE | 1 | 1.0000 | 2026-01-01 | SAM | 1 | 2026-01-01 | SAMP | 1 | SAMPLE |
Example values from field definitions
- ACTIONR
- SAMPLE
- ROW_SEQR
- 1
- CHUNK_IDR
- 1
- PROCESS_IDR
- 1
- ITEM
- SAMPLE
- STATE
- SAMPLE
- CC_REQ
- 1
- SOURCE
- SAMPLE
- DIFF_ID
- SAMPLE
- LOCATION
- 1
- ERROR_MSG
- SAMPLE
- CHANGE_TYPE
- SAMPLE
- REASON_CODE
- SAMPLE
- SOURCE_FILE
- SAMPLE
- START_STATE
- 1
- CLEARANCE_ID
- 1
- GENERATED_BY
- S
- IL_OWNED_IND
- 1
- IL_RANGE_IND
- 1
- MARKDOWN_NBR
- SAMPLE
- CHANGE_AMOUNT
- 1.0000
- LOCATION_TYPE
- SAMPLE
- NEW_GRP_BATCH
- 1
- PURCHASE_TYPE
- 1
- EFFECTIVE_DATE
- 2026-01-01
- PROCESS$STATUS
- SAMPLE
- NEED_EXPLODE_IND
- 1
- PRICE_EVENT_TYPE
- SAM
- PRIMARY_SUPPLIER
- 1
- ROUNDING_RULE_ID
- SAMPLE
- LOCATION_CURRENCY
- SAM
- START_CHANGE_TYPE
- 1
- CLEARANCE_GROUP_ID
- 1
- START_CHANGE_AMOUNT
- 1.0000
- CLEARANCE_DISPLAY_ID
- SAMPLE
- CLEARANCE_GROUP_DESC
- SAMPLE
- LOCATION_INTERNAL_ID
- 1
- START_CHANGE_PERCENT
- 1.0000
- START_EFFECTIVE_DATE
- 2026-01-01
- START_CHANGE_CURRENCY
- SAM
- START_ROUNDING_RULE_ID
- 1
- UPDATED_EFFECTIVE_DATE
- 2026-01-01
- START_CHANGE_SELLING_UOM
- SAMP
- ROUNDING_RULE_ID_INTERNAL
- 1
- CLEARANCE_GROUP_DISPLAY_ID
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 55
- Governed Rule Count
- 46