RPM Icl Price Event Payload

In Scope

Technical: RPM_ICL_PRICE_EVENT_PAYLOAD | ID: OR-PRC-RPM_ICL_PRICE_EVENT_PAYLOAD-RPM_ICL_PRICE_EVENT_PAYLOAD

Stores a log of when Price Change and Clearance data has been processed through the Conflict Checking engine and is to be picked up by SIOCS for extraction.

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_ICL_PRICE_EVENT_PAYLOAD

Field Definitions(5)

Rules & Considerations(16)

validation

constraint

Sample Load Data(4)

_scenario	ICL_TABLE_NAMER	ICL_CHANGE_TYPER	PRICE_EVENT_TYPE	ICL_PROCESSED_IND	ICL_TRANSACTION_ID	PRICE_EVENT_PAYLOAD_ID	ICL_IDYYRAW16SYS_GUID()2ICL_CONSUMER	ICL_CREATE_TIMESTAMPYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE6ICL_CREATE_ID
Example values from field definitions	SAMPLE	S	SA	S	SAMPLE	1	SAMPLE	SAMPLE
default	RPM Icl Price Event Payload Se	I	RP	i	ALT-RPM_ICL-002	1000000003	RPM Icl Price Event Payload-002-ALT	APP_USER_ID
default	RPM Icl Price Event Payload Co	I	RP	N	EDGE-RPM_ICL-003	1000000005	RPM Icl Price Event Payload-003-EDGE	USERENV

Example values from field definitions

ICL_TABLE_NAMER: SAMPLE
ICL_CHANGE_TYPER: S
PRICE_EVENT_TYPE: SA
ICL_PROCESSED_IND: S
ICL_TRANSACTION_ID: SAMPLE
PRICE_EVENT_PAYLOAD_ID: 1
ICL_IDYYRAW16SYS_GUID()2ICL_CONSUMER: SAMPLE
ICL_CREATE_TIMESTAMPYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE6ICL_CREATE_ID: SAMPLE

default

ICL_TABLE_NAMER: RPM Icl Price Event Payload Se
ICL_CHANGE_TYPER: I
PRICE_EVENT_TYPE: RP
ICL_PROCESSED_IND: i
ICL_TRANSACTION_ID: ALT-RPM_ICL-002
PRICE_EVENT_PAYLOAD_ID: 1000000003
ICL_IDYYRAW16SYS_GUID()2ICL_CONSUMER: RPM Icl Price Event Payload-002-ALT
ICL_CREATE_TIMESTAMPYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE6ICL_CREATE_ID: APP_USER_ID