RPM Service Clearance Bak

In Scope

Technical: 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(5)

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
default	RPM Svc Cl	3	1000000003	1000000003	RPM Svc Clearance Bak-002	RPM Sv	3	RPM Svc Clearance Bak-002	ALT-RPM_SV	3	RPM Svc Clearance Bak-002-ALT	RPM Sv	ALT-RP	RPM Svc Clearance Bak-002-ALT	3	1000000003	R	0	3	RPM Sv	12.5000	RPM Sv	3	3	2026-01-03	PENDING-AL	0	RPM	3	ALT-RPM_SVC-002	RPM	3	1000000003	12.5000	ALT-RPM_SVC-002	RPM Svc Clearance Bak-002-ALT	1000000003	12.5000	2026-01-03	RPM	1000000003	2026-01-03	RPM	3	ALT-RPM_SVC-002
default	RPM Svc Cl	5	1000000005	1000000005	RPM Svc Clearance Bak-003	RPM Sv	5	RPM Svc Clearance Bak-003	EDGE-RPM_S	5	RPM Svc Clearance Bak-003-EDGE	RPM Sv	EDGE-R	RPM Svc Clearance Bak-003-EDGE	5	1000000005	R	0	5	RPM Sv	14.0000	RPM Sv	5	5	2026-01-05	ACTIVE-EDG	0	RPM	5	EDGE-RPM_SVC-003	RPM	5	1000000005	14.0000	EDGE-RPM_SVC-00	RPM Svc Clearance Bak-003-EDGE	1000000005	14.0000	2026-01-05	RPM	1000000005	2026-01-05	RPM	5	EDGE-RPM_SVC-00

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

default

ACTIONR: RPM Svc Cl
ROW_SEQR: 3
CHUNK_IDR: 1000000003
PROCESS_IDR: 1000000003
ITEM: RPM Svc Clearance Bak-002
STATE: RPM Sv
CC_REQ: 3
SOURCE: RPM Svc Clearance Bak-002
DIFF_ID: ALT-RPM_SV
LOCATION: 3
ERROR_MSG: RPM Svc Clearance Bak-002-ALT
CHANGE_TYPE: RPM Sv
REASON_CODE: ALT-RP
SOURCE_FILE: RPM Svc Clearance Bak-002-ALT
START_STATE: 3
CLEARANCE_ID: 1000000003
GENERATED_BY: R
IL_OWNED_IND: 0
IL_RANGE_IND: 3
MARKDOWN_NBR: RPM Sv
CHANGE_AMOUNT: 12.5000
LOCATION_TYPE: RPM Sv
NEW_GRP_BATCH: 3
PURCHASE_TYPE: 3
EFFECTIVE_DATE: 2026-01-03
PROCESS$STATUS: PENDING-AL
NEED_EXPLODE_IND: 0
PRICE_EVENT_TYPE: RPM
PRIMARY_SUPPLIER: 3
ROUNDING_RULE_ID: ALT-RPM_SVC-002
LOCATION_CURRENCY: RPM
START_CHANGE_TYPE: 3
CLEARANCE_GROUP_ID: 1000000003
START_CHANGE_AMOUNT: 12.5000
CLEARANCE_DISPLAY_ID: ALT-RPM_SVC-002
CLEARANCE_GROUP_DESC: RPM Svc Clearance Bak-002-ALT
LOCATION_INTERNAL_ID: 1000000003
START_CHANGE_PERCENT: 12.5000
START_EFFECTIVE_DATE: 2026-01-03
START_CHANGE_CURRENCY: RPM
START_ROUNDING_RULE_ID: 1000000003
UPDATED_EFFECTIVE_DATE: 2026-01-03
START_CHANGE_SELLING_UOM: RPM
ROUNDING_RULE_ID_INTERNAL: 3
CLEARANCE_GROUP_DISPLAY_ID: ALT-RPM_SVC-002