Clearance Data For The Induction Process

In Scope

Technical: RPM_SVC_CLEARANCE | ID: OR-PRC-RPM_SVC_CLEARANCE-RPM_SERVICE_CLEARANCE

Stores the clearance data for the induction process.

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

Field Definitions(5)

Rules & Considerations(48)

validation

constraint

Sample Load Data(4)

_scenario	ACTIONR	ROW_SEQRPK	CHUNK_IDR	PROCESS_IDRPK	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-002-ALT	RPM Sv	0	RPM Svc Clearance-002-ALT	ALT-RPM_SV	3	RPM Svc Clearance-002-ALT	RPM Sv	ALT-RP	RPM Svc Clearance-002-ALT	3	1000000003	S	0	0	RPM Sv	12.5000	RPM Sv	3	1	2026-01-03	N	0	RPM	3	ALT-RPM_SVC-002	RPM	3	1000000003	12.5000	ALT-RPM_SVC-002	RPM Svc Clearance-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-003-EDG	RPM Sv	0	RPM Svc Clearance-003-EDG	EDGE-RPM_S	5	RPM Svc Clearance-003-EDGE	RPM Sv	EDGE-R	RPM Svc Clearance-003-EDGE	5	1000000005	S	0	0	RPM Sv	14.0000	RPM Sv	5	0	2026-01-05	N	0	RPM	5	EDGE-RPM_SVC-003	RPM	5	1000000005	14.0000	EDGE-RPM_SVC-00	RPM Svc Clearance-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_SEQRPK: 1
CHUNK_IDR: 1
PROCESS_IDRPK: 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_SEQRPK: 3
CHUNK_IDR: 1000000003
PROCESS_IDRPK: 1000000003
ITEM: RPM Svc Clearance-002-ALT
STATE: RPM Sv
CC_REQ: 0
SOURCE: RPM Svc Clearance-002-ALT
DIFF_ID: ALT-RPM_SV
LOCATION: 3
ERROR_MSG: RPM Svc Clearance-002-ALT
CHANGE_TYPE: RPM Sv
REASON_CODE: ALT-RP
SOURCE_FILE: RPM Svc Clearance-002-ALT
START_STATE: 3
CLEARANCE_ID: 1000000003
GENERATED_BY: S
IL_OWNED_IND: 0
IL_RANGE_IND: 0
MARKDOWN_NBR: RPM Sv
CHANGE_AMOUNT: 12.5000
LOCATION_TYPE: RPM Sv
NEW_GRP_BATCH: 3
PURCHASE_TYPE: 1
EFFECTIVE_DATE: 2026-01-03
PROCESS$STATUS: N
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-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