RPM Icl Price Event Payload
In ScopeTechnical: 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(8)
Rules & Considerations(16)
validation
constraint
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 |
|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | S | SA | S | SAMPLE | 1 | SAMPLE | SAMPLE |
Example values from field definitions
- ICL_TABLE_NAMER
- SAMPLE
- ICL_CHANGE_TYPER
- S
- PRICE_EVENT_TYPER
- SA
- ICL_PROCESSED_INDR
- S
- ICL_TRANSACTION_IDR
- SAMPLE
- PRICE_EVENT_PAYLOAD_IDR
- 1
- ICL_IDYYRAW16SYS_GUID()2ICL_CONSUMERR
- SAMPLE
- ICL_CREATE_TIMESTAMPYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE6ICL_CREATE_IDR
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 21
- Governed Rule Count
- 16