RPM Price Event Payload

primary key of price event Oracle Retail target column PRICE_EVENT_PAYLOAD_ID on RPM_PRICE_EVENT_PAYLOAD.

the message family. Oracle Retail target column MSG_FAMILY on RPM_PRICE_EVENT_PAYLOAD.

The message type. Oracle Retail target column MSG_TYPE on RPM_PRICE_EVENT_PAYLOAD.

default value should be 0 Oracle Retail target column PUBLISH_STATUS on RPM_PRICE_EVENT_PAYLOAD.

published date of event Oracle Retail target column PUBLISH_DATE on RPM_PRICE_EVENT_PAYLOAD.

A unique identifier of a bulk conflict check process

Identifies the parent_thread_number for the record under the given bulk_cc_pe_id used by conflict checking to bring data from multiple threads under one header record.

Identifies the thread_number for the record under the given bulk_cc_pe_id and parent_thread_number combination used by some conflict checking to bring data from multiple threads under one header record.

This field indicate whether the publish batch that generate flat file for the events from the payload has been run or not. Valid value are: 0 - means flat file has been generated, 1 - means flat file has not been generated.

Flat File Extract Date. Oracle Retail target column FLAT_FILE_EXTRACT_DATE on RPM_PRICE_EVENT_PAYLOAD.

Indicates if the associated payload data has been extracted by SIOCS or not. Valid values are 0 (not extracted) and 1 (extracted).

Date and time that the associated payload data was marked as extracted by SIOCS.

Indicates the date and time when associated data was processed for updating the corresponding JSON cache.

Indicates if the associated data has been processed for updating the corresponding JSON cache. Valid values are 0 (not processed) and 1 (processed).

Indicates if the associated data has been processed for staging for replication to RDS. Valid values are 0 (not processed) and 1 (processed).

Indicates the date and time when associated data was processed for staging for replication to RDS.