I need some help in understanding RPM_ITEM_ZONE_PRICE.
Does this table retain the information of only Primary zone (the zone used to set up the initial price when the item is created) or does it track zone level price changes or clearances at the Regular or Clearances zones?
e.g. I have the following RPM zones:
Z1 - Primary zone (zone used for setting the initial price of an item during item creation)
Z2 - Regular zone
Suppose, when an item is created, the initial price is set to 10$. So RPM_ITEM_ZONE_PRICE will have 10$ for Item/Z1 combination.
Later in RPM, suppose the user does a zone level price change for this item for zone Z2 to 15$.
In this scenario, will RPM_ITEM_ZONE_PRICE table be populated with the record item/Z2 with 15$ or will it have information of only item/Z1?
as I remember,
RPM_ITEM_ZONE_PRICE is populated while item creation (RetailByZone form) and contains actual prices at the zone level, for the zones which belongs to Primary zone
Hope it helps.