RPM Svc Promo Offer Cond Merch

The process_id is the ID of the current induction run.

The chunk_id breaks up the data under a process_id for concurrent processing.

The row ID. Oracle Retail target column ROW_SEQ on RPM_SVC_PROMO_OFFER_COND_MERCH.

The action for the row: NEW, MOD, DEL.

The status of the row: 'N'ew, 'E'rror, 'W'arning, 'P'rocessed, 'I' - Processing, 'S' - Skipped.

The grouping column for new offers.

The offer ID of the row. Oracle Retail target column OFFER_ID on RPM_SVC_PROMO_OFFER_COND_MERCH.

The offer display of the row. Oracle Retail target column OFFER_DISPLAY_ID on RPM_SVC_PROMO_OFFER_COND_MERCH.

The offer start date. Oracle Retail target column OFFER_START_DATE on RPM_SVC_PROMO_OFFER_COND_MERCH.

The offer end date. Oracle Retail target column OFFER_END_DATE on RPM_SVC_PROMO_OFFER_COND_MERCH.

The condition ID of the row. Oracle Retail target column COND_ID on RPM_SVC_PROMO_OFFER_COND_MERCH.

The condition display of the row.

The offer condition merch ID of the row.

The merchandise level of the offer condition. Valid values are in code_detail table with code_type of 'OFIL' excludes Item List and Upload List for induction.

The department of the row. Oracle Retail target column DEPT on RPM_SVC_PROMO_OFFER_COND_MERCH.

The class of the row. Oracle Retail target column CLASS on RPM_SVC_PROMO_OFFER_COND_MERCH.

The subclass of the row. Oracle Retail target column SUBCLASS on RPM_SVC_PROMO_OFFER_COND_MERCH.

The item of the row. Oracle Retail target column ITEM on RPM_SVC_PROMO_OFFER_COND_MERCH.

The diff_id of the row. Oracle Retail target column DIFF_ID on RPM_SVC_PROMO_OFFER_COND_MERCH.

The exclude indicator of the row.

The reason code for the cancel.

Holds the supplier site information of the selected merch.

Holds the brand information of the selected merch.

The error message for the row.

Indicates if a lower level merch record exists on the ops table already that this record will override.

This column will indicate whether the promotion offer is cancelled or not

The Date when the offer is cancelled