• A typical Price Master table would look like the one below:

    Product ID--------Price------From Date-------To Date

    P001-------------100-------1/1/2013---------12/31/2013

    P001-------------150-------1/1/2014---------12/31/2014

    P001-------------175-------1/1/2015---------

    Your logic would pick up the Price based on the current date residing between From Date and To Date.