Are Purchase Price & Purchase Price (Foreign Currency) on the item record two different fields in the back-end tables? From everything I can find, it appears not, but I can't find full confirmation. Seems like Purchase Price Foreign currency may be the equivalent of a calculated field, though it's a standard field listed in a saved search

purchase price = {cost}, and purchase price foreign currency = {fxcost}

Right, sorry what I was asking about was in the SQL tables. There appears to be only Cost_0, which seems to correspond to just {cost}. I don't see anything around the {fxcost} and I also don't see it listed in the Connect schema.