RPM Icl Price Event Payload

Oracle Retail target column ICL_IDYYRAW16SYS_GUID()2ICL_CONSUMER on RPM_ICL_PRICE_EVENT_PAYLOAD.

Indicates the change type of the source table that resulted in the record being written. The only valid value is: 'I'nsert.

Indicates the source table that has changed which resulted in the record being written. The only valid value is 'RPM_PRICE_EVENT_PAYLOAD'.

Oracle Retail target column ICL_CREATE_TIMESTAMPYTIMESTAMP(6)WITHTIMEZONE13SYSTIMESTAMPATTIMEZONEDBTIMEZONE6ICL_CREATE_ID on RPM_ICL_PRICE_EVENT_PAYLOAD.

Transaction ID of the transaction in which the record was committed in the source table. Populated via dbms_transaction.local_transaction_id.

Indicates if the record has been processed by the consuming application. Valid values are: 'N' (not processed), 'Y' (processed), 'I' (in-progress). Updated by the consuming applincation as needed.

The price event payload id value used to look up data on RPM_PRICE_EVENT_PAYLOAD and associated views for SIOCS data extraction.

The type of price event associated with the record. Valid values are 'PC' for Price Change and 'CL' for Clearance.