RPM Icl Price Event Payload
In ScopeTechnical: RPM_ICL_PRICE_EVENT_PAYLOAD | ID: OR-RPCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_ICL_PRICE_EVENT_PAYLOAD
Field Definitions(8)
Rules & Considerations(30)
Sample Load Data(4)
| _scenario | ICL_TABLE_NAMER | ICL_CHANGE_TYPER | PRICE_EVENT_TYPER | ICL_PROCESSED_INDR | ICL_TRANSACTION_IDR | PRICE_EVENT_PAYLOAD_IDR | ICL_IDYYRAW16SYS_GUID()2ICL_CONSUMERR | ICL_CREATE_TIMESTAMPYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE6ICL_CREATE_IDR |
|---|---|---|---|---|---|---|---|---|
| default | RPM Icl Price Event Payload Primary | I | RPM Icl Price Event Payload-001 | N | STD-RPM_ICL-001 | 1000000001 | RPM Icl Price Event Payload-001 | RETAIL_CTX |
default
- ICL_TABLE_NAMER
- RPM Icl Price Event Payload Primary
- ICL_CHANGE_TYPER
- I
- PRICE_EVENT_TYPER
- RPM Icl Price Event Payload-001
- ICL_PROCESSED_INDR
- N
- ICL_TRANSACTION_IDR
- STD-RPM_ICL-001
- PRICE_EVENT_PAYLOAD_IDR
- 1000000001
- ICL_IDYYRAW16SYS_GUID()2ICL_CONSUMERR
- RPM Icl Price Event Payload-001
- ICL_CREATE_TIMESTAMPYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE6ICL_CREATE_IDR
- RETAIL_CTX