RPM Svc Price Change

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_PRICE_CHANGE.

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

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

The price change group the price change belongs to.

The price change group display id.

The price change group description.

The price change ID of the row.

The price change display of the row.

The item of the price change. Oracle Retail target column ITEM on RPM_SVC_PRICE_CHANGE.

The diff id of the price change.

The location type of the price change.

The location of the price change.

The effective date of the price change.

The new effective date for the price change.

The change type of the price change.

The change amount of the price change.

The change amount unit of measure of the price change.

The reason code of the price change.

The rounding rule id for the price change.

The state of the price change.

The ignore constraints value of the price change.

The grouping column for new price changes.

The input location mapped to RPM's internal value.

The currency of the internal location of the price change.

The input rounding rule mapped to RPM's internal value.

Helper for the state of the price change.

Helper for the change type of the price change.

Helper for the change amount of the price change.

Helper for the change percent of the price change.

Helper for the change currency of the price change.

Helper for the change selling UOM of the price change.

Helper for the effective date of the price change.

Helper for the rounding rule of the price change.

Helper for conflict checking. Oracle Retail target column CC_REQ on RPM_SVC_PRICE_CHANGE.

Helper for ranging validation.

Helper for conflict checking. Oracle Retail target column PRICE_EVENT_TYPE on RPM_SVC_PRICE_CHANGE.

The error message for the row.

This is a column to indicate what is the Price Change impact to Multi Unit information. Valid values are codes from CODE_DETAIL with a CODE_TYPE of PCIM. These values are AU - Multi Unit information is added or updated, R - Multi Unit information is removed and N - Multi unit information is not changed.

This is the multi units value.

This is the Multi unit Retail of an item.

This is the Multi unit Selling UOM of the item.

This is a helper column for the Price Change impact to Multi Unit information.

This is helper for the multi units value.

This is helper for the Multi unit Retail of an item.

This is helper for the Multi unit Selling UOM of the item.

The primary supplier for the item/location.

The purchase type. Valid value comes from code_detail table with code_type PRTP; those are 0 - Owned, 1 - Consignment and 2 - Concession.

The creator of the price change. Valid value comes from code_detail table with code_type PRCT; those are S - Supplier and R - Retailer.

Helper for ownership validation.

Helper to indicate if the explosion is needed due to ownership variation.

The file that inserted the price change record

The source that last created/updated the price change